APPS.IEC_G_CAL_DAYS_PKG dependencies on IEC_G_CAL_DAYS_B

Line 22: cursor C is select ROWID from IEC_G_CAL_DAYS_B

18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: cursor C is select ROWID from IEC_G_CAL_DAYS_B
23: where DAY_ID = X_DAY_ID
24: ;
25: begin
26: insert into IEC_G_CAL_DAYS_B (

Line 26: insert into IEC_G_CAL_DAYS_B (

22: cursor C is select ROWID from IEC_G_CAL_DAYS_B
23: where DAY_ID = X_DAY_ID
24: ;
25: begin
26: insert into IEC_G_CAL_DAYS_B (
27: DAY_ID,
28: CALENDAR_ID,
29: DAY_CODE,
30: PATTERN_CODE,

Line 117: from IEC_G_CAL_DAYS_B

113: EXCEPTION_DAY,
114: EXCEPTION_YEAR,
115: EXCEPTION_WEEKDAY_CODE,
116: OBJECT_VERSION_NUMBER
117: from IEC_G_CAL_DAYS_B
118: where DAY_ID = X_DAY_ID
119: for update of DAY_ID nowait;
120: recinfo c%rowtype;
121:

Line 188: update IEC_G_CAL_DAYS_B set

184: X_LAST_UPDATED_BY in NUMBER,
185: X_LAST_UPDATE_LOGIN in NUMBER
186: ) is
187: begin
188: update IEC_G_CAL_DAYS_B set
189: CALENDAR_ID = X_CALENDAR_ID,
190: DAY_CODE = X_DAY_CODE,
191: PATTERN_CODE = X_PATTERN_CODE,
192: EXCEPTION_MONTH = X_EXCEPTION_MONTH,

Line 231: delete from IEC_G_CAL_DAYS_B

227: if (sql%notfound) then
228: raise no_data_found;
229: end if;
230:
231: delete from IEC_G_CAL_DAYS_B
232: where DAY_ID = X_DAY_ID;
233:
234: if (sql%notfound) then
235: raise no_data_found;

Line 245: from IEC_G_CAL_DAYS_B B

241: begin
242: delete from IEC_G_CAL_DAYS_TL T
243: where not exists
244: (select NULL
245: from IEC_G_CAL_DAYS_B B
246: where B.DAY_ID = T.DAY_ID
247: );
248:
249: update IEC_G_CAL_DAYS_TL T set (