APPS.JTF_TASK_PRIORITIES_PKG dependencies on JTF_TASK_PRIORITIES_B

Line 34: cursor C is select ROWID from JTF_TASK_PRIORITIES_B

30: X_LAST_UPDATE_DATE in DATE,
31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER
33: ) is
34: cursor C is select ROWID from JTF_TASK_PRIORITIES_B
35: where TASK_PRIORITY_ID = X_TASK_PRIORITY_ID
36: ;
37: begin
38: insert into JTF_TASK_PRIORITIES_B (

Line 38: insert into JTF_TASK_PRIORITIES_B (

34: cursor C is select ROWID from JTF_TASK_PRIORITIES_B
35: where TASK_PRIORITY_ID = X_TASK_PRIORITY_ID
36: ;
37: begin
38: insert into JTF_TASK_PRIORITIES_B (
39: TASK_PRIORITY_ID,
40: IMPORTANCE_LEVEL,
41: START_DATE_ACTIVE,
42: END_DATE_ACTIVE,

Line 197: update JTF_TASK_PRIORITIES_B set

193: X_LAST_UPDATED_BY in NUMBER,
194: X_LAST_UPDATE_LOGIN in NUMBER
195: ) is
196: begin
197: update JTF_TASK_PRIORITIES_B set
198: IMPORTANCE_LEVEL = X_IMPORTANCE_LEVEL,
199: /*CHANGED TO OBJECT_VERSION_NUMBER +1 */
200: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER+1,
201: START_DATE_ACTIVE = X_START_DATE_ACTIVE,

Line 255: delete from JTF_TASK_PRIORITIES_B

251: if (sql%notfound) then
252: raise no_data_found;
253: end if;
254:
255: delete from JTF_TASK_PRIORITIES_B
256: where TASK_PRIORITY_ID = X_TASK_PRIORITY_ID ;
257:
258: if (sql%notfound) then
259: raise no_data_found;

Line 274: from JTF_TASK_PRIORITIES_B B

270: /*
271: delete from JTF_TASK_PRIORITIES_TL T
272: where not exists
273: (select NULL
274: from JTF_TASK_PRIORITIES_B B
275: where B.TASK_PRIORITY_ID = T.TASK_PRIORITY_ID
276: );
277:
278: update JTF_TASK_PRIORITIES_TL T set (

Line 409: update JTF_TASK_PRIORITIES_B set

405: where task_priority_id = x_task_priority_id;
406:
407:
408:
409: update JTF_TASK_PRIORITIES_B set
410: IMPORTANCE_LEVEL = X_IMPORTANCE_LEVEL,
411: /*CHANGED TO OBJECT_VERSION_NUMBER +1 */
412: OBJECT_VERSION_NUMBER = l_object_version_number+1,
413: START_DATE_ACTIVE = X_START_DATE_ACTIVE,