[Home] [Help]
5:
6:
7: /*============================================================================+
8: | This procedure is called by the Accounting Package for the Accounting Lib. |
9: | It first gets the details of the transaction from RCV_TRANSACTIONS |
10: | for the txn that is being processed. The appropriate procedure is then |
11: | called to create the accounting entry lines in the form of a PL/SQL table |
12: | |
13: | Logic : |
11: | called to create the accounting entry lines in the form of a PL/SQL table |
12: | |
13: | Logic : |
14: | |
15: | For the transaction passed in, get the txn details from RCV_TRANSACTIONS |
16: | If the current txn is period end accrual txn , call create_per_end_ae_lines |
17: | If the current txn is accrual txn, call create_rcv_ae_lines |
18: | Period End Accrual : |
19: | If current transaction is not receive or match, return |
164: INTO
165: l_po_line_count
166: FROM
167: po_lines_all pol,
168: rcv_transactions rt
169: WHERE
170: pol.po_line_id = rt.po_line_id AND
171: rt.transaction_id = i_transaction_id;
172:
249: l_ae_txn_rec.exp_item ,
250: l_ae_txn_rec.line_id,
251: l_ae_txn_rec.lcm_flag
252: FROM
253: rcv_transactions rt,
254: po_lines_all pol,
255: po_line_locations_all poll -- Added for Complex work procurement
256: WHERE
257: rt.po_line_id = pol.po_line_id
340: INTO
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
988: rt6.transaction_id
989: INTO
990: l_par_rcv_txn
991: FROM
992: rcv_transactions rt6
993: WHERE
994: rt6.transaction_type in (l_receive,l_match)
995: START WITH
996: rt6.transaction_id = i_ae_txn_rec.transaction_id
1089: l_acq_cost_ent_po
1090: from
1091: cst_rcv_acq_cost_details cracd,
1092: po_line_locations_all poll,
1093: rcv_transactions rt
1094: where
1095: poll.line_location_id = cracd.po_line_location_id
1096: and cracd.header_id = (select header_id
1097: from cst_rcv_acq_costs crac
1164: INTO
1165: l_par_txn,
1166: l_par_txn_type
1167: FROM
1168: rcv_transactions rt1
1169: WHERE
1170: rt1.transaction_id = (select rt2.parent_transaction_id
1171: FROM
1172: rcv_transactions rt2
1168: rcv_transactions rt1
1169: WHERE
1170: rt1.transaction_id = (select rt2.parent_transaction_id
1171: FROM
1172: rcv_transactions rt2
1173: WHERE
1174: rt2.transaction_id = i_ae_txn_rec.transaction_id);
1175:
1176: END IF;
1232: INTO
1233: l_doc_level,
1234: l_doc_id
1235: FROM
1236: rcv_transactions rt
1237: WHERE
1238: rt.transaction_id = i_ae_txn_rec.transaction_id;
1239:
1240: IF l_debug_flag = 'Y' THEN
1349: -----------------------------------------------------------------------------------------
1350: INTO
1351: l_po_price
1352: FROM
1353: rcv_transactions rt,
1354: po_line_locations_all poll
1355: WHERE
1356: rt.transaction_id = i_ae_txn_rec.transaction_id
1357: AND rt.po_line_location_id = poll.line_location_id;
1707: select org_id
1708: into l_po_ou_id /* Get the OU where PO is created */
1709: from po_headers_all
1710: where po_header_id = (select po_header_id
1711: from rcv_transactions
1712: where transaction_id = i_ae_txn_rec.transaction_id);
1713:
1714: l_stmt_num := 751;
1715:
2198: poll.price_override * rt.source_doc_quantity / rt.primary_quantity)
2199: INTO
2200: l_po_price
2201: FROM
2202: rcv_transactions rt,
2203: po_line_locations_all poll
2204: WHERE
2205: rt.transaction_id = i_ae_txn_rec.transaction_id
2206: AND rt.po_line_location_id = poll.line_location_id;
2488: po_headers_all POH,
2489: po_lines_all POL,
2490: po_line_locations_all POLL,
2491: po_distributions_all POD,
2492: rcv_transactions RT
2493: WHERE
2494: POH.po_header_id = POD.po_header_id AND
2495: POL.po_line_id = POD.po_line_id AND
2496: POLL.line_location_id = POD.line_location_id AND
2525: po_headers_all POH,
2526: po_lines_all POL,
2527: po_line_locations_all POLL,
2528: po_distributions_all POD,
2529: rcv_transactions RT
2530: WHERE
2531: POH.po_header_id = POD.po_header_id
2532: AND POL.po_line_id = POD.po_line_id
2533: AND POLL.line_location_id = POD.line_location_id
3115: INTO
3116: l_doc_level,
3117: l_doc_id
3118: FROM
3119: rcv_transactions rt
3120: WHERE
3121: rt.transaction_id = i_ae_txn_rec.transaction_id;
3122:
3123: IF l_debug_flag = 'Y' THEN
3456: l_operating_unit
3457: FROM
3458: po_headers_all
3459: WHERE
3460: po_header_id = (select po_header_id from rcv_transactions
3461: where transaction_id = i_transaction_id);
3462:
3463:
3464: l_stmt_num := 30;
3728: -- End of Bug 3588765
3729: ----------------------------------------------------------------------------
3730: rt4.parent_transaction_id
3731: FROM
3732: rcv_transactions rt4
3733: -- J Changes -------------------------------------------------------------
3734: -- Bug 3588765 --
3735: -- PO_LINES_ALL POL
3736: -- End of Bug 3588765
3750: prior rt4.transaction_id = rt4.parent_transaction_id
3751: AND rt4.po_line_location_id = PRIOR rt4.po_line_location_id; -- Change for the bug 4968702
3752:
3753: l_nqd NUMBER := 0;
3754: l_parent_type rcv_transactions.transaction_type%TYPE;
3755: l_stmt_num NUMBER := 0;
3756: -- Bug 3588765 --
3757: l_primary_quantity NUMBER := 0;
3758: -- End of Bug 3588765
3770: SELECT DECODE(POLL1.MATCHING_BASIS, -- Changed for Complex work procurement
3771: 'AMOUNT', rt6.AMOUNT,
3772: 'QUANTITY', RT6.PRIMARY_QUANTITY) "PRIMARY_QUANTITY"
3773: INTO l_primary_quantity
3774: FROM rcv_transactions rt6,
3775: PO_LINE_LOCATIONS_ALL POLL1 -- Changed for Complex work procurement
3776: WHERE rt6.transaction_id=c_nqd_rec.transaction_id
3777: AND RT6.PO_LINE_LOCATION_ID= POLL1.LINE_LOCATION_ID; -- Changed for Complex work procurement
3778: -- End of Bug 3588765 ----------------------
3789: rt5.transaction_type
3790: INTO
3791: l_parent_type
3792: FROM
3793: rcv_transactions rt5
3794: WHERE
3795: rt5.transaction_id = c_nqd_rec.parent_transaction_id;
3796: END IF;
3797: ------------------------------------------------------------