APPS.PO_REQ_LINES_SV dependencies on OE_ORDER_IMPORT_INTEROP_PUB

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

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

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

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

Line 413: X_quantity_cancelled := OE_ORDER_IMPORT_INTEROP_PUB.Get_Cancelled_Qty(

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

Line 535: X_quantity_cancelled := OE_ORDER_IMPORT_INTEROP_PUB.Get_Cancelled_Qty(

531: select order_source_id
532: into X_order_source_id
533: from po_system_parameters;
534:
535: X_quantity_cancelled := OE_ORDER_IMPORT_INTEROP_PUB.Get_Cancelled_Qty(
536: X_order_source_id,
537: to_char(X_req_header_id),
538: to_char(X_req_line_id));
539: EXCEPTION

Line 1185: X_oe_line_tbl OE_ORDER_IMPORT_INTEROP_PUB.LineId_Tbl_Type;

1181:
1182: X_progress VARCHAR2(3) := NULL;
1183: X_order_source_id po_system_parameters.order_source_id%TYPE;
1184: X_req_num po_requisition_headers_all.segment1%TYPE;
1185: X_oe_line_tbl OE_ORDER_IMPORT_INTEROP_PUB.LineId_Tbl_Type;
1186: X_oe_return VARCHAR2(30);
1187: X_oe_line_ctr NUMBER := 0;
1188:
1189: X_in_rec_type WSH_INTEGRATION.LineIntfInRecType;

Line 1216: OE_ORDER_IMPORT_INTEROP_PUB.Get_Line_Id (

1212: WHERE requisition_header_id = X_req_header_id;
1213:
1214: X_progress := '030';
1215:
1216: OE_ORDER_IMPORT_INTEROP_PUB.Get_Line_Id (
1217: p_order_source_id => X_order_source_id,
1218: p_orig_sys_document_ref => X_req_num,
1219: p_requisition_header_id => X_req_header_id,
1220: p_line_num => NULL,