APPS.CAC_SR_EXCEPTIONS_PKG dependencies on CAC_SR_EXCEPTIONS_B

Line 22: cursor C is select ROWID from CAC_SR_EXCEPTIONS_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 CAC_SR_EXCEPTIONS_B
23: where EXCEPTION_ID = X_EXCEPTION_ID
24: ;
25: begin
26: insert into CAC_SR_EXCEPTIONS_B (

Line 26: insert into CAC_SR_EXCEPTIONS_B (

22: cursor C is select ROWID from CAC_SR_EXCEPTIONS_B
23: where EXCEPTION_ID = X_EXCEPTION_ID
24: ;
25: begin
26: insert into CAC_SR_EXCEPTIONS_B (
27: EXCEPTION_ID,
28: OBJECT_VERSION_NUMBER,
29: EXCEPTION_GROUP,
30: EXCEPTION_TYPE,

Line 120: from CAC_SR_EXCEPTIONS_B

116: TEMPLATE_ID,
117: START_DATE_TIME,
118: END_DATE_TIME,
119: WHOLE_DAY_FLAG
120: from CAC_SR_EXCEPTIONS_B
121: where EXCEPTION_ID = X_EXCEPTION_ID
122: for update of EXCEPTION_ID nowait;
123: recinfo c%rowtype;
124:

Line 194: update CAC_SR_EXCEPTIONS_B set

190: X_LAST_UPDATED_BY in NUMBER,
191: X_LAST_UPDATE_LOGIN in NUMBER
192: ) is
193: begin
194: update CAC_SR_EXCEPTIONS_B set
195: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
196: EXCEPTION_GROUP = X_EXCEPTION_GROUP,
197: EXCEPTION_TYPE = X_EXCEPTION_TYPE,
198: PERIOD_CATEGORY_ID = X_PERIOD_CATEGORY_ID,

Line 238: delete from CAC_SR_EXCEPTIONS_B

234: if (sql%notfound) then
235: raise no_data_found;
236: end if;
237:
238: delete from CAC_SR_EXCEPTIONS_B
239: where EXCEPTION_ID = X_EXCEPTION_ID;
240:
241: if (sql%notfound) then
242: raise no_data_found;

Line 252: from CAC_SR_EXCEPTIONS_B B

248: begin
249: delete from CAC_SR_EXCEPTIONS_TL T
250: where not exists
251: (select NULL
252: from CAC_SR_EXCEPTIONS_B B
253: where B.EXCEPTION_ID = T.EXCEPTION_ID
254: );
255:
256: update CAC_SR_EXCEPTIONS_TL T set (