APPS.JTF_TASK_STATUSES_PKG dependencies on JTF_TASK_STATUSES_B

Line 56: cursor C is select ROWID from JTF_TASK_STATUSES_B

52: X_VALIDATION_START_DATE IN DATE DEFAULT NULL,
53: X_VALIDATION_END_DATE IN DATE DEFAULT NULL,
54: X_RESTRICT_UPDATES_FLAG in VARCHAR2 DEFAULT NULL
55: ) is
56: cursor C is select ROWID from JTF_TASK_STATUSES_B
57: where TASK_STATUS_ID = X_TASK_STATUS_ID
58: ;
59: begin
60: insert into JTF_TASK_STATUSES_B (

Line 60: insert into JTF_TASK_STATUSES_B (

56: cursor C is select ROWID from JTF_TASK_STATUSES_B
57: where TASK_STATUS_ID = X_TASK_STATUS_ID
58: ;
59: begin
60: insert into JTF_TASK_STATUSES_B (
61: TASK_STATUS_ID,
62: CLOSED_FLAG,
63: START_DATE_ACTIVE,
64: END_DATE_ACTIVE,

Line 284: update JTF_TASK_STATUSES_B set

280: X_VALIDATION_END_DATE IN DATE DEFAULT NULL,
281: X_RESTRICT_UPDATES_FLAG in VARCHAR2 DEFAULT NULL
282: ) is
283: begin
284: update JTF_TASK_STATUSES_B set
285: CLOSED_FLAG = X_CLOSED_FLAG,
286: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER + 1,
287: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
288: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 363: delete from JTF_TASK_STATUSES_B

359: if (sql%notfound) then
360: raise no_data_found;
361: end if;
362:
363: delete from JTF_TASK_STATUSES_B
364: where TASK_STATUS_ID = X_TASK_STATUS_ID ;
365:
366: if (sql%notfound) then
367: raise no_data_found;

Line 382: from JTF_TASK_STATUSES_B B

378:
379: /* delete from JTF_TASK_STATUSES_TL T
380: where not exists
381: (select NULL
382: from JTF_TASK_STATUSES_B B
383: where B.TASK_STATUS_ID = T.TASK_STATUS_ID
384: );
385:
386: update JTF_TASK_STATUSES_TL T set (

Line 533: update JTF_TASK_STATUSES_B set

529: WHERE task_status_id = x_task_status_id;
530:
531:
532:
533: update JTF_TASK_STATUSES_B set
534: CLOSED_FLAG = X_CLOSED_FLAG,
535: OBJECT_VERSION_NUMBER = l_object_version_number + 1,
536: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
537: END_DATE_ACTIVE = X_END_DATE_ACTIVE,