APPS.CUG_TSK_TYP_ATTR_MAPS_PKG dependencies on CUG_TSK_TYP_ATTR_MAPS_B

Line 37: cursor C is select ROWID from CUG_TSK_TYP_ATTR_MAPS_B

33: X_LAST_UPDATE_DATE in DATE,
34: X_LAST_UPDATED_BY in NUMBER,
35: X_LAST_UPDATE_LOGIN in NUMBER
36: ) is
37: cursor C is select ROWID from CUG_TSK_TYP_ATTR_MAPS_B
38: where TSK_TYP_ATTR_MAP_ID = X_TSK_TYP_ATTR_MAP_ID
39: ;
40: begin
41: insert into CUG_TSK_TYP_ATTR_MAPS_B (

Line 41: insert into CUG_TSK_TYP_ATTR_MAPS_B (

37: cursor C is select ROWID from CUG_TSK_TYP_ATTR_MAPS_B
38: where TSK_TYP_ATTR_MAP_ID = X_TSK_TYP_ATTR_MAP_ID
39: ;
40: begin
41: insert into CUG_TSK_TYP_ATTR_MAPS_B (
42: END_DATE_ACTIVE,
43: TSK_TYP_ATTR_MAP_ID,
44: OBJECT_VERSION_NUMBER,
45: START_DATE_ACTIVE,

Line 196: from CUG_TSK_TYP_ATTR_MAPS_B

192: ATTRIBUTE13,
193: ATTRIBUTE14,
194: ATTRIBUTE15,
195: ATTRIBUTE_CATEGORY
196: from CUG_TSK_TYP_ATTR_MAPS_B
197: where TSK_TYP_ATTR_MAP_ID = X_TSK_TYP_ATTR_MAP_ID
198: for update of TSK_TYP_ATTR_MAP_ID nowait;
199: recinfo c%rowtype;
200:

Line 317: update CUG_TSK_TYP_ATTR_MAPS_B set

313: X_LAST_UPDATED_BY in NUMBER,
314: X_LAST_UPDATE_LOGIN in NUMBER
315: ) is
316: begin
317: update CUG_TSK_TYP_ATTR_MAPS_B set
318: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
319: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
320: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
321: TASK_TYPE_ATTRIBUTE_CODE = X_TASK_TYPE_ATTRIBUTE_CODE,

Line 376: delete from CUG_TSK_TYP_ATTR_MAPS_B

372: if (sql%notfound) then
373: raise no_data_found;
374: end if;
375:
376: delete from CUG_TSK_TYP_ATTR_MAPS_B
377: where TSK_TYP_ATTR_MAP_ID = X_TSK_TYP_ATTR_MAP_ID;
378:
379: if (sql%notfound) then
380: raise no_data_found;

Line 518: from CUG_TSK_TYP_ATTR_MAPS_B B

514: begin
515: delete from CUG_TSK_TYP_ATTR_MAPS_TL T
516: where not exists
517: (select NULL
518: from CUG_TSK_TYP_ATTR_MAPS_B B
519: where B.TSK_TYP_ATTR_MAP_ID = T.TSK_TYP_ATTR_MAP_ID
520: );
521:
522: update CUG_TSK_TYP_ATTR_MAPS_TL T set (