APPS.IGS_HE_IMPORT_DATA dependencies on IGS_HE_UCAS_IMP_ERR

Line 20: l_batch_id igs_he_ucas_imp_err.batch_id%TYPE ;

16: l_oss_disability igs_he_code_map_val.map2%TYPE ;
17: l_oss_fee_elig igs_he_code_values.value%TYPE ;
18: l_oss_inst igs_or_org_alt_ids.org_structure_id%TYPE ;
19: l_oss_social_class igs_he_code_map_val.map2%TYPE ;
20: l_batch_id igs_he_ucas_imp_err.batch_id%TYPE ;
21: l_error_flag BOOLEAN ;
22:
23: -- Get the oss person details
24: CURSOR c_pe_det ( cp_person_number igs_pe_person.person_number%TYPE ) IS

Line 35: PROCEDURE log_error(p_error_code igs_he_ucas_imp_err.error_code%TYPE ,

31: pp.party_id(+)=p.party_id AND
32: SYSDATE BETWEEN NVL(pp.effective_start_date,SYSDATE) AND NVL(pp.effective_end_date,SYSDATE);
33: c_pe_det_rec c_pe_det%ROWTYPE ;
34:
35: PROCEDURE log_error(p_error_code igs_he_ucas_imp_err.error_code%TYPE ,
36: p_interface_id igs_he_ucas_imp_err.interface_hesa_id%TYPE,
37: p_append VARCHAR2) IS
38: /******************************************************************
39: Created By : smaddali

Line 36: p_interface_id igs_he_ucas_imp_err.interface_hesa_id%TYPE,

32: SYSDATE BETWEEN NVL(pp.effective_start_date,SYSDATE) AND NVL(pp.effective_end_date,SYSDATE);
33: c_pe_det_rec c_pe_det%ROWTYPE ;
34:
35: PROCEDURE log_error(p_error_code igs_he_ucas_imp_err.error_code%TYPE ,
36: p_interface_id igs_he_ucas_imp_err.interface_hesa_id%TYPE,
37: p_append VARCHAR2) IS
38: /******************************************************************
39: Created By : smaddali
40: Date Created By : 30-oct-2002

Line 50: l_error_text igs_he_ucas_imp_err.error_text%TYPE ;

46: ***************************************************************** */
47:
48: l_error_interface_id NUMBER ;
49: l_rowid VARCHAR2(50) ;
50: l_error_text igs_he_ucas_imp_err.error_text%TYPE ;
51:
52: CURSOR c_err_text IS
53: SELECT description
54: FROM igs_lookups_view

Line 74: igs_he_ucas_imp_err_pkg.insert_row ( X_ROWID => l_rowid ,

70: END IF ;
71:
72: l_rowid := NULL ;
73: l_error_interface_id := NULL ;
74: igs_he_ucas_imp_err_pkg.insert_row ( X_ROWID => l_rowid ,
75: X_ERROR_INTERFACE_ID => l_error_interface_id ,
76: X_INTERFACE_HESA_ID => p_interface_id ,
77: X_BATCH_ID => l_batch_id ,
78: X_ERROR_CODE => p_error_code ,

Line 1115: FROM igs_he_ucas_imp_err err

1111:
1112: -- Get all the error records for the passed batch id and interface id
1113: CURSOR c_del_err(cp_interface_id igs_he_ucas_imp_int.interface_hesa_id%TYPE) IS
1114: SELECT err.rowid
1115: FROM igs_he_ucas_imp_err err
1116: WHERE err.batch_id = p_batch_id AND
1117: err.interface_hesa_id = NVL(cp_interface_id, err.interface_hesa_id);
1118: c_del_err_rec c_del_err%ROWTYPE ;
1119:

Line 1419: igs_he_ucas_imp_err_pkg.delete_row( X_ROWID => c_del_err_rec.rowid ) ;

1415: END IF ;
1416:
1417: -- Delete all the error records existing for the passed batch_id
1418: FOR c_del_err_rec IN c_del_err(NULL) LOOP
1419: igs_he_ucas_imp_err_pkg.delete_row( X_ROWID => c_del_err_rec.rowid ) ;
1420: END LOOP ;
1421:
1422: -- Person Id type setup validations
1423: -- If a person id type HUSID is not setup then log error