344:
345:
346: ALGORITHM : Retreive po parameters from
347: financials_system_parameters,gl_sets_of_books,
348: po_system_parameters and rcv_parameters tables.
349:
350: NOTES :
351:
352: =========================================================================== */
459: end get_po_parameters;
460:
461: /* Bug 7518967: ER Default Acceptance Required Check : Overloading the procedure
462: get_po_parameters to get the default acceptance_required_flag from
463: PO_SYSTEM_PARAMETERS_ALL */
464:
465: /* ===========================================================================
466: PROCEDURE NAME: get_po_parameters
467:
522:
523:
524: ALGORITHM : Retreive po parameters from
525: financials_system_parameters,gl_sets_of_books,
526: po_system_parameters and rcv_parameters tables.
527:
528: NOTES :
529:
530: =========================================================================== */
678: x_qty_rcv_tolerance,
679: x_acceptance_required_flag
680: FROM financials_system_parameters fsp,
681: gl_sets_of_books sob,
682: po_system_parameters psp,
683: rcv_parameters rcv,
684: ap_product_setup aps
685: WHERE fsp.set_of_books_id = sob.set_of_books_id
686: AND rcv.organization_id (+) = fsp.inventory_organization_id;