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 2766: l_period_name gl_period_statuses.period_name%TYPE := '';

2762: Function get_reversal_gl_date(P_date in date,
2763: P_Org_Id In Number) return date
2764: is
2765: l_open_gl_date date :='';
2766: l_period_name gl_period_statuses.period_name%TYPE := '';
2767: begin
2768: l_period_name := ap_utilities_pkg.get_current_gl_date(p_date, P_org_id);
2769: if l_period_name is null then
2770: ap_utilities_pkg.get_open_gl_date(p_date,

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

2797: Function get_reversal_period(P_date in date,
2798: P_org_id In Number) return varchar2
2799: is
2800: l_open_gl_date date :='';
2801: l_period_name gl_period_statuses.period_name%TYPE := '';
2802: begin
2803: l_period_name := ap_utilities_pkg.get_current_gl_date(p_date, p_org_id);
2804: if l_period_name is null then
2805: ap_utilities_pkg.get_open_gl_date(p_date,

Line 3263: FROM gl_period_statuses GLPS,

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

Line 3270: v_closing_status GL_PERIOD_STATUSES.CLOSING_STATUS%TYPE;

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';
3269:
3270: v_closing_status GL_PERIOD_STATUSES.CLOSING_STATUS%TYPE;
3271:
3272: BEGIN
3273:
3274: OPEN c_input_period;

Line 3332: FROM gl_period_statuses GLPS,

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

Line 3340: v_closing_status GL_PERIOD_STATUSES.CLOSING_STATUS%TYPE;

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
3338: AND NVL(GLPS.adjustment_period_flag, 'N') = 'N';
3339:
3340: v_closing_status GL_PERIOD_STATUSES.CLOSING_STATUS%TYPE;
3341:
3342: BEGIN
3343: OPEN c_closing_status;
3344:

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

3855: P_Batch_GL_Date IN DATE DEFAULT NULL,
3856: P_Org_Id IN NUMBER DEFAULT
3857: MO_GLOBAL.GET_CURRENT_ORG_ID)
3858: IS
3859: l_period_name gl_period_statuses.period_name%TYPE := '';
3860: l_current_date date := '';
3861: l_gl_date date := '';
3862: y_date date := '';
3863: n_date date := '';

Line 3929: FROM gl_period_statuses GLPS,

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

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

3934: AND trunc(P_Date) BETWEEN start_date AND end_date
3935: AND closing_status in ('O', 'F')
3936: AND NVL(adjustment_period_flag, 'N') = 'N';
3937:
3938: l_period_name gl_period_statuses.period_name%TYPE := '';
3939: l_api_name CONSTANT VARCHAR2(200) := 'Get_Current_Gl_Date_No_Cache';
3940: l_debug_info Varchar2(2000);
3941:
3942: begin

Line 3970: FROM gl_period_statuses GLPS,

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

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

3978: GROUP BY period_name
3979: ORDER BY MIN(start_date);
3980:
3981: l_start_date date := '';
3982: l_period_name gl_period_statuses.period_name%TYPE := '';
3983: l_api_name CONSTANT VARCHAR2(200) := 'Get_Open_Gl_Date_No_Cache';
3984: l_debug_info Varchar2(2000);
3985:
3986: