eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_IAPP_FAMILIES_PKG dependencies on JTF_IAPP_FAMILY_APP_MAP

Line 193: from JTF_IAPP_FAMILIES_B f, JTF_IAPP_FAMILY_APP_MAP a

189: where APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME
190: ;
191:
192: cursor C_2 is select f.APP_FAMILY_ID, APPLICATION_ID
193: from JTF_IAPP_FAMILIES_B f, JTF_IAPP_FAMILY_APP_MAP a
194: where f.APP_FAMILY_ID = a.APP_FAMILY_ID
195: AND f.APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME
196: AND a.APPLICATION_ID = X_APP_ID
197: ;

Line 217: insert into JTF_IAPP_FAMILY_APP_MAP (

213: FETCH C INTO l_app_family_id;
214: CLOSE C;
215: End If;
216:
217: insert into JTF_IAPP_FAMILY_APP_MAP (
218: APP_FAMILY_ID,
219: APPLICATION_ID,
220: CREATED_BY,
221: CREATION_DATE,

Line 259: delete from JTF_IAPP_FAMILY_APP_MAP

255: FETCH C INTO l_app_family_id;
256: CLOSE C;
257: End If;
258:
259: delete from JTF_IAPP_FAMILY_APP_MAP
260: where APP_FAMILY_ID = l_app_family_id;
261:
262: -- if (sql%notfound) then
263: -- raise no_data_found;

Line 304: delete from JTF_IAPP_FAMILY_APP_MAP

300: FETCH C INTO l_app_family_id;
301: CLOSE C;
302: End If;
303:
304: delete from JTF_IAPP_FAMILY_APP_MAP
305: where APP_FAMILY_ID = l_app_family_id
306: AND APPLICATION_ID = X_APP_ID;
307:
308: if (sql%notfound) then