APPS.JTF_TASK_TEMPLATES_PKG dependencies on JTF_TASK_TEMPLATES_B

Line 58: cursor C is select ROWID from JTF_TASK_TEMPLATES_B

54: X_LAST_UPDATE_DATE in DATE,
55: X_LAST_UPDATED_BY in NUMBER,
56: X_LAST_UPDATE_LOGIN in NUMBER
57: ) is
58: cursor C is select ROWID from JTF_TASK_TEMPLATES_B
59: where TASK_TEMPLATE_ID = X_TASK_TEMPLATE_ID
60: ;
61: begin
62: insert into JTF_TASK_TEMPLATES_B (

Line 62: insert into JTF_TASK_TEMPLATES_B (

58: cursor C is select ROWID from JTF_TASK_TEMPLATES_B
59: where TASK_TEMPLATE_ID = X_TASK_TEMPLATE_ID
60: ;
61: begin
62: insert into JTF_TASK_TEMPLATES_B (
63: ALARM_ON,
64: ALARM_COUNT,
65: ALARM_INTERVAL,
66: ALARM_INTERVAL_UOM,

Line 294: update JTF_TASK_TEMPLATES_B set

290: X_LAST_UPDATED_BY in NUMBER,
291: X_LAST_UPDATE_LOGIN in NUMBER
292: ) is
293: begin
294: update JTF_TASK_TEMPLATES_B set
295: ALARM_ON = X_ALARM_ON,
296: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER + 1,
297: ALARM_COUNT = X_ALARM_COUNT,
298: ALARM_INTERVAL = X_ALARM_INTERVAL,

Line 375: delete from JTF_TASK_TEMPLATES_B

371: if (sql%notfound) then
372: raise no_data_found;
373: end if;
374:
375: delete from JTF_TASK_TEMPLATES_B
376: where TASK_TEMPLATE_ID = X_TASK_TEMPLATE_ID ;
377:
378: if (sql%notfound) then
379: raise no_data_found;

Line 395: from JTF_TASK_TEMPLATES_B B

391:
392: delete from JTF_TASK_TEMPLATES_TL T
393: where not exists
394: (select NULL
395: from JTF_TASK_TEMPLATES_B B
396: where B.TASK_TEMPLATE_ID = T.TASK_TEMPLATE_ID
397: );
398:
399: update JTF_TASK_TEMPLATES_TL T set (