APPS.PO_REQ_LINES_SV dependencies on PO_SYSTEM_PARAMETERS

Line 243: PO_SYSTEM_PARAMETERS POSP

239: --Modified the call to procedure to replace req_num and line_num with ids.
240: /* SELECT COUNT(1)
241: INTO X_row_exists
242: FROM PO_REQUISITION_HEADERS PORH, PO_REQUISITION_LINES PORL,
243: PO_SYSTEM_PARAMETERS POSP
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'

Line 255: PO_SYSTEM_PARAMETERS POSP

251: */
252: SELECT COUNT(1)
253: INTO X_row_exists
254: FROM PO_REQUISITION_HEADERS PORH, PO_REQUISITION_LINES PORL,
255: PO_SYSTEM_PARAMETERS POSP
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'

Line 385: X_order_source_id po_system_parameters.order_source_id%TYPE;

381: X_oe_installed_flag IN VARCHAR2) IS
382:
383: X_progress VARCHAR2(3) := NULL;
384: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;
385: X_order_source_id po_system_parameters.order_source_id%TYPE;
386:
387: BEGIN
388:
389: -- dbms_output.put_line('Enter update_reqs_lines_incomplete');

Line 411: from po_system_parameters;

407:
408: BEGIN
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),

Line 487: X_order_source_id PO_SYSTEM_PARAMETERS.order_source_id%TYPE;

483: X_closed_reason PO_REQUISITION_LINES.closed_reason%TYPE := NULL;
484: X_closed_date PO_REQUISITION_LINES.closed_date%TYPE := NULL;
485: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;
486: X_terminal_performed NUMBER(1) := 0; --
487: X_order_source_id PO_SYSTEM_PARAMETERS.order_source_id%TYPE;
488:
489: BEGIN
490:
491: -- dbms_output.put_line('Enter update_reqs_lines_status');

Line 533: from po_system_parameters;

529:
530: BEGIN
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),

Line 1183: X_order_source_id po_system_parameters.order_source_id%TYPE;

1179: (X_req_header_id IN NUMBER,
1180: X_req_line_id IN NUMBER) RETURN BOOLEAN IS
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;

Line 1205: from po_system_parameters;

1201: X_progress := '010';
1202:
1203: select order_source_id
1204: into X_order_source_id
1205: from po_system_parameters;
1206:
1207: X_progress := '020';
1208:
1209: SELECT segment1