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.38.12010000.3 2008/08/13 07:17:48 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 158: FROM ap_system_parameters s,

154: INTO p_sys_info_rec.base_currency,
155: p_sys_info_rec.default_exchange_rate_type,
156: p_sys_info_rec.base_curr_name,
157: p_sys_info_rec.sys_multi_curr_flag
158: FROM ap_system_parameters s,
159: fnd_currencies_vl c
160: WHERE c.currency_code = s.base_currency_code;
161:
162: RETURN TRUE;

Line 181: FROM ap_system_parameters s,

177: ------------------------------------------------------------------
178: BEGIN
179: SELECT s.default_exchange_rate_type
180: INTO p_default_exchange_rate_type
181: FROM ap_system_parameters s,
182: fnd_currencies_vl c
183: WHERE c.currency_code = s.base_currency_code;
184:
185: EXCEPTION

Line 474: l_signingCurrencyCode ap_system_parameters_all.base_currency_code%TYPE,

470: l_signingLimitRate NUMBER;
471:
472: TYPE SigningLimitRecTyp IS RECORD (
473: l_signingLimit NUMBER,
474: l_signingCurrencyCode ap_system_parameters_all.base_currency_code%TYPE,
475: l_exchangeRateType VARCHAR2(30));
476:
477: TYPE SigningLimitCurTyp IS REF CURSOR RETURN SigningLimitRecTyp;
478:

Line 525: from ap_system_parameters p,

521: -- Y=>Numbers Only (is unchecked for the valueset)
522: IF (l_alphanumeric_allowed_flag = 'N') THEN
523: OPEN SigningCurrencyCodes FOR
524: select s.signing_limit, p.base_currency_code, p.default_exchange_rate_type
525: from ap_system_parameters p,
526: ap_web_signing_limits s
527: where employee_id = p_approver_id
528: and to_number(cost_center) = to_number(l_doc_cost_center)
529: and document_type = p_item_type;

Line 533: from ap_system_parameters p,

529: and document_type = p_item_type;
530: ELSE
531: OPEN SigningCurrencyCodes FOR
532: select s.signing_limit, p.base_currency_code, p.default_exchange_rate_type
533: from ap_system_parameters p,
534: ap_web_signing_limits s
535: where employee_id = p_approver_id
536: and cost_center = l_doc_cost_center
537: and document_type = p_item_type;

Line 652: FROM ap_system_parameters S,

648: /* Bug 3916349/4042775 - comment
649: cursor c1(p_employee_id IN number) is
650: SELECT GS.chart_of_accounts_id,
651: HR.default_code_combination_id
652: FROM ap_system_parameters S,
653: gl_sets_of_books GS,
654: per_workforce_x HR
655: WHERE HR.person_id = p_employee_id
656: AND GS.set_of_books_id = S.set_of_books_id

Line 912: FROM ap_system_parameters;

908: -------------------------------------------------------------------------------
909: BEGIN
910: SELECT ROUNDING_ERROR_CCID
911: INTO p_ccid
912: FROM ap_system_parameters;
913:
914: RETURN TRUE;
915:
916: EXCEPTION

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

1154:
1155: SELECT inv.invoice_amount, inv.exchange_rate,
1156: F.minimum_accountable_unit, F.precision
1157: INTO p_invoiceAmt, p_exchangeRate, p_minAcctUnit, p_precision
1158: FROM AP_INVOICES inv, ap_system_parameters sp, fnd_currencies F
1159: WHERE inv.invoice_id = p_invoiceId
1160: AND inv.set_of_books_id = sp.set_of_books_id
1161: AND F.currency_code = sp.base_currency_code;
1162: