APPS.CAC_SR_PERIODS_PKG dependencies on CAC_SR_PERIODS_B

Line 26: cursor C is select ROWID from CAC_SR_PERIODS_B

22: X_LAST_UPDATE_DATE in DATE,
23: X_LAST_UPDATED_BY in NUMBER,
24: X_LAST_UPDATE_LOGIN in NUMBER
25: ) is
26: cursor C is select ROWID from CAC_SR_PERIODS_B
27: where PERIOD_ID = X_PERIOD_ID
28: ;
29: begin
30: insert into CAC_SR_PERIODS_B (

Line 30: insert into CAC_SR_PERIODS_B (

26: cursor C is select ROWID from CAC_SR_PERIODS_B
27: where PERIOD_ID = X_PERIOD_ID
28: ;
29: begin
30: insert into CAC_SR_PERIODS_B (
31: PERIOD_ID,
32: OBJECT_VERSION_NUMBER,
33: START_DATE_ACTIVE,
34: END_DATE_ACTIVE,

Line 140: from CAC_SR_PERIODS_B

136: DURATION_UOM,
137: SHORT_CODE,
138: HAS_DETAILS,
139: SHOW_IN_LOV
140: from CAC_SR_PERIODS_B
141: where PERIOD_ID = X_PERIOD_ID
142: for update of PERIOD_ID nowait;
143: recinfo c%rowtype;
144:

Line 227: update CAC_SR_PERIODS_B set

223: X_LAST_UPDATED_BY in NUMBER,
224: X_LAST_UPDATE_LOGIN in NUMBER
225: ) is
226: begin
227: update CAC_SR_PERIODS_B set
228: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
229: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
230: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
231: PERIOD_CATEGORY_ID = X_PERIOD_CATEGORY_ID,

Line 275: delete from CAC_SR_PERIODS_B

271: if (sql%notfound) then
272: raise no_data_found;
273: end if;
274:
275: delete from CAC_SR_PERIODS_B
276: where PERIOD_ID = X_PERIOD_ID;
277:
278: if (sql%notfound) then
279: raise no_data_found;

Line 289: from CAC_SR_PERIODS_B B

285: begin
286: delete from CAC_SR_PERIODS_TL T
287: where not exists
288: (select NULL
289: from CAC_SR_PERIODS_B B
290: where B.PERIOD_ID = T.PERIOD_ID
291: );
292:
293: update CAC_SR_PERIODS_TL T set (