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_TRANSACTION_INTERFACE_ALL

Line 3775: INSERT INTO pa_transaction_interface_all(

3771: End If;
3772:
3773: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
3774:
3775: INSERT INTO pa_transaction_interface_all(
3776: transaction_source
3777: , user_transaction_source
3778: , system_linkage
3779: , batch_name

Line 3925: INSERT INTO pa_transaction_interface_all(

3921: write_log(LOG, 'Inserting adjustment records..');
3922:
3923:
3924: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
3925: INSERT INTO pa_transaction_interface_all(
3926: transaction_source
3927: , user_transaction_source
3928: , system_linkage
3929: , batch_name

Line 4085: UPDATE pa_transaction_interface_all xface

4081: FOR i in l_rev_child_dist_id_tbl.FIRST ..l_rev_child_dist_id_tbl.LAST LOOP
4082:
4083: IF l_rev_child_dist_id_tbl(i) > 0 THEN
4084:
4085: UPDATE pa_transaction_interface_all xface
4086: SET xface.net_zero_adjustment_flag ='Y',
4087: xface.adjusted_txn_interface_id =
4088: (select distinct xface1.txn_interface_id /*Added Distinct for bug 9266578 */
4089: from pa_transaction_interface xface1

Line 5169: FROM pa_transaction_interface_all txnintf

5165: ,project_id
5166: ,l_pa_addflag
5167: ,l_assets_addflag
5168: ,document_distribution_type /*Bug 13602288: Self Assessed Tax Changes*/
5169: FROM pa_transaction_interface_all txnintf
5170: WHERE txnintf.transaction_source = p_txn_src
5171: AND txnintf.batch_name = p_batch_name
5172: AND txnintf.interface_id = p_interface_id;
5173:

Line 6038: INSERT INTO pa_transaction_interface_all(

6034:
6035: --FORALL i IN l_inv_pay_id_tbl.FIRST..l_inv_pay_id_tbl.LAST
6036: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
6037:
6038: INSERT INTO pa_transaction_interface_all(
6039: transaction_source
6040: , user_transaction_source
6041: , system_linkage
6042: , batch_name

Line 6179: INSERT INTO pa_transaction_interface_all(

6175: write_log(LOG, 'Inserting adjustment records..');
6176: --FORALL i IN l_inv_pay_id_tbl.FIRST..l_inv_pay_id_tbl.LAST
6177: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
6178:
6179: INSERT INTO pa_transaction_interface_all(
6180: transaction_source
6181: , user_transaction_source
6182: , system_linkage
6183: , batch_name

Line 6332: UPDATE pa_transaction_interface_all xface

6328: FOR i in l_rev_child_dist_id_tbl.FIRST ..l_rev_child_dist_id_tbl.LAST LOOP
6329:
6330: IF l_rev_child_dist_id_tbl(i) > 0 THEN
6331:
6332: UPDATE pa_transaction_interface_all xface
6333: SET xface.net_zero_adjustment_flag ='Y',
6334: xface.adjusted_txn_interface_id =
6335: (select distinct xface1.txn_interface_id /* bug 9266578 */
6336: from pa_transaction_interface xface1

Line 7217: INSERT INTO pa_transaction_interface_all(

7213: BEGIN
7214:
7215: FORALL i IN l_rcv_txn_id_tbl.FIRST..l_rcv_txn_id_tbl.LAST
7216:
7217: INSERT INTO pa_transaction_interface_all(
7218: transaction_source
7219: , user_transaction_source
7220: , system_linkage
7221: , batch_name

Line 7359: INSERT INTO pa_transaction_interface_all(

7355: write_log(LOG, 'Inserting adjustment records..');
7356:
7357: FORALL i IN l_rcv_txn_id_tbl.FIRST..l_rcv_txn_id_tbl.LAST
7358:
7359: INSERT INTO pa_transaction_interface_all(
7360: transaction_source
7361: , user_transaction_source
7362: , system_linkage
7363: , batch_name

Line 8569: FROM pa_transaction_interface_all txnintf

8565: ,project_id
8566: ,l_pa_addflag
8567: ,orig_exp_txn_reference2 -- pricing changes
8568: ,dr_code_combination_id
8569: FROM pa_transaction_interface_all txnintf
8570: WHERE txnintf.transaction_source = p_txn_src
8571: AND txnintf.batch_name = p_batch_name
8572: AND txnintf.interface_id = p_interface_id;
8573:

Line 8830: UPDATE pa_transaction_interface_all

8826: for NRTAX */
8827:
8828: write_log(LOG,'Batch Name and Interface Id is : '||G_RCVTAX_BATCH_NAME||' '||G_UNIQUE_ID);
8829:
8830: UPDATE pa_transaction_interface_all
8831: SET transaction_status_code = 'T'
8832: WHERE batch_name = G_RCVTAX_BATCH_NAME /* p_batch_name changed for #2912545 */
8833: AND interface_id = G_RCVNRT_INTERFACE_ID /* p_interface_id changed for #2912545 */
8834: AND transaction_source = 'PO RECEIPT NRTAX' /* PO RECEIPT TAX. changed for #2912545 */

Line 8840: UPDATE pa_transaction_interface_all

8836: AND cdl_system_reference3 = v_po_dist_id
8837: AND cdl_system_reference4 = v_txn_id;
8838:
8839: -- pricing changes
8840: UPDATE pa_transaction_interface_all
8841: SET transaction_status_code = 'T'
8842: WHERE batch_name = G_RCVTAX_BATCH_NAME /* p_batch_name changed for #2912545 */
8843: AND interface_id = G_RCVNRT_INTERFACE_ID /* p_interface_id changed for #2912545 */
8844: AND transaction_source = 'PO RECEIPT NRTAX PRICE ADJ' /* PO RECEIPT TAX. changed for #2912545 */

Line 9509: INSERT INTO pa_transaction_interface_all(

9505: BEGIN
9506:
9507: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
9508:
9509: INSERT INTO pa_transaction_interface_all(
9510: transaction_source
9511: , user_transaction_source
9512: , system_linkage
9513: , batch_name

Line 9655: INSERT INTO pa_transaction_interface_all(

9651: write_log(LOG, 'Inserting adjustment records..');
9652: End if;
9653:
9654: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
9655: INSERT INTO pa_transaction_interface_all(
9656: transaction_source
9657: , user_transaction_source
9658: , system_linkage
9659: , batch_name

Line 10218: FROM pa_transaction_interface_all txnintf

10214: ,project_id
10215: ,l_pa_addflag
10216: ,l_assets_addflag
10217: ,expenditure_item_id /* Bug 8709614 */
10218: FROM pa_transaction_interface_all txnintf
10219: WHERE txnintf.transaction_source = p_txn_src
10220: AND txnintf.batch_name = p_batch_name
10221: AND txnintf.interface_id = p_interface_id;
10222:

Line 11215: INSERT INTO pa_transaction_interface_all(

11211: BEGIN
11212:
11213: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
11214:
11215: INSERT INTO pa_transaction_interface_all(
11216: transaction_source
11217: , user_transaction_source
11218: , system_linkage
11219: , batch_name

Line 11363: INSERT INTO pa_transaction_interface_all(

11359: write_log(LOG, 'Inserting adjustment records..');
11360:
11361: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
11362:
11363: INSERT INTO pa_transaction_interface_all(
11364: transaction_source
11365: , user_transaction_source
11366: , system_linkage
11367: , batch_name

Line 11522: UPDATE pa_transaction_interface_all xface

11518: write_log(LOG, 'Updating adjustment records..');
11519: IF l_rev_child_dist_id_tbl.exists(1) THEN
11520: FOR i in l_rev_child_dist_id_tbl.FIRST ..l_rev_child_dist_id_tbl.LAST LOOP
11521: IF l_rev_child_dist_id_tbl(i) > 0 THEN
11522: UPDATE pa_transaction_interface_all xface
11523: SET xface.net_zero_adjustment_flag ='Y',
11524: xface.adjusted_txn_interface_id =
11525: (select distinct xface1.txn_interface_id /* bug 9266578 */
11526: from pa_transaction_interface xface1

Line 12558: FROM pa_transaction_interface_all txnintf

12554: ,transaction_status_code
12555: ,project_id
12556: ,l_pa_addflag
12557: ,l_assets_addflag
12558: FROM pa_transaction_interface_all txnintf
12559: WHERE txnintf.transaction_source = p_txn_src
12560: AND txnintf.batch_name = p_batch_name
12561: AND txnintf.interface_id = p_interface_id;
12562: