APPS.IGS_AD_IMP_007 dependencies on IGS_PE_IMMU_DTLS_PKG

Line 74: || igs_pe_hlth_ins_pkg and igs_pe_immu_dtls_pkg, #2608360

70: || sarakshi 12-Nov-2001 Bug no.2103692:Person Interface DLD
71: || Added the DFF validation before insert/update to the oss table, also in
72: || the call to insert_row/update_row to the oss table adding the dff columns
73: || kumma 23-OCT-2002 Added the parameters for DFF columns to the calls of insert_row and update_row on
74: || igs_pe_hlth_ins_pkg and igs_pe_immu_dtls_pkg, #2608360
75: || kumma 28-OCT-2002 Replaced MILITARY_TYPE_ID with MILITARY_TYPE_CD in validate_military procedure, #2608360
76: || Changed the data type of parameter p_MILITARY_TYPE_CD to VARCHAR2 in procedure CHK_DUP_MILIT
77: || kumma 30-OCT-2002 Added the call to igs_ad_imp_018.validate_desc_flex for new flex fields added in health
78: || insurance and immunization details

Line 847: igs_pe_immu_dtls_pkg.INSERT_ROW (

843: IF l_enable_log = 'Y' THEN
844: igs_ad_imp_001.logerrormessage(health_insur_rec.INTERFACE_IMMU_DTLS_ID,'E255','IGS_PE_IMMU_DTL_INT');
845: END IF;
846: ELSE
847: igs_pe_immu_dtls_pkg.INSERT_ROW (
848: x_rowid => l_rowid,
849: x_immu_details_id => l_immu_details_id,
850: x_person_id => health_insur_rec.person_id,
851: x_immunization_code => health_insur_rec.immunization_code,

Line 907: || ' Exception from IGS_PE_IMMU_DTLS_PKG.INSERT_ROW '

903:
904: l_label := 'igs.plsql.igs_ad_imp_007.crt_health_ins.exception';
905:
906: l_debug_str := 'Igs_Ad_Imp_007.PRC_PE_IMMU_DLTS.CRT_HEALTH_INS'
907: || ' Exception from IGS_PE_IMMU_DTLS_PKG.INSERT_ROW '
908: || ' Interface Id : '
909: || (health_insur_rec.interface_immu_dtls_id)
910: || ' Status : 3'|| ' ErrorCode : E159' ||SQLERRM;
911:

Line 1097: igs_pe_immu_dtls_pkg.UPDATE_ROW

1093: status = '3'
1094: WHERE INTERFACE_IMMU_DTLS_ID = pe_health_rec.interface_immu_dtls_id;
1095:
1096: ELSE
1097: igs_pe_immu_dtls_pkg.UPDATE_ROW
1098: (
1099: x_rowid => dup_chk_health_rec.ROWID,
1100: x_start_date => NVL(pe_health_rec.start_date,dup_chk_health_rec.start_date),
1101: x_end_date => NVL(pe_health_rec.end_date,dup_chk_health_rec.start_date),

Line 1212: igs_pe_immu_dtls_pkg.UPDATE_ROW

1208: SET ERROR_CODE ='E255',
1209: status = '3'
1210: WHERE INTERFACE_IMMU_DTLS_ID = pe_health_rec.INTERFACE_IMMU_DTLS_ID;
1211: ELSE
1212: igs_pe_immu_dtls_pkg.UPDATE_ROW
1213: (
1214: x_rowid => dup_chk_health_rec.ROWID,
1215: x_start_date => NVL(pe_health_rec.start_date,dup_chk_health_rec.start_date),
1216: x_end_date => NVL(pe_health_rec.end_date,dup_chk_health_rec.end_date),