APPS.XTR_FPS3_P dependencies on GL_TRANSACTION_CALENDAR

Line 35: PROCEDURE IMPORT_GL_HOLIDAYS(p_calendar_in IN gl_transaction_calendar.name%TYPE,

31: end CHK_DEAL_SUBTYPE;
32:
33: ----------------------------------------------------------------------------------------------------------------
34: -- Procedure to import holidays from GL
35: PROCEDURE IMPORT_GL_HOLIDAYS(p_calendar_in IN gl_transaction_calendar.name%TYPE,
36: p_currency_in IN xtr_holidays.currency%TYPE) IS
37:
38: v_calendar gl_transaction_calendar%ROWTYPE;
39: v_holiday_seq xtr_holidays.hol_seq%TYPE;

Line 38: v_calendar gl_transaction_calendar%ROWTYPE;

34: -- Procedure to import holidays from GL
35: PROCEDURE IMPORT_GL_HOLIDAYS(p_calendar_in IN gl_transaction_calendar.name%TYPE,
36: p_currency_in IN xtr_holidays.currency%TYPE) IS
37:
38: v_calendar gl_transaction_calendar%ROWTYPE;
39: v_holiday_seq xtr_holidays.hol_seq%TYPE;
40: v_nls_adjust NUMBER;
41:
42: cursor get_calendar_id(p_calendar_name gl_transaction_calendar.name%TYPE) is

Line 42: cursor get_calendar_id(p_calendar_name gl_transaction_calendar.name%TYPE) is

38: v_calendar gl_transaction_calendar%ROWTYPE;
39: v_holiday_seq xtr_holidays.hol_seq%TYPE;
40: v_nls_adjust NUMBER;
41:
42: cursor get_calendar_id(p_calendar_name gl_transaction_calendar.name%TYPE) is
43: select *
44: from gl_transaction_calendar
45: where name=p_calendar_name;
46:

Line 44: from gl_transaction_calendar

40: v_nls_adjust NUMBER;
41:
42: cursor get_calendar_id(p_calendar_name gl_transaction_calendar.name%TYPE) is
43: select *
44: from gl_transaction_calendar
45: where name=p_calendar_name;
46:
47: cursor get_gl_holidays(p_calendar gl_transaction_calendar%ROWTYPE,
48: p_currency xtr_holidays.currency%TYPE,

Line 47: cursor get_gl_holidays(p_calendar gl_transaction_calendar%ROWTYPE,

43: select *
44: from gl_transaction_calendar
45: where name=p_calendar_name;
46:
47: cursor get_gl_holidays(p_calendar gl_transaction_calendar%ROWTYPE,
48: p_currency xtr_holidays.currency%TYPE,
49: p_sun NUMBER,
50: p_mon NUMBER,
51: p_tue NUMBER,

Line 152: cursor get_gl_weekend(p_calendar_name gl_transaction_calendar.name%TYPE,

148: from xtr_master_currencies
149: where currency=p_currency
150: and authorised='Y';
151:
152: cursor get_gl_weekend(p_calendar_name gl_transaction_calendar.name%TYPE,
153: p_date DATE,
154: p_sun NUMBER,
155: p_mon NUMBER,
156: p_tue NUMBER,

Line 170: from gl_transaction_calendar

166: p_wed,wed_business_day_flag,
167: p_thu,thu_business_day_flag,
168: p_fri,fri_business_day_flag,
169: p_sat,sat_business_day_flag)
170: from gl_transaction_calendar
171: where name = p_calendar_name;
172:
173: --
174: begin