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 665: SELECT po_requisition_headers_s.nextval

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

Line 817: ( x_table_name => 'PO_REQUISITION_HEADERS'

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

Line 827: FROM po_requisition_headers

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

Line 875: -- insert into PO_REQUISITION_HEADERS

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

Line 876: INSERT INTO po_requisition_headers(

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