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.IGS_OR_INST_IMP_002 dependencies on IGS_OR_CWLK_DTL

Line 304: FROM IGS_OR_CWLK_DTL

300: ***************************************************************/
301:
302: CURSOR chk_dup(cp_data_src VARCHAR2,cp_data_val VARCHAR2) IS
303: SELECT 'Y'
304: FROM IGS_OR_CWLK_DTL
305: WHERE ALT_ID_TYPE = cp_data_src AND
306: ALT_ID_VALUE = cp_data_val;
307:
308: l_rowid VARCHAR2(25);

Line 310: l_crswalkdtl_id igs_or_cwlk_dtl.crosswalk_dtl_id%TYPE;

306: ALT_ID_VALUE = cp_data_val;
307:
308: l_rowid VARCHAR2(25);
309: l_exists VARCHAR2(1);
310: l_crswalkdtl_id igs_or_cwlk_dtl.crosswalk_dtl_id%TYPE;
311:
312: BEGIN
313:
314: OPEN chk_dup(p_datasrc,p_dataval);

Line 319: IGS_OR_CWLK_DTL_PKG.INSERT_ROW (

315: FETCH chk_dup INTO l_exists;
316: CLOSE chk_dup;
317:
318: IF l_exists IS NULL THEN
319: IGS_OR_CWLK_DTL_PKG.INSERT_ROW (
320: x_rowid => l_rowid,
321: x_crosswalk_dtl_id => l_crswalkdtl_id,
322: x_crosswalk_id => p_crwlkid,
323: x_alt_id_type => p_datasrc,