DBA Data[Home] [Help]

APPS.PO_AUTO_HEADER_PROCESS_PVT dependencies on PO_HEADERS_S

Line 747: SELECT po_headers_s.nextval INTO x_headers.po_header_id FROM sys.dual;

743: ELSIF (PO_AUTOCREATE_PARAMS.g_mode='NEW') THEN
744:
745: l_progress := '020';
746:
747: SELECT po_headers_s.nextval INTO x_headers.po_header_id FROM sys.dual;
748:
749: IF (PO_AUTOCREATE_PARAMS.g_sys.user_defined_po_num_code='AUTOMATIC') AND (PO_AUTOCREATE_PARAMS.g_document_type IN ('PO','PA')) THEN
750:
751: --< Bug 14314684 Create Workflow project >

Line 1025: x_valid_ship_to po_headers.ship_to_location_id%TYPE;

1021: IS
1022:
1023: l_progress VARCHAR2(3) := '000';
1024: l_api_name CONSTANT VARCHAR2(30) := 'validate_header';
1025: x_valid_ship_to po_headers.ship_to_location_id%TYPE;
1026: x_valid_bill_to po_headers.bill_to_location_id%TYPE;
1027: x_is_valid VARCHAR(1) := 'N';
1028:
1029: BEGIN