APPS.JTF_CAL_EXCEPTIONS_PKG dependencies on JTF_CAL_EXCEPTIONS_B

Line 36: cursor C is select ROWID from JTF_CAL_EXCEPTIONS_B

32: X_LAST_UPDATED_BY in NUMBER,
33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: v_begin_time date;
36: cursor C is select ROWID from JTF_CAL_EXCEPTIONS_B
37: where EXCEPTION_ID = X_EXCEPTION_ID
38: ;
39:
40: v_exception_id NUMBER;

Line 114: insert into JTF_CAL_EXCEPTIONS_B (

110: INTO v_exception_id
111: FROM dual;
112: X_EXCEPTION_ID := v_exception_id;
113:
114: insert into JTF_CAL_EXCEPTIONS_B (
115: OBJECT_VERSION_NUMBER,
116: EXCEPTION_ID,
117: START_DATE_TIME,
118: END_DATE_TIME,

Line 257: from JTF_CAL_EXCEPTIONS_B

253: ATTRIBUTE13,
254: ATTRIBUTE14,
255: ATTRIBUTE15,
256: ATTRIBUTE_CATEGORY
257: from JTF_CAL_EXCEPTIONS_B
258: where EXCEPTION_ID = X_EXCEPTION_ID
259: for update of EXCEPTION_ID nowait;
260: recinfo c%rowtype;
261:

Line 441: update JTF_CAL_EXCEPTIONS_B set

437: ELSE
438: X_ERROR := 'N';
439: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER +1;
440:
441: update JTF_CAL_EXCEPTIONS_B set
442: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
443: START_DATE_TIME = X_START_DATE_TIME,
444: END_DATE_TIME = X_END_DATE_TIME,
445: EXCEPTION_CATEGORY = X_EXCEPTION_CATEGORY,

Line 521: delete from JTF_CAL_EXCEPTIONS_B

517: if (sql%notfound) then
518: raise no_data_found;
519: end if;
520:
521: delete from JTF_CAL_EXCEPTIONS_B
522: where EXCEPTION_ID = X_EXCEPTION_ID;
523:
524: if (sql%notfound) then
525: raise no_data_found;

Line 535: from JTF_CAL_EXCEPTIONS_B B

531: begin
532: delete from JTF_CAL_EXCEPTIONS_TL T
533: where not exists
534: (select NULL
535: from JTF_CAL_EXCEPTIONS_B B
536: where B.EXCEPTION_ID = T.EXCEPTION_ID
537: );
538:
539: update JTF_CAL_EXCEPTIONS_TL T set (