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 670: SELECT po_requisition_lines_s.nextval

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

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

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

Line 1113: -- insert into po_requisition_lines table

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

Line 1128: INSERT INTO po_requisition_lines(

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