APPS.FEM_CAL_PERIODS_PKG dependencies on FEM_CAL_PERIODS_B

Line 20: cursor C is select ROWID from FEM_CAL_PERIODS_B

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from FEM_CAL_PERIODS_B
21: where CAL_PERIOD_ID = X_CAL_PERIOD_ID
22: ;
23: begin
24: insert into FEM_CAL_PERIODS_B (

Line 24: insert into FEM_CAL_PERIODS_B (

20: cursor C is select ROWID from FEM_CAL_PERIODS_B
21: where CAL_PERIOD_ID = X_CAL_PERIOD_ID
22: ;
23: begin
24: insert into FEM_CAL_PERIODS_B (
25: CAL_PERIOD_ID,
26: DIMENSION_GROUP_ID,
27: CALENDAR_ID,
28: ENABLED_FLAG,

Line 114: from FEM_CAL_PERIODS_B

110: ENABLED_FLAG,
111: PERSONAL_FLAG,
112: READ_ONLY_FLAG,
113: OBJECT_VERSION_NUMBER
114: from FEM_CAL_PERIODS_B
115: where CAL_PERIOD_ID = X_CAL_PERIOD_ID
116: for update of CAL_PERIOD_ID nowait;
117: recinfo c%rowtype;
118:

Line 180: update FEM_CAL_PERIODS_B set

176: X_LAST_UPDATED_BY in NUMBER,
177: X_LAST_UPDATE_LOGIN in NUMBER
178: ) is
179: begin
180: update FEM_CAL_PERIODS_B set
181: DIMENSION_GROUP_ID = X_DIMENSION_GROUP_ID,
182: CALENDAR_ID = X_CALENDAR_ID,
183: ENABLED_FLAG = X_ENABLED_FLAG,
184: PERSONAL_FLAG = X_PERSONAL_FLAG,

Line 222: delete from FEM_CAL_PERIODS_B

218: if (sql%notfound) then
219: raise no_data_found;
220: end if;
221:
222: delete from FEM_CAL_PERIODS_B
223: where CAL_PERIOD_ID = X_CAL_PERIOD_ID;
224:
225: if (sql%notfound) then
226: raise no_data_found;

Line 236: from FEM_CAL_PERIODS_B B

232: begin
233: delete from FEM_CAL_PERIODS_TL T
234: where not exists
235: (select NULL
236: from FEM_CAL_PERIODS_B B
237: where B.CAL_PERIOD_ID = T.CAL_PERIOD_ID
238: );
239:
240: update FEM_CAL_PERIODS_TL T set (