[Home] [Help]
24: p_match_ind IN VARCHAR2 DEFAULT NULL) AS
25: /*****************************************************************
26: Created By : asbala
27: Creation date : 9/23/2003
28: Purpose : This function is to print the statistics from igs_ad_imp_stats.
29: Know limitations, enhancements or remarks
30: Change History
31: Who When What
32: (reverse chronological order - newest change first)
58: PROCEDURE print_stats(p_interface_run_id IN igs_ad_interface_all.interface_run_id%TYPE) AS
59: /*****************************************************************
60: Created By : asbala
61: Creation date : 9/23/2003
62: Purpose : This function is to print the statistics from igs_ad_imp_stats.
63: Know limitations, enhancements or remarks
64: Change History
65: Who When What
66: (reverse chronological order - newest change first)
67: ***************************************************************/
68: CURSOR c_get_statistics (cp_lookup_type VARCHAR2,
69: cp_interface_run_id NUMBER) IS
70: SELECT total_rec_num, total_warn_num, total_success_num, total_error_num, meaning,entity_name
71: FROM igs_ad_imp_stats imp, igs_lookup_values lk
72: WHERE imp.src_cat_code = lk.lookup_code
73: AND lk.lookup_type = cp_lookup_type
74: AND imp.interface_run_id = cp_interface_run_id
75: ORDER BY meaning, entity_name;
418: 'E - '|| to_char(l_error) ||' : '||
419: 'W - '|| to_char(l_warning) ||' : '||
420: 'T - '|| to_char(l_total_rec));
421: *********************************************************/
422: INSERT INTO IGS_AD_IMP_STATS (
423: INTERFACE_RUN_ID,
424: SRC_CAT_CODE,
425: ENTITY_NAME,
426: TOTAL_REC_NUM,