eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_GL_REV_XFER_AUDIT_PKG dependencies on DBMS_SQL

Line 10: erdl_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;

6: x_from_date IN DATE,
7: x_to_date IN DATE,
8: x_request_id IN NUMBER)
9: IS
10: erdl_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
11: rdl_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
12: uer_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
13: ubr_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
14: gain_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;

Line 11: rdl_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;

7: x_to_date IN DATE,
8: x_request_id IN NUMBER)
9: IS
10: erdl_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
11: rdl_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
12: uer_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
13: ubr_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
14: gain_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
15: loss_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;

Line 12: uer_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;

8: x_request_id IN NUMBER)
9: IS
10: erdl_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
11: rdl_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
12: uer_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
13: ubr_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
14: gain_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
15: loss_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
16: erdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;

Line 13: ubr_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;

9: IS
10: erdl_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
11: rdl_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
12: uer_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
13: ubr_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
14: gain_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
15: loss_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
16: erdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
17: rdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;

Line 14: gain_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;

10: erdl_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
11: rdl_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
12: uer_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
13: ubr_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
14: gain_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
15: loss_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
16: erdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
17: rdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
18: uer_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;

Line 15: loss_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;

11: rdl_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
12: uer_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
13: ubr_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
14: gain_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
15: loss_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
16: erdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
17: rdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
18: uer_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
19: ubr_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;

Line 16: erdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;

12: uer_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
13: ubr_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
14: gain_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
15: loss_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
16: erdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
17: rdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
18: uer_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
19: ubr_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
20: gain_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;

Line 17: rdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;

13: ubr_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
14: gain_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
15: loss_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
16: erdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
17: rdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
18: uer_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
19: ubr_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
20: gain_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
21: loss_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;

Line 18: uer_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;

14: gain_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
15: loss_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
16: erdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
17: rdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
18: uer_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
19: ubr_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
20: gain_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
21: loss_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
22: fdbk NUMBER;

Line 19: ubr_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;

15: loss_cur NUMBER:= DBMS_SQL.OPEN_CURSOR;
16: erdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
17: rdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
18: uer_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
19: ubr_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
20: gain_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
21: loss_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
22: fdbk NUMBER;
23: je_statement varchar2(100);

Line 20: gain_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;

16: erdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
17: rdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
18: uer_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
19: ubr_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
20: gain_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
21: loss_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
22: fdbk NUMBER;
23: je_statement varchar2(100);
24: erdl_stmt varchar2(4000);

Line 21: loss_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;

17: rdl_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
18: uer_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
19: ubr_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
20: gain_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
21: loss_cur1 NUMBER:= DBMS_SQL.OPEN_CURSOR;
22: fdbk NUMBER;
23: je_statement varchar2(100);
24: erdl_stmt varchar2(4000);
25: rdl_stmt varchar2(4000);

Line 120: DBMS_SQL.PARSE (erdl_cur, erdl_stmt, DBMS_SQL.NATIVE);

116: AND aeh.accounting_entry_status_code = ''F''
117: AND ael.code_combination_id = cc.code_combination_id
118: AND pdr.event_id IS NOT NULL';
119:
120: DBMS_SQL.PARSE (erdl_cur, erdl_stmt, DBMS_SQL.NATIVE);
121: fdbk := DBMS_SQL.EXECUTE (erdl_cur);
122: DBMS_SQL.CLOSE_CURSOR (erdl_cur);
123: COMMIT;
124:

Line 121: fdbk := DBMS_SQL.EXECUTE (erdl_cur);

117: AND ael.code_combination_id = cc.code_combination_id
118: AND pdr.event_id IS NOT NULL';
119:
120: DBMS_SQL.PARSE (erdl_cur, erdl_stmt, DBMS_SQL.NATIVE);
121: fdbk := DBMS_SQL.EXECUTE (erdl_cur);
122: DBMS_SQL.CLOSE_CURSOR (erdl_cur);
123: COMMIT;
124:
125: ERDL_STMT1 := 'insert into pa_gl_rev_xfer_audit_rep

Line 122: DBMS_SQL.CLOSE_CURSOR (erdl_cur);

118: AND pdr.event_id IS NOT NULL';
119:
120: DBMS_SQL.PARSE (erdl_cur, erdl_stmt, DBMS_SQL.NATIVE);
121: fdbk := DBMS_SQL.EXECUTE (erdl_cur);
122: DBMS_SQL.CLOSE_CURSOR (erdl_cur);
123: COMMIT;
124:
125: ERDL_STMT1 := 'insert into pa_gl_rev_xfer_audit_rep
126: (

Line 192: DBMS_SQL.PARSE (erdl_cur1, erdl_stmt1, DBMS_SQL.NATIVE);

188: AND '||x_where_cc||'
189: AND rdl.batch_name = jel.reference_1' ;
190:
191:
192: DBMS_SQL.PARSE (erdl_cur1, erdl_stmt1, DBMS_SQL.NATIVE);
193: fdbk := DBMS_SQL.EXECUTE (erdl_cur1);
194: DBMS_SQL.CLOSE_CURSOR (erdl_cur1);
195: COMMIT;
196:

Line 193: fdbk := DBMS_SQL.EXECUTE (erdl_cur1);

189: AND rdl.batch_name = jel.reference_1' ;
190:
191:
192: DBMS_SQL.PARSE (erdl_cur1, erdl_stmt1, DBMS_SQL.NATIVE);
193: fdbk := DBMS_SQL.EXECUTE (erdl_cur1);
194: DBMS_SQL.CLOSE_CURSOR (erdl_cur1);
195: COMMIT;
196:
197: /*

Line 194: DBMS_SQL.CLOSE_CURSOR (erdl_cur1);

190:
191:
192: DBMS_SQL.PARSE (erdl_cur1, erdl_stmt1, DBMS_SQL.NATIVE);
193: fdbk := DBMS_SQL.EXECUTE (erdl_cur1);
194: DBMS_SQL.CLOSE_CURSOR (erdl_cur1);
195: COMMIT;
196:
197: /*
198: Insertion of RDL lines

Line 270: DBMS_SQL.PARSE (rdl_cur, rdl_stmt, DBMS_SQL.NATIVE);

266: AND nvl(TRUNC(TO_DATE('''||to_char(x_to_date,'DD-MM-RRRR')||''',''DD-MM-RRRR'')),TRUNC(pdr.transferred_date))
267: AND ael.code_combination_id = cc.code_combination_id
268: AND '||x_where_cc;
269:
270: DBMS_SQL.PARSE (rdl_cur, rdl_stmt, DBMS_SQL.NATIVE);
271: fdbk := DBMS_SQL.EXECUTE (rdl_cur);
272: DBMS_SQL.CLOSE_CURSOR (rdl_cur);
273:
274:

Line 271: fdbk := DBMS_SQL.EXECUTE (rdl_cur);

267: AND ael.code_combination_id = cc.code_combination_id
268: AND '||x_where_cc;
269:
270: DBMS_SQL.PARSE (rdl_cur, rdl_stmt, DBMS_SQL.NATIVE);
271: fdbk := DBMS_SQL.EXECUTE (rdl_cur);
272: DBMS_SQL.CLOSE_CURSOR (rdl_cur);
273:
274:
275: rdl_stmt1 := 'insert into pa_gl_rev_xfer_audit_rep

Line 272: DBMS_SQL.CLOSE_CURSOR (rdl_cur);

268: AND '||x_where_cc;
269:
270: DBMS_SQL.PARSE (rdl_cur, rdl_stmt, DBMS_SQL.NATIVE);
271: fdbk := DBMS_SQL.EXECUTE (rdl_cur);
272: DBMS_SQL.CLOSE_CURSOR (rdl_cur);
273:
274:
275: rdl_stmt1 := 'insert into pa_gl_rev_xfer_audit_rep
276: (

Line 342: DBMS_SQL.PARSE (rdl_cur1, rdl_stmt1, DBMS_SQL.NATIVE);

338: AND '||x_where_cc||'
339: AND pdr.event_id IS NULL ';
340:
341:
342: DBMS_SQL.PARSE (rdl_cur1, rdl_stmt1, DBMS_SQL.NATIVE);
343: fdbk := DBMS_SQL.EXECUTE (rdl_cur1);
344: DBMS_SQL.CLOSE_CURSOR (rdl_cur1);
345:
346: update pa_gl_rev_xfer_audit_rep rep set (TRANSACTION_TYPE,TRANSACTION_DATE,TASK_ID,EMP_OR_ORG_NAME) =

Line 343: fdbk := DBMS_SQL.EXECUTE (rdl_cur1);

339: AND pdr.event_id IS NULL ';
340:
341:
342: DBMS_SQL.PARSE (rdl_cur1, rdl_stmt1, DBMS_SQL.NATIVE);
343: fdbk := DBMS_SQL.EXECUTE (rdl_cur1);
344: DBMS_SQL.CLOSE_CURSOR (rdl_cur1);
345:
346: update pa_gl_rev_xfer_audit_rep rep set (TRANSACTION_TYPE,TRANSACTION_DATE,TASK_ID,EMP_OR_ORG_NAME) =
347: (select ei.expenditure_type,ei.expenditure_item_date,ei.task_id,DECODE(emp.full_name, null,org.name, emp.full_name )

Line 344: DBMS_SQL.CLOSE_CURSOR (rdl_cur1);

340:
341:
342: DBMS_SQL.PARSE (rdl_cur1, rdl_stmt1, DBMS_SQL.NATIVE);
343: fdbk := DBMS_SQL.EXECUTE (rdl_cur1);
344: DBMS_SQL.CLOSE_CURSOR (rdl_cur1);
345:
346: update pa_gl_rev_xfer_audit_rep rep set (TRANSACTION_TYPE,TRANSACTION_DATE,TASK_ID,EMP_OR_ORG_NAME) =
347: (select ei.expenditure_type,ei.expenditure_item_date,ei.task_id,DECODE(emp.full_name, null,org.name, emp.full_name )
348: from hr_organization_units org,

Line 436: DBMS_SQL.PARSE (uer_cur, uer_stmt, DBMS_SQL.NATIVE);

432: AND nvl(TRUNC(TO_DATE('''||to_char(x_to_date,'DD-MM-RRRR')||''',''DD-MM-RRRR'')),TRUNC(pdr.transferred_date))
433: AND ael.code_combination_id = cc.code_combination_id
434: AND '||x_where_cc;
435:
436: DBMS_SQL.PARSE (uer_cur, uer_stmt, DBMS_SQL.NATIVE);
437: fdbk := DBMS_SQL.EXECUTE (uer_cur);
438: DBMS_SQL.CLOSE_CURSOR (uer_cur);
439: COMMIT;
440:

Line 437: fdbk := DBMS_SQL.EXECUTE (uer_cur);

433: AND ael.code_combination_id = cc.code_combination_id
434: AND '||x_where_cc;
435:
436: DBMS_SQL.PARSE (uer_cur, uer_stmt, DBMS_SQL.NATIVE);
437: fdbk := DBMS_SQL.EXECUTE (uer_cur);
438: DBMS_SQL.CLOSE_CURSOR (uer_cur);
439: COMMIT;
440:
441:

Line 438: DBMS_SQL.CLOSE_CURSOR (uer_cur);

434: AND '||x_where_cc;
435:
436: DBMS_SQL.PARSE (uer_cur, uer_stmt, DBMS_SQL.NATIVE);
437: fdbk := DBMS_SQL.EXECUTE (uer_cur);
438: DBMS_SQL.CLOSE_CURSOR (uer_cur);
439: COMMIT;
440:
441:
442: uer_stmt1 := 'insert into pa_gl_rev_xfer_audit_rep

Line 505: DBMS_SQL.PARSE (uer_cur1, uer_stmt1, DBMS_SQL.NATIVE);

501: AND nvl(TRUNC(TO_DATE('''||to_char(x_to_date,'DD-MM-RRRR')||''',''DD-MM-RRRR'')),TRUNC(pdr.transferred_date))
502: AND '||x_where_cc||'
503: AND pdr.event_id IS NULL ';
504:
505: DBMS_SQL.PARSE (uer_cur1, uer_stmt1, DBMS_SQL.NATIVE);
506: fdbk := DBMS_SQL.EXECUTE (uer_cur1);
507: DBMS_SQL.CLOSE_CURSOR (uer_cur1);
508: COMMIT;
509:

Line 506: fdbk := DBMS_SQL.EXECUTE (uer_cur1);

502: AND '||x_where_cc||'
503: AND pdr.event_id IS NULL ';
504:
505: DBMS_SQL.PARSE (uer_cur1, uer_stmt1, DBMS_SQL.NATIVE);
506: fdbk := DBMS_SQL.EXECUTE (uer_cur1);
507: DBMS_SQL.CLOSE_CURSOR (uer_cur1);
508: COMMIT;
509:
510: /*

Line 507: DBMS_SQL.CLOSE_CURSOR (uer_cur1);

503: AND pdr.event_id IS NULL ';
504:
505: DBMS_SQL.PARSE (uer_cur1, uer_stmt1, DBMS_SQL.NATIVE);
506: fdbk := DBMS_SQL.EXECUTE (uer_cur1);
507: DBMS_SQL.CLOSE_CURSOR (uer_cur1);
508: COMMIT;
509:
510: /*
511: Insertion of UBR Lines

Line 580: DBMS_SQL.PARSE (ubr_cur, ubr_stmt, DBMS_SQL.NATIVE);

576: AND nvl(TRUNC(TO_DATE('''||to_char(x_to_date,'DD-MM-RRRR')||''',''DD-MM-RRRR'')),TRUNC(pdr.transferred_date))
577: AND ael.code_combination_id = cc.code_combination_id
578: AND '||x_where_cc;
579:
580: DBMS_SQL.PARSE (ubr_cur, ubr_stmt, DBMS_SQL.NATIVE);
581: fdbk := DBMS_SQL.EXECUTE (ubr_cur);
582: DBMS_SQL.CLOSE_CURSOR (ubr_cur);
583: COMMIT;
584:

Line 581: fdbk := DBMS_SQL.EXECUTE (ubr_cur);

577: AND ael.code_combination_id = cc.code_combination_id
578: AND '||x_where_cc;
579:
580: DBMS_SQL.PARSE (ubr_cur, ubr_stmt, DBMS_SQL.NATIVE);
581: fdbk := DBMS_SQL.EXECUTE (ubr_cur);
582: DBMS_SQL.CLOSE_CURSOR (ubr_cur);
583: COMMIT;
584:
585:

Line 582: DBMS_SQL.CLOSE_CURSOR (ubr_cur);

578: AND '||x_where_cc;
579:
580: DBMS_SQL.PARSE (ubr_cur, ubr_stmt, DBMS_SQL.NATIVE);
581: fdbk := DBMS_SQL.EXECUTE (ubr_cur);
582: DBMS_SQL.CLOSE_CURSOR (ubr_cur);
583: COMMIT;
584:
585:
586: ubr_stmt1 := 'insert into pa_gl_rev_xfer_audit_rep

Line 649: DBMS_SQL.PARSE (ubr_cur1, ubr_stmt1, DBMS_SQL.NATIVE);

645: AND nvl(TRUNC(TO_DATE('''||to_char(x_to_date,'DD-MM-RRRR')||''',''DD-MM-RRRR'')),TRUNC(pdr.transferred_date))
646: AND '||x_where_cc||'
647: AND pdr.event_id IS NULL ';
648:
649: DBMS_SQL.PARSE (ubr_cur1, ubr_stmt1, DBMS_SQL.NATIVE);
650: fdbk := DBMS_SQL.EXECUTE (ubr_cur1);
651: DBMS_SQL.CLOSE_CURSOR (ubr_cur1);
652: COMMIT;
653:

Line 650: fdbk := DBMS_SQL.EXECUTE (ubr_cur1);

646: AND '||x_where_cc||'
647: AND pdr.event_id IS NULL ';
648:
649: DBMS_SQL.PARSE (ubr_cur1, ubr_stmt1, DBMS_SQL.NATIVE);
650: fdbk := DBMS_SQL.EXECUTE (ubr_cur1);
651: DBMS_SQL.CLOSE_CURSOR (ubr_cur1);
652: COMMIT;
653:
654: /*

Line 651: DBMS_SQL.CLOSE_CURSOR (ubr_cur1);

647: AND pdr.event_id IS NULL ';
648:
649: DBMS_SQL.PARSE (ubr_cur1, ubr_stmt1, DBMS_SQL.NATIVE);
650: fdbk := DBMS_SQL.EXECUTE (ubr_cur1);
651: DBMS_SQL.CLOSE_CURSOR (ubr_cur1);
652: COMMIT;
653:
654: /*
655: Insertion of RLZD-GAIN lines

Line 724: DBMS_SQL.PARSE (gain_cur, gain_stmt, DBMS_SQL.NATIVE);

720: AND nvl(TRUNC(TO_DATE('''||to_char(x_to_date,'DD-MM-RRRR')||''',''DD-MM-RRRR'')),TRUNC(pdr.transferred_date))
721: AND ael.code_combination_id = cc.code_combination_id
722: AND '||x_where_cc;
723:
724: DBMS_SQL.PARSE (gain_cur, gain_stmt, DBMS_SQL.NATIVE);
725: fdbk := DBMS_SQL.EXECUTE (gain_cur);
726: DBMS_SQL.CLOSE_CURSOR (gain_cur);
727: COMMIT;
728:

Line 725: fdbk := DBMS_SQL.EXECUTE (gain_cur);

721: AND ael.code_combination_id = cc.code_combination_id
722: AND '||x_where_cc;
723:
724: DBMS_SQL.PARSE (gain_cur, gain_stmt, DBMS_SQL.NATIVE);
725: fdbk := DBMS_SQL.EXECUTE (gain_cur);
726: DBMS_SQL.CLOSE_CURSOR (gain_cur);
727: COMMIT;
728:
729:

Line 726: DBMS_SQL.CLOSE_CURSOR (gain_cur);

722: AND '||x_where_cc;
723:
724: DBMS_SQL.PARSE (gain_cur, gain_stmt, DBMS_SQL.NATIVE);
725: fdbk := DBMS_SQL.EXECUTE (gain_cur);
726: DBMS_SQL.CLOSE_CURSOR (gain_cur);
727: COMMIT;
728:
729:
730:

Line 793: DBMS_SQL.PARSE (gain_cur1, gain_stmt1, DBMS_SQL.NATIVE);

789: AND nvl(TRUNC(TO_DATE('''||to_char(x_to_date,'DD-MM-RRRR')||''',''DD-MM-RRRR'')),TRUNC(pdr.transferred_date))
790: AND '||x_where_cc||'
791: AND pdr.event_id IS NULL ';
792:
793: DBMS_SQL.PARSE (gain_cur1, gain_stmt1, DBMS_SQL.NATIVE);
794: fdbk := DBMS_SQL.EXECUTE (gain_cur1);
795: DBMS_SQL.CLOSE_CURSOR (gain_cur1);
796: COMMIT;
797:

Line 794: fdbk := DBMS_SQL.EXECUTE (gain_cur1);

790: AND '||x_where_cc||'
791: AND pdr.event_id IS NULL ';
792:
793: DBMS_SQL.PARSE (gain_cur1, gain_stmt1, DBMS_SQL.NATIVE);
794: fdbk := DBMS_SQL.EXECUTE (gain_cur1);
795: DBMS_SQL.CLOSE_CURSOR (gain_cur1);
796: COMMIT;
797:
798: /*

Line 795: DBMS_SQL.CLOSE_CURSOR (gain_cur1);

791: AND pdr.event_id IS NULL ';
792:
793: DBMS_SQL.PARSE (gain_cur1, gain_stmt1, DBMS_SQL.NATIVE);
794: fdbk := DBMS_SQL.EXECUTE (gain_cur1);
795: DBMS_SQL.CLOSE_CURSOR (gain_cur1);
796: COMMIT;
797:
798: /*
799: Insertion of RLZD-LOSS lines

Line 868: DBMS_SQL.PARSE (loss_cur, loss_stmt, DBMS_SQL.NATIVE);

864: AND nvl(TRUNC(TO_DATE('''||to_char(x_to_date,'DD-MM-RRRR')||''',''DD-MM-RRRR'')),TRUNC(pdr.transferred_date))
865: AND ael.code_combination_id = cc.code_combination_id
866: AND '||x_where_cc;
867:
868: DBMS_SQL.PARSE (loss_cur, loss_stmt, DBMS_SQL.NATIVE);
869: fdbk := DBMS_SQL.EXECUTE (loss_cur);
870: DBMS_SQL.CLOSE_CURSOR (loss_cur);
871: COMMIT;
872:

Line 869: fdbk := DBMS_SQL.EXECUTE (loss_cur);

865: AND ael.code_combination_id = cc.code_combination_id
866: AND '||x_where_cc;
867:
868: DBMS_SQL.PARSE (loss_cur, loss_stmt, DBMS_SQL.NATIVE);
869: fdbk := DBMS_SQL.EXECUTE (loss_cur);
870: DBMS_SQL.CLOSE_CURSOR (loss_cur);
871: COMMIT;
872:
873: loss_stmt1 :='insert into pa_gl_rev_xfer_audit_rep

Line 870: DBMS_SQL.CLOSE_CURSOR (loss_cur);

866: AND '||x_where_cc;
867:
868: DBMS_SQL.PARSE (loss_cur, loss_stmt, DBMS_SQL.NATIVE);
869: fdbk := DBMS_SQL.EXECUTE (loss_cur);
870: DBMS_SQL.CLOSE_CURSOR (loss_cur);
871: COMMIT;
872:
873: loss_stmt1 :='insert into pa_gl_rev_xfer_audit_rep
874: (

Line 935: DBMS_SQL.PARSE (loss_cur1, loss_stmt1, DBMS_SQL.NATIVE);

931: AND nvl(TRUNC(TO_DATE('''||to_char(x_to_date,'DD-MM-RRRR')||''',''DD-MM-RRRR'')),TRUNC(pdr.transferred_date))
932: AND '||x_where_cc||'
933: AND pdr.event_id IS NULL ';
934:
935: DBMS_SQL.PARSE (loss_cur1, loss_stmt1, DBMS_SQL.NATIVE);
936: fdbk := DBMS_SQL.EXECUTE (loss_cur1);
937: DBMS_SQL.CLOSE_CURSOR (loss_cur1);
938: COMMIT;
939:

Line 936: fdbk := DBMS_SQL.EXECUTE (loss_cur1);

932: AND '||x_where_cc||'
933: AND pdr.event_id IS NULL ';
934:
935: DBMS_SQL.PARSE (loss_cur1, loss_stmt1, DBMS_SQL.NATIVE);
936: fdbk := DBMS_SQL.EXECUTE (loss_cur1);
937: DBMS_SQL.CLOSE_CURSOR (loss_cur1);
938: COMMIT;
939:
940:

Line 937: DBMS_SQL.CLOSE_CURSOR (loss_cur1);

933: AND pdr.event_id IS NULL ';
934:
935: DBMS_SQL.PARSE (loss_cur1, loss_stmt1, DBMS_SQL.NATIVE);
936: fdbk := DBMS_SQL.EXECUTE (loss_cur1);
937: DBMS_SQL.CLOSE_CURSOR (loss_cur1);
938: COMMIT;
939:
940:
941: /*