eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_RELGEN_PKG dependencies on PO_SYSTEM_PARAMETERS

Line 82: l_enf_vendor_hold_flag po_system_parameters.enforce_vendor_hold_flag%TYPE;

78:
79: --bug2880298 start
80:
81: l_req_enc_flag financials_system_parameters.req_encumbrance_flag%TYPE;
82: l_enf_vendor_hold_flag po_system_parameters.enforce_vendor_hold_flag%TYPE;
83:
84: -- bug2880298 end
85:
86: --

Line 112: PO_SYSTEM_PARAMETERS POSP;

108: x_expense_accrual_code,
109: l_req_enc_flag, --bug2880298
110: l_enf_vendor_hold_flag --bug2880298
111: FROM FINANCIALS_SYSTEM_PARAMETERS FSP,
112: PO_SYSTEM_PARAMETERS POSP;
113:
114: IF SQL%NOTFOUND THEN
115: RAISE NO_DATA_FOUND;
116: END IF;

Line 703: x_acceptance_required_flag po_system_parameters.acceptance_required_flag%TYPE; /Bug7668178/

699: x_release_num number := 0;
700: x_purch_encumbrance_flag varchar2(1) := 'N';
701: x_pay_on_code varchar2(25) := '';
702: x_shipping_control varchar2(30) := ''; /* Bug 6454219 */
703: x_acceptance_required_flag po_system_parameters.acceptance_required_flag%TYPE; /*Bug7668178*/
704:
705: BEGIN
706:
707: SELECT NVL(PURCH_ENCUMBRANCE_FLAG,'N')

Line 711: /Bug7668178: Get the default Acceptance Required Flag value from PO System Parameters /

707: SELECT NVL(PURCH_ENCUMBRANCE_FLAG,'N')
708: INTO x_purch_encumbrance_flag
709: FROM FINANCIALS_SYSTEM_PARAMETERS;
710:
711: /*Bug7668178: Get the default Acceptance Required Flag value from PO System Parameters */
712:
713: SELECT Decode(acceptance_required_flag,'D','Y','Y','Y','S','Y','N')
714: INTO x_acceptance_required_flag
715: FROM po_system_parameters;

Line 715: FROM po_system_parameters;

711: /*Bug7668178: Get the default Acceptance Required Flag value from PO System Parameters */
712:
713: SELECT Decode(acceptance_required_flag,'D','Y','Y','Y','S','Y','N')
714: INTO x_acceptance_required_flag
715: FROM po_system_parameters;
716:
717:
718: IF (req_line.doc_generation_method = 'CREATE_AND_APPROVE' AND
719: x_purch_encumbrance_flag = 'N')

Line 845: x_taxable_flag po_system_parameters.taxable_flag%type;

841: IS
842: l_api_name CONSTANT VARCHAR2(30) := 'create_release_shipment';
843:
844: x_ship_to_location_id number := 0;
845: x_taxable_flag po_system_parameters.taxable_flag%type;
846: x_shipment_num number := 0;
847: rcv_controls rcv_control_type;
848: x_conversion_rate number := 1;
849: x_best_price number :=0;

Line 1810: from po_system_parameters posp;

1806: into rcv_controls.inspection_required_flag,
1807: rcv_controls.receipt_required_flag,
1808: rcv_controls.invoice_close_tolerance,
1809: rcv_controls.receipt_close_tolerance
1810: from po_system_parameters posp;
1811:
1812: IF (rcv_controls.inspection_required_flag is NULL) THEN
1813: rcv_controls.inspection_required_flag := 'N';
1814: END IF;

Line 2477: l_enforce_price_tolerance po_system_parameters.enforce_price_change_allowance%TYPE;

2473: l_textline po_online_report_text.text_line%TYPE := NULL;
2474: l_api_name CONSTANT varchar2(40) := 'CHECK_REL_REQPRICE';
2475: l_progress VARCHAR2(3);
2476:
2477: l_enforce_price_tolerance po_system_parameters.enforce_price_change_allowance%TYPE;
2478: l_enforce_price_amount po_system_parameters.enforce_price_change_amount%TYPE;
2479: l_amount_tolerance po_system_parameters.price_change_amount%TYPE;
2480:
2481: TYPE unit_of_measure IS TABLE of PO_LINES.unit_meas_lookup_code%TYPE;

Line 2478: l_enforce_price_amount po_system_parameters.enforce_price_change_amount%TYPE;

2474: l_api_name CONSTANT varchar2(40) := 'CHECK_REL_REQPRICE';
2475: l_progress VARCHAR2(3);
2476:
2477: l_enforce_price_tolerance po_system_parameters.enforce_price_change_allowance%TYPE;
2478: l_enforce_price_amount po_system_parameters.enforce_price_change_amount%TYPE;
2479: l_amount_tolerance po_system_parameters.price_change_amount%TYPE;
2480:
2481: TYPE unit_of_measure IS TABLE of PO_LINES.unit_meas_lookup_code%TYPE;
2482: TYPE NumTab IS TABLE of NUMBER;

Line 2479: l_amount_tolerance po_system_parameters.price_change_amount%TYPE;

2475: l_progress VARCHAR2(3);
2476:
2477: l_enforce_price_tolerance po_system_parameters.enforce_price_change_allowance%TYPE;
2478: l_enforce_price_amount po_system_parameters.enforce_price_change_amount%TYPE;
2479: l_amount_tolerance po_system_parameters.price_change_amount%TYPE;
2480:
2481: TYPE unit_of_measure IS TABLE of PO_LINES.unit_meas_lookup_code%TYPE;
2482: TYPE NumTab IS TABLE of NUMBER;
2483: l_ship_price_in_base_curr NumTab;

Line 2593: FROM po_system_parameters;

2589: nvl(price_change_amount, -1)
2590: INTO l_enforce_price_tolerance,
2591: l_enforce_price_amount,
2592: l_amount_tolerance
2593: FROM po_system_parameters;
2594:
2595: l_progress := '001';
2596: IF g_fnd_debug = 'Y' THEN
2597: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 2695: PO_SYSTEM_PARAMETERS POSP,

2691: SELECT NVL(MSI.price_tolerance_percent/100,
2692: NVL(POSP.price_change_allowance/100,-1))
2693: INTO l_price_tolerance_allowed
2694: FROM MTL_SYSTEM_ITEMS MSI,
2695: PO_SYSTEM_PARAMETERS POSP,
2696: FINANCIALS_SYSTEM_PARAMETERS FSP
2697: WHERE msi.inventory_item_id(+) = l_item_id(shipment_line)
2698: AND MSI.organization_id(+) = FSP.inventory_organization_id;
2699:

Line 2811: --PO_SYSTEM_PARAMETERS.

2807: --do the amount check
2808: --makes sure the requisition amount and
2809: --PO amount for each shipment line is within the value
2810: --defined in the column PRICE_CHANGE_AMOUNT of table
2811: --PO_SYSTEM_PARAMETERS.
2812: IF ((l_ship_price_ext_precn -
2813: (l_req_line_unit_price(req_line) *
2814: l_shipment_to_req_rate))
2815: * l_po_req_quantity(req_line)