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 922: UPDATE rcv_receiving_sub_ledger rcv_sub

918:
919: IF G_ACCTNG_METHOD = 'A' THEN
920:
921: --added the following for PO RECEIPT processing
922: UPDATE rcv_receiving_sub_ledger rcv_sub
923: SET rcv_sub.pa_addition_flag = 'N'
924: ,rcv_sub.request_id = G_REQUEST_ID
925: WHERE rcv_sub.pa_addition_flag = 'O'
926: AND NOT EXISTS (SELECT 'X'

Line 934: UPDATE rcv_receiving_sub_ledger rcv_sub

930: If g_body_debug_mode = 'Y' Then
931: write_log(LOG, 'Number of rcv txn cleaned up from O:' || to_char(SQL%ROWCOUNT));
932: end if;
933:
934: UPDATE rcv_receiving_sub_ledger rcv_sub
935: SET rcv_sub.pa_addition_flag = 'I'
936: WHERE rcv_sub.pa_addition_flag = 'J';
937:
938: If g_body_debug_mode = 'Y' Then

Line 4279: UPDATE rcv_receiving_sub_ledger rcv_sub

4275:
4276: --pricing changes, updating sub_ledger instead of rcv_transactions
4277: -- Modified this update for bug 6825742
4278:
4279: UPDATE rcv_receiving_sub_ledger rcv_sub
4280: SET rcv_sub.pa_addition_flag = 'L'
4281: WHERE rcv_sub.pa_addition_flag = 'N'
4282: and reference3 = TO_CHAR(p_po_distribution_id) and exists (
4283: select 1 from po_distributions_all pod

Line 4289: /* UPDATE rcv_receiving_sub_ledger rcv_sub

4285: and po_distribution_id = p_po_distribution_id
4286: and code_combination_id = rcv_sub.code_combination_id
4287: and accrue_on_receipt_flag = 'Y');
4288:
4289: /* UPDATE rcv_receiving_sub_ledger rcv_sub
4290: SET rcv_sub.pa_addition_flag = 'L'
4291: WHERE rcv_sub.pa_addition_flag = 'N'
4292: AND EXISTS (SELECT transaction_id
4293: FROM rcv_transactions rcv_txn

Line 4321: UPDATE rcv_receiving_sub_ledger rcv_sub

4317:
4318: G_err_stage := 'Within calling tieback_locked_rcvtxn';
4319: write_log(LOG, G_err_stage);
4320:
4321: UPDATE rcv_receiving_sub_ledger rcv_sub
4322: SET rcv_sub.pa_addition_flag = 'G'
4323: WHERE rcv_sub.pa_addition_flag = 'L';
4324:
4325: l_num_rows := SQL%ROWCOUNT;

Line 5568: UPDATE rcv_receiving_sub_ledger rcv_sub

5564: /* Modified the below update statement for better performence bug#7526677
5565: Not commenting and doing the changes because it has already become a mess with these updates
5566: */
5567:
5568: UPDATE rcv_receiving_sub_ledger rcv_sub
5569: SET rcv_sub.pa_Addition_Flag = decode(rcv_sub.pa_addition_flag,'N','O','I','J'),
5570: rcv_sub.request_id = G_REQUEST_ID,
5571: rcv_sub.last_update_date = SYSDATE,
5572: rcv_sub.last_updated_by = G_USER_ID,

Line 5616: UPDATE rcv_receiving_sub_ledger rcv_sub

5612: /* Modified the below update statement for better performence bug#7526677
5613: Not commenting and doing the changes because it has already become a mess with these updates
5614: */
5615:
5616: UPDATE rcv_receiving_sub_ledger rcv_sub
5617: SET rcv_sub.pa_Addition_Flag = decode(rcv_sub.pa_addition_flag,'N','O','I','J'),
5618: rcv_sub.request_id = G_REQUEST_ID,
5619: rcv_sub.last_update_date = SYSDATE,
5620: rcv_sub.last_updated_by = G_USER_ID,

Line 6307: FROM rcv_receiving_sub_ledger

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)
6309: AND pa_addition_flag in ('Y','I')) ;
6310: EXCEPTION
6311: WHEN NO_DATA_FOUND THEN

Line 6418: FROM rcv_receiving_sub_ledger

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)
6420: AND pa_addition_flag in ('Y','I')) ;
6421: EXCEPTION
6422: WHEN NO_DATA_FOUND THEN

Line 6582: UPDATE rcv_receiving_sub_ledger rcv_sub

6578: END LOOP; /* End of looping through each record in plsql table */
6579:
6580: -- Update to set all the transactions that got interfaced through AP to 'G'
6581: FORALL i IN l_rcv_txn_id_tbl.FIRST..l_rcv_txn_id_tbl.LAST
6582: UPDATE rcv_receiving_sub_ledger rcv_sub
6583: SET rcv_sub.pa_addition_flag = decode(l_pa_add_flag_tbl(i),'G','G',pa_addition_flag)
6584: WHERE rcv_sub.rcv_transaction_id = l_rcv_txn_id_tbl(i)
6585: AND rcv_sub.pa_addition_flag = 'O'
6586: AND l_insert_flag_tbl(i) = 'N' ;

Line 6692: FROM rcv_receiving_sub_ledger

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)
6694: AND pa_addition_flag in ('Y','I')) ;
6695:
6696: -- Should we call this api at all? This api processes the records

Line 7203: UPDATE rcv_receiving_sub_ledger rcv_sub -- pricing changes

7199: FORALL i IN l_sys_ref1_tbl.FIRST..l_sys_ref1_tbl.LAST
7200:
7201: /* Code combination Id join is required so that the record whichw as earlier updated to X does nto get updated to Y */
7202:
7203: UPDATE rcv_receiving_sub_ledger rcv_sub -- pricing changes
7204: SET rcv_sub.pa_addition_flag = l_pa_addflag_tbl(i)
7205: WHERE rcv_sub.rcv_transaction_id = l_sys_ref4_tbl(i)
7206: AND (rcv_sub.accounting_event_id = l_rcv_acct_evt_id_tbl(i) OR rcv_sub.accounting_event_id IS NULL)
7207: AND rcv_sub.code_combination_id = l_dr_ccid_tbl(i)

Line 7514: , rcv_receiving_sub_ledger rcv_sub

7510: AND apdist1.po_distribution_id = dist.po_distribution_id
7511: )
7512: OR EXISTS ( SELECT rcv_txn.po_distribution_id
7513: FROM rcv_transactions rcv_txn
7514: , rcv_receiving_sub_ledger rcv_sub
7515: WHERE rcv_txn.po_distribution_id = dist.po_distribution_id
7516: AND rcv_sub.pa_addition_flag || '' IN ('Y','I')
7517: AND rcv_sub.rcv_transaction_id = rcv_txn.transaction_id
7518: )

Line 7643: , rcv_receiving_sub_ledger rcv_sub

7639: AND apdist1.po_distribution_id = dist.po_distribution_id
7640: )
7641: OR EXISTS ( SELECT rcv_txn.po_distribution_id
7642: FROM rcv_transactions rcv_txn
7643: , rcv_receiving_sub_ledger rcv_sub
7644: WHERE rcv_txn.po_distribution_id = dist.po_distribution_id
7645: AND rcv_sub.pa_addition_flag || '' IN ('Y','I')
7646: AND rcv_sub.rcv_transaction_id = rcv_txn.transaction_id
7647: )

Line 11357: ,rcv_receiving_sub_ledger rcv_sub2

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
11359: AND rcv_txn2.po_distribution_id = P_Po_Distribution_Id
11360: AND rcv_sub2.pa_addition_flag = 'G'
11361: UNION ALL