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_DOCUMENT_CHECKS_PVT dependencies on PO_SYSTEM_PARAMETERS

Line 586: FROM po_system_parameters_all

582: WHERE po_header_id = p_document_id;
583:
584: CURSOR c_vendor_check_params IS
585: SELECT ENABLE_EPLS , Trunc(EPLS_TIMEFRAME)
586: FROM po_system_parameters_all
587: WHERE org_id = p_org_id;
588:
589: l_enable_epls VARCHAR2(1):='N';
590: l_epls_timeframe NUMBER;

Line 789: FROM po_system_parameters_all

785:
786:
787: CURSOR c_wdol_params IS
788: SELECT ENABLE_WDOL
789: FROM po_system_parameters_all
790: WHERE org_id = p_org_id;
791:
792: l_enable_wdol VARCHAR2(1):='N';
793: l_attachment_pk1 VARCHAR2(100);

Line 944: FROM po_system_parameters_all

940: WHERE po_header_id = p_document_id;
941:
942: CURSOR c_eda_params IS
943: SELECT ENABLE_EDA
944: FROM po_system_parameters_all
945: WHERE org_id = p_org_id;
946:
947: l_complete_lookup VARCHAR2(100);
948:

Line 4292: PO_SYSTEM_PARAMETERS PSP

4288: p_sequence + ROWNUM,
4289: substr(l_textline,1,240),
4290: 'PO_SUB_REL_VENDOR_ON_HOLD'
4291: FROM PO_RELEASES_GT POR,PO_HEADERS_GT POH,PO_VENDORS POV,
4292: PO_SYSTEM_PARAMETERS PSP
4293: WHERE POR.po_header_id = POH.po_header_id
4294: AND POV.vendor_id = POH.vendor_id
4295: AND POR.po_release_id = p_document_id
4296: AND nvl(PSP.ENFORCE_VENDOR_HOLD_FLAG,'N') = 'Y'

Line 5920: l_enforce_price_tolerance po_system_parameters.enforce_price_change_allowance%TYPE;

5916: l_textline po_online_report_text.text_line%TYPE := NULL;
5917: l_api_name CONSTANT varchar2(40) := 'CHECK_PO_REL_REQPRICE';
5918: l_progress VARCHAR2(3);
5919:
5920: l_enforce_price_tolerance po_system_parameters.enforce_price_change_allowance%TYPE;
5921: l_enforce_price_amount po_system_parameters.enforce_price_change_amount%TYPE;
5922: l_amount_tolerance po_system_parameters.price_change_amount%TYPE;
5923:
5924: TYPE unit_of_measure IS TABLE of PO_LINES.unit_meas_lookup_code%TYPE;

Line 5921: l_enforce_price_amount po_system_parameters.enforce_price_change_amount%TYPE;

5917: l_api_name CONSTANT varchar2(40) := 'CHECK_PO_REL_REQPRICE';
5918: l_progress VARCHAR2(3);
5919:
5920: l_enforce_price_tolerance po_system_parameters.enforce_price_change_allowance%TYPE;
5921: l_enforce_price_amount po_system_parameters.enforce_price_change_amount%TYPE;
5922: l_amount_tolerance po_system_parameters.price_change_amount%TYPE;
5923:
5924: TYPE unit_of_measure IS TABLE of PO_LINES.unit_meas_lookup_code%TYPE;
5925: TYPE NumTab IS TABLE of NUMBER;

Line 5922: l_amount_tolerance po_system_parameters.price_change_amount%TYPE;

5918: l_progress VARCHAR2(3);
5919:
5920: l_enforce_price_tolerance po_system_parameters.enforce_price_change_allowance%TYPE;
5921: l_enforce_price_amount po_system_parameters.enforce_price_change_amount%TYPE;
5922: l_amount_tolerance po_system_parameters.price_change_amount%TYPE;
5923:
5924: TYPE unit_of_measure IS TABLE of PO_LINES.unit_meas_lookup_code%TYPE;
5925: TYPE NumTab IS TABLE of NUMBER;
5926: l_ship_price_in_base_curr NumTab;

Line 5952: l_rate_type PO_SYSTEM_PARAMETERS_ALL.default_rate_type%TYPE;

5948: l_po_curr FND_CURRENCIES.currency_code%TYPE;
5949: l_req_ou_func_curr FND_CURRENCIES.currency_code%TYPE;
5950: l_rate_date DATE;
5951: l_rate NUMBER;
5952: l_rate_type PO_SYSTEM_PARAMETERS_ALL.default_rate_type%TYPE;
5953: l_requesting_org_id NumTab;
5954: l_display_rate NUMBER;
5955: l_return_status VARCHAR2(1);
5956: l_error_message_name FND_NEW_MESSAGES.message_name%TYPE;

Line 6196: FROM po_system_parameters;

6192: nvl(price_change_amount, -1)
6193: INTO l_enforce_price_tolerance,
6194: l_enforce_price_amount,
6195: l_amount_tolerance
6196: FROM po_system_parameters;
6197:
6198: l_progress := '001';
6199: IF g_debug_stmt THEN
6200: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 6421: PO_SYSTEM_PARAMETERS POSP,

6417: SELECT NVL(MSI.price_tolerance_percent/100,
6418: NVL(POSP.price_change_allowance/100,-1))
6419: INTO l_price_tolerance_allowed
6420: FROM MTL_SYSTEM_ITEMS MSI,
6421: PO_SYSTEM_PARAMETERS POSP,
6422: FINANCIALS_SYSTEM_PARAMETERS FSP
6423: WHERE msi.inventory_item_id(+) = l_item_id(shipment_line)
6424: AND MSI.organization_id(+) = FSP.inventory_organization_id;
6425:

Line 6607: FROM po_system_parameters;

6603: IF l_rate IS NULL THEN
6604: BEGIN
6605: SELECT default_rate_type
6606: INTO l_rate_type
6607: FROM po_system_parameters;
6608: EXCEPTION
6609: WHEN OTHERS THEN
6610: RAISE;
6611: END;

Line 6969: FROM po_system_parameters;

6965: IF l_rate IS NULL THEN
6966: BEGIN
6967: SELECT default_rate_type
6968: INTO l_rate_type
6969: FROM po_system_parameters;
6970: EXCEPTION
6971: WHEN OTHERS THEN
6972: RAISE;
6973: END;

Line 7035: --PO_SYSTEM_PARAMETERS.

7031: --do the amount check
7032: --makes sure the requisition amount and
7033: --PO amount for each shipment line is within the value
7034: --defined in the column PRICE_CHANGE_AMOUNT of table
7035: --PO_SYSTEM_PARAMETERS.
7036: --Bug 3262304, 3266272 mbhargav Using the Req price which is
7037: --rounded to the ext_precn of the its currency.
7038: IF ((l_ship_price_ext_precn -
7039: (l_req_line_price_ext_precn * l_shipment_to_req_rate)

Line 7210: FROM PO_HEADERS_GT POH, PO_VENDORS POV, PO_SYSTEM_PARAMETERS PSP

7206: 0,
7207: p_sequence + ROWNUM,
7208: substr(l_textline,1,240),
7209: 'PO_SUB_VENDOR_ON_HOLD'
7210: FROM PO_HEADERS_GT POH, PO_VENDORS POV, PO_SYSTEM_PARAMETERS PSP
7211: WHERE POV.vendor_id = POH.vendor_id
7212: AND POH.po_header_id = p_document_id
7213: AND nvl(PSP.ENFORCE_VENDOR_HOLD_FLAG,'N') = 'Y'
7214: AND nvl(POV.hold_flag,'N') = 'Y';

Line 8248: l_enf_funds_change_allowance po_system_parameters.enforce_funds_change_allowance%TYPE;

8244: -- CLM Aprvl
8245: l_clm_document VARCHAR2(1) := 'N'; -- Whether its a CLM document or Not
8246: -- CLM Aprvl
8247: -- CLM-LnSc-st
8248: l_enf_funds_change_allowance po_system_parameters.enforce_funds_change_allowance%TYPE;
8249: l_funds_change_allowance po_system_parameters.funds_change_allowance%TYPE;
8250: l_funds_change_amount po_system_parameters.funds_change_amount%TYPE;
8251: -- CLM-LnSc-end
8252:

Line 8249: l_funds_change_allowance po_system_parameters.funds_change_allowance%TYPE;

8245: l_clm_document VARCHAR2(1) := 'N'; -- Whether its a CLM document or Not
8246: -- CLM Aprvl
8247: -- CLM-LnSc-st
8248: l_enf_funds_change_allowance po_system_parameters.enforce_funds_change_allowance%TYPE;
8249: l_funds_change_allowance po_system_parameters.funds_change_allowance%TYPE;
8250: l_funds_change_amount po_system_parameters.funds_change_amount%TYPE;
8251: -- CLM-LnSc-end
8252:
8253: BEGIN

Line 8250: l_funds_change_amount po_system_parameters.funds_change_amount%TYPE;

8246: -- CLM Aprvl
8247: -- CLM-LnSc-st
8248: l_enf_funds_change_allowance po_system_parameters.enforce_funds_change_allowance%TYPE;
8249: l_funds_change_allowance po_system_parameters.funds_change_allowance%TYPE;
8250: l_funds_change_amount po_system_parameters.funds_change_amount%TYPE;
8251: -- CLM-LnSc-end
8252:
8253: BEGIN
8254:

Line 10140: FROM po_system_parameters;

10136: nvl(funds_change_amount, -1)
10137: INTO l_enf_funds_change_allowance,
10138: l_funds_change_allowance,
10139: l_funds_change_amount
10140: FROM po_system_parameters;
10141:
10142: IF g_debug_stmt THEN
10143: PO_DEBUG.debug_stmt(g_log_head || '.'||l_api_name||'.', l_progress,
10144: 'Is Funds Change Allowance enforced ' || l_enf_funds_change_allowance

Line 12722: po_system_parameters PSP

12718: WHERE pllg.po_line_id = pol.po_line_id
12719: AND pllg.approved_date IS NOT NULL) --< Bug 3301427 End >
12720: AND NOT EXISTS (SELECT 1
12721: FROM po_ga_org_assignments PGOA,
12722: po_system_parameters PSP
12723: WHERE PGOA.po_header_id = POHA.po_header_id
12724: AND PGOA.purchasing_org_id = PSP.org_id
12725: AND PGOA.enabled_flag = 'Y');
12726:

Line 16080: ' FROM PO_EMPLOYEE_HIERARCHIES H, PO_SYSTEM_PARAMETERS PSP WHERE H.employee_id = ' ||

16076: /* End Bug 7229262/7239696 */
16077:
16078: ' AND POAH2.object_id = ' || p_query_table || '.' || l_id_column || ')) OR (' ||
16079: p_employee_id || ' IN (SELECT H.superior_id ' ||
16080: ' FROM PO_EMPLOYEE_HIERARCHIES H, PO_SYSTEM_PARAMETERS PSP WHERE H.employee_id = ' ||
16081: p_query_table || '.' || p_owner_id_column ||
16082: ' AND H.position_structure_id = NVL(PSP.SECURITY_POSITION_STRUCTURE_ID,-1) '
16083: ||'AND PSP.ORG_ID = '||p_query_table || '.ORG_ID '
16084: ||'))))';