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 689: SELECT pa_interface_id_s.nextval

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

Line 4728: SELECT pa_interface_id_s.nextval

4724: --Creating new interface ID every time this is called
4725: G_err_stage := 'CREATING NEW INTERFACE ID';
4726: write_log(LOG, G_err_stage);
4727:
4728: SELECT pa_interface_id_s.nextval
4729: INTO G_INTERFACE_ID
4730: FROM dual;
4731:
4732: G_err_stage := 'CREATING NEW NRT INTERFACE ID';

Line 4733: SELECT pa_interface_id_s.nextval

4729: INTO G_INTERFACE_ID
4730: FROM dual;
4731:
4732: G_err_stage := 'CREATING NEW NRT INTERFACE ID';
4733: SELECT pa_interface_id_s.nextval
4734: into G_NRT_INTERFACE_ID
4735: FROM dual;
4736:
4737: --new

Line 4739: SELECT pa_interface_id_s.nextval

4735: FROM dual;
4736:
4737: --new
4738: G_err_stage := 'CREATING NEW FRT INTERFACE ID';
4739: SELECT pa_interface_id_s.nextval
4740: into G_AP_FRT_INTERFACE_ID
4741: FROM dual;
4742:
4743: --new

Line 4745: SELECT pa_interface_id_s.nextval

4741: FROM dual;
4742:
4743: --new
4744: G_err_stage := 'CREATING NEW VARIANCE INTERFACE ID';
4745: SELECT pa_interface_id_s.nextval
4746: into G_AP_VAR_INTERFACE_ID
4747: FROM dual;
4748: --new
4749: G_err_stage := 'CREATING NEW VARIANCE INTERFACE ID';

Line 4750: SELECT pa_interface_id_s.nextval

4746: into G_AP_VAR_INTERFACE_ID
4747: FROM dual;
4748: --new
4749: G_err_stage := 'CREATING NEW VARIANCE INTERFACE ID';
4750: SELECT pa_interface_id_s.nextval
4751: into G_AP_ERV_INTERFACE_ID
4752: FROM dual;
4753:
4754: FETCH Invoice_Cur BULK COLLECT INTO

Line 6734: SELECT pa_interface_id_s.nextval

6730:
6731: G_err_stage := 'CREATING NEW INTERFACE ID';
6732: write_log(LOG, G_err_stage);
6733:
6734: SELECT pa_interface_id_s.nextval
6735: INTO G_DISC_INTERFACE_ID
6736: FROM dual;
6737:
6738: G_err_stage := 'Fetching Discount Cursor';

Line 8310: SELECT pa_interface_id_s.nextval

8306: clear_plsql_tables;
8307:
8308: G_err_stage := 'CREATING NEW INTERFACE ID';
8309: write_log(LOG, G_err_stage);
8310: SELECT pa_interface_id_s.nextval
8311: INTO G_RCV_INTERFACE_ID FROM dual;
8312:
8313: SELECT pa_interface_id_s.nextval
8314: INTO G_RCVNRT_INTERFACE_ID FROM dual;

Line 8313: SELECT pa_interface_id_s.nextval

8309: write_log(LOG, G_err_stage);
8310: SELECT pa_interface_id_s.nextval
8311: INTO G_RCV_INTERFACE_ID FROM dual;
8312:
8313: SELECT pa_interface_id_s.nextval
8314: INTO G_RCVNRT_INTERFACE_ID FROM dual;
8315:
8316: G_err_stage:='Fetching Receipts Cursor';
8317: write_log(LOG, G_err_stage);

Line 10041: SELECT pa_interface_id_s.nextval

10037: --Creating new interface ID every time this is called
10038: G_err_stage := 'CREATING NEW INTERFACE ID';
10039: write_log(LOG, G_err_stage);
10040:
10041: SELECT pa_interface_id_s.nextval
10042: INTO G_AP_VAR_INTERFACE_ID
10043: FROM dual;
10044:
10045: FETCH Invoice_Variance_Cur BULK COLLECT INTO

Line 12071: SELECT pa_interface_id_s.nextval

12067: --Creating new interface ID every time this is called
12068: G_err_stage := 'CREATING NEW INTERFACE ID';
12069: write_log(LOG, G_err_stage);
12070:
12071: SELECT pa_interface_id_s.nextval
12072: INTO G_INTERFACE_ID
12073: FROM dual;
12074:
12075: G_err_stage := 'CREATING NEW NRT INTERFACE ID';

Line 12076: SELECT pa_interface_id_s.nextval

12072: INTO G_INTERFACE_ID
12073: FROM dual;
12074:
12075: G_err_stage := 'CREATING NEW NRT INTERFACE ID';
12076: SELECT pa_interface_id_s.nextval
12077: into G_NRT_INTERFACE_ID
12078: FROM dual;
12079:
12080: G_err_stage := 'CREATING NEW FRT INTERFACE ID';

Line 12081: SELECT pa_interface_id_s.nextval

12077: into G_NRT_INTERFACE_ID
12078: FROM dual;
12079:
12080: G_err_stage := 'CREATING NEW FRT INTERFACE ID';
12081: SELECT pa_interface_id_s.nextval
12082: into G_AP_FRT_INTERFACE_ID
12083: FROM dual;
12084:
12085: G_err_stage := 'CREATING NEW VARIANCE INTERFACE ID';

Line 12086: SELECT pa_interface_id_s.nextval

12082: into G_AP_FRT_INTERFACE_ID
12083: FROM dual;
12084:
12085: G_err_stage := 'CREATING NEW VARIANCE INTERFACE ID';
12086: SELECT pa_interface_id_s.nextval
12087: into G_AP_VAR_INTERFACE_ID
12088: FROM dual;
12089:
12090: G_err_stage := 'CREATING NEW ERV VARIANCE INTERFACE ID';

Line 12091: SELECT pa_interface_id_s.nextval

12087: into G_AP_VAR_INTERFACE_ID
12088: FROM dual;
12089:
12090: G_err_stage := 'CREATING NEW ERV VARIANCE INTERFACE ID';
12091: SELECT pa_interface_id_s.nextval
12092: into G_AP_ERV_INTERFACE_ID
12093: FROM dual;
12094:
12095: FETCH Payments_Cur BULK COLLECT INTO

Line 12333: SELECT pa_interface_id_s.nextval

12329:
12330: clear_plsql_tables;
12331:
12332: G_err_stage := 'CREATING NEW PREPAYMENT INTERFACE ID';
12333: SELECT pa_interface_id_s.nextval
12334: into G_PREPAY_INTERFACE_ID
12335: FROM dual;
12336:
12337: G_err_stage := 'Before Fetching records for prepayment application within transfer_pay_to_pa';