APPS.PO_CREATE_REQUISITION_SV dependencies on PO_REQUISITION_LINES

Line 588: PO_REQUISITION_LINES. However, when populating PO_REQ_DISTRIBUTIONS,validations

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
592: calling routine, since ITEM_DESCRIPTION is a mandatory column in PO_REQUISITION_LINES.

Line 592: calling routine, since ITEM_DESCRIPTION is a mandatory column in PO_REQUISITION_LINES.

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
592: calling routine, since ITEM_DESCRIPTION is a mandatory column in PO_REQUISITION_LINES.
593: */
594:
595: PROCEDURE process_requisition(
596: p_api_version IN NUMBER := 1.0

Line 638: l_line_type_id po_requisition_lines.line_type_id%TYPE;

634:
635: s_chart_of_accounts_id NUMBER;
636: s_currency_code VARCHAR2(15);
637: l_dummy VARCHAR2(1);
638: l_line_type_id po_requisition_lines.line_type_id%TYPE;
639: l_create_req_supply BOOLEAN;
640: l_set_of_books_id NUMBER;
641:
642: l_header_rec po_create_requisition_sv.Header_Rec_Type;

Line 652: l_manufacturer_id po_requisition_lines_All.MANUFACTURER_ID%TYPE;

648:
649: d_chart_of_accounts_id NUMBER; /* bug 5637277 - Please refer the bug for the details */
650:
651:
652: l_manufacturer_id po_requisition_lines_All.MANUFACTURER_ID%TYPE;
653: l_manufacturer_name PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE;
654: l_manufacturer_pn PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE;
655: l_lead_time PO_ATTRIBUTE_VALUES.lead_time%TYPE;
656:

Line 672: SELECT po_requisition_lines_s.nextval

668: FROM sys.dual;
669:
670: -- Cursor to get unique Requisition_Line_ID
671: CURSOR req_line_id_cur IS
672: SELECT po_requisition_lines_s.nextval
673: FROM sys.dual;
674:
675: -- Cursor to get unique Distribution_id
676: CURSOR dist_line_id_cur IS

Line 964: -- get all the values required to insert into po_requisition_lines table

960: l_header_rec.closed_code ,
961: 'CREATE' --
962: );
963:
964: -- get all the values required to insert into po_requisition_lines table
965:
966: -- line_type_id for Requisition
967: OPEN line_type_cur (l_header_rec.org_id);
968: FETCH line_type_cur INTO l_line_type_id;

Line 1115: -- insert into po_requisition_lines table

1111: END IF;
1112: CLOSE destination_type_cur;
1113: END IF;
1114:
1115: -- insert into po_requisition_lines table
1116: --
1117: -- Added order_type_lookup_code, purchase_basis and
1118: -- matching_basis
1119:

Line 1130: INSERT INTO po_requisition_lines(

1126:
1127: END IF ;
1128:
1129:
1130: INSERT INTO po_requisition_lines(
1131: requisition_line_id,
1132: requisition_header_id,
1133: line_num,
1134: line_type_id,