APPS.CN_CW_WORKBENCH_ITEMS_ALL_PKG dependencies on CN_CW_WORKBENCH_ITEMS_ALL_B

Line 20: cursor C is select ROWID from CN_CW_WORKBENCH_ITEMS_ALL_B

16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER,
18: X_ORG_ID IN NUMBER
19: ) is
20: cursor C is select ROWID from CN_CW_WORKBENCH_ITEMS_ALL_B
21: where WORKBENCH_ITEM_CODE = X_WORKBENCH_ITEM_CODE AND
22: ORG_ID=X_ORG_ID;
23: begin
24: insert into CN_CW_WORKBENCH_ITEMS_ALL_B (

Line 24: insert into CN_CW_WORKBENCH_ITEMS_ALL_B (

20: cursor C is select ROWID from CN_CW_WORKBENCH_ITEMS_ALL_B
21: where WORKBENCH_ITEM_CODE = X_WORKBENCH_ITEM_CODE AND
22: ORG_ID=X_ORG_ID;
23: begin
24: insert into CN_CW_WORKBENCH_ITEMS_ALL_B (
25: WORKBENCH_ITEM_CODE,
26: WORKBENCH_ITEM_SEQUENCE,
27: WORKBENCH_PARENT_ITEM_CODE,
28: WORKBENCH_ITEM_TYPE,

Line 109: from CN_CW_WORKBENCH_ITEMS_ALL_B

105: WORKBENCH_PARENT_ITEM_CODE,
106: WORKBENCH_ITEM_TYPE,
107: OBJECT_VERSION_NUMBER,
108: ORG_ID
109: from CN_CW_WORKBENCH_ITEMS_ALL_B
110: where WORKBENCH_ITEM_CODE = X_WORKBENCH_ITEM_CODE AND
111: ORG_ID=X_ORG_ID
112: for update of WORKBENCH_ITEM_CODE nowait;
113: recinfo c%rowtype;

Line 176: update CN_CW_WORKBENCH_ITEMS_ALL_B set

172: X_LAST_UPDATE_LOGIN in NUMBER,
173: X_ORG_ID IN NUMBER
174: ) is
175: begin
176: update CN_CW_WORKBENCH_ITEMS_ALL_B set
177: WORKBENCH_ITEM_SEQUENCE = X_WORKBENCH_ITEM_SEQUENCE,
178: WORKBENCH_PARENT_ITEM_CODE = X_WORKBENCH_PARENT_ITEM_CODE,
179: WORKBENCH_ITEM_TYPE = X_WORKBENCH_ITEM_TYPE,
180: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 220: delete from CN_CW_WORKBENCH_ITEMS_ALL_B

216: if (sql%notfound) then
217: raise no_data_found;
218: end if;
219:
220: delete from CN_CW_WORKBENCH_ITEMS_ALL_B
221: where WORKBENCH_ITEM_CODE = X_WORKBENCH_ITEM_CODE AND
222: ORG_ID=X_ORG_ID;
223:
224: if (sql%notfound) then

Line 235: from CN_CW_WORKBENCH_ITEMS_ALL_B B

231: begin
232: delete from CN_CW_WORKBENCH_ITEMS_ALL_TL T
233: where not exists
234: (select NULL
235: from CN_CW_WORKBENCH_ITEMS_ALL_B B
236: where B.WORKBENCH_ITEM_CODE = T.WORKBENCH_ITEM_CODE AND
237: B.ORG_ID=T.ORG_ID
238: );
239:

Line 354: UPDATE CN_CW_WORKBENCH_ITEMS_ALL_B SET

350: USER_ID := 1;
351: ELSE
352: USER_ID := 0;
353: END IF;
354: UPDATE CN_CW_WORKBENCH_ITEMS_ALL_B SET
355: WORKBENCH_ITEM_SEQUENCE = X_WORKBENCH_ITEM_SEQUENCE,
356: WORKBENCH_PARENT_ITEM_CODE = X_WORKBENCH_PARENT_ITEM_CODE,
357: WORKBENCH_ITEM_TYPE = X_WORKBENCH_ITEM_TYPE,
358: LAST_UPDATE_DATE = SYSDATE,

Line 365: insert into CN_CW_WORKBENCH_ITEMS_ALL_B (

361: where WORKBENCH_ITEM_CODE = X_WORKBENCH_ITEM_CODE;
362:
363: IF (SQL%NOTFOUND) THEN
364: -- Insert new record to _B table
365: insert into CN_CW_WORKBENCH_ITEMS_ALL_B (
366: WORKBENCH_ITEM_CODE,
367: WORKBENCH_ITEM_SEQUENCE,
368: WORKBENCH_PARENT_ITEM_CODE,
369: WORKBENCH_ITEM_TYPE,