DBA Data[Home] [Help]

APPS.JTF_DIAGNOSTIC_MIGRATE dependencies on JTF_DIAGNOSTIC_GROUP_S

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