APPS.JTF_DIAGNOSTIC_MIGRATE dependencies on JTF_DIAGNOSTIC_GROUP

Line 289: select count(*) into v_count from jtf_diagnostic_group

285: FOR X IN grplist LOOP
286:
287: -- check if this already exists.
288: -- if not insert, else update
289: select count(*) into v_count from jtf_diagnostic_group
290: where appid = P_ASN
291: and groupname = x.attribute_value;
292:
293: if v_last_migrate_date < x.last_update_date or v_count = 0 then

Line 298: from jtf_diagnostic_group where appid = p_asn;

294:
295: -- v_temp := grplist%ROWCOUNT;
296:
297: select MAX(ordernumber) into v_temp
298: from jtf_diagnostic_group where appid = p_asn;
299:
300: if sql%notfound or v_temp = 0 then
301: v_temp := 1;
302: else v_temp := v_temp + 1;

Line 313: insert into jtf_diagnostic_group(SEQUENCE, GROUPNAME,

309: -- number there
310:
311: -- insert the record
312:
313: insert into jtf_diagnostic_group(SEQUENCE, GROUPNAME,
314: APPID, ORDERNUMBER, OBJECT_VERSION_NUMBER,
315: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
316: LAST_UPDATE_LOGIN, CREATION_DATE, SENSITIVITY) values (
317: JTF_DIAGNOSTIC_GROUP_S.NEXTVAL, x.attribute_value,

Line 317: JTF_DIAGNOSTIC_GROUP_S.NEXTVAL, x.attribute_value,

313: insert into jtf_diagnostic_group(SEQUENCE, GROUPNAME,
314: APPID, ORDERNUMBER, OBJECT_VERSION_NUMBER,
315: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
316: LAST_UPDATE_LOGIN, CREATION_DATE, SENSITIVITY) values (
317: JTF_DIAGNOSTIC_GROUP_S.NEXTVAL, x.attribute_value,
318: P_ASN, DECODE(v_temp,null,1,v_temp),
319: x.OBJECT_VERSION_NUMBER, x.CREATED_BY,
320: x.LAST_UPDATE_DATE, x.created_by, NULL,
321: x.LAST_UPDATE_DATE, 1);

Line 326: update jtf_diagnostic_group set

322:
323: else
324: -- update the record
325:
326: update jtf_diagnostic_group set
327: OBJECT_VERSION_NUMBER = x.OBJECT_VERSION_NUMBER,
328: LAST_UPDATE_DATE = x.LAST_UPDATE_DATE,
329: LAST_UPDATED_BY = x.LAST_UPDATED_BY
330: where appid = P_ASN