APPS.JTF_TASK_TEMP_GROUPS_PKG dependencies on JTF_TASK_TEMP_GROUPS_B

Line 34: cursor C is select ROWID from JTF_TASK_TEMP_GROUPS_B

30: X_LAST_UPDATED_BY in NUMBER,
31: X_LAST_UPDATE_LOGIN in NUMBER,
32: X_APPLICATION_ID in NUMBER default null
33: ) is
34: cursor C is select ROWID from JTF_TASK_TEMP_GROUPS_B
35: where TASK_TEMPLATE_GROUP_ID = X_TASK_TEMPLATE_GROUP_ID
36: ;
37: begin
38: insert into JTF_TASK_TEMP_GROUPS_B (

Line 38: insert into JTF_TASK_TEMP_GROUPS_B (

34: cursor C is select ROWID from JTF_TASK_TEMP_GROUPS_B
35: where TASK_TEMPLATE_GROUP_ID = X_TASK_TEMPLATE_GROUP_ID
36: ;
37: begin
38: insert into JTF_TASK_TEMP_GROUPS_B (
39: TASK_TEMPLATE_GROUP_ID,
40: SOURCE_OBJECT_TYPE_CODE,
41: START_DATE_ACTIVE,
42: END_DATE_ACTIVE,

Line 203: update JTF_TASK_TEMP_GROUPS_B set

199: X_LAST_UPDATE_LOGIN in NUMBER,
200: X_APPLICATION_ID in NUMBER default fnd_api.g_miss_num
201: ) is
202: begin
203: update JTF_TASK_TEMP_GROUPS_B set
204: SOURCE_OBJECT_TYPE_CODE = X_SOURCE_OBJECT_TYPE_CODE,
205: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER + 1,
206: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
207: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 261: delete from JTF_TASK_TEMP_GROUPS_B

257: if (sql%notfound) then
258: raise no_data_found;
259: end if;
260:
261: delete from JTF_TASK_TEMP_GROUPS_B
262: where TASK_TEMPLATE_GROUP_ID = X_TASK_TEMPLATE_GROUP_ID ;
263:
264: if (sql%notfound) then
265: raise no_data_found;

Line 275: from JTF_TASK_TEMP_GROUPS_B B

271: begin
272: delete from JTF_TASK_TEMP_GROUPS_TL T
273: where not exists
274: (select NULL
275: from JTF_TASK_TEMP_GROUPS_B B
276: where B.TASK_TEMPLATE_GROUP_ID = T.TASK_TEMPLATE_GROUP_ID
277: );
278:
279: update JTF_TASK_TEMP_GROUPS_TL T set (