[Home] [Help]
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.
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.
671: FROM sys.dual;
672:
673: -- Cursor to get unique Distribution_id
674: CURSOR dist_line_id_cur IS
675: SELECT po_req_distributions_s.nextval
676: FROM sys.dual;
677:
678: -- Cursor to get Accrual Account ID and Variance Account ID
679: -- For Destination Type Code INVENTORY get accrual account id
732: FROM po_lookup_codes plc
733: WHERE plc.lookup_type = 'AUTHORIZATION STATUS'
734: AND plc.lookup_code = p_authorization_status;
735:
736: -- Get Set of Books ID for a given Org_ID - Mandatory in PO_REQ_DISTRIBUTIONS
737: CURSOR set_of_books_cur (p_organization_id NUMBER) IS
738: SELECT set_of_books_id
739: FROM hr_operating_units
740: WHERE organization_id = p_organization_id;
753: AND mp.organization_id = msi.organization_id;
754:
755: -- Get Requisition Encumbrance Flag for the Set of Books
756: -- Based of this flag Budget Account will be populated
757: -- in PO_REQ_DISTRIBUTIONS
758: CURSOR req_encumbrance_cur (p_set_of_books_id NUMBER) IS
759: SELECT nvl (fsp.req_encumbrance_flag,'N')
760: FROM financials_system_parameters fsp
761: WHERE fsp.set_of_books_id = p_set_of_books_id;
1418: l_dist_rec.gl_encumbered_date := '';
1419: END IF;
1420:
1421:
1422: INSERT INTO po_req_distributions
1423: (
1424: distribution_id
1425: ,last_update_date
1426: ,last_updated_by