APPS.JTF_TASK_STATUSES_PKG dependencies on JTF_TASK_STATUSES_B

Line 50: cursor C is select ROWID from JTF_TASK_STATUSES_B

46: X_ASSIGNMENT_STATUS_FLAG in VARCHAR2,
47: X_START_DATE_TYPE IN VARCHAR2,
48: X_END_DATE_TYPE IN VARCHAR2
49: ) is
50: cursor C is select ROWID from JTF_TASK_STATUSES_B
51: where TASK_STATUS_ID = X_TASK_STATUS_ID
52: ;
53: begin
54: insert into JTF_TASK_STATUSES_B (

Line 54: insert into JTF_TASK_STATUSES_B (

50: cursor C is select ROWID from JTF_TASK_STATUSES_B
51: where TASK_STATUS_ID = X_TASK_STATUS_ID
52: ;
53: begin
54: insert into JTF_TASK_STATUSES_B (
55: TASK_STATUS_ID,
56: CLOSED_FLAG,
57: START_DATE_ACTIVE,
58: END_DATE_ACTIVE,

Line 260: update JTF_TASK_STATUSES_B set

256: X_START_DATE_TYPE IN VARCHAR2 DEFAULT NULL,
257: X_END_DATE_TYPE IN VARCHAR2 DEFAULT NULL
258: ) is
259: begin
260: update JTF_TASK_STATUSES_B set
261: CLOSED_FLAG = X_CLOSED_FLAG,
262: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER + 1,
263: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
264: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 333: delete from JTF_TASK_STATUSES_B

329: if (sql%notfound) then
330: raise no_data_found;
331: end if;
332:
333: delete from JTF_TASK_STATUSES_B
334: where TASK_STATUS_ID = X_TASK_STATUS_ID ;
335:
336: if (sql%notfound) then
337: raise no_data_found;

Line 352: from JTF_TASK_STATUSES_B B

348:
349: /* delete from JTF_TASK_STATUSES_TL T
350: where not exists
351: (select NULL
352: from JTF_TASK_STATUSES_B B
353: where B.TASK_STATUS_ID = T.TASK_STATUS_ID
354: );
355:
356: update JTF_TASK_STATUSES_TL T set (

Line 501: update JTF_TASK_STATUSES_B set

497: WHERE task_status_id = x_task_status_id;
498:
499:
500:
501: update JTF_TASK_STATUSES_B set
502: CLOSED_FLAG = X_CLOSED_FLAG,
503: OBJECT_VERSION_NUMBER = l_object_version_number + 1,
504: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
505: END_DATE_ACTIVE = X_END_DATE_ACTIVE,