APPS.IBY_SETUP_TASKS_PKG dependencies on IBY_SETUP_TASKS_B

Line 22: cursor C is select ROWID from IBY_SETUP_TASKS_B

18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: cursor C is select ROWID from IBY_SETUP_TASKS_B
23: where TASK_CODE = X_TASK_CODE
24: ;
25: begin
26: insert into IBY_SETUP_TASKS_B (

Line 26: insert into IBY_SETUP_TASKS_B (

22: cursor C is select ROWID from IBY_SETUP_TASKS_B
23: where TASK_CODE = X_TASK_CODE
24: ;
25: begin
26: insert into IBY_SETUP_TASKS_B (
27: TASK_CODE,
28: STATUS,
29: LEAF_NODE_FLAG,
30: PARENT_TASK_CODE,

Line 118: from IBY_SETUP_TASKS_B

114: DEST_FUNCTION_NAME,
115: SETUP_FLOW_CODE,
116: DISPLAY_ORDER,
117: OBJECT_VERSION_NUMBER
118: from IBY_SETUP_TASKS_B
119: where TASK_CODE = X_TASK_CODE
120: for update of TASK_CODE nowait;
121: recinfo c%rowtype;
122:

Line 192: update IBY_SETUP_TASKS_B set

188: X_LAST_UPDATED_BY in NUMBER,
189: X_LAST_UPDATE_LOGIN in NUMBER
190: ) is
191: begin
192: update IBY_SETUP_TASKS_B set
193: STATUS = X_STATUS,
194: LEAF_NODE_FLAG = X_LEAF_NODE_FLAG,
195: PARENT_TASK_CODE = X_PARENT_TASK_CODE,
196: DEST_FUNCTION_NAME = X_DEST_FUNCTION_NAME,

Line 240: update IBY_SETUP_TASKS_B set

236: X_LAST_UPDATED_BY in NUMBER,
237: X_LAST_UPDATE_LOGIN in NUMBER
238: ) is
239: begin
240: update IBY_SETUP_TASKS_B set
241: LEAF_NODE_FLAG = X_LEAF_NODE_FLAG,
242: PARENT_TASK_CODE = X_PARENT_TASK_CODE,
243: DEST_FUNCTION_NAME = X_DEST_FUNCTION_NAME,
244: SETUP_FLOW_CODE = X_SETUP_FLOW_CODE,

Line 282: delete from IBY_SETUP_TASKS_B

278: if (sql%notfound) then
279: raise no_data_found;
280: end if;
281:
282: delete from IBY_SETUP_TASKS_B
283: where TASK_CODE = X_TASK_CODE;
284:
285: if (sql%notfound) then
286: raise no_data_found;

Line 296: from IBY_SETUP_TASKS_B B

292: begin
293: delete from IBY_SETUP_TASKS_TL T
294: where not exists
295: (select NULL
296: from IBY_SETUP_TASKS_B B
297: where B.TASK_CODE = T.TASK_CODE
298: );
299:
300: update IBY_SETUP_TASKS_TL T set (