DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_SYSTEM_PARAMETERS_ALL

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 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;