APPS.CSTPAPPR dependencies on RCV_ACCOUNTING_EVENTS

Line 278: -- Populate the transaction details from RCV_ACCOUNTING_EVENTS

274: ELSIF l_ae_txn_rec.txn_type_flag = 'ADJ' THEN
275: IF l_debug_flag = 'Y' THEN
276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RetroActive Price Adjust Event');
277: END IF;
278: -- Populate the transaction details from RCV_ACCOUNTING_EVENTS
279: l_ae_txn_rec.source_table := 'RAE';
280: l_ae_txn_rec.source_id := i_transaction_id;
281: l_ae_txn_rec.cost_group_id := i_cost_group_id;
282: l_ae_txn_rec.legal_entity_id := i_legal_entity;

Line 322: RCV_ACCOUNTING_EVENTS

318: l_ae_txn_rec.credit_account,
319: l_ae_txn_rec.organization_id,
320: l_ae_txn_rec.po_distribution_id
321: FROM
322: RCV_ACCOUNTING_EVENTS
323: WHERE
324: ACCOUNTING_EVENT_ID = i_transaction_id;
325:
326: -- Rest of the fields in l_ae_txn_rec are NULL.. Is initialization to NULL

Line 345: rcv_accounting_events rae

341: l_po_line_count
342: FROM
343: po_lines_all pol,
344: rcv_transactions rt,
345: rcv_accounting_events rae
346: WHERE
347: pol.po_line_id = rt.po_line_id AND
348: rt.transaction_id = rae.rcv_transaction_id AND
349: rae.accounting_event_id = i_transaction_id;

Line 432: rcv_accounting_events rae,

428: l_ae_txn_rec.flow_schedule,
429: l_ae_txn_rec.exp_item ,
430: l_ae_txn_rec.line_id
431: FROM
432: rcv_accounting_events rae,
433: po_lines_all pol,
434: po_line_locations_all poll -- Added for Complex work procurement
435: WHERE
436: pol.po_line_id = RAE.PO_LINE_ID AND

Line 448: -- Populate the transaction details from RCV_ACCOUNTING_EVENTS

444: ELSIF l_ae_txn_rec.txn_type_flag = 'LC ADJ' THEN
445: IF l_debug_flag = 'Y' THEN
446: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Landed Cost Adjust Event');
447: END IF;
448: -- Populate the transaction details from RCV_ACCOUNTING_EVENTS
449: l_ae_txn_rec.source_table := 'RAE';
450: l_ae_txn_rec.source_id := i_transaction_id;
451: l_ae_txn_rec.cost_group_id := i_cost_group_id;
452: l_ae_txn_rec.legal_entity_id := i_legal_entity;

Line 490: RCV_ACCOUNTING_EVENTS

486: l_ae_txn_rec.debit_account,
487: l_ae_txn_rec.organization_id,
488: l_ae_txn_rec.po_distribution_id
489: FROM
490: RCV_ACCOUNTING_EVENTS
491: WHERE
492: ACCOUNTING_EVENT_ID = i_transaction_id;
493: ELSE
494: RAISE CST_TXN_TYPE_FAIL;

Line 740: from rcv_accounting_events rae,

736: 'QUANTITY', rae.unit_price)
737: into l_debit_acct_id, l_credit_acct_id,
738: l_po_dist_id,
739: l_unit_price
740: from rcv_accounting_events rae,
741: PO_LINE_LOCATIONS_ALL POLL -- Changed for Complex work procurement
742: where rae.accounting_event_id = i_ae_txn_rec.transaction_id
743: and RAE.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID; -- Changed for Complex work procurement
744:

Line 1682: from rcv_accounting_events

1678:
1679: begin
1680: select credit_account_id, debit_account_id
1681: into l_credit_Account, l_debit_account
1682: from rcv_accounting_events
1683: where rcv_transaction_id = i_ae_txn_rec.transaction_id
1684: and organization_id = i_ae_txn_rec.organization_id
1685: and event_type_id = 1
1686: and rownum = 1;