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.PAAPIMP_PKG dependencies on PA_INTERFACE_ID_S

Line 687: SELECT pa_interface_id_s.nextval

683: write_log(LOG, G_err_stack);
684: End If;
685:
686: --Getting a unique sequence for batch name from interface_id
687: SELECT pa_interface_id_s.nextval
688: into v_interface_id
689: FROM dual;
690:
691: G_UNIQUE_ID := v_interface_id;

Line 3594: SELECT pa_interface_id_s.nextval

3590: --Creating new interface ID every time this is called
3591: G_err_stage := 'CREATING NEW INTERFACE ID';
3592: write_log(LOG, G_err_stage);
3593:
3594: SELECT pa_interface_id_s.nextval
3595: INTO G_INTERFACE_ID
3596: FROM dual;
3597:
3598: G_err_stage := 'CREATING NEW NRT INTERFACE ID';

Line 3599: SELECT pa_interface_id_s.nextval

3595: INTO G_INTERFACE_ID
3596: FROM dual;
3597:
3598: G_err_stage := 'CREATING NEW NRT INTERFACE ID';
3599: SELECT pa_interface_id_s.nextval
3600: into G_NRT_INTERFACE_ID
3601: FROM dual;
3602:
3603: --new

Line 3605: SELECT pa_interface_id_s.nextval

3601: FROM dual;
3602:
3603: --new
3604: G_err_stage := 'CREATING NEW FRT INTERFACE ID';
3605: SELECT pa_interface_id_s.nextval
3606: into G_AP_FRT_INTERFACE_ID
3607: FROM dual;
3608:
3609: --new

Line 3611: SELECT pa_interface_id_s.nextval

3607: FROM dual;
3608:
3609: --new
3610: G_err_stage := 'CREATING NEW VARIANCE INTERFACE ID';
3611: SELECT pa_interface_id_s.nextval
3612: into G_AP_VAR_INTERFACE_ID
3613: FROM dual;
3614: --new
3615: G_err_stage := 'CREATING NEW VARIANCE INTERFACE ID';

Line 3616: SELECT pa_interface_id_s.nextval

3612: into G_AP_VAR_INTERFACE_ID
3613: FROM dual;
3614: --new
3615: G_err_stage := 'CREATING NEW VARIANCE INTERFACE ID';
3616: SELECT pa_interface_id_s.nextval
3617: into G_AP_ERV_INTERFACE_ID
3618: FROM dual;
3619:
3620: FETCH Invoice_Cur BULK COLLECT INTO

Line 5390: SELECT pa_interface_id_s.nextval

5386:
5387: G_err_stage := 'CREATING NEW INTERFACE ID';
5388: write_log(LOG, G_err_stage);
5389:
5390: SELECT pa_interface_id_s.nextval
5391: INTO G_DISC_INTERFACE_ID
5392: FROM dual;
5393:
5394: G_err_stage := 'Fetching Discount Cursor';

Line 6846: SELECT pa_interface_id_s.nextval

6842: clear_plsql_tables;
6843:
6844: G_err_stage := 'CREATING NEW INTERFACE ID';
6845: write_log(LOG, G_err_stage);
6846: SELECT pa_interface_id_s.nextval
6847: INTO G_RCV_INTERFACE_ID FROM dual;
6848:
6849: SELECT pa_interface_id_s.nextval
6850: INTO G_RCVNRT_INTERFACE_ID FROM dual;

Line 6849: SELECT pa_interface_id_s.nextval

6845: write_log(LOG, G_err_stage);
6846: SELECT pa_interface_id_s.nextval
6847: INTO G_RCV_INTERFACE_ID FROM dual;
6848:
6849: SELECT pa_interface_id_s.nextval
6850: INTO G_RCVNRT_INTERFACE_ID FROM dual;
6851:
6852: G_err_stage:='Fetching Receipts Cursor';
6853: write_log(LOG, G_err_stage);

Line 8331: SELECT pa_interface_id_s.nextval

8327: --Creating new interface ID every time this is called
8328: G_err_stage := 'CREATING NEW INTERFACE ID';
8329: write_log(LOG, G_err_stage);
8330:
8331: SELECT pa_interface_id_s.nextval
8332: INTO G_AP_VAR_INTERFACE_ID
8333: FROM dual;
8334:
8335: FETCH Invoice_Variance_Cur BULK COLLECT INTO

Line 10310: SELECT pa_interface_id_s.nextval

10306: --Creating new interface ID every time this is called
10307: G_err_stage := 'CREATING NEW INTERFACE ID';
10308: write_log(LOG, G_err_stage);
10309:
10310: SELECT pa_interface_id_s.nextval
10311: INTO G_INTERFACE_ID
10312: FROM dual;
10313:
10314: G_err_stage := 'CREATING NEW NRT INTERFACE ID';

Line 10315: SELECT pa_interface_id_s.nextval

10311: INTO G_INTERFACE_ID
10312: FROM dual;
10313:
10314: G_err_stage := 'CREATING NEW NRT INTERFACE ID';
10315: SELECT pa_interface_id_s.nextval
10316: into G_NRT_INTERFACE_ID
10317: FROM dual;
10318:
10319: G_err_stage := 'CREATING NEW FRT INTERFACE ID';

Line 10320: SELECT pa_interface_id_s.nextval

10316: into G_NRT_INTERFACE_ID
10317: FROM dual;
10318:
10319: G_err_stage := 'CREATING NEW FRT INTERFACE ID';
10320: SELECT pa_interface_id_s.nextval
10321: into G_AP_FRT_INTERFACE_ID
10322: FROM dual;
10323:
10324: G_err_stage := 'CREATING NEW VARIANCE INTERFACE ID';

Line 10325: SELECT pa_interface_id_s.nextval

10321: into G_AP_FRT_INTERFACE_ID
10322: FROM dual;
10323:
10324: G_err_stage := 'CREATING NEW VARIANCE INTERFACE ID';
10325: SELECT pa_interface_id_s.nextval
10326: into G_AP_VAR_INTERFACE_ID
10327: FROM dual;
10328:
10329: G_err_stage := 'CREATING NEW ERV VARIANCE INTERFACE ID';

Line 10330: SELECT pa_interface_id_s.nextval

10326: into G_AP_VAR_INTERFACE_ID
10327: FROM dual;
10328:
10329: G_err_stage := 'CREATING NEW ERV VARIANCE INTERFACE ID';
10330: SELECT pa_interface_id_s.nextval
10331: into G_AP_ERV_INTERFACE_ID
10332: FROM dual;
10333:
10334: FETCH Payments_Cur BULK COLLECT INTO

Line 10572: SELECT pa_interface_id_s.nextval

10568:
10569: clear_plsql_tables;
10570:
10571: G_err_stage := 'CREATING NEW PREPAYMENT INTERFACE ID';
10572: SELECT pa_interface_id_s.nextval
10573: into G_PREPAY_INTERFACE_ID
10574: FROM dual;
10575:
10576: G_err_stage := 'Before Fetching records for prepayment application within transfer_pay_to_pa';