APPS.XTR_FPS3_P dependencies on XTR_HOLIDAYS

Line 36: p_currency_in IN xtr_holidays.currency%TYPE) IS

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;
40: v_nls_adjust NUMBER;

Line 39: v_holiday_seq xtr_holidays.hol_seq%TYPE;

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
43: select *

Line 48: p_currency xtr_holidays.currency%TYPE,

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,
52: p_wed NUMBER,

Line 72: from xtr_holidays

68: p_fri,p_calendar.fri_business_day_flag,
69: p_sat,p_calendar.sat_business_day_flag)
70: and not exists (
71: select holiday_date
72: from xtr_holidays
73: where currency=p_currency
74: and holiday_date=transaction_date);
75:
76: BEGIN

Line 83: select XTR_HOLIDAYS_S.nextval

79: fetch get_calendar_id into v_calendar;
80: close get_calendar_id;
81:
82: if (v_calendar.transaction_calendar_id is not null) then
83: select XTR_HOLIDAYS_S.nextval
84: into v_holiday_seq
85: from dual;
86:
87: if (v_holiday_seq is null) then

Line 104: insert into xtr_holidays(

100: (4+v_nls_adjust) mod 7,
101: (5+v_nls_adjust) mod 7,
102: (6+v_nls_adjust) mod 7
103: ) loop
104: insert into xtr_holidays(
105: comments,
106: currency,
107: day_desc,
108: holiday_date,

Line 142: from XTR_HOLIDAYS

138: v_bHasGLCalendar boolean := false;
139:
140: cursor HOL is
141: select count(*)
142: from XTR_HOLIDAYS
143: where HOLIDAY_DATE =in_date
144: and CURRENCY = l_currency;
145:
146: cursor get_calendar_name(p_currency xtr_master_currencies_v.currency%TYPE) is