APPS.CN_CW_SETUP_TASKS_ALL_PKG dependencies on CN_CW_SETUP_TASKS_ALL_B

Line 22: cursor C is select ROWID from CN_CW_SETUP_TASKS_ALL_B

18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER,
20: X_ORG_ID in NUMBER
21: ) is
22: cursor C is select ROWID from CN_CW_SETUP_TASKS_ALL_B
23: where SETUP_TASK_CODE = X_SETUP_TASK_CODE
24: AND ORG_ID = X_ORG_ID
25: ;
26: begin

Line 27: insert into CN_CW_SETUP_TASKS_ALL_B (

23: where SETUP_TASK_CODE = X_SETUP_TASK_CODE
24: AND ORG_ID = X_ORG_ID
25: ;
26: begin
27: insert into CN_CW_SETUP_TASKS_ALL_B (
28: SETUP_TASK_CODE,
29: WORKBENCH_ITEM_CODE,
30: SETUP_TASK_SEQUENCE,
31: SETUP_TASK_STATUS,

Line 119: from CN_CW_SETUP_TASKS_ALL_B

115: SETUP_TASK_STATUS,
116: SETUP_TASK_TYPE,
117: SETUP_TASK_ACTION,
118: OBJECT_VERSION_NUMBER
119: from CN_CW_SETUP_TASKS_ALL_B
120: where SETUP_TASK_CODE = X_SETUP_TASK_CODE
121: and ORG_ID = X_ORG_ID
122: for update of SETUP_TASK_CODE nowait;
123: recinfo c%rowtype;

Line 190: update CN_CW_SETUP_TASKS_ALL_B set

186: X_LAST_UPDATE_LOGIN in NUMBER,
187: X_ORG_ID in NUMBER
188: ) is
189: begin
190: update CN_CW_SETUP_TASKS_ALL_B set
191: WORKBENCH_ITEM_CODE = X_WORKBENCH_ITEM_CODE,
192: SETUP_TASK_SEQUENCE = X_SETUP_TASK_SEQUENCE,
193: SETUP_TASK_STATUS = X_SETUP_TASK_STATUS,
194: SETUP_TASK_TYPE = X_SETUP_TASK_TYPE,

Line 236: delete from CN_CW_SETUP_TASKS_ALL_B

232: if (sql%notfound) then
233: raise no_data_found;
234: end if;
235:
236: delete from CN_CW_SETUP_TASKS_ALL_B
237: where SETUP_TASK_CODE = X_SETUP_TASK_CODE
238: and ORG_ID = X_ORG_ID;
239:
240: if (sql%notfound) then

Line 301: UPDATE CN_CW_SETUP_TASKS_ALL_B SET

297: USER_ID := 1;
298: ELSE
299: USER_ID := 0;
300: END IF;
301: UPDATE CN_CW_SETUP_TASKS_ALL_B SET
302: WORKBENCH_ITEM_CODE = X_WORKBENCH_ITEM_CODE,
303: SETUP_TASK_SEQUENCE = X_SETUP_TASK_SEQUENCE,
304: SETUP_TASK_STATUS = X_SETUP_TASK_STATUS,
305: SETUP_TASK_TYPE = X_SETUP_TASK_TYPE,

Line 314: INSERT INTO CN_CW_SETUP_TASKS_ALL_B (

310: where SETUP_TASK_CODE = X_SETUP_TASK_CODE;
311:
312: IF (SQL%NOTFOUND) THEN
313: -- Insert new record to _B table
314: INSERT INTO CN_CW_SETUP_TASKS_ALL_B (
315: SETUP_TASK_CODE,
316: WORKBENCH_ITEM_CODE,
317: SETUP_TASK_SEQUENCE,
318: SETUP_TASK_STATUS,

Line 399: from CN_CW_SETUP_TASKS_ALL_B B

395: begin
396: delete from CN_CW_SETUP_TASKS_ALL_TL T
397: where not exists
398: (select NULL
399: from CN_CW_SETUP_TASKS_ALL_B B
400: where B.SETUP_TASK_CODE = T.SETUP_TASK_CODE
401: and B.ORG_ID = T.ORG_ID
402: );
403: