[Home] [Help]
1233: x_result out NOCOPY boolean,
1234: X_Msg_Count out NOCOPY number,
1235: X_Msg_Data out NOCOPY varchar2) as
1236:
1237: l_reservation_id mtl_reservations.reservation_id%type;
1238:
1239: BEGIN
1240:
1241: IF PG_DEBUG <> 0 THEN
1254:
1255: SELECT reservation_id
1256: INTO l_reservation_id
1257: FROM
1258: mtl_reservations mr,
1259: oe_order_lines_all oel,
1260: oe_order_headers_all oeh,
1261: oe_transaction_types_all ota,
1262: oe_transaction_types_tl otl,
1420: -- Introdcued this to get a unique user name
1421: -- based on the Buyer on the PO
1422: CURSOR get_buyer_from_po(config_line_id IN NUMBER) IS
1423: select u.user_name
1424: from mtl_reservations mr,
1425: po_headers_all poh,
1426: oe_order_lines_all oel,
1427: fnd_user u
1428: where oel.line_id = config_line_id and
1437: -- Introdcued this to get a unique user name
1438: -- based on the Buyer on the PO req line
1439: CURSOR get_buyer_from_po_req_line(config_line_id IN NUMBER) IS
1440: select u.user_name
1441: from mtl_reservations mr,
1442: po_requisition_headers_all porh,
1443: po_requisition_lines_all porl,
1444: oe_order_lines_all oel,
1445: fnd_user u
2664: --OPM
2665: l_supply_qty2 number := 0;
2666: k number;
2667:
2668: l_prim_uom_code mtl_reservations.primary_uom_code%TYPE;
2669:
2670:
2671: Begin
2672:
2930: -- sum of reservations - flow quanity.
2931:
2932: --modified the code for secondary quantity change for OPM.
2933: --decision was made to use same API inorder minimize the db hit
2934: --on mtl_reservations table when the primary and sec qty change in
2935: --a single session
2936:
2937: lStmtNumber := 40;
2938: