APPS.JTF_CALENDARS_PKG dependencies on JTF_CALENDARS_B

Line 35: cursor C is select ROWID from JTF_CALENDARS_B

31: X_LAST_UPDATE_DATE in DATE,
32: X_LAST_UPDATED_BY in NUMBER,
33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: cursor C is select ROWID from JTF_CALENDARS_B
36: where CALENDAR_ID = X_CALENDAR_ID;
37:
38: v_error CHAR := 'N';
39: v_calendar_id NUMBER;

Line 106: insert into JTF_CALENDARS_B (

102: FROM dual;
103:
104: X_CALENDAR_ID := v_calendar_id;
105:
106: insert into JTF_CALENDARS_B (
107: OBJECT_VERSION_NUMBER,
108: CALENDAR_ID,
109: START_DATE_ACTIVE,
110: END_DATE_ACTIVE,

Line 249: from JTF_CALENDARS_B

245: ATTRIBUTE14,
246: ATTRIBUTE15,
247: ATTRIBUTE_CATEGORY,
248: CALENDAR_TYPE
249: from JTF_CALENDARS_B
250: where CALENDAR_ID = X_CALENDAR_ID
251: for update of CALENDAR_ID nowait;
252: recinfo c%rowtype;
253:

Line 433: update JTF_CALENDARS_B set

429: ELSE
430: X_ERROR := 'N';
431: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
432:
433: update JTF_CALENDARS_B set
434: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
435: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
436: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
437: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 512: delete from JTF_CALENDARS_B

508: if (sql%notfound) then
509: raise no_data_found;
510: end if;
511:
512: delete from JTF_CALENDARS_B
513: where CALENDAR_ID = X_CALENDAR_ID;
514:
515: if (sql%notfound) then
516: raise no_data_found;

Line 526: from JTF_CALENDARS_B B

522: begin
523: delete from JTF_CALENDARS_TL T
524: where not exists
525: (select NULL
526: from JTF_CALENDARS_B B
527: where B.CALENDAR_ID = T.CALENDAR_ID
528: );
529:
530: update JTF_CALENDARS_TL T set (