APPS.PO_REQ_LINES_SV dependencies on OE_ORDER_IMPORT_INTEROP_PUB

Line 249: AND OE_ORDER_IMPORT_INTEROP_PUB .Get_Open_Qty(POSP.order_source_id,

245: WHERE PORH.requisition_header_id = X_req_header_id
246: AND PORL.requisition_line_id = nvl(X_req_line_id, PORL.requisition_line_id)
247: AND PORH.requisition_header_id = PORL.requisition_header_id
248: AND PORL.source_type_code = 'INVENTORY'
249: AND OE_ORDER_IMPORT_INTEROP_PUB .Get_Open_Qty(POSP.order_source_id,
250: PORH.segment1,
251: PORL.line_num ) > 0 ;
252: */
253: SELECT COUNT(1)

Line 261: AND OE_ORDER_IMPORT_INTEROP_PUB .Get_Open_Qty(POSP.order_source_id,

257: WHERE PORH.requisition_header_id = X_req_header_id
258: AND PORL.requisition_line_id = nvl(X_req_line_id, PORL.requisition_line_id)
259: AND PORH.requisition_header_id = PORL.requisition_header_id
260: AND PORL.source_type_code = 'INVENTORY'
261: AND OE_ORDER_IMPORT_INTEROP_PUB .Get_Open_Qty(POSP.order_source_id,
262: PORH.requisition_header_id,
263: PORL.requisition_line_id ) > 0 ;
264: ELSE
265: /* DEBUG - show error message */

Line 414: X_quantity_cancelled := OE_ORDER_IMPORT_INTEROP_PUB.Get_Cancelled_Qty(

410: select order_source_id
411: into X_order_source_id
412: from po_system_parameters;
413:
414: X_quantity_cancelled := OE_ORDER_IMPORT_INTEROP_PUB.Get_Cancelled_Qty(
415: X_order_source_id,
416: to_char(X_req_header_id),
417: to_char(X_req_line_id));
418: EXCEPTION

Line 536: OE_ORDER_IMPORT_INTEROP_PUB.Get_Cancelled_Qty(

532: x_last_updated_by,
533: x_last_update_date,
534: decode(X_cancel_flag, 'Y', Decode(SOURCE_TYPE_CODE,'INVENTORY',
535: Decode(TRANSFERRED_TO_OE_FLAG,'Y',
536: OE_ORDER_IMPORT_INTEROP_PUB.Get_Cancelled_Qty(
537: X_order_source_id,
538: to_char(X_req_header_id),
539: Nvl(to_char(X_req_line_id), requisition_line_id)),quantity),
540: quantity - quantity_delivered), quantity_cancelled)

Line 1341: X_oe_line_tbl OE_ORDER_IMPORT_INTEROP_PUB.LineId_Tbl_Type;

1337:
1338: X_progress VARCHAR2(3) := NULL;
1339: X_order_source_id po_system_parameters.order_source_id%TYPE;
1340: X_req_num po_requisition_headers_all.segment1%TYPE;
1341: X_oe_line_tbl OE_ORDER_IMPORT_INTEROP_PUB.LineId_Tbl_Type;
1342: X_oe_return VARCHAR2(30);
1343: X_oe_line_ctr NUMBER := 0;
1344:
1345: X_in_rec_type WSH_INTEGRATION.LineIntfInRecType;

Line 1372: OE_ORDER_IMPORT_INTEROP_PUB.Get_Line_Id (

1368: WHERE requisition_header_id = X_req_header_id;
1369:
1370: X_progress := '030';
1371:
1372: OE_ORDER_IMPORT_INTEROP_PUB.Get_Line_Id (
1373: p_order_source_id => X_order_source_id,
1374: p_orig_sys_document_ref => X_req_num,
1375: p_requisition_header_id => X_req_header_id,
1376: p_line_num => NULL,