uploads-tiflux.s3.amazonaws.com
Open in
urlscan Pro
52.95.165.0
Public Scan
Submitted URL: http://uploads-tiflux.s3.amazonaws.com/production/service_desk/ticket_files/archives/6107748/08db83fe-5ab8-4267-926b-db89b80a5e5e/scrip...
Effective URL: https://uploads-tiflux.s3.amazonaws.com/production/service_desk/ticket_files/archives/6107748/08db83fe-5ab8-4267-926b-db89b80a5e5e/scrip...
Submission: On May 04 via api from US — Scanned from DE
Effective URL: https://uploads-tiflux.s3.amazonaws.com/production/service_desk/ticket_files/archives/6107748/08db83fe-5ab8-4267-926b-db89b80a5e5e/scrip...
Submission: On May 04 via api from US — Scanned from DE
Form analysis 0 forms found in the DOM
Text Content
DECLARE
ws_amount_juros_id NUMBER(019) := 0;
ws_data_corte TIMESTAMP(6);
ws_data_registrado TIMESTAMP(6);
ws_data_registro TIMESTAMP(6);
ws_juros FLOAT(126);
ws_usuario_id NUMBER(019);
ws_calculo_juros VARCHAR2(255 CHAR);
CURSOR cursor_fields IS
SELECT
*
FROM
r_pao_amt_jr
WHERE
amount_juros_id in (421, 422);
BEGIN
FOR fc IN cursor_fields LOOP
ws_amount_juros_id := amount_juros_seq.nextval;
SELECT
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
INTO
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
FROM
amount_juros
WHERE
amount_juros_id = fc.amount_juros_id;
INSERT INTO amount_juros (
amount_juros_id,
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
) VALUES (
ws_amount_juros_id,
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
);
INSERT INTO r_pao_amt_jr (
amount_id,
amount_juros_id
) VALUES (
fc.amount_id,
ws_amount_juros_id
);
COMMIT;
END LOOP;
END;
delete from r_pao_amt_jr WHERE
amount_juros_id in (421, 422);
DECLARE
ws_amount_juros_id NUMBER(019) := 0;
ws_data_corte TIMESTAMP(6);
ws_data_registrado TIMESTAMP(6);
ws_data_registro TIMESTAMP(6);
ws_juros FLOAT(126);
ws_usuario_id NUMBER(019);
ws_calculo_juros VARCHAR2(255 CHAR);
CURSOR cursor_fields IS
SELECT
*
FROM
r_pao_amt_jr_i0
WHERE
amount_juros_id in (421, 422);
BEGIN
FOR fc IN cursor_fields LOOP
ws_amount_juros_id := amount_juros_seq.nextval;
SELECT
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
INTO
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
FROM
amount_juros
WHERE
amount_juros_id = fc.amount_juros_id;
INSERT INTO amount_juros (
amount_juros_id,
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
) VALUES (
ws_amount_juros_id,
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
);
INSERT INTO r_pao_amt_jr_i0 (
amount_id,
amount_juros_id
) VALUES (
fc.amount_id,
ws_amount_juros_id
);
COMMIT;
END LOOP;
END;
delete from r_pao_amt_jr_i0 WHERE
amount_juros_id in (421, 422);
DECLARE
ws_amount_juros_id NUMBER(019) := 0;
ws_data_corte TIMESTAMP(6);
ws_data_registrado TIMESTAMP(6);
ws_data_registro TIMESTAMP(6);
ws_juros FLOAT(126);
ws_usuario_id NUMBER(019);
ws_calculo_juros VARCHAR2(255 CHAR);
CURSOR cursor_fields IS
SELECT
*
FROM
r_pao_amt_jr_i1
WHERE
amount_juros_id in (421, 422);
BEGIN
FOR fc IN cursor_fields LOOP
ws_amount_juros_id := amount_juros_seq.nextval;
SELECT
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
INTO
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
FROM
amount_juros
WHERE
amount_juros_id = fc.amount_juros_id;
INSERT INTO amount_juros (
amount_juros_id,
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
) VALUES (
ws_amount_juros_id,
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
);
INSERT INTO r_pao_amt_jr_i1 (
amount_id,
amount_juros_id
) VALUES (
fc.amount_id,
ws_amount_juros_id
);
COMMIT;
END LOOP;
END;
delete from r_pao_amt_jr_i1 WHERE
amount_juros_id in (421, 422);
DECLARE
ws_amount_juros_id NUMBER(019) := 0;
ws_data_corte TIMESTAMP(6);
ws_data_registrado TIMESTAMP(6);
ws_data_registro TIMESTAMP(6);
ws_juros FLOAT(126);
ws_usuario_id NUMBER(019);
ws_calculo_juros VARCHAR2(255 CHAR);
CURSOR cursor_fields IS
SELECT
*
FROM
r_pao_amt_jr_i2
WHERE
amount_juros_id in (421, 422);
BEGIN
FOR fc IN cursor_fields LOOP
ws_amount_juros_id := amount_juros_seq.nextval;
SELECT
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
INTO
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
FROM
amount_juros
WHERE
amount_juros_id = fc.amount_juros_id;
INSERT INTO amount_juros (
amount_juros_id,
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
) VALUES (
ws_amount_juros_id,
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
);
INSERT INTO r_pao_amt_jr_i2 (
amount_id,
amount_juros_id
) VALUES (
fc.amount_id,
ws_amount_juros_id
);
COMMIT;
END LOOP;
END;
delete from r_pao_amt_jr_i2 WHERE
amount_juros_id in (421, 422);
DECLARE
ws_amount_juros_id NUMBER(019) := 0;
ws_data_corte TIMESTAMP(6);
ws_data_registrado TIMESTAMP(6);
ws_data_registro TIMESTAMP(6);
ws_juros FLOAT(126);
ws_usuario_id NUMBER(019);
ws_calculo_juros VARCHAR2(255 CHAR);
CURSOR cursor_fields IS
SELECT
*
FROM
r_pao_amt_jr_i3
WHERE
amount_juros_id in (421, 422);
BEGIN
FOR fc IN cursor_fields LOOP
ws_amount_juros_id := amount_juros_seq.nextval;
SELECT
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
INTO
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
FROM
amount_juros
WHERE
amount_juros_id = fc.amount_juros_id;
INSERT INTO amount_juros (
amount_juros_id,
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
) VALUES (
ws_amount_juros_id,
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
);
INSERT INTO r_pao_amt_jr_i3 (
amount_id,
amount_juros_id
) VALUES (
fc.amount_id,
ws_amount_juros_id
);
COMMIT;
END LOOP;
END;
delete from r_pao_amt_jr_i3 WHERE
amount_juros_id in (421, 422);
DECLARE
ws_amount_juros_id NUMBER(019) := 0;
ws_data_corte TIMESTAMP(6);
ws_data_registrado TIMESTAMP(6);
ws_data_registro TIMESTAMP(6);
ws_juros FLOAT(126);
ws_usuario_id NUMBER(019);
ws_calculo_juros VARCHAR2(255 CHAR);
CURSOR cursor_fields IS
SELECT
*
FROM
r_pao_amt_jr_i4
WHERE
amount_juros_id in (421, 422);
BEGIN
FOR fc IN cursor_fields LOOP
ws_amount_juros_id := amount_juros_seq.nextval;
SELECT
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
INTO
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
FROM
amount_juros
WHERE
amount_juros_id = fc.amount_juros_id;
INSERT INTO amount_juros (
amount_juros_id,
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
) VALUES (
ws_amount_juros_id,
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
);
INSERT INTO r_pao_amt_jr_i4 (
amount_id,
amount_juros_id
) VALUES (
fc.amount_id,
ws_amount_juros_id
);
COMMIT;
END LOOP;
END;
delete from r_pao_amt_jr_i4 WHERE
amount_juros_id in (421, 422);
DECLARE
ws_amount_juros_id NUMBER(019) := 0;
ws_data_corte TIMESTAMP(6);
ws_data_registrado TIMESTAMP(6);
ws_data_registro TIMESTAMP(6);
ws_juros FLOAT(126);
ws_usuario_id NUMBER(019);
ws_calculo_juros VARCHAR2(255 CHAR);
CURSOR cursor_fields IS
SELECT
*
FROM
r_pao_amt_jr_ex
WHERE
amount_juros_id in (421, 422);
BEGIN
FOR fc IN cursor_fields LOOP
ws_amount_juros_id := amount_juros_seq.nextval;
SELECT
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
INTO
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
FROM
amount_juros
WHERE
amount_juros_id = fc.amount_juros_id;
INSERT INTO amount_juros (
amount_juros_id,
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
) VALUES (
ws_amount_juros_id,
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
);
INSERT INTO r_pao_amt_jr_ex (
amount_id,
amount_juros_id
) VALUES (
fc.amount_id,
ws_amount_juros_id
);
COMMIT;
END LOOP;
END;
delete from r_pao_amt_jr_ex WHERE
amount_juros_id in (421, 422);
DECLARE
ws_amount_juros_id NUMBER(019) := 0;
ws_data_corte TIMESTAMP(6);
ws_data_registrado TIMESTAMP(6);
ws_data_registro TIMESTAMP(6);
ws_juros FLOAT(126);
ws_usuario_id NUMBER(019);
ws_calculo_juros VARCHAR2(255 CHAR);
CURSOR cursor_fields IS
SELECT
*
FROM
r_pao_amt_jr
WHERE
amount_juros_id in (421, 422);
BEGIN
FOR fc IN cursor_fields LOOP
ws_amount_juros_id := amount_juros_seq.nextval;
SELECT
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
INTO
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
FROM
amount_juros
WHERE
amount_juros_id = fc.amount_juros_id;
INSERT INTO amount_juros (
amount_juros_id,
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
) VALUES (
ws_amount_juros_id,
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
);
INSERT INTO r_pao_amt_jr (
amount_id,
amount_juros_id
) VALUES (
fc.amount_id,
ws_amount_juros_id
);
COMMIT;
END LOOP;
END;
delete from r_pao_amt_jr WHERE
amount_juros_id in (421, 422);
DECLARE
ws_amount_juros_id NUMBER(019) := 0;
ws_data_corte TIMESTAMP(6);
ws_data_registrado TIMESTAMP(6);
ws_data_registro TIMESTAMP(6);
ws_juros FLOAT(126);
ws_usuario_id NUMBER(019);
ws_calculo_juros VARCHAR2(255 CHAR);
CURSOR cursor_fields IS
SELECT
*
FROM
r_pao_amt_jr_mlt_isl
WHERE
amount_juros_id in (421, 422);
BEGIN
FOR fc IN cursor_fields LOOP
ws_amount_juros_id := amount_juros_seq.nextval;
SELECT
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
INTO
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
FROM
amount_juros
WHERE
amount_juros_id = fc.amount_juros_id;
INSERT INTO amount_juros (
amount_juros_id,
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
) VALUES (
ws_amount_juros_id,
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
);
INSERT INTO r_pao_amt_jr_mlt_isl (
prc_amount_obj_id,
amount_juros_id
) VALUES (
fc.prc_amount_obj_id,
ws_amount_juros_id
);
COMMIT;
END LOOP;
END;
delete from r_pao_amt_jr_mlt_isl WHERE
amount_juros_id in (421, 422);
DECLARE
ws_amount_juros_id NUMBER(019) := 0;
ws_data_corte TIMESTAMP(6);
ws_data_registrado TIMESTAMP(6);
ws_data_registro TIMESTAMP(6);
ws_juros FLOAT(126);
ws_usuario_id NUMBER(019);
ws_calculo_juros VARCHAR2(255 CHAR);
CURSOR cursor_fields IS
SELECT
*
FROM
r_pao_amt_jr_mlt_ofc
WHERE
amount_juros_id in (421, 422);
BEGIN
FOR fc IN cursor_fields LOOP
ws_amount_juros_id := amount_juros_seq.nextval;
SELECT
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
INTO
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
FROM
amount_juros
WHERE
amount_juros_id = fc.amount_juros_id;
INSERT INTO amount_juros (
amount_juros_id,
data_corte,
data_registrado,
data_registro,
juros,
usuario_id,
calculo_juros
) VALUES (
ws_amount_juros_id,
ws_data_corte,
ws_data_registrado,
ws_data_registro,
ws_juros,
ws_usuario_id,
ws_calculo_juros
);
INSERT INTO r_pao_amt_jr_mlt_ofc (
prc_amount_obj_id,
amount_juros_id
) VALUES (
fc.prc_amount_obj_id,
ws_amount_juros_id
);
COMMIT;
END LOOP;
END;
delete from r_pao_amt_jr_mlt_ofc WHERE
amount_juros_id in (421, 422);