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.IGF_AP_ISIR_IMPORT_PKG dependencies on IGF_AP_MATCHING_PROCESS_PKG

Line 555: -- g_where := g_where || ' AND ' || '''' || g_message_class || '''' || ' = igf_ap_matching_process_pkg.get_msg_class_from_filename(data_file_name_txt) ';

551:
552: -- adding Message Class filtering RAMMOHAN chk whether function call is efficient or direct derivation.
553: IF g_message_class IS NOT NULL THEN
554: -- g_where := g_where || ' AND ' || '''' || g_message_class || '''' || ' = DECODE(INSTR(data_file_name_txt, ''.''), 0, data_file_name_txt, SUBSTR(data_file_name_txt, 1, INSTR(data_file_name_txt, ''.'')-1))';
555: -- g_where := g_where || ' AND ' || '''' || g_message_class || '''' || ' = igf_ap_matching_process_pkg.get_msg_class_from_filename(data_file_name_txt) ';
556: g_where := g_where || ' AND ' || ' igf_ap_matching_process_pkg.get_msg_class_from_filename(data_file_name_txt) IN (' || get_msg_class(g_message_class) || ')';
557: END IF;
558:
559:

Line 556: g_where := g_where || ' AND ' || ' igf_ap_matching_process_pkg.get_msg_class_from_filename(data_file_name_txt) IN (' || get_msg_class(g_message_class) || ')';

552: -- adding Message Class filtering RAMMOHAN chk whether function call is efficient or direct derivation.
553: IF g_message_class IS NOT NULL THEN
554: -- g_where := g_where || ' AND ' || '''' || g_message_class || '''' || ' = DECODE(INSTR(data_file_name_txt, ''.''), 0, data_file_name_txt, SUBSTR(data_file_name_txt, 1, INSTR(data_file_name_txt, ''.'')-1))';
555: -- g_where := g_where || ' AND ' || '''' || g_message_class || '''' || ' = igf_ap_matching_process_pkg.get_msg_class_from_filename(data_file_name_txt) ';
556: g_where := g_where || ' AND ' || ' igf_ap_matching_process_pkg.get_msg_class_from_filename(data_file_name_txt) IN (' || get_msg_class(g_message_class) || ')';
557: END IF;
558:
559:
560: -- adding School Code filtering

Line 1006: l_msg_class := igf_ap_matching_process_pkg.get_msg_class_from_filename(cur_ISIR_rec.data_file_name_txt);

1002: IF p_system_record_type = 'ORIGINAL' THEN
1003: FOR cur_ISIR_rec IN cur_upd_ISIR LOOP
1004:
1005: -- get message class from data file name
1006: l_msg_class := igf_ap_matching_process_pkg.get_msg_class_from_filename(cur_ISIR_rec.data_file_name_txt);
1007:
1008: igf_ap_ISIR_matched_pkg.update_row (x_Mode => 'R',
1009: x_rowid => cur_ISIR_rec.row_id,
1010: x_ISIR_id => cur_ISIR_rec.ISIR_id,