APPS.CUG_TSK_TYP_ATTR_DEPS_PKG dependencies on CUG_TSK_TYP_ATTR_DEPS_B

Line 36: cursor C is select ROWID from CUG_TSK_TYP_ATTR_DEPS_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 CUG_TSK_TYP_ATTR_DEPS_B
37: where TSK_TYP_ATTR_DEP_ID = X_TSK_TYP_ATTR_DEP_ID
38: ;
39: begin
40: insert into CUG_TSK_TYP_ATTR_DEPS_B (

Line 40: insert into CUG_TSK_TYP_ATTR_DEPS_B (

36: cursor C is select ROWID from CUG_TSK_TYP_ATTR_DEPS_B
37: where TSK_TYP_ATTR_DEP_ID = X_TSK_TYP_ATTR_DEP_ID
38: ;
39: begin
40: insert into CUG_TSK_TYP_ATTR_DEPS_B (
41: TSK_TYP_ATTR_DEP_ID,
42: OBJECT_VERSION_NUMBER,
43: INCIDENT_TYPE_ID,
44: TASK_TYPE_ID,

Line 191: from CUG_TSK_TYP_ATTR_DEPS_B

187: ATTRIBUTE13,
188: ATTRIBUTE14,
189: ATTRIBUTE15,
190: ATTRIBUTE_CATEGORY
191: from CUG_TSK_TYP_ATTR_DEPS_B
192: where TSK_TYP_ATTR_DEP_ID = X_TSK_TYP_ATTR_DEP_ID
193: for update of TSK_TYP_ATTR_DEP_ID nowait;
194: recinfo c%rowtype;
195:

Line 309: update CUG_TSK_TYP_ATTR_DEPS_B set

305: X_LAST_UPDATED_BY in NUMBER,
306: X_LAST_UPDATE_LOGIN in NUMBER
307: ) is
308: begin
309: update CUG_TSK_TYP_ATTR_DEPS_B set
310: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
311: INCIDENT_TYPE_ID = X_INCIDENT_TYPE_ID,
312: TASK_TYPE_ID = X_TASK_TYPE_ID,
313: SR_ATTRIBUTE_CODE = X_SR_ATTRIBUTE_CODE,

Line 367: delete from CUG_TSK_TYP_ATTR_DEPS_B

363: if (sql%notfound) then
364: raise no_data_found;
365: end if;
366:
367: delete from CUG_TSK_TYP_ATTR_DEPS_B
368: where TSK_TYP_ATTR_DEP_ID = X_TSK_TYP_ATTR_DEP_ID;
369:
370: if (sql%notfound) then
371: raise no_data_found;

Line 381: from CUG_TSK_TYP_ATTR_DEPS_B B

377: begin
378: delete from CUG_TSK_TYP_ATTR_DEPS_TL T
379: where not exists
380: (select NULL
381: from CUG_TSK_TYP_ATTR_DEPS_B B
382: where B.TSK_TYP_ATTR_DEP_ID = T.TSK_TYP_ATTR_DEP_ID
383: );
384:
385: update CUG_TSK_TYP_ATTR_DEPS_TL T set (