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.IGR_IMP_002 dependencies on IGS_AD_GEN_016

Line 43: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)

39: -- Based upon inquiry child
40: UPDATE igr_i_appl_int iappl
41: SET status = '4',
42: error_code = 'E347',
43: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)
44: WHERE status = '1'
45: AND interface_run_id = p_interface_run_id
46: AND (
47: EXISTS (SELECT 1 FROM igr_i_lines_int WHERE status <> '1' AND interface_inq_appl_id = iappl.interface_inq_appl_id)

Line 88: g_inquiry_inst_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_INSTANCE');

84: l_meaning igs_lookup_values.meaning%TYPE;
85:
86: BEGIN
87:
88: g_inquiry_inst_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_INSTANCE');
89: IF g_inquiry_inst_inc THEN
90: g_inquiry_dtls_inc := TRUE;
91: g_inquiry_acad_int_inc := TRUE;
92: g_inquiry_pkg_itm_inc := TRUE;

Line 96: g_inquiry_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_DETAILS');

92: g_inquiry_pkg_itm_inc := TRUE;
93: g_inquiry_info_type_inc := TRUE;
94: g_inquiry_char_inc := TRUE;
95: ELSE
96: g_inquiry_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_DETAILS');
97: g_inquiry_acad_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_ACADEMIC_INTEREST');
98: g_inquiry_pkg_itm_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_PACKAGE_ITEMS');
99: g_inquiry_info_type_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_INFORMATION_TYPES');
100: g_inquiry_char_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_CHARACTERISTICS');

Line 97: g_inquiry_acad_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_ACADEMIC_INTEREST');

93: g_inquiry_info_type_inc := TRUE;
94: g_inquiry_char_inc := TRUE;
95: ELSE
96: g_inquiry_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_DETAILS');
97: g_inquiry_acad_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_ACADEMIC_INTEREST');
98: g_inquiry_pkg_itm_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_PACKAGE_ITEMS');
99: g_inquiry_info_type_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_INFORMATION_TYPES');
100: g_inquiry_char_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_CHARACTERISTICS');
101: END IF;

Line 98: g_inquiry_pkg_itm_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_PACKAGE_ITEMS');

94: g_inquiry_char_inc := TRUE;
95: ELSE
96: g_inquiry_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_DETAILS');
97: g_inquiry_acad_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_ACADEMIC_INTEREST');
98: g_inquiry_pkg_itm_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_PACKAGE_ITEMS');
99: g_inquiry_info_type_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_INFORMATION_TYPES');
100: g_inquiry_char_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_CHARACTERISTICS');
101: END IF;
102:

Line 99: g_inquiry_info_type_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_INFORMATION_TYPES');

95: ELSE
96: g_inquiry_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_DETAILS');
97: g_inquiry_acad_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_ACADEMIC_INTEREST');
98: g_inquiry_pkg_itm_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_PACKAGE_ITEMS');
99: g_inquiry_info_type_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_INFORMATION_TYPES');
100: g_inquiry_char_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_CHARACTERISTICS');
101: END IF;
102:
103: IF g_inquiry_inst_inc THEN

Line 100: g_inquiry_char_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_CHARACTERISTICS');

96: g_inquiry_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_DETAILS');
97: g_inquiry_acad_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_ACADEMIC_INTEREST');
98: g_inquiry_pkg_itm_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_PACKAGE_ITEMS');
99: g_inquiry_info_type_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_INFORMATION_TYPES');
100: g_inquiry_char_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_CHARACTERISTICS');
101: END IF;
102:
103: IF g_inquiry_inst_inc THEN
104: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'INQUIRY_INSTANCE', 8405);

Line 104: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'INQUIRY_INSTANCE', 8405);

100: g_inquiry_char_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_CHARACTERISTICS');
101: END IF;
102:
103: IF g_inquiry_inst_inc THEN
104: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'INQUIRY_INSTANCE', 8405);
105:
106: IF p_enable_log = 'Y' THEN
107: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
108: p_token_name => 'TYPE_NAME',

Line 121: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'INQUIRY_DETAILS', 8405);

117: -- g_inquiry_char_inc (INQUIRY_CHARACTERISTICS)
118: END IF; -- g_inquiry_inst_inc
119:
120: IF g_inquiry_dtls_inc THEN
121: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'INQUIRY_DETAILS', 8405);
122:
123: IF p_enable_log = 'Y' THEN
124: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
125: p_token_name => 'TYPE_NAME',

Line 164: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'INQUIRY_ACADEMIC_INTEREST', 8405);

160:
161: END IF; -- g_inquiry_dtls_inc
162:
163: IF g_inquiry_acad_int_inc THEN
164: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'INQUIRY_ACADEMIC_INTEREST', 8405);
165:
166: IF p_enable_log = 'Y' THEN
167: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
168: p_token_name => 'TYPE_NAME',

Line 197: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'INQUIRY_PACKAGE_ITEMS', 8405);

193:
194: END IF; -- g_inquiry_acad_int_inc
195:
196: IF g_inquiry_pkg_itm_inc THEN
197: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'INQUIRY_PACKAGE_ITEMS', 8405);
198:
199: IF p_enable_log = 'Y' THEN
200: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
201: p_token_name => 'TYPE_NAME',

Line 230: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'INQUIRY_INFORMATION_TYPES', 8405);

226:
227: END IF; -- g_inquiry_pkg_itm_inc
228:
229: IF g_inquiry_info_type_inc THEN
230: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'INQUIRY_INFORMATION_TYPES', 8405);
231:
232: IF p_enable_log = 'Y' THEN
233: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
234: p_token_name => 'TYPE_NAME',

Line 263: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'INQUIRY_CHARACTERISTICS', 8405);

259:
260: END IF; -- g_inquiry_info_type_inc
261:
262: IF g_inquiry_char_inc THEN
263: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'INQUIRY_CHARACTERISTICS', 8405);
264:
265: IF p_enable_log = 'Y' THEN
266: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
267: p_token_name => 'TYPE_NAME',