APPS.IEC_G_CAL_CALENDARS_PKG dependencies on IEC_G_CAL_CALENDARS_B

Line 17: cursor C is select ROWID from IEC_G_CAL_CALENDARS_B

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from IEC_G_CAL_CALENDARS_B
18: where CALENDAR_ID = X_CALENDAR_ID
19: ;
20: begin
21: insert into IEC_G_CAL_CALENDARS_B (

Line 21: insert into IEC_G_CAL_CALENDARS_B (

17: cursor C is select ROWID from IEC_G_CAL_CALENDARS_B
18: where CALENDAR_ID = X_CALENDAR_ID
19: ;
20: begin
21: insert into IEC_G_CAL_CALENDARS_B (
22: CALENDAR_ID,
23: CALENDAR_TYPE_CODE,
24: TERRITORY_CODE,
25: OVERRIDE_CC_CAL_FLAG,

Line 96: from IEC_G_CAL_CALENDARS_B

92: CALENDAR_TYPE_CODE,
93: TERRITORY_CODE,
94: OVERRIDE_CC_CAL_FLAG,
95: OBJECT_VERSION_NUMBER
96: from IEC_G_CAL_CALENDARS_B
97: where CALENDAR_ID = X_CALENDAR_ID
98: for update of CALENDAR_ID nowait;
99: recinfo c%rowtype;
100:

Line 156: update IEC_G_CAL_CALENDARS_B set

152: X_LAST_UPDATED_BY in NUMBER,
153: X_LAST_UPDATE_LOGIN in NUMBER
154: ) is
155: begin
156: update IEC_G_CAL_CALENDARS_B set
157: CALENDAR_TYPE_CODE = X_CALENDAR_TYPE_CODE,
158: TERRITORY_CODE = X_TERRITORY_CODE,
159: OVERRIDE_CC_CAL_FLAG = X_OVERRIDE_CC_CAL_FLAG,
160: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 195: delete from IEC_G_CAL_CALENDARS_B

191: if (sql%notfound) then
192: raise no_data_found;
193: end if;
194:
195: delete from IEC_G_CAL_CALENDARS_B
196: where CALENDAR_ID = X_CALENDAR_ID;
197:
198: if (sql%notfound) then
199: raise no_data_found;

Line 209: from IEC_G_CAL_CALENDARS_B B

205: begin
206: delete from IEC_G_CAL_CALENDARS_TL T
207: where not exists
208: (select NULL
209: from IEC_G_CAL_CALENDARS_B B
210: where B.CALENDAR_ID = T.CALENDAR_ID
211: );
212:
213: update IEC_G_CAL_CALENDARS_TL T set (