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.QRM_PA_AGGREGATION_P dependencies on GL_TRANSACTION_CALENDAR

Line 2657: reference date, based on a GL Transaction Calendar. In the case

2653:
2654: /********************************************************************
2655: get_beg_end_of_week
2656: Procedure that provides the beginning and end of the week given a
2657: reference date, based on a GL Transaction Calendar. In the case
2658: where there are either no or all business days, it defines the
2659: first of the week by following NLS_TERRITORY settings.
2660:
2661: This procedure attempts to determine the beginning of the week by

Line 2690: FROM gl_transaction_calendar

2686: mon_business_day_flag,
2687: tue_business_day_flag,
2688: wed_business_day_flag,
2689: thu_business_day_flag
2690: FROM gl_transaction_calendar
2691: WHERE transaction_calendar_id = p_gl_trans_calendar_id;
2692: --
2693: v_day_table SYSTEM.QRM_VARCHAR_TABLE;
2694: v_fri GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;

Line 2694: v_fri GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;

2690: FROM gl_transaction_calendar
2691: WHERE transaction_calendar_id = p_gl_trans_calendar_id;
2692: --
2693: v_day_table SYSTEM.QRM_VARCHAR_TABLE;
2694: v_fri GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2695: v_sat GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2696: v_sun GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2697: v_mon GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2698: v_tue GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;

Line 2695: v_sat GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;

2691: WHERE transaction_calendar_id = p_gl_trans_calendar_id;
2692: --
2693: v_day_table SYSTEM.QRM_VARCHAR_TABLE;
2694: v_fri GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2695: v_sat GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2696: v_sun GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2697: v_mon GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2698: v_tue GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2699: v_wed GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;

Line 2696: v_sun GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;

2692: --
2693: v_day_table SYSTEM.QRM_VARCHAR_TABLE;
2694: v_fri GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2695: v_sat GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2696: v_sun GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2697: v_mon GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2698: v_tue GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2699: v_wed GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2700: v_thu GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;

Line 2697: v_mon GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;

2693: v_day_table SYSTEM.QRM_VARCHAR_TABLE;
2694: v_fri GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2695: v_sat GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2696: v_sun GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2697: v_mon GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2698: v_tue GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2699: v_wed GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2700: v_thu GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2701: --

Line 2698: v_tue GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;

2694: v_fri GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2695: v_sat GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2696: v_sun GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2697: v_mon GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2698: v_tue GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2699: v_wed GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2700: v_thu GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2701: --
2702: v_last_nonbus_day NUMBER := 0;

Line 2699: v_wed GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;

2695: v_sat GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2696: v_sun GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2697: v_mon GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2698: v_tue GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2699: v_wed GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2700: v_thu GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2701: --
2702: v_last_nonbus_day NUMBER := 0;
2703: v_nonbus_count NUMBER := 0;

Line 2700: v_thu GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;

2696: v_sun GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2697: v_mon GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2698: v_tue GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2699: v_wed GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2700: v_thu GL_TRANSACTION_CALENDAR.SAT_BUSINESS_DAY_FLAG%TYPE;
2701: --
2702: v_last_nonbus_day NUMBER := 0;
2703: v_nonbus_count NUMBER := 0;
2704: v_ref_day NUMBER;