APPS.JTF_DIAGNOSTIC_MIGRATE dependencies on JTF_DIAGNOSTIC_PREREQ_S

Line 25: (JTF_DIAGNOSTIC_PREREQ_S.NEXTVAL, 'migrate_date_flag',

21: SOURCEAPPID, TYPE, OBJECT_VERSION_NUMBER,
22: CREATED_BY, LAST_UPDATE_DATE,
23: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE)
24: values
25: (JTF_DIAGNOSTIC_PREREQ_S.NEXTVAL, 'migrate_date_flag',
26: 'migrate_date_flag', 'migrate_date_flag', -1,
27: -1, -1,v_date , -1,
28: NULL, v_date);
29: end if;

Line 191: JTF_DIAGNOSTIC_PREREQ_S.nextval, p_asn, x.attribute_value,

187: SOURCEAPPID, TYPE, OBJECT_VERSION_NUMBER,
188: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
189: LAST_UPDATE_LOGIN, CREATION_DATE)
190: values(
191: JTF_DIAGNOSTIC_PREREQ_S.nextval, p_asn, x.attribute_value,
192: p_asn, 1, x.object_version_number,
193: x.created_by, x.last_update_date, x.created_by,
194: NULL, x.LAST_UPDATE_DATE);
195:

Line 199: update jtf_diagnostic_prereq set

195:
196: else
197: -- update the prereq
198:
199: update jtf_diagnostic_prereq set
200: last_update_date = x.last_update_date,
201: LAST_UPDATED_BY = x.LAST_UPDATED_BY,
202: OBJECT_VERSION_NUMBER = x.OBJECT_VERSION_NUMBER
203: where sourceappid = p_asn and

Line 429: JTF_DIAGNOSTIC_PREREQ_S.NEXTVAL,

425: SOURCEAPPID, TYPE, OBJECT_VERSION_NUMBER,
426: CREATED_BY, LAST_UPDATE_DATE,
427: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE)
428: values(
429: JTF_DIAGNOSTIC_PREREQ_S.NEXTVAL,
430: p_grpname, x.attribute_value, p_asn,
431: 2, x.object_version_number, x.created_by,
432: x.last_update_date, x.created_by,
433: NULL, x.last_update_date);

Line 438: update jtf_diagnostic_prereq set

434:
435:
436: else
437: -- just update the group prereq
438: update jtf_diagnostic_prereq set
439: OBJECT_VERSION_NUMBER = x.OBJECT_VERSION_NUMBER,
440: LAST_UPDATE_DATE = x.LAST_UPDATE_DATE,
441: LAST_UPDATED_BY = x.LAST_UPDATED_BY;
442: