APPS.JTF_TASK_DATE_TYPES_PKG dependencies on JTF_TASK_DATE_TYPES_B

Line 32: cursor C is select ROWID from JTF_TASK_DATE_TYPES_B

28: X_LAST_UPDATE_DATE in DATE,
29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER
31: ) is
32: cursor C is select ROWID from JTF_TASK_DATE_TYPES_B
33: where DATE_TYPE_ID = X_DATE_TYPE_ID
34: ;
35: begin
36: insert into JTF_TASK_DATE_TYPES_B (

Line 36: insert into JTF_TASK_DATE_TYPES_B (

32: cursor C is select ROWID from JTF_TASK_DATE_TYPES_B
33: where DATE_TYPE_ID = X_DATE_TYPE_ID
34: ;
35: begin
36: insert into JTF_TASK_DATE_TYPES_B (
37: DATE_TYPE_ID,
38: SEQUENCE,
39: APPLICATION_REFERENCE,
40: ATTRIBUTE1,

Line 189: update JTF_TASK_DATE_TYPES_B set

185: X_LAST_UPDATED_BY in NUMBER,
186: X_LAST_UPDATE_LOGIN in NUMBER
187: ) is
188: begin
189: update JTF_TASK_DATE_TYPES_B set
190: SEQUENCE = X_SEQUENCE,
191: /*changed from X_OBJECT_VERSION_NUMBER TO X_OBJECT_VERSION_NUMBER +1 */
192: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER+1,
193: APPLICATION_REFERENCE = X_APPLICATION_REFERENCE,

Line 245: delete from JTF_TASK_DATE_TYPES_B

241: if (sql%notfound) then
242: raise no_data_found;
243: end if;
244:
245: delete from JTF_TASK_DATE_TYPES_B
246: where DATE_TYPE_ID = X_DATE_TYPE_ID ;
247:
248: if (sql%notfound) then
249: raise no_data_found;

Line 265: from JTF_TASK_DATE_TYPES_B B

261:
262: delete from JTF_TASK_DATE_TYPES_TL T
263: where not exists
264: (select NULL
265: from JTF_TASK_DATE_TYPES_B B
266: where B.DATE_TYPE_ID = T.DATE_TYPE_ID
267: );
268:
269: update JTF_TASK_DATE_TYPES_TL T set (