APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 5: -- Function to get from ap_system_parameters:

1: PACKAGE BODY AP_WEB_DB_AP_INT_PKG AS
2: /* $Header: apwdbapb.pls 120.51.12020000.2 2012/07/05 14:12:36 rveliche ship $ */
3:
4: /* -------------------------------------------------------------------
5: -- Function to get from ap_system_parameters:
6: -- 1. func currency
7: -- 2. set of books id
8: -- 3. default template id
9: -- 4. default exchange rate type

Line 30: from ap_system_parameters;

26: into p_base_curr_code,
27: p_set_of_books_id,
28: p_expense_report_id,
29: p_default_exch_rate_type
30: from ap_system_parameters;
31:
32: return TRUE;
33:
34: exception

Line 128: from ap_system_parameters S,

124: -------------------------------------------------------------------
125: BEGIN
126: select GS.chart_of_accounts_id
127: into p_chart_of_accounts
128: from ap_system_parameters S,
129: gl_sets_of_books GS
130: where GS.set_of_books_id = S.set_of_books_id;
131:
132: return TRUE;

Line 162: FROM ap_system_parameters s,

158: INTO p_sys_info_rec.base_currency,
159: p_sys_info_rec.default_exchange_rate_type,
160: p_sys_info_rec.base_curr_name,
161: p_sys_info_rec.sys_multi_curr_flag
162: FROM ap_system_parameters s,
163: fnd_currencies_vl c
164: WHERE c.currency_code = s.base_currency_code;
165:
166: RETURN TRUE;

Line 196: FROM ap_system_parameters s,

192:
193: BEGIN
194: SELECT s.default_exchange_rate_type
195: INTO p_default_exchange_rate_type
196: FROM ap_system_parameters s,
197: fnd_currencies_vl c
198: WHERE c.currency_code = s.base_currency_code;
199:
200: EXCEPTION

Line 495: l_signingCurrencyCode ap_system_parameters_all.base_currency_code%TYPE,

491: l_signingLimitRate NUMBER;
492:
493: TYPE SigningLimitRecTyp IS RECORD (
494: l_signingLimit NUMBER,
495: l_signingCurrencyCode ap_system_parameters_all.base_currency_code%TYPE,
496: l_exchangeRateType VARCHAR2(30));
497:
498: TYPE SigningLimitCurTyp IS REF CURSOR RETURN SigningLimitRecTyp;
499:

Line 547: from ap_system_parameters p,

543: IF (l_alphanumeric_allowed_flag = 'N') THEN
544: OPEN SigningCurrencyCodes FOR
545: select s.signing_limit, p.base_currency_code,
546: nvl((SELECT exchange_rate_type FROM ap_pol_exrate_options WHERE enabled = 'Y'),p.default_exchange_rate_type)
547: from ap_system_parameters p,
548: ap_web_signing_limits s
549: where employee_id = p_approver_id
550: and to_number(cost_center) = to_number(l_doc_cost_center)
551: and document_type = p_item_type;

Line 556: from ap_system_parameters p,

552: ELSE
553: OPEN SigningCurrencyCodes FOR
554: select s.signing_limit, p.base_currency_code,
555: nvl((SELECT exchange_rate_type FROM ap_pol_exrate_options WHERE enabled = 'Y'),p.default_exchange_rate_type)
556: from ap_system_parameters p,
557: ap_web_signing_limits s
558: where employee_id = p_approver_id
559: and cost_center = l_doc_cost_center
560: and document_type = p_item_type;

Line 675: FROM ap_system_parameters S,

671: /* Bug 3916349/4042775 - comment
672: cursor c1(p_employee_id IN number) is
673: SELECT GS.chart_of_accounts_id,
674: HR.default_code_combination_id
675: FROM ap_system_parameters S,
676: gl_sets_of_books GS,
677: per_workforce_x HR
678: WHERE HR.person_id = p_employee_id
679: AND GS.set_of_books_id = S.set_of_books_id

Line 938: FROM ap_system_parameters;

934: -------------------------------------------------------------------------------
935: BEGIN
936: SELECT ROUNDING_ERROR_CCID
937: INTO p_ccid
938: FROM ap_system_parameters;
939:
940: RETURN TRUE;
941:
942: EXCEPTION

Line 1200: FROM AP_INVOICES inv, ap_system_parameters sp, fnd_currencies F

1196:
1197: SELECT inv.invoice_amount, inv.exchange_rate,
1198: F.minimum_accountable_unit, F.precision
1199: INTO p_invoiceAmt, p_exchangeRate, p_minAcctUnit, p_precision
1200: FROM AP_INVOICES inv, ap_system_parameters sp, fnd_currencies F
1201: WHERE inv.invoice_id = p_invoiceId
1202: AND inv.set_of_books_id = sp.set_of_books_id
1203: AND F.currency_code = sp.base_currency_code;
1204: