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 689: FROM dual;

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;
692:
693: v_new_batch_name := 'AP-' ||G_UNIQUE_ID;

Line 2847: FROM dual

2843: ,l_ln_type_lookup_tbl(i)
2844: ,l_sc_xfer_code_tbl(i)
2845: ,l_si_assts_add_flg_tbl(i)
2846: ,l_net_zero_flag_tbl(i)
2847: FROM dual
2848: WHERE l_insert_flag_tbl(i) not in ('F', 'P');
2849:
2850: -- Insert the reversal of reversed/cancelled invoice distribution recs from AP.
2851: IF l_create_adj_recs = 'Y' THEN

Line 3002: FROM dual

2998: and NVL(xface.adjusted_expenditure_item_id,0) = 0 ) -- R12 funds management Uptake
2999: ,'P' -- sc_xfer_code
3000: ,'T' -- l_si_assts_add_flg_tbl(i)
3001: ,l_net_zero_flag_tbl(i)
3002: FROM dual
3003: WHERE l_insert_flag_tbl(i)= 'A';
3004:
3005: -- Handle both the parent and the reversal getting interfaced into PA
3006: -- in the same run.

Line 3596: FROM dual;

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

Line 3601: 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
3604: G_err_stage := 'CREATING NEW FRT INTERFACE ID';
3605: SELECT pa_interface_id_s.nextval

Line 3607: FROM dual;

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

Line 3613: FROM dual;

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

Line 3618: 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
3621: l_invoice_id_tbl
3622: ,l_created_by_tbl

Line 4399: from DUAL;

4395: BEGIN
4396:
4397: select nvl(fnd_profile.value_specific('PA_DISC_PULL_START_DATE'),'2051/01/01') --bug4474213.
4398: INTO v_discount_start_date
4399: from DUAL;
4400: RETURN v_discount_start_date;
4401:
4402: END return_profile_discount_date;
4403:

Line 4889: FROM dual;

4885: ,l_ln_type_lookup_tbl(i)
4886: ,l_si_assts_add_flg_tbl(i)
4887: ,l_sc_xfer_code_tbl(i)
4888: ,l_net_zero_flag_tbl(i)
4889: FROM dual;
4890:
4891: -- Insert the reversal of the reversed/cancelled distribution recs from AP.
4892: IF l_create_adj_recs = 'Y' THEN
4893:

Line 5036: FROM dual

5032: and xface.cdl_system_reference5 = l_invoice_dist_id_tbl(i)
5033: and NVL(xface.adjusted_expenditure_item_id,0) = 0 ) -- R12 funds management Uptake
5034: ,'P' -- sc_xfer_code
5035: ,l_net_zero_flag_tbl(i)
5036: FROM dual
5037: WHERE l_insert_flag_tbl(i)= 'A';
5038: --WHERE l_net_zero_flag_tbl(i)= 'Y';
5039:
5040: -- Handle both the parent and the reversal getting interfaced into PA

Line 5392: FROM dual;

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

Line 5925: FROM dual

5921: ,l_trx_type_tbl(i)
5922: ,l_sc_xfer_code_tbl(i)
5923: ,l_si_assts_add_flg_tbl(i)
5924: ,l_net_zero_flag_tbl(i)
5925: FROM dual
5926: WHERE l_insert_flag_tbl(i) in ('Y','A');
5927:
5928: -- Insert the adjustment recs from AP.
5929: IF l_create_adj_recs = 'Y' THEN

Line 6074: FROM dual

6070: and nVL(xface.adjusted_expenditure_item_id,0) = 0 ) -- R12 funds management Uptake
6071: ,'P' -- sc_xfer_code
6072: ,'T' -- Si assets flag
6073: ,l_net_zero_flag_tbl(i)
6074: FROM dual
6075: WHERE l_insert_flag_tbl(i) = 'A';
6076: END IF;
6077:
6078: EXCEPTION

Line 6304: FROM dual

6300: /*bug7168636 handling no data found */
6301: BEGIN
6302: SELECT 'Y'
6303: INTO l_exists
6304: FROM dual
6305: WHERE EXISTS (
6306: SELECT pa_addition_flag
6307: FROM rcv_receiving_sub_ledger
6308: WHERE rcv_transaction_id = l_parent_rcv_id_tbl(i)

Line 6415: FROM dual

6411: /*bug 7168636 handling no data found*/
6412: BEGIN
6413: SELECT 'Y'
6414: INTO l_exists
6415: FROM dual
6416: WHERE EXISTS (
6417: SELECT pa_addition_flag
6418: FROM rcv_receiving_sub_ledger
6419: WHERE rcv_transaction_id = l_parent_rcv_id_tbl(i)

Line 6689: FROM dual

6685: -- Check if the parent has been interfaced to Projects.
6686:
6687: SELECT 'Y'
6688: INTO l_exists
6689: FROM dual
6690: WHERE EXISTS (
6691: SELECT pa_addition_flag
6692: FROM rcv_receiving_sub_ledger
6693: WHERE rcv_transaction_id = l_parent_rcv_id_tbl(i)

Line 6847: INTO G_RCV_INTERFACE_ID FROM dual;

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

Line 6850: INTO G_RCVNRT_INTERFACE_ID FROM dual;

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

Line 7969: FROM dual;

7965: ,l_sc_xfer_code_tbl(i)
7966: ,l_si_assts_add_flg_tbl(i)
7967: ,l_net_zero_flag_tbl(i)
7968: ,0 -- To relieve the cmt. It will not be interfaced from xface in trx imp.
7969: FROM dual;
7970:
7971: -- Insert the reversal of the reversed/cancelled distribution recs from AP.
7972: IF l_create_adj_recs = 'Y' THEN
7973:

Line 8118: FROM dual

8114: and NVL(xface.adjusted_expenditure_item_id,0) =0 ) -- R12 funds management Uptake
8115: ,'P' -- sc_xfer_code
8116: ,l_si_assts_add_flg_tbl(i)
8117: ,l_net_zero_flag_tbl(i)
8118: FROM dual
8119: WHERE l_insert_flag_tbl(i)= 'A';
8120: --WHERE l_net_zero_flag_tbl(i)= 'Y';
8121: END IF;
8122:

Line 8333: FROM dual;

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
8336: l_invoice_id_tbl
8337: ,l_invoice_dist_id_tbl --NEW

Line 9632: FROM DUAL

9628: ,l_ln_type_lookup_tbl(i)
9629: ,l_sc_xfer_code_tbl(i)
9630: ,l_si_assts_add_flg_tbl(i)
9631: ,l_net_zero_flag_tbl(i)
9632: FROM DUAL
9633: WHERE l_insert_flag_tbl(i) not in ('P','F');
9634:
9635: -- Insert the adjustment recs from AP.
9636: IF l_create_adj_recs = 'Y' THEN

Line 9789: FROM dual

9785: and NVL(xface.adjusted_expenditure_item_id,0) = 0 ) -- R12 funds management Uptake
9786: ,'P'
9787: ,'T' -- l_si_assts_add_flg_tbl(i)
9788: ,l_net_zero_flag_tbl(i)
9789: FROM dual
9790: WHERE l_insert_flag_tbl(i)= 'A';
9791: -- WHERE l_net_zero_flag_tbl(i)= 'Y';
9792:
9793: -- Handle both the parent and the reversal getting interfaced into PA

Line 10312: FROM dual;

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

Line 10317: 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';
10320: SELECT pa_interface_id_s.nextval
10321: into G_AP_FRT_INTERFACE_ID

Line 10322: 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';
10325: SELECT pa_interface_id_s.nextval
10326: into G_AP_VAR_INTERFACE_ID

Line 10327: 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';
10330: SELECT pa_interface_id_s.nextval
10331: into G_AP_ERV_INTERFACE_ID

Line 10332: 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
10335: l_inv_pay_id_tbl,
10336: l_invoice_id_tbl,

Line 10574: FROM dual;

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

Line 11354: FROM DUAL

11350: l_Pa_Addition_Flag:=p_Pa_Addition_Flag;
11351:
11352: SELECT 'X'
11353: INTO l_Dummy
11354: FROM DUAL
11355: WHERE EXISTS ( SELECT NULL
11356: FROM rcv_transactions rcv_txn2
11357: ,rcv_receiving_sub_ledger rcv_sub2
11358: WHERE rcv_sub2.rcv_transaction_id = rcv_txn2.transaction_id