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 RCV_RECEIVING_SUB_LEDGER

Line 940: UPDATE rcv_receiving_sub_ledger rcv_sub

936:
937: IF G_ACCTNG_METHOD = 'A' THEN
938:
939: --added the following for PO RECEIPT processing
940: UPDATE rcv_receiving_sub_ledger rcv_sub
941: SET rcv_sub.pa_addition_flag = 'N'
942: ,rcv_sub.request_id = G_REQUEST_ID
943: WHERE rcv_sub.pa_addition_flag = 'O'
944: AND NOT EXISTS (SELECT 'X'

Line 952: UPDATE rcv_receiving_sub_ledger rcv_sub

948: If g_body_debug_mode = 'Y' Then
949: write_log(LOG, 'Number of rcv txn cleaned up from O:' || to_char(SQL%ROWCOUNT));
950: end if;
951:
952: UPDATE rcv_receiving_sub_ledger rcv_sub
953: SET rcv_sub.pa_addition_flag = 'I'
954: WHERE rcv_sub.pa_addition_flag = 'J';
955:
956: If g_body_debug_mode = 'Y' Then

Line 2688: AND NOT EXISTS (select 'X' from rcv_receiving_sub_ledger rcv_sub,

2684: )
2685: )
2686: )
2687: )/* Start changes for bug#14320909 */
2688: AND NOT EXISTS (select 'X' from rcv_receiving_sub_ledger rcv_sub,
2689: po_distributions_all po_dist1
2690: where po_dist1.CODE_COMBINATION_ID =rcv_sub.CODE_COMBINATION_ID
2691: AND rcv_sub.ACTUAL_FLAG = 'A'
2692: and rcv_sub.pa_addition_flag ='Y'

Line 3132: AND NOT EXISTS (select 'X' from rcv_receiving_sub_ledger rcv_sub,

3128: )
3129: )
3130: )
3131: )/* Start changes for bug#14320909 */
3132: AND NOT EXISTS (select 'X' from rcv_receiving_sub_ledger rcv_sub,
3133: po_distributions_all po_dist1
3134: where po_dist1.CODE_COMBINATION_ID =rcv_sub.CODE_COMBINATION_ID
3135: AND rcv_sub.ACTUAL_FLAG = 'A'
3136: and rcv_sub.pa_addition_flag ='Y'

Line 5435: UPDATE rcv_receiving_sub_ledger rcv_sub

5431:
5432: --pricing changes, updating sub_ledger instead of rcv_transactions
5433: -- Modified this update for bug 6825742
5434:
5435: UPDATE rcv_receiving_sub_ledger rcv_sub
5436: SET rcv_sub.pa_addition_flag = 'L'
5437: WHERE rcv_sub.pa_addition_flag = 'N'
5438: and reference3 = TO_CHAR(p_po_distribution_id) and exists (
5439: select 1 from po_distributions_all pod

Line 5445: /* UPDATE rcv_receiving_sub_ledger rcv_sub

5441: and po_distribution_id = p_po_distribution_id
5442: and code_combination_id = rcv_sub.code_combination_id
5443: and accrue_on_receipt_flag = 'Y');
5444:
5445: /* UPDATE rcv_receiving_sub_ledger rcv_sub
5446: SET rcv_sub.pa_addition_flag = 'L'
5447: WHERE rcv_sub.pa_addition_flag = 'N'
5448: AND EXISTS (SELECT transaction_id
5449: FROM rcv_transactions rcv_txn

Line 5477: UPDATE rcv_receiving_sub_ledger rcv_sub

5473:
5474: G_err_stage := 'Within calling tieback_locked_rcvtxn';
5475: write_log(LOG, G_err_stage);
5476:
5477: UPDATE rcv_receiving_sub_ledger rcv_sub
5478: SET rcv_sub.pa_addition_flag = 'G'
5479: WHERE rcv_sub.pa_addition_flag = 'L';
5480:
5481: l_num_rows := SQL%ROWCOUNT;

Line 6912: UPDATE rcv_receiving_sub_ledger rcv_sub

6908: /* Modified the below update statement for better performence bug#7526677
6909: Not commenting and doing the changes because it has already become a mess with these updates
6910: */
6911:
6912: UPDATE rcv_receiving_sub_ledger rcv_sub
6913: SET rcv_sub.pa_Addition_Flag = decode(rcv_sub.pa_addition_flag,'N','O','I','J'),
6914: rcv_sub.request_id = G_REQUEST_ID,
6915: rcv_sub.last_update_date = SYSDATE,
6916: rcv_sub.last_updated_by = G_USER_ID,

Line 6997: UPDATE rcv_receiving_sub_ledger rcv_sub

6993: /* Modified the below update statement for better performence bug#7526677
6994: Not commenting and doing the changes because it has already become a mess with these updates
6995: */
6996:
6997: UPDATE rcv_receiving_sub_ledger rcv_sub
6998: SET rcv_sub.pa_Addition_Flag = decode(rcv_sub.pa_addition_flag,'N','O','I','J'),
6999: rcv_sub.request_id = G_REQUEST_ID,
7000: rcv_sub.last_update_date = SYSDATE,
7001: rcv_sub.last_updated_by = G_USER_ID,

Line 7765: FROM rcv_receiving_sub_ledger

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)
7767: AND pa_addition_flag in ('Y','I')) ;
7768: EXCEPTION
7769: WHEN NO_DATA_FOUND THEN

Line 7876: FROM rcv_receiving_sub_ledger

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)
7878: AND pa_addition_flag in ('Y','I')) ;
7879: EXCEPTION
7880: WHEN NO_DATA_FOUND THEN

Line 8040: UPDATE rcv_receiving_sub_ledger rcv_sub

8036: END LOOP; /* End of looping through each record in plsql table */
8037:
8038: -- Update to set all the transactions that got interfaced through AP to 'G'
8039: FORALL i IN l_rcv_txn_id_tbl.FIRST..l_rcv_txn_id_tbl.LAST
8040: UPDATE rcv_receiving_sub_ledger rcv_sub
8041: SET rcv_sub.pa_addition_flag = decode(l_pa_add_flag_tbl(i),'G','G',pa_addition_flag)
8042: WHERE rcv_sub.rcv_transaction_id = l_rcv_txn_id_tbl(i)
8043: AND rcv_sub.pa_addition_flag = 'O'
8044: AND l_insert_flag_tbl(i) = 'N' ;

Line 8151: FROM rcv_receiving_sub_ledger

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)
8153: AND pa_addition_flag in ('Y','I')) ;
8154: exception
8155: when others then

Line 8667: UPDATE rcv_receiving_sub_ledger rcv_sub -- pricing changes

8663: FORALL i IN l_sys_ref1_tbl.FIRST..l_sys_ref1_tbl.LAST
8664:
8665: /* Code combination Id join is required so that the record whichw as earlier updated to X does nto get updated to Y */
8666:
8667: UPDATE rcv_receiving_sub_ledger rcv_sub -- pricing changes
8668: SET rcv_sub.pa_addition_flag = l_pa_addflag_tbl(i)
8669: WHERE rcv_sub.rcv_transaction_id = l_sys_ref4_tbl(i)
8670: AND (rcv_sub.accounting_event_id = l_rcv_acct_evt_id_tbl(i) OR rcv_sub.accounting_event_id IS NULL)
8671: AND rcv_sub.code_combination_id = l_dr_ccid_tbl(i)

Line 9018: , rcv_receiving_sub_ledger rcv_sub

9014: AND apdist1.Line_Type_Lookup_Code <> 'PREPAY' /*Changes for bug 7650946 -- End */
9015: )
9016: OR EXISTS ( SELECT rcv_txn.po_distribution_id
9017: FROM rcv_transactions rcv_txn
9018: , rcv_receiving_sub_ledger rcv_sub
9019: WHERE rcv_txn.po_distribution_id = dist.po_distribution_id
9020: AND rcv_sub.pa_addition_flag || '' IN ('Y','I')
9021: AND rcv_sub.rcv_transaction_id = rcv_txn.transaction_id
9022: )

Line 9093: , rcv_receiving_sub_ledger rcv_sub

9089: AND apdist1.Line_Type_Lookup_Code <> 'PREPAY' /*Changes for bug 7650946 -- End
9090: )
9091: OR EXISTS ( SELECT rcv_txn.po_distribution_id
9092: FROM rcv_transactions rcv_txn
9093: , rcv_receiving_sub_ledger rcv_sub
9094: WHERE rcv_txn.po_distribution_id = dist.po_distribution_id
9095: AND rcv_sub.pa_addition_flag || '' IN ('Y','I')
9096: AND rcv_sub.rcv_transaction_id = rcv_txn.transaction_id
9097: )

Line 9239: , rcv_receiving_sub_ledger rcv_sub

9235: AND apdist1.Line_Type_Lookup_Code <> 'PREPAY' /*Changes for bug 7650946 -- End */
9236: )
9237: OR EXISTS ( SELECT rcv_txn.po_distribution_id
9238: FROM rcv_transactions rcv_txn
9239: , rcv_receiving_sub_ledger rcv_sub
9240: WHERE rcv_txn.po_distribution_id = dist.po_distribution_id
9241: AND rcv_sub.pa_addition_flag || '' IN ('Y','I')
9242: AND rcv_sub.rcv_transaction_id = rcv_txn.transaction_id
9243: )

Line 9314: , rcv_receiving_sub_ledger rcv_sub

9310: AND apdist1.Line_Type_Lookup_Code <> 'PREPAY' /*Changes for bug 7650946 -- End
9311: )
9312: OR EXISTS ( SELECT rcv_txn.po_distribution_id
9313: FROM rcv_transactions rcv_txn
9314: , rcv_receiving_sub_ledger rcv_sub
9315: WHERE rcv_txn.po_distribution_id = dist.po_distribution_id
9316: AND rcv_sub.pa_addition_flag || '' IN ('Y','I')
9317: AND rcv_sub.rcv_transaction_id = rcv_txn.transaction_id
9318: )

Line 13147: ,rcv_receiving_sub_ledger rcv_sub2

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
13149: AND rcv_txn2.po_distribution_id = P_Po_Distribution_Id
13150: AND rcv_sub2.pa_addition_flag = 'G'
13151: UNION ALL