APPS.PO_REQ_LINES_SV dependencies on PO_SYSTEM_PARAMETERS

Line 244: PO_SYSTEM_PARAMETERS POSP

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

Line 256: PO_SYSTEM_PARAMETERS POSP

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

Line 386: X_order_source_id po_system_parameters.order_source_id%TYPE;

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

Line 412: from po_system_parameters;

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

Line 488: X_order_source_id PO_SYSTEM_PARAMETERS.order_source_id%TYPE;

484: X_closed_reason PO_REQUISITION_LINES.closed_reason%TYPE := NULL;
485: X_closed_date PO_REQUISITION_LINES.closed_date%TYPE := NULL;
486: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;
487: X_terminal_performed NUMBER(1) := 0; --
488: X_order_source_id PO_SYSTEM_PARAMETERS.order_source_id%TYPE;
489: x_last_update_login po_requisition_lines.last_update_login%TYPE := fnd_global.login_id;
490: x_last_updated_by po_requisition_lines.last_updated_by%TYPE := fnd_global.user_id;
491: x_last_update_date po_requisition_lines.last_update_date%TYPE := SYSDATE;
492:

Line 592: from po_system_parameters;

588:
589: BEGIN
590: select order_source_id
591: into X_order_source_id
592: from po_system_parameters;
593:
594: -- for bug 16240233 adding exception clause to handle cases of req lines not transferred to OE.
595:
596: EXCEPTION

Line 1339: X_order_source_id po_system_parameters.order_source_id%TYPE;

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

Line 1361: from po_system_parameters;

1357: X_progress := '010';
1358:
1359: select order_source_id
1360: into X_order_source_id
1361: from po_system_parameters;
1362:
1363: X_progress := '020';
1364:
1365: SELECT segment1