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_003_PKG dependencies on IGS_OR_ORG_NOTE_TYPE

Line 95: cp_inst_flag igs_or_org_note_type.inst_flag%TYPE) IS

91: oss_notes_rec cur_get_oss_notes%ROWTYPE;
92:
93: --Cursor added for field level validation for ORG_NOTE_TYPE
94: CURSOR c_val_note_type(p_org_note_type igs_or_inst_nts_int.org_note_type%TYPE,
95: cp_inst_flag igs_or_org_note_type.inst_flag%TYPE) IS
96: SELECT 'Y'
97: FROM igs_or_org_note_type
98: WHERE org_notes_type = p_org_note_type
99: AND inst_flag=cp_inst_flag;

Line 97: FROM igs_or_org_note_type

93: --Cursor added for field level validation for ORG_NOTE_TYPE
94: CURSOR c_val_note_type(p_org_note_type igs_or_inst_nts_int.org_note_type%TYPE,
95: cp_inst_flag igs_or_org_note_type.inst_flag%TYPE) IS
96: SELECT 'Y'
97: FROM igs_or_org_note_type
98: WHERE org_notes_type = p_org_note_type
99: AND inst_flag=cp_inst_flag;
100:
101: c_val_note_type_rec c_val_note_type%rowtype;