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 1713: from rcv_accounting_events

1709:
1710: begin
1711: select credit_account_id, debit_account_id
1712: into l_credit_Account, l_debit_account
1713: from rcv_accounting_events
1714: where rcv_transaction_id = i_ae_txn_rec.transaction_id
1715: and organization_id = i_ae_txn_rec.organization_id
1716: and rownum = 1;
1717:

Line 2509: from rcv_accounting_events

2505: /*Bug 14602236 both 5 and 16 type need to get the correct currency conversion rate and related information for global procurement scenario, so we get them directly from RAE
2506: , then prevent to get the conversion rate form the procurement organizations for phsical txn, it is not correct.*/
2507: select currency_conversion_rate, currency_conversion_date, currency_conversion_type
2508: into l_curr_rec.currency_conv_rate, l_curr_rec.currency_conv_date, l_curr_rec.currency_conv_type
2509: from rcv_accounting_events
2510: where rcv_transaction_id = i_ae_txn_rec.transaction_id
2511: and organization_id = i_ae_txn_rec.organization_id
2512: and accounting_event_id = (
2513: select min(accounting_event_id)

Line 2514: from rcv_accounting_events

2510: where rcv_transaction_id = i_ae_txn_rec.transaction_id
2511: and organization_id = i_ae_txn_rec.organization_id
2512: and accounting_event_id = (
2513: select min(accounting_event_id)
2514: from rcv_accounting_events
2515: where rcv_transaction_id = i_ae_txn_rec.transaction_id
2516: and organization_id = i_ae_txn_rec.organization_id
2517: );
2518:

Line 2566: from rcv_accounting_events

2562: RECEIVE*/
2563: begin
2564: select credit_account_id, debit_account_id
2565: into l_credit_Account, l_debit_account
2566: from rcv_accounting_events
2567: where rcv_transaction_id = i_ae_txn_rec.transaction_id
2568: and organization_id = i_ae_txn_rec.organization_id
2569: and accounting_event_id = (
2570: select min(accounting_event_id)

Line 2571: from rcv_accounting_events

2567: where rcv_transaction_id = i_ae_txn_rec.transaction_id
2568: and organization_id = i_ae_txn_rec.organization_id
2569: and accounting_event_id = (
2570: select min(accounting_event_id)
2571: from rcv_accounting_events
2572: where rcv_transaction_id = i_ae_txn_rec.transaction_id
2573: and organization_id = i_ae_txn_rec.organization_id
2574: );
2575:

Line 2651: from rcv_accounting_events

2647: DELIVER txn*/
2648: begin
2649: select credit_account_id, debit_account_id, currency_conversion_rate, currency_conversion_date, currency_conversion_type
2650: into l_credit_Account, l_debit_account, l_curr_rec.currency_conv_rate, l_curr_rec.currency_conv_date, l_curr_rec.currency_conv_type
2651: from rcv_accounting_events
2652: where rcv_transaction_id = i_ae_txn_rec.transaction_id
2653: and organization_id = i_ae_txn_rec.organization_id
2654: and accounting_event_id = (
2655: select min(accounting_event_id)

Line 2656: from rcv_accounting_events

2652: where rcv_transaction_id = i_ae_txn_rec.transaction_id
2653: and organization_id = i_ae_txn_rec.organization_id
2654: and accounting_event_id = (
2655: select min(accounting_event_id)
2656: from rcv_accounting_events
2657: where rcv_transaction_id = i_ae_txn_rec.transaction_id
2658: and organization_id = i_ae_txn_rec.organization_id
2659: );
2660: