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 GL_PERIOD_STATUSES

Line 404: FROM gl_period_statuses GLPS,

400: mo_global.get_current_org_id) return varchar2
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

Line 413: l_period_name gl_period_statuses.period_name%TYPE := '';

409: AND trunc(P_Date) BETWEEN start_date AND end_date
410: AND closing_status in ('O', 'F')
411: AND NVL(adjustment_period_flag, 'N') = 'N';
412:
413: l_period_name gl_period_statuses.period_name%TYPE := '';
414: l_acct_date_org Varchar2(30);
415: l_api_name CONSTANT VARCHAR2(200) := 'Get_Current_Gl_Date';
416: l_debug_info Varchar2(2000);
417:

Line 491: FROM gl_period_statuses GLPS,

487: mo_global.get_current_org_id) return varchar2
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

Line 500: l_period_name gl_period_statuses.period_name%TYPE := '';

496: /* Bug 5368685 */
497: AND trunc(P_Date) BETWEEN start_date AND end_date
498: AND NVL(adjustment_period_flag, 'N') = 'N';
499:
500: l_period_name gl_period_statuses.period_name%TYPE := '';
501:
502: begin
503:
504: open l_current_cursor;

Line 532: FROM gl_period_statuses GLPS,

528: is
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

Line 544: l_period_name gl_period_statuses.period_name%TYPE := '';

540: GROUP BY period_name
541: ORDER BY MIN(start_date);
542:
543: l_start_date date := '';
544: l_period_name gl_period_statuses.period_name%TYPE := '';
545: l_acct_date_org Varchar2(30);
546: l_api_name CONSTANT VARCHAR2(200) := 'Get_Open_Gl_Date';
547: l_debug_info Varchar2(2000);
548:

Line 634: FROM gl_period_statuses GLPS,

630: is
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

Line 647: l_period_name gl_period_statuses.period_name%TYPE := '';

643: GROUP BY period_name
644: ORDER BY MIN(start_date);
645:
646: l_start_date date := '';
647: l_period_name gl_period_statuses.period_name%TYPE := '';
648:
649: begin
650:
651: open l_open_cursor;

Line 2761: l_period_name gl_period_statuses.period_name%TYPE := '';

2757: Function get_reversal_gl_date(P_date in date,
2758: P_Org_Id In Number) return date
2759: is
2760: l_open_gl_date date :='';
2761: l_period_name gl_period_statuses.period_name%TYPE := '';
2762: begin
2763: l_period_name := ap_utilities_pkg.get_current_gl_date(p_date, P_org_id);
2764: if l_period_name is null then
2765: ap_utilities_pkg.get_open_gl_date(p_date,

Line 2796: l_period_name gl_period_statuses.period_name%TYPE := '';

2792: Function get_reversal_period(P_date in date,
2793: P_org_id In Number) return varchar2
2794: is
2795: l_open_gl_date date :='';
2796: l_period_name gl_period_statuses.period_name%TYPE := '';
2797: begin
2798: l_period_name := ap_utilities_pkg.get_current_gl_date(p_date, p_org_id);
2799: if l_period_name is null then
2800: ap_utilities_pkg.get_open_gl_date(p_date,

Line 3233: FROM gl_period_statuses GLPS,

3229: RETURN VARCHAR2 IS
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

Line 3240: v_closing_status GL_PERIOD_STATUSES.CLOSING_STATUS%TYPE;

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';
3239:
3240: v_closing_status GL_PERIOD_STATUSES.CLOSING_STATUS%TYPE;
3241:
3242: BEGIN
3243:
3244: OPEN c_input_period;

Line 3302: FROM gl_period_statuses GLPS,

3298: mo_global.get_current_org_id) RETURN varchar2 IS
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

Line 3310: v_closing_status GL_PERIOD_STATUSES.CLOSING_STATUS%TYPE;

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
3308: AND NVL(GLPS.adjustment_period_flag, 'N') = 'N';
3309:
3310: v_closing_status GL_PERIOD_STATUSES.CLOSING_STATUS%TYPE;
3311:
3312: BEGIN
3313: OPEN c_closing_status;
3314: