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_UTILITIES_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 203: FROM ap_system_parameters SP,

199: FC.minimum_accountable_unit
200: INTO l_func_currency,
201: l_fc_precision,
202: l_fc_min_acct_unit
203: FROM ap_system_parameters SP,
204: fnd_currencies FC
205: WHERE FC.currency_code = P_Currency_Code;
206:
207:

Line 405: ap_system_parameters_all SP

401: is
402: cursor l_current_cursor is
403: SELECT period_name
404: FROM gl_period_statuses GLPS,
405: ap_system_parameters_all SP
406: WHERE application_id = 200
407: AND sp.org_id = P_Org_Id
408: AND GLPS.set_of_books_id = SP.set_of_books_id
409: AND trunc(P_Date) BETWEEN start_date AND end_date

Line 492: ap_system_parameters_all SP

488: is
489: cursor l_current_cursor is
490: SELECT period_name
491: FROM gl_period_statuses GLPS,
492: ap_system_parameters_all SP
493: WHERE application_id = 200
494: AND sp.org_id = p_org_id
495: AND GLPS.set_of_books_id = SP.set_of_books_id
496: /* Bug 5368685 */

Line 533: ap_system_parameters_all SP

529: cursor l_open_cursor is
530: SELECT MIN(start_date),
531: period_name
532: FROM gl_period_statuses GLPS,
533: ap_system_parameters_all SP
534: WHERE application_id = 200
535: AND sp.org_id = P_Org_Id
536: AND GLPS.set_of_books_id = SP.set_of_books_id
537: AND end_date >= P_Date --Bug6809792

Line 635: ap_system_parameters_all SP --8281653

631: cursor l_open_cursor is
632: SELECT MIN(start_date),
633: period_name
634: FROM gl_period_statuses GLPS,
635: ap_system_parameters_all SP --8281653
636: WHERE application_id = 200
637: AND SP.org_id = P_Org_Id
638: AND GLPS.set_of_books_id = SP.set_of_books_id
639: AND (start_date > P_Date OR

Line 811: , ap_system_parameters aps

807: decode(l_multi_cur, 'N', NULL,
808: ': ' || substr(g.currency_code, 1, 5)))),1,60)
809: into l_wnd_context
810: from gl_sets_of_books g
811: , ap_system_parameters aps
812: where aps.SET_OF_BOOKS_ID = g.SET_OF_BOOKS_ID;
813: EXCEPTION
814: WHEN NO_DATA_FOUND THEN
815: return (null);

Line 854: ap_system_parameters aps,

850: decode(l_multi_cur, 'N', NULL,
851: ': ' || substr(g.currency_code, 1, 5)))),1,60)
852: into l_wnd_context
853: from gl_sets_of_books g,
854: ap_system_parameters aps,
855: hr_operating_units h
856: where h.organization_id = to_number(l_id)
857: and aps.set_of_books_id = g.set_of_books_id;
858: EXCEPTION

Line 2241: l_primary_sob_id AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;

2237: l_num_of_segments NUMBER ;
2238: l_result BOOLEAN ;
2239: l_curr_calling_sequence VARCHAR2(2000);
2240: G_flex_qualifier_name VARCHAR2(100);
2241: l_primary_sob_id AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
2242: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
2243: l_chart_of_accts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
2244: G_flex_segment_num NUMBER;
2245:

Line 2242: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;

2238: l_result BOOLEAN ;
2239: l_curr_calling_sequence VARCHAR2(2000);
2240: G_flex_qualifier_name VARCHAR2(100);
2241: l_primary_sob_id AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
2242: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
2243: l_chart_of_accts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
2244: G_flex_segment_num NUMBER;
2245:
2246:

Line 2253: FROM ap_system_parameters;

2249: SELECT set_of_books_id,
2250: nvl(liability_post_lookup_code, 'NONE')
2251: INTO l_primary_sob_id,
2252: l_liability_post_lookup_code
2253: FROM ap_system_parameters;
2254:
2255: SELECT chart_of_accounts_id
2256: INTO l_chart_of_accts_id
2257: FROM gl_sets_of_books

Line 2399: l_primary_sob_id AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;

2395: l_num_of_segments NUMBER ;
2396: l_result BOOLEAN ;
2397: l_curr_calling_sequence VARCHAR2(2000);
2398: G_flex_qualifier_name VARCHAR2(100);
2399: l_primary_sob_id AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
2400: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
2401: l_chart_of_accts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
2402: G_flex_segment_num NUMBER;
2403: l_return_segments varchar2(200) := null;

Line 2400: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;

2396: l_result BOOLEAN ;
2397: l_curr_calling_sequence VARCHAR2(2000);
2398: G_flex_qualifier_name VARCHAR2(100);
2399: l_primary_sob_id AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
2400: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
2401: l_chart_of_accts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
2402: G_flex_segment_num NUMBER;
2403: l_return_segments varchar2(200) := null;
2404:

Line 2415: FROM ap_system_parameters;

2411: SELECT set_of_books_id,
2412: nvl(liability_post_lookup_code, 'NONE')
2413: INTO l_primary_sob_id,
2414: l_liability_post_lookup_code
2415: FROM ap_system_parameters;
2416:
2417: -----------------------------------------------------------------------------------------
2418: -- Get Chart of Accounts Information
2419:

Line 2642: FROM ap_system_parameters;

2638: BEGIN
2639:
2640: SELECT nvl(calc_user_xrate, 'N')
2641: INTO l_calc_user_xrate
2642: FROM ap_system_parameters;
2643:
2644: IF (P_exchange_rate_type = 'User') THEN
2645: IF (gl_euro_user_rate_api.is_cross_rate(P_invoice_curr,
2646: P_base_curr,

Line 3234: ap_system_parameters SP

3230:
3231: CURSOR c_input_period IS
3232: SELECT GLPS.closing_status
3233: FROM gl_period_statuses GLPS,
3234: ap_system_parameters SP
3235: WHERE GLPS.application_id = 200
3236: AND GLPS.set_of_books_id = SP.set_of_books_id
3237: AND TRUNC(p_gl_date) BETWEEN GLPS.start_date AND GLPS.end_date
3238: AND NVL(GLPS.adjustment_period_flag, 'N') = 'N';

Line 3303: ap_system_parameters SP

3299:
3300: CURSOR c_closing_status IS
3301: SELECT GLPS.closing_status
3302: FROM gl_period_statuses GLPS,
3303: ap_system_parameters SP
3304: WHERE GLPS.application_id = 8721
3305: AND SP.org_id = P_Org_Id
3306: AND GLPS.set_of_books_id = SP.set_of_books_id
3307: AND TRUNC(p_gl_date) BETWEEN GLPS.start_date AND GLPS.end_date