APPS.ENG_CHANGE_TASKS_PKG dependencies on ENG_CHANGE_TASKS_B

Line 20: cursor C is select ROWID from ENG_CHANGE_TASKS_B

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from ENG_CHANGE_TASKS_B
21: where CHANGE_TASK_ID = X_CHANGE_TASK_ID
22: ;
23: begin
24: insert into ENG_CHANGE_TASKS_B (

Line 24: insert into ENG_CHANGE_TASKS_B (

20: cursor C is select ROWID from ENG_CHANGE_TASKS_B
21: where CHANGE_TASK_ID = X_CHANGE_TASK_ID
22: ;
23: begin
24: insert into ENG_CHANGE_TASKS_B (
25: CHANGE_TASK_ID,
26: ORGANIZATION_ID,
27: SEQUENCE_NUMBER,
28: REQUIRED_FLAG,

Line 110: from ENG_CHANGE_TASKS_B

106: REQUIRED_FLAG,
107: DEFAULT_ASSIGNEE_ID,
108: DEFAULT_ASSIGNEE_TYPE,
109: CHANGE_TEMPLATE_ID
110: from ENG_CHANGE_TASKS_B
111: where CHANGE_TASK_ID = X_CHANGE_TASK_ID
112: for update of CHANGE_TASK_ID nowait;
113: recinfo c%rowtype;
114:

Line 180: update ENG_CHANGE_TASKS_B set

176: X_LAST_UPDATED_BY in NUMBER,
177: X_LAST_UPDATE_LOGIN in NUMBER
178: ) is
179: begin
180: update ENG_CHANGE_TASKS_B set
181: ORGANIZATION_ID = X_ORGANIZATION_ID,
182: SEQUENCE_NUMBER = X_SEQUENCE_NUMBER,
183: REQUIRED_FLAG = X_REQUIRED_FLAG,
184: DEFAULT_ASSIGNEE_ID = X_DEFAULT_ASSIGNEE_ID,

Line 222: delete from ENG_CHANGE_TASKS_B

218: if (sql%notfound) then
219: raise no_data_found;
220: end if;
221:
222: delete from ENG_CHANGE_TASKS_B
223: where CHANGE_TASK_ID = X_CHANGE_TASK_ID;
224:
225: if (sql%notfound) then
226: raise no_data_found;

Line 236: from ENG_CHANGE_TASKS_B B

232: begin
233: delete from ENG_CHANGE_TASKS_TL T
234: where not exists
235: (select NULL
236: from ENG_CHANGE_TASKS_B B
237: where B.CHANGE_TASK_ID = T.CHANGE_TASK_ID
238: );
239:
240: update ENG_CHANGE_TASKS_TL T set (