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 DUAL

Line 691: FROM dual;

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;
694:
695: v_new_batch_name := 'AP-' ||G_UNIQUE_ID;

Line 3915: FROM dual

3911: ,l_sc_xfer_code_tbl(i)
3912: ,l_si_assts_add_flg_tbl(i)
3913: ,l_net_zero_flag_tbl(i)
3914: ,l_cbs_element_id_tbl(i) -- Added for CBS Enhancement Bug 16220146
3915: FROM dual
3916: WHERE l_insert_flag_tbl(i) not in ('F', 'P');
3917:
3918: -- Insert the reversal of reversed/cancelled invoice distribution recs from AP.
3919: IF l_create_adj_recs = 'Y' THEN

Line 4072: FROM dual

4068: ,'P' -- sc_xfer_code
4069: ,'T' -- l_si_assts_add_flg_tbl(i)
4070: ,l_net_zero_flag_tbl(i)
4071: ,l_cbs_element_id_tbl(i) -- Added for CBS Enhancement Bug 16220146
4072: FROM dual
4073: WHERE l_insert_flag_tbl(i)= 'A';
4074:
4075: -- Handle both the parent and the reversal getting interfaced into PA
4076: -- in the same run.

Line 4730: FROM dual;

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';
4733: SELECT pa_interface_id_s.nextval
4734: into G_NRT_INTERFACE_ID

Line 4735: 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
4738: G_err_stage := 'CREATING NEW FRT INTERFACE ID';
4739: SELECT pa_interface_id_s.nextval

Line 4741: FROM dual;

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
4744: G_err_stage := 'CREATING NEW VARIANCE INTERFACE ID';
4745: SELECT pa_interface_id_s.nextval

Line 4747: FROM dual;

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';
4750: SELECT pa_interface_id_s.nextval
4751: into G_AP_ERV_INTERFACE_ID

Line 4752: 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
4755: l_invoice_id_tbl
4756: ,l_created_by_tbl

Line 5555: from DUAL;

5551: BEGIN
5552:
5553: select nvl(fnd_profile.value_specific('PA_DISC_PULL_START_DATE'),'2051/01/01') --bug4474213.
5554: INTO v_discount_start_date
5555: from DUAL;
5556: RETURN v_discount_start_date;
5557:
5558: END return_profile_discount_date;
5559:

Line 6170: FROM dual;

6166: ,l_si_assts_add_flg_tbl(i)
6167: ,l_sc_xfer_code_tbl(i)
6168: ,l_net_zero_flag_tbl(i)
6169: ,l_cbs_element_id_tbl(i) -- Added for CBS Enhancement Bug 16220146
6170: FROM dual;
6171:
6172: -- Insert the reversal of the reversed/cancelled distribution recs from AP.
6173: IF l_create_adj_recs = 'Y' THEN
6174:

Line 6319: FROM dual

6315: and NVL(xface.adjusted_expenditure_item_id,0) = 0 ) -- R12 funds management Uptake
6316: ,'P' -- sc_xfer_code
6317: ,l_net_zero_flag_tbl(i)
6318: ,l_cbs_element_id_tbl(i) -- Added for CBS Enhancement Bug 16220146
6319: FROM dual
6320: WHERE l_insert_flag_tbl(i)= 'A';
6321: --WHERE l_net_zero_flag_tbl(i)= 'Y';
6322:
6323: -- Handle both the parent and the reversal getting interfaced into PA

Line 6736: FROM dual;

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';
6739: write_log(LOG, G_err_stage);
6740:

Line 7349: FROM dual

7345: ,l_sc_xfer_code_tbl(i)
7346: ,l_si_assts_add_flg_tbl(i)
7347: ,l_net_zero_flag_tbl(i)
7348: ,l_cbs_element_id_tbl(i) -- Added for CBS Enhancement Bug 16220146
7349: FROM dual
7350: WHERE l_insert_flag_tbl(i) in ('Y','A');
7351:
7352: -- Insert the adjustment recs from AP.
7353: IF l_create_adj_recs = 'Y' THEN

Line 7500: FROM dual

7496: ,'P' -- sc_xfer_code
7497: ,'T' -- Si assets flag
7498: ,l_net_zero_flag_tbl(i)
7499: ,l_cbs_element_id_tbl(i) -- Added for CBS Enhancement Bug 16220146
7500: FROM dual
7501: WHERE l_insert_flag_tbl(i) = 'A';
7502: END IF;
7503:
7504: EXCEPTION

Line 7762: FROM dual

7758: /*bug7168636 handling no data found */
7759: BEGIN
7760: SELECT 'Y'
7761: INTO l_exists
7762: FROM dual
7763: WHERE EXISTS (
7764: SELECT pa_addition_flag
7765: FROM rcv_receiving_sub_ledger
7766: WHERE rcv_transaction_id = l_parent_rcv_id_tbl(i)

Line 7873: FROM dual

7869: /*bug 7168636 handling no data found*/
7870: BEGIN
7871: SELECT 'Y'
7872: INTO l_exists
7873: FROM dual
7874: WHERE EXISTS (
7875: SELECT pa_addition_flag
7876: FROM rcv_receiving_sub_ledger
7877: WHERE rcv_transaction_id = l_parent_rcv_id_tbl(i)

Line 8148: FROM dual

8144: --added exception block to handle exception for the bug 12379537.
8145: begin
8146: SELECT 'Y'
8147: INTO l_exists
8148: FROM dual
8149: WHERE EXISTS (
8150: SELECT pa_addition_flag
8151: FROM rcv_receiving_sub_ledger
8152: WHERE rcv_transaction_id = l_parent_rcv_id_tbl(i)

Line 8311: INTO G_RCV_INTERFACE_ID FROM dual;

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;
8315:

Line 8314: INTO G_RCVNRT_INTERFACE_ID FROM dual;

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);
8318:

Line 9645: FROM dual;

9641: ,l_si_assts_add_flg_tbl(i)
9642: ,l_net_zero_flag_tbl(i)
9643: ,0 -- To relieve the cmt. It will not be interfaced from xface in trx imp.
9644: ,l_cbs_element_id_tbl(i) -- Added for CBS Enhancement Bug 16220146
9645: FROM dual;
9646:
9647: -- Insert the reversal of the reversed/cancelled distribution recs from AP.
9648: IF l_create_adj_recs = 'Y' THEN
9649:

Line 9796: FROM dual

9792: ,'P' -- sc_xfer_code
9793: ,l_si_assts_add_flg_tbl(i)
9794: ,l_net_zero_flag_tbl(i)
9795: ,l_cbs_element_id_tbl(i) -- Added for CBS Enhancement Bug 16220146
9796: FROM dual
9797: WHERE l_insert_flag_tbl(i)= 'A';
9798: --WHERE l_net_zero_flag_tbl(i)= 'Y';
9799: END IF;
9800:

Line 10043: FROM dual;

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
10046: l_invoice_id_tbl
10047: ,l_invoice_dist_id_tbl --NEW

Line 11353: FROM DUAL

11349: ,l_sc_xfer_code_tbl(i)
11350: ,l_si_assts_add_flg_tbl(i)
11351: ,l_net_zero_flag_tbl(i)
11352: ,l_cbs_element_id_tbl(i) -- Added for CBS Enhancement Bug 16220146
11353: FROM DUAL
11354: WHERE l_insert_flag_tbl(i) not in ('P','F');
11355:
11356: -- Insert the adjustment recs from AP.
11357: IF l_create_adj_recs = 'Y' THEN

Line 11512: FROM dual

11508: ,'P'
11509: ,'T' -- l_si_assts_add_flg_tbl(i)
11510: ,l_net_zero_flag_tbl(i)
11511: ,l_cbs_element_id_tbl(i) -- Added for CBS Enhancement Bug 16220146
11512: FROM dual
11513: WHERE l_insert_flag_tbl(i)= 'A';
11514: -- WHERE l_net_zero_flag_tbl(i)= 'Y';
11515:
11516: -- Handle both the parent and the reversal getting interfaced into PA

Line 12073: FROM dual;

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';
12076: SELECT pa_interface_id_s.nextval
12077: into G_NRT_INTERFACE_ID

Line 12078: 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';
12081: SELECT pa_interface_id_s.nextval
12082: into G_AP_FRT_INTERFACE_ID

Line 12083: 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';
12086: SELECT pa_interface_id_s.nextval
12087: into G_AP_VAR_INTERFACE_ID

Line 12088: 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';
12091: SELECT pa_interface_id_s.nextval
12092: into G_AP_ERV_INTERFACE_ID

Line 12093: 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
12096: l_inv_pay_id_tbl,
12097: l_invoice_id_tbl,

Line 12335: FROM dual;

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';
12338: write_log(LOG, G_err_stage);
12339:

Line 13063: FROM dual;

13059: write_log(LOG, 'Parent dist ='||l_rev_parent_dist_id_tbl(i)||' Child dist = '||l_rev_child_dist_id_tbl(i));
13060: /*Start changes for bug#15974243 */
13061: SELECT pa_utils.getweekending(l_ei_date_tbl(p_current_index))
13062: INTO l_exp_end_date_tbl(p_current_index)
13063: FROM dual;
13064: /*End changes for bug#15974243 */
13065:
13066: END IF;
13067:

Line 13144: FROM DUAL

13140: l_Pa_Addition_Flag:=p_Pa_Addition_Flag;
13141:
13142: SELECT 'X'
13143: INTO l_Dummy
13144: FROM DUAL
13145: WHERE EXISTS ( SELECT NULL
13146: FROM rcv_transactions rcv_txn2
13147: ,rcv_receiving_sub_ledger rcv_sub2
13148: WHERE rcv_sub2.rcv_transaction_id = rcv_txn2.transaction_id