APPS.PO_CREATE_REQUISITION_SV dependencies on PO_REQ_DISTRIBUTIONS

Line 581: the colling routine, however, PO_REQ_DISTRIBUTIONS table will be populated

577: END valid_account_id_fun;
578:
579:
580: /* Procedure to Process Internal Requisition. Most of the values will come from
581: the colling routine, however, PO_REQ_DISTRIBUTIONS table will be populated
582: within this Package.
583:
584: This package assumes that there is only one distribution per order line, since
585: Order Line cannot be shipped to multiple locations.

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 677: SELECT po_req_distributions_s.nextval

673: FROM sys.dual;
674:
675: -- Cursor to get unique Distribution_id
676: CURSOR dist_line_id_cur IS
677: SELECT po_req_distributions_s.nextval
678: FROM sys.dual;
679:
680: -- Cursor to get Accrual Account ID and Variance Account ID
681: -- For Destination Type Code INVENTORY get accrual account id

Line 738: -- Get Set of Books ID for a given Org_ID - Mandatory in PO_REQ_DISTRIBUTIONS

734: FROM po_lookup_codes plc
735: WHERE plc.lookup_type = 'AUTHORIZATION STATUS'
736: AND plc.lookup_code = p_authorization_status;
737:
738: -- Get Set of Books ID for a given Org_ID - Mandatory in PO_REQ_DISTRIBUTIONS
739: CURSOR set_of_books_cur (p_organization_id NUMBER) IS
740: SELECT set_of_books_id
741: FROM hr_operating_units
742: WHERE organization_id = p_organization_id;

Line 759: -- in PO_REQ_DISTRIBUTIONS

755: AND mp.organization_id = msi.organization_id;
756:
757: -- Get Requisition Encumbrance Flag for the Set of Books
758: -- Based of this flag Budget Account will be populated
759: -- in PO_REQ_DISTRIBUTIONS
760: CURSOR req_encumbrance_cur (p_set_of_books_id NUMBER) IS
761: SELECT nvl (fsp.req_encumbrance_flag,'N')
762: FROM financials_system_parameters fsp
763: WHERE fsp.set_of_books_id = p_set_of_books_id;

Line 1425: INSERT INTO po_req_distributions

1421: l_dist_rec.gl_encumbered_date := '';
1422: END IF;
1423:
1424:
1425: INSERT INTO po_req_distributions
1426: (
1427: distribution_id
1428: ,last_update_date
1429: ,last_updated_by