APPS.CUG_SR_TASK_ATTR_VALS_PKG dependencies on CUG_SR_TASK_ATTR_VALS_B

Line 16: cursor C is select ROWID from CUG_SR_TASK_ATTR_VALS_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from CUG_SR_TASK_ATTR_VALS_B
17: where SR_TASK_ATTR_VAL_ID = X_SR_TASK_ATTR_VAL_ID
18: ;
19: begin
20: insert into CUG_SR_TASK_ATTR_VALS_B (

Line 20: insert into CUG_SR_TASK_ATTR_VALS_B (

16: cursor C is select ROWID from CUG_SR_TASK_ATTR_VALS_B
17: where SR_TASK_ATTR_VAL_ID = X_SR_TASK_ATTR_VAL_ID
18: ;
19: begin
20: insert into CUG_SR_TASK_ATTR_VALS_B (
21: SR_TASK_ATTR_VAL_ID,
22: OBJECT_VERSION_NUMBER,
23: TSK_TYP_ATTR_DEPEND_ID,
24: TASK_TYPE_ATTR_MAP_ID,

Line 91: from CUG_SR_TASK_ATTR_VALS_B

87: cursor c is select
88: OBJECT_VERSION_NUMBER,
89: TSK_TYP_ATTR_DEPEND_ID,
90: TASK_TYPE_ATTR_MAP_ID
91: from CUG_SR_TASK_ATTR_VALS_B
92: where SR_TASK_ATTR_VAL_ID = X_SR_TASK_ATTR_VAL_ID
93: for update of SR_TASK_ATTR_VAL_ID nowait;
94: recinfo c%rowtype;
95:

Line 149: update CUG_SR_TASK_ATTR_VALS_B set

145: X_LAST_UPDATED_BY in NUMBER,
146: X_LAST_UPDATE_LOGIN in NUMBER
147: ) is
148: begin
149: update CUG_SR_TASK_ATTR_VALS_B set
150: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
151: TSK_TYP_ATTR_DEPEND_ID = X_TSK_TYP_ATTR_DEPEND_ID,
152: TASK_TYPE_ATTR_MAP_ID = X_TASK_TYPE_ATTR_MAP_ID,
153: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 187: delete from CUG_SR_TASK_ATTR_VALS_B

183: if (sql%notfound) then
184: raise no_data_found;
185: end if;
186:
187: delete from CUG_SR_TASK_ATTR_VALS_B
188: where SR_TASK_ATTR_VAL_ID = X_SR_TASK_ATTR_VAL_ID;
189:
190: if (sql%notfound) then
191: raise no_data_found;

Line 201: from CUG_SR_TASK_ATTR_VALS_B B

197: begin
198: delete from CUG_SR_TASK_ATTR_VALS_TL T
199: where not exists
200: (select NULL
201: from CUG_SR_TASK_ATTR_VALS_B B
202: where B.SR_TASK_ATTR_VAL_ID = T.SR_TASK_ATTR_VAL_ID
203: );
204:
205: update CUG_SR_TASK_ATTR_VALS_TL T set (