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: --Bug 13975870
858: and h.organization_id = aps.org_id

Line 2245: l_primary_sob_id AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;

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

Line 2246: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;

2242: l_result BOOLEAN ;
2243: l_curr_calling_sequence VARCHAR2(2000);
2244: G_flex_qualifier_name VARCHAR2(100);
2245: l_primary_sob_id AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
2246: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
2247: l_chart_of_accts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
2248: G_flex_segment_num NUMBER;
2249:
2250:

Line 2257: FROM ap_system_parameters

2253: SELECT set_of_books_id,
2254: nvl(liability_post_lookup_code, 'NONE')
2255: INTO l_primary_sob_id,
2256: l_liability_post_lookup_code
2257: FROM ap_system_parameters
2258: where org_id = nvl(AP_UTILITIES_PKG.g_org_id,org_id); /*Bug11720134*/
2259:
2260: SELECT chart_of_accounts_id
2261: INTO l_chart_of_accts_id

Line 2404: l_primary_sob_id AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;

2400: l_num_of_segments NUMBER ;
2401: l_result BOOLEAN ;
2402: l_curr_calling_sequence VARCHAR2(2000);
2403: G_flex_qualifier_name VARCHAR2(100);
2404: l_primary_sob_id AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
2405: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
2406: l_chart_of_accts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
2407: G_flex_segment_num NUMBER;
2408: l_return_segments varchar2(200) := null;

Line 2405: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;

2401: l_result BOOLEAN ;
2402: l_curr_calling_sequence VARCHAR2(2000);
2403: G_flex_qualifier_name VARCHAR2(100);
2404: l_primary_sob_id AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
2405: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
2406: l_chart_of_accts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
2407: G_flex_segment_num NUMBER;
2408: l_return_segments varchar2(200) := null;
2409:

Line 2420: FROM ap_system_parameters;

2416: SELECT set_of_books_id,
2417: nvl(liability_post_lookup_code, 'NONE')
2418: INTO l_primary_sob_id,
2419: l_liability_post_lookup_code
2420: FROM ap_system_parameters;
2421:
2422: -----------------------------------------------------------------------------------------
2423: -- Get Chart of Accounts Information
2424:

Line 2647: FROM ap_system_parameters;

2643: BEGIN
2644:
2645: SELECT nvl(calc_user_xrate, 'N')
2646: INTO l_calc_user_xrate
2647: FROM ap_system_parameters;
2648:
2649: IF (P_exchange_rate_type = 'User') THEN
2650: IF (gl_euro_user_rate_api.is_cross_rate(P_invoice_curr,
2651: P_base_curr,

Line 3264: ap_system_parameters SP

3260:
3261: CURSOR c_input_period IS
3262: SELECT GLPS.closing_status
3263: FROM gl_period_statuses GLPS,
3264: ap_system_parameters SP
3265: WHERE GLPS.application_id = 200
3266: AND GLPS.set_of_books_id = SP.set_of_books_id
3267: AND TRUNC(p_gl_date) BETWEEN GLPS.start_date AND GLPS.end_date
3268: AND NVL(GLPS.adjustment_period_flag, 'N') = 'N';

Line 3333: ap_system_parameters SP

3329:
3330: CURSOR c_closing_status IS
3331: SELECT GLPS.closing_status
3332: FROM gl_period_statuses GLPS,
3333: ap_system_parameters SP
3334: WHERE GLPS.application_id = 8721
3335: AND SP.org_id = P_Org_Id
3336: AND GLPS.set_of_books_id = SP.set_of_books_id
3337: AND TRUNC(p_gl_date) BETWEEN GLPS.start_date AND GLPS.end_date

Line 3889: FROM ap_system_parameters_all SP --5126689

3885: 'Y',y_date,
3886: 'N',n_date,
3887: TRUNC(P_Date)))
3888: INTO l_current_date
3889: FROM ap_system_parameters_all SP --5126689
3890: WHERE sp.org_id = p_org_id;
3891:
3892: -- Initialize the IN OUT NOCOPY variables
3893: P_GL_Date := '';

Line 3930: ap_system_parameters_all SP

3926: is
3927: cursor l_current_cursor is
3928: SELECT period_name
3929: FROM gl_period_statuses GLPS,
3930: ap_system_parameters_all SP
3931: WHERE application_id = 200
3932: AND sp.org_id = P_Org_Id
3933: AND GLPS.set_of_books_id = SP.set_of_books_id
3934: AND trunc(P_Date) BETWEEN start_date AND end_date

Line 3971: ap_system_parameters_all SP

3967: cursor l_open_cursor is
3968: SELECT MIN(start_date),
3969: period_name
3970: FROM gl_period_statuses GLPS,
3971: ap_system_parameters_all SP
3972: WHERE application_id = 200
3973: AND sp.org_id = P_Org_Id
3974: AND GLPS.set_of_books_id = SP.set_of_books_id
3975: AND end_date >= P_Date --Bug6809792