APPS.CAC_SR_SCHEDULES_PKG dependencies on CAC_SR_SCHEDULES_B

Line 21: cursor C is select ROWID from CAC_SR_SCHEDULES_B

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from CAC_SR_SCHEDULES_B
22: where SCHEDULE_ID = X_SCHEDULE_ID
23: ;
24: begin
25: insert into CAC_SR_SCHEDULES_B (

Line 25: insert into CAC_SR_SCHEDULES_B (

21: cursor C is select ROWID from CAC_SR_SCHEDULES_B
22: where SCHEDULE_ID = X_SCHEDULE_ID
23: ;
24: begin
25: insert into CAC_SR_SCHEDULES_B (
26: SCHEDULE_ID,
27: OBJECT_VERSION_NUMBER,
28: TEMPLATE_ID,
29: TEMPLATE_OVN,

Line 115: from CAC_SR_SCHEDULES_B

111: SCHEDULE_CATEGORY,
112: START_DATE_ACTIVE,
113: END_DATE_ACTIVE,
114: DELETED_DATE
115: from CAC_SR_SCHEDULES_B
116: where SCHEDULE_ID = X_SCHEDULE_ID
117: for update of SCHEDULE_ID nowait;
118: recinfo c%rowtype;
119:

Line 184: update CAC_SR_SCHEDULES_B set

180: X_LAST_UPDATED_BY in NUMBER,
181: X_LAST_UPDATE_LOGIN in NUMBER
182: ) is
183: begin
184: update CAC_SR_SCHEDULES_B set
185: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
186: TEMPLATE_ID = X_TEMPLATE_ID,
187: TEMPLATE_OVN = X_TEMPLATE_OVN,
188: SCHEDULE_CATEGORY = X_SCHEDULE_CATEGORY,

Line 227: delete from CAC_SR_SCHEDULES_B

223: if (sql%notfound) then
224: raise no_data_found;
225: end if;
226:
227: delete from CAC_SR_SCHEDULES_B
228: where SCHEDULE_ID = X_SCHEDULE_ID;
229:
230: if (sql%notfound) then
231: raise no_data_found;

Line 241: from CAC_SR_SCHEDULES_B B

237: begin
238: delete from CAC_SR_SCHEDULES_TL T
239: where not exists
240: (select NULL
241: from CAC_SR_SCHEDULES_B B
242: where B.SCHEDULE_ID = T.SCHEDULE_ID
243: );
244:
245: update CAC_SR_SCHEDULES_TL T set (