APPS.AHL_WARRANTY_TMPL_CTR_PKG dependencies on AHL_WARRANTY_TMPL_CTR_B

Line 36: cursor C is select ROWID from AHL_WARRANTY_TMPL_CTR_B

32: X_LAST_UPDATE_DATE in DATE,
33: X_LAST_UPDATED_BY in NUMBER,
34: X_LAST_UPDATE_LOGIN in NUMBER
35: ) is
36: cursor C is select ROWID from AHL_WARRANTY_TMPL_CTR_B
37: where WARRANTY_TMPL_COUNTER_ID = X_WARRANTY_TMPL_COUNTER_ID
38: ;
39: begin
40: insert into AHL_WARRANTY_TMPL_CTR_B (

Line 40: insert into AHL_WARRANTY_TMPL_CTR_B (

36: cursor C is select ROWID from AHL_WARRANTY_TMPL_CTR_B
37: where WARRANTY_TMPL_COUNTER_ID = X_WARRANTY_TMPL_COUNTER_ID
38: ;
39: begin
40: insert into AHL_WARRANTY_TMPL_CTR_B (
41: WARRANTY_TMPL_COUNTER_ID,
42: OBJECT_VERSION_NUMBER,
43: WARRANTY_TEMPLATE_ID,
44: COUNTER_ID,

Line 188: from AHL_WARRANTY_TMPL_CTR_B

184: ATTRIBUTE12,
185: ATTRIBUTE13,
186: ATTRIBUTE14,
187: ATTRIBUTE15
188: from AHL_WARRANTY_TMPL_CTR_B
189: where WARRANTY_TMPL_COUNTER_ID = X_WARRANTY_TMPL_COUNTER_ID
190: for update of WARRANTY_TMPL_COUNTER_ID nowait;
191: recinfo c%rowtype;
192:

Line 307: update AHL_WARRANTY_TMPL_CTR_B set

303: X_LAST_UPDATED_BY in NUMBER,
304: X_LAST_UPDATE_LOGIN in NUMBER
305: ) is
306: begin
307: update AHL_WARRANTY_TMPL_CTR_B set
308: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
309: WARRANTY_TEMPLATE_ID = X_WARRANTY_TEMPLATE_ID,
310: COUNTER_ID = X_COUNTER_ID,
311: THRESHOLD = X_THRESHOLD,

Line 365: delete from AHL_WARRANTY_TMPL_CTR_B

361: if (sql%notfound) then
362: raise no_data_found;
363: end if;
364:
365: delete from AHL_WARRANTY_TMPL_CTR_B
366: where WARRANTY_TMPL_COUNTER_ID = X_WARRANTY_TMPL_COUNTER_ID;
367:
368: if (sql%notfound) then
369: raise no_data_found;

Line 379: from AHL_WARRANTY_TMPL_CTR_B B

375: begin
376: delete from AHL_WARRANTY_TMPL_CTR_TL T
377: where not exists
378: (select NULL
379: from AHL_WARRANTY_TMPL_CTR_B B
380: where B.WARRANTY_TMPL_COUNTER_ID = T.WARRANTY_TMPL_COUNTER_ID
381: );
382:
383: update AHL_WARRANTY_TMPL_CTR_TL T set (