APPS.JTF_DIAGNOSTIC_MIGRATE dependencies on JTF_DIAGNOSTIC_APP

Line 105: select count(*) into v_count from jtf_diagnostic_app

101: for x in applist
102: loop
103: -- check if this already exists.
104: -- if not insert, else update
105: select count(*) into v_count from jtf_diagnostic_app
106: where appid = x.application_short_name;
107:
108: if v_last_migrate_date < x.last_update_date or v_count = 0 then
109:

Line 112: insert into jtf_diagnostic_app(

108: if v_last_migrate_date < x.last_update_date or v_count = 0 then
109:
110: if v_count = 0 then
111:
112: insert into jtf_diagnostic_app(
113: sequence, appID, OBJECT_VERSION_NUMBER, CREATED_BY,
114: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
115: CREATION_DATE) values(
116: JTF_DIAGNOSTIC_APP_S.nextval,

Line 116: JTF_DIAGNOSTIC_APP_S.nextval,

112: insert into jtf_diagnostic_app(
113: sequence, appID, OBJECT_VERSION_NUMBER, CREATED_BY,
114: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
115: CREATION_DATE) values(
116: JTF_DIAGNOSTIC_APP_S.nextval,
117: x.application_short_name, x.object_version_number,
118: x.CREATED_BY, x.LAST_UPDATE_DATE, x.created_by,
119: null, x.LAST_UPDATE_DATE);
120:

Line 122: update jtf_diagnostic_app set

118: x.CREATED_BY, x.LAST_UPDATE_DATE, x.created_by,
119: null, x.LAST_UPDATE_DATE);
120:
121: else
122: update jtf_diagnostic_app set
123: last_update_date = x.last_update_date,
124: LAST_UPDATED_BY = x.LAST_UPDATED_BY,
125: OBJECT_VERSION_NUMBER = x.OBJECT_VERSION_NUMBER
126: where appid = x.application_short_name;