APPS.PO_CREATE_REQUISITION_SV dependencies on PO_REQUISITION_HEADERS

Line 587: Minimum validations are considered when populating PO_REQUISITION_HEADERS and

583:
584: This package assumes that there is only one distribution per order line, since
585: Order Line cannot be shipped to multiple locations.
586:
587: Minimum validations are considered when populating PO_REQUISITION_HEADERS and
588: PO_REQUISITION_LINES. However, when populating PO_REQ_DISTRIBUTIONS,validations
589: related to ACCOUNTS are done.
590:
591: This package assumes that Inventory Item ID will always be passed from the

Line 667: SELECT po_requisition_headers_s.nextval

663: -- an API
664:
665: -- Cursor to get unique Requisition_Header_ID
666: CURSOR req_header_id_cur IS
667: SELECT po_requisition_headers_s.nextval
668: FROM sys.dual;
669:
670: -- Cursor to get unique Requisition_Line_ID
671: CURSOR req_line_id_cur IS

Line 819: ( x_table_name => 'PO_REQUISITION_HEADERS'

815:
816: -- bug5176308
817: l_header_rec.segment1 :=
818: PO_CORE_SV1.default_po_unique_identifier
819: ( x_table_name => 'PO_REQUISITION_HEADERS'
820: );
821:
822: -- check for uniqueness of requisition_number
823: BEGIN

Line 829: FROM po_requisition_headers

825: SELECT 'X' INTO l_dummy
826: FROM DUAL
827: WHERE NOT EXISTS
828: ( SELECT 'X'
829: FROM po_requisition_headers
830: WHERE Segment1 = l_header_rec.segment1);
831:
832: EXCEPTION
833: WHEN NO_DATA_FOUND THEN

Line 877: -- insert into PO_REQUISITION_HEADERS

873: CLOSE authorization_status_cur;
874: END IF;
875:
876: -- create approved requisition headers
877: -- insert into PO_REQUISITION_HEADERS
878: INSERT INTO po_requisition_headers(
879: org_id,
880: requisition_header_id,
881: preparer_id,

Line 878: INSERT INTO po_requisition_headers(

874: END IF;
875:
876: -- create approved requisition headers
877: -- insert into PO_REQUISITION_HEADERS
878: INSERT INTO po_requisition_headers(
879: org_id,
880: requisition_header_id,
881: preparer_id,
882: last_update_date,