APPS.CAC_SR_TEMPLATES_PKG dependencies on CAC_SR_TEMPLATES_B

Line 20: cursor C is select ROWID from CAC_SR_TEMPLATES_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 CAC_SR_TEMPLATES_B
21: where TEMPLATE_ID = X_TEMPLATE_ID
22: ;
23: begin
24: insert into CAC_SR_TEMPLATES_B (

Line 24: insert into CAC_SR_TEMPLATES_B (

20: cursor C is select ROWID from CAC_SR_TEMPLATES_B
21: where TEMPLATE_ID = X_TEMPLATE_ID
22: ;
23: begin
24: insert into CAC_SR_TEMPLATES_B (
25: TEMPLATE_ID,
26: OBJECT_VERSION_NUMBER,
27: TEMPLATE_TYPE,
28: TEMPLATE_LENGTH_DAYS,

Line 110: from CAC_SR_TEMPLATES_B

106: TEMPLATE_LENGTH_DAYS,
107: START_DATE_ACTIVE,
108: END_DATE_ACTIVE,
109: DELETED_DATE
110: from CAC_SR_TEMPLATES_B
111: where TEMPLATE_ID = X_TEMPLATE_ID
112: for update of TEMPLATE_ID nowait;
113: recinfo c%rowtype;
114:

Line 179: update CAC_SR_TEMPLATES_B set

175: X_LAST_UPDATED_BY in NUMBER,
176: X_LAST_UPDATE_LOGIN in NUMBER
177: ) is
178: begin
179: update CAC_SR_TEMPLATES_B set
180: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
181: TEMPLATE_TYPE = X_TEMPLATE_TYPE,
182: TEMPLATE_LENGTH_DAYS = X_TEMPLATE_LENGTH_DAYS,
183: START_DATE_ACTIVE = X_START_DATE_ACTIVE,

Line 221: delete from CAC_SR_TEMPLATES_B

217: if (sql%notfound) then
218: raise no_data_found;
219: end if;
220:
221: delete from CAC_SR_TEMPLATES_B
222: where TEMPLATE_ID = X_TEMPLATE_ID;
223:
224: if (sql%notfound) then
225: raise no_data_found;

Line 235: from CAC_SR_TEMPLATES_B B

231: begin
232: delete from CAC_SR_TEMPLATES_TL T
233: where not exists
234: (select NULL
235: from CAC_SR_TEMPLATES_B B
236: where B.TEMPLATE_ID = T.TEMPLATE_ID
237: );
238:
239: update CAC_SR_TEMPLATES_TL T set (