DBA Data[Home] [Help]

APPS.IGF_AP_ISIR_IMPORT_PKG dependencies on IGF_AP_ISIR_MATCHED_ALL

Line 862: fnd_stats.gather_table_stats(ownname => 'IGF', tabname => 'IGF_AP_ISIR_MATCHED_ALL' , cascade => TRUE);

858:
859: -- gather Statistics RAMMOHAN commented for testing
860: log_debug_message(' Starting to gather statistics. ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
861: fnd_stats.gather_table_stats(ownname => 'IGF', tabname => 'IGF_AP_ISIR_INTS_ALL' , cascade => TRUE);
862: fnd_stats.gather_table_stats(ownname => 'IGF', tabname => 'IGF_AP_ISIR_MATCHED_ALL' , cascade => TRUE);
863: log_debug_message(' End of Statistics gathering. ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
864:
865: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
866: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.main_import_process.debug','After gathering Statistics: ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 973: PROCEDURE update_matched_ISIR (p_ISIR_id igf_ap_ISIR_matched_all.ISIR_id%TYPE,

969: igs_ge_msg_stack.conc_exception_hndl;
970: END main_import_process;
971:
972:
973: PROCEDURE update_matched_ISIR (p_ISIR_id igf_ap_ISIR_matched_all.ISIR_id%TYPE,
974: p_system_record_type igf_ap_ISIR_matched_all.system_record_type%TYPE,
975: p_payment_ISIR igf_ap_ISIR_matched_all.payment_ISIR%TYPE,
976: p_active_ISIR igf_ap_ISIR_matched_all.active_ISIR%TYPE)
977: IS

Line 974: p_system_record_type igf_ap_ISIR_matched_all.system_record_type%TYPE,

970: END main_import_process;
971:
972:
973: PROCEDURE update_matched_ISIR (p_ISIR_id igf_ap_ISIR_matched_all.ISIR_id%TYPE,
974: p_system_record_type igf_ap_ISIR_matched_all.system_record_type%TYPE,
975: p_payment_ISIR igf_ap_ISIR_matched_all.payment_ISIR%TYPE,
976: p_active_ISIR igf_ap_ISIR_matched_all.active_ISIR%TYPE)
977: IS
978: /*

Line 975: p_payment_ISIR igf_ap_ISIR_matched_all.payment_ISIR%TYPE,

971:
972:
973: PROCEDURE update_matched_ISIR (p_ISIR_id igf_ap_ISIR_matched_all.ISIR_id%TYPE,
974: p_system_record_type igf_ap_ISIR_matched_all.system_record_type%TYPE,
975: p_payment_ISIR igf_ap_ISIR_matched_all.payment_ISIR%TYPE,
976: p_active_ISIR igf_ap_ISIR_matched_all.active_ISIR%TYPE)
977: IS
978: /*
979: || Created By : brajendr

Line 976: p_active_ISIR igf_ap_ISIR_matched_all.active_ISIR%TYPE)

972:
973: PROCEDURE update_matched_ISIR (p_ISIR_id igf_ap_ISIR_matched_all.ISIR_id%TYPE,
974: p_system_record_type igf_ap_ISIR_matched_all.system_record_type%TYPE,
975: p_payment_ISIR igf_ap_ISIR_matched_all.payment_ISIR%TYPE,
976: p_active_ISIR igf_ap_ISIR_matched_all.active_ISIR%TYPE)
977: IS
978: /*
979: || Created By : brajendr
980: || Created On : 08-NOV-2000