APPS.JTF_CAL_SHIFTS_PKG dependencies on JTF_CAL_SHIFTS_B

Line 37: cursor C is select ROWID from JTF_CAL_SHIFTS_B

33: ) is
34:
35: v_error CHAR := 'N';
36: v_shift_id NUMBER;
37: cursor C is select ROWID from JTF_CAL_SHIFTS_B
38: where SHIFT_ID = X_SHIFT_ID;
39: begin
40: fnd_msg_pub.initialize;
41: IF JTF_CAL_SHIFTS_PKG.NOT_NULL(X_START_DATE_ACTIVE) = FALSE THEN

Line 139: insert into JTF_CAL_SHIFTS_B (

135: END IF; -- End of User Hook Check for INSERT
136: */
137: -- End of Comment
138:
139: insert into JTF_CAL_SHIFTS_B (
140: OBJECT_VERSION_NUMBER,
141: SHIFT_ID,
142: START_DATE_ACTIVE,
143: END_DATE_ACTIVE,

Line 278: from JTF_CAL_SHIFTS_B

274: ATTRIBUTE13,
275: ATTRIBUTE14,
276: ATTRIBUTE15,
277: ATTRIBUTE_CATEGORY
278: from JTF_CAL_SHIFTS_B
279: where SHIFT_ID = X_SHIFT_ID
280: for update of SHIFT_ID nowait;
281: recinfo c%rowtype;
282:

Line 464: update JTF_CAL_SHIFTS_B set

460:
461: */
462: -- End of comment
463:
464: update JTF_CAL_SHIFTS_B set
465: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
466: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
467: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
468: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 563: delete from JTF_CAL_SHIFTS_B

559: if (sql%notfound) then
560: raise no_data_found;
561: end if;
562:
563: delete from JTF_CAL_SHIFTS_B
564: where SHIFT_ID = X_SHIFT_ID;
565:
566: if (sql%notfound) then
567: raise no_data_found;

Line 577: from JTF_CAL_SHIFTS_B B

573: begin
574: delete from JTF_CAL_SHIFTS_TL T
575: where not exists
576: (select NULL
577: from JTF_CAL_SHIFTS_B B
578: where B.SHIFT_ID = T.SHIFT_ID
579: );
580:
581: update JTF_CAL_SHIFTS_TL T set (