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.AP_VENDOR_PUB_PKG dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 2234: l_rfq_only_site FINANCIALS_SYSTEM_PARAMS_ALL.rfq_only_site_flag%TYPE;

2230: p_country_code IN OUT NOCOPY VARCHAR2,
2231: p_ship_via_lookup_code IN OUT NOCOPY VARCHAR2
2232: ) IS
2233:
2234: l_rfq_only_site FINANCIALS_SYSTEM_PARAMS_ALL.rfq_only_site_flag%TYPE;
2235: l_accts_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.accts_pay_code_combination_id%TYPE;
2236: l_prepay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.prepay_code_combination_id%TYPE;
2237: l_future_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.future_dated_payment_ccid%TYPE;
2238: l_home_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;

Line 2235: l_accts_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.accts_pay_code_combination_id%TYPE;

2231: p_ship_via_lookup_code IN OUT NOCOPY VARCHAR2
2232: ) IS
2233:
2234: l_rfq_only_site FINANCIALS_SYSTEM_PARAMS_ALL.rfq_only_site_flag%TYPE;
2235: l_accts_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.accts_pay_code_combination_id%TYPE;
2236: l_prepay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.prepay_code_combination_id%TYPE;
2237: l_future_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.future_dated_payment_ccid%TYPE;
2238: l_home_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;
2239: l_default_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;

Line 2236: l_prepay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.prepay_code_combination_id%TYPE;

2232: ) IS
2233:
2234: l_rfq_only_site FINANCIALS_SYSTEM_PARAMS_ALL.rfq_only_site_flag%TYPE;
2235: l_accts_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.accts_pay_code_combination_id%TYPE;
2236: l_prepay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.prepay_code_combination_id%TYPE;
2237: l_future_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.future_dated_payment_ccid%TYPE;
2238: l_home_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;
2239: l_default_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;
2240:

Line 2237: l_future_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.future_dated_payment_ccid%TYPE;

2233:
2234: l_rfq_only_site FINANCIALS_SYSTEM_PARAMS_ALL.rfq_only_site_flag%TYPE;
2235: l_accts_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.accts_pay_code_combination_id%TYPE;
2236: l_prepay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.prepay_code_combination_id%TYPE;
2237: l_future_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.future_dated_payment_ccid%TYPE;
2238: l_home_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;
2239: l_default_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;
2240:
2241: BEGIN

Line 2238: l_home_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;

2234: l_rfq_only_site FINANCIALS_SYSTEM_PARAMS_ALL.rfq_only_site_flag%TYPE;
2235: l_accts_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.accts_pay_code_combination_id%TYPE;
2236: l_prepay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.prepay_code_combination_id%TYPE;
2237: l_future_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.future_dated_payment_ccid%TYPE;
2238: l_home_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;
2239: l_default_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;
2240:
2241: BEGIN
2242:

Line 2239: l_default_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;

2235: l_accts_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.accts_pay_code_combination_id%TYPE;
2236: l_prepay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.prepay_code_combination_id%TYPE;
2237: l_future_pay_ccid FINANCIALS_SYSTEM_PARAMS_ALL.future_dated_payment_ccid%TYPE;
2238: l_home_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;
2239: l_default_country_code FINANCIALS_SYSTEM_PARAMS_ALL.vat_country_code%TYPE;
2240:
2241: BEGIN
2242:
2243: SELECT FIN.rfq_only_site_flag,

Line 2255: FROM FINANCIALS_SYSTEM_PARAMS_ALL FIN,

2251: l_prepay_ccid,
2252: l_future_pay_ccid,
2253: l_home_country_code,
2254: p_ship_via_lookup_code
2255: FROM FINANCIALS_SYSTEM_PARAMS_ALL FIN,
2256: HR_OPERATING_UNITS HR
2257: WHERE HR.organization_id = FIN.org_id
2258: AND ( HR.name = p_org_name OR
2259: HR.organization_id = p_org_id);

Line 2646: FROM org_freight FRT, financials_system_params_all FIN

2642: x_valid := TRUE;
2643:
2644: SELECT FRT.freight_code
2645: INTO l_dummy
2646: FROM org_freight FRT, financials_system_params_all FIN
2647: WHERE FRT.organization_id = FIN.inventory_organization_id
2648: AND FIN.org_id = p_org_id
2649: AND nvl(FRT.disable_date, sysdate +1 ) > sysdate
2650: AND FRT.freight_code = p_ship_via_lookup_code;

Line 5120: FROM FINANCIALS_SYSTEM_PARAMS_ALL FIN,

5116:
5117: /*
5118: SELECT FIN.vat_country_code
5119: INTO l_default_country_code
5120: FROM FINANCIALS_SYSTEM_PARAMS_ALL FIN,
5121: AP_SYSTEM_PARAMETERS_ALL ASP
5122: WHERE ASP.set_of_books_id=p_vendor_rec.set_of_books_id
5123: AND FIN.org_id = ASP.org_id;
5124: */