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.IGS_AD_IMP_007 dependencies on IGS_PE_IMMU_DTLS

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 660: CURSOR dup_chk_health_cur(cp_person_id igs_pe_immu_dtls.person_id%TYPE,

656: AND ai.interface_id = i.interface_id
657: AND ai.interface_run_id = cp_interface_run_id
658: AND ai.status = '2';
659:
660: CURSOR dup_chk_health_cur(cp_person_id igs_pe_immu_dtls.person_id%TYPE,
661: cp_immu_code igs_pe_immu_dtls.immunization_code%TYPE,
662: cp_start_date igs_pe_immu_dtls.start_date%TYPE ) IS
663: SELECT ROWID, mi.*
664: FROM igs_pe_immu_dtls mi

Line 661: cp_immu_code igs_pe_immu_dtls.immunization_code%TYPE,

657: AND ai.interface_run_id = cp_interface_run_id
658: AND ai.status = '2';
659:
660: CURSOR dup_chk_health_cur(cp_person_id igs_pe_immu_dtls.person_id%TYPE,
661: cp_immu_code igs_pe_immu_dtls.immunization_code%TYPE,
662: cp_start_date igs_pe_immu_dtls.start_date%TYPE ) IS
663: SELECT ROWID, mi.*
664: FROM igs_pe_immu_dtls mi
665: WHERE person_id =cp_person_id

Line 662: cp_start_date igs_pe_immu_dtls.start_date%TYPE ) IS

658: AND ai.status = '2';
659:
660: CURSOR dup_chk_health_cur(cp_person_id igs_pe_immu_dtls.person_id%TYPE,
661: cp_immu_code igs_pe_immu_dtls.immunization_code%TYPE,
662: cp_start_date igs_pe_immu_dtls.start_date%TYPE ) IS
663: SELECT ROWID, mi.*
664: FROM igs_pe_immu_dtls mi
665: WHERE person_id =cp_person_id
666: AND immunization_code = cp_immu_code

Line 664: FROM igs_pe_immu_dtls mi

660: CURSOR dup_chk_health_cur(cp_person_id igs_pe_immu_dtls.person_id%TYPE,
661: cp_immu_code igs_pe_immu_dtls.immunization_code%TYPE,
662: cp_start_date igs_pe_immu_dtls.start_date%TYPE ) IS
663: SELECT ROWID, mi.*
664: FROM igs_pe_immu_dtls mi
665: WHERE person_id =cp_person_id
666: AND immunization_code = cp_immu_code
667: AND TRUNC(start_date) =TRUNC(cp_start_date);
668:

Line 672: l_immu_details_id igs_pe_immu_dtls.immu_details_id%TYPE;

668:
669: dup_chk_health_rec dup_chk_health_cur%ROWTYPE;
670: health_insur_rec c_immu_dtls_cur%ROWTYPE;
671: l_dup_var BOOLEAN;
672: l_immu_details_id igs_pe_immu_dtls.immu_details_id%TYPE;
673: l_var VARCHAR2(1);
674: l_rule VARCHAR2(1);
675: l_error_code igs_pe_immu_dtl_int.error_code%TYPE;
676: l_status igs_pe_immu_dtl_int.status%TYPE;

Line 795: l_immu_id igs_pe_immu_dtls.immu_details_id%TYPE;

791: || (reverse chronological order - newest change first)
792: */
793: l_dummy VARCHAR2(1);
794: l_rowid VARCHAR2(25);
795: l_immu_id igs_pe_immu_dtls.immu_details_id%TYPE;
796:
797: BEGIN
798:
799: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 839: p_desc_flex_name => 'IGS_PE_IMMU_DTLS_FLEX' ) THEN

835: p_attribute17 => health_insur_rec.attribute17 ,
836: p_attribute18 => health_insur_rec.attribute18 ,
837: p_attribute19 => health_insur_rec.attribute19 ,
838: p_attribute20 => health_insur_rec.attribute20 ,
839: p_desc_flex_name => 'IGS_PE_IMMU_DTLS_FLEX' ) THEN
840:
841: p_status:='3';
842: p_error_code:='E255';
843: IF l_enable_log = 'Y' THEN

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 971: FROM igs_pe_immu_dtls pe, igs_ad_interface_all ii

967: match_ind = cst_mi_val_19
968: WHERE mi.interface_run_id = l_interface_run_id
969: AND mi.status = cst_stat_val_2
970: AND EXISTS ( SELECT '1'
971: FROM igs_pe_immu_dtls pe, igs_ad_interface_all ii
972: WHERE ii.interface_run_id = l_interface_run_id
973: AND ii.interface_id = mi.interface_id
974: AND ii.person_id = pe.person_id
975: AND pe.immunization_code = UPPER(mi.immunization_code)

Line 1008: FROM igs_pe_immu_dtls pe, igs_ad_interface_all ii

1004: WHERE mi.interface_run_id = l_interface_run_id
1005: AND mi.match_ind IS NULL
1006: AND mi.status = cst_stat_val_2
1007: AND EXISTS ( SELECT '1'
1008: FROM igs_pe_immu_dtls pe, igs_ad_interface_all ii
1009: WHERE ii.interface_run_id = l_interface_run_id
1010: AND ii.interface_id = mi.interface_id
1011: AND ii.person_id = pe.person_id
1012: AND pe.immunization_code = UPPER(mi.immunization_code)

Line 1025: FROM igs_pe_immu_dtls pe, igs_ad_interface_all ii

1021: UPDATE igs_pe_immu_dtl_int mi
1022: SET status = cst_stat_val_3,
1023: match_ind = cst_mi_val_20,
1024: dup_immu_details_id = (SELECT pe.immu_details_id
1025: FROM igs_pe_immu_dtls pe, igs_ad_interface_all ii
1026: WHERE mi.interface_run_id = l_interface_run_id
1027: AND ii.interface_id = mi.interface_id
1028: AND ii.person_id = pe.person_id
1029: AND pe.immunization_code = UPPER(mi.immunization_code)

Line 1036: FROM igs_pe_immu_dtls pe, igs_ad_interface_all ii

1032: WHERE mi.interface_run_id = l_interface_run_id
1033: AND mi.match_ind IS NULL
1034: AND mi.status = cst_stat_val_2
1035: AND EXISTS (SELECT '1'
1036: FROM igs_pe_immu_dtls pe, igs_ad_interface_all ii
1037: WHERE ii.interface_run_id = l_interface_run_id
1038: AND ii.interface_id = mi.interface_id
1039: AND ii.person_id = pe.person_id
1040: AND pe.immunization_code = UPPER(mi.immunization_code)

Line 1085: p_desc_flex_name =>'IGS_PE_IMMU_DTLS_FLEX' ) THEN

1081: p_attribute17 =>pe_health_rec.attribute17 ,
1082: p_attribute18 =>pe_health_rec.attribute18 ,
1083: p_attribute19 =>pe_health_rec.attribute19 ,
1084: p_attribute20 =>pe_health_rec.attribute20 ,
1085: p_desc_flex_name =>'IGS_PE_IMMU_DTLS_FLEX' ) THEN
1086:
1087: IF l_enable_log = 'Y' THEN
1088: igs_ad_imp_001.logerrormessage(pe_health_rec.interface_immu_dtls_id,'E255','IGS_PE_IMMU_DTL_INT');
1089: END IF;

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 1201: p_desc_flex_name =>'IGS_PE_IMMU_DTLS_FLEX' ) THEN

1197: p_attribute17 =>pe_health_rec.attribute17 ,
1198: p_attribute18 =>pe_health_rec.attribute18 ,
1199: p_attribute19 =>pe_health_rec.attribute19 ,
1200: p_attribute20 =>pe_health_rec.attribute20 ,
1201: p_desc_flex_name =>'IGS_PE_IMMU_DTLS_FLEX' ) THEN
1202:
1203: IF l_enable_log = 'Y' THEN
1204: igs_ad_imp_001.logerrormessage(pe_health_rec.INTERFACE_IMMU_DTLS_ID,'E255','IGS_PE_IMMU_DTL_INT');
1205: END IF;

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),