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_AD_IMP_018

Line 77: || kumma 30-OCT-2002 Added the call to igs_ad_imp_018.validate_desc_flex for new flex fields added in health

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
79: || pkpatel 6-JAN-2003 Bug No: 2729633
80: || Added the UPPER for all VARCHAR2 fileds. Add additional columns for discrepancy. Add NOT NULL
81: || check for separation type.

Line 272: IF NOT igs_ad_imp_018.validate_desc_flex(

268: RAISE NO_DATA_FOUND;
269: END IF;
270: END IF;
271:
272: IF NOT igs_ad_imp_018.validate_desc_flex(
273: p_attribute_category =>MILITARY_REC.attribute_category,
274: p_attribute1 =>MILITARY_REC.attribute1 ,
275: p_attribute2 =>MILITARY_REC.attribute2 ,
276: p_attribute3 =>MILITARY_REC.attribute3 ,

Line 817: IF NOT igs_ad_imp_018.validate_desc_flex(

813:
814: --validate record values
815: validate_record_health (health_insur_rec, l_error_code);
816: IF l_error_code IS NULL THEN
817: IF NOT igs_ad_imp_018.validate_desc_flex(
818: p_attribute_category => health_insur_rec.attribute_category,
819: p_attribute1 => health_insur_rec.attribute1 ,
820: p_attribute2 => health_insur_rec.attribute2 ,
821: p_attribute3 => health_insur_rec.attribute3 ,

Line 1063: IF NOT igs_ad_imp_018.validate_desc_flex(

1059: IF l_rule = 'I' THEN
1060: validate_record_health(pe_health_rec, l_error_code);
1061: IF l_error_code IS NULL THEN
1062: BEGIN
1063: IF NOT igs_ad_imp_018.validate_desc_flex(
1064: p_attribute_category =>pe_health_rec.attribute_category,
1065: p_attribute1 =>pe_health_rec.attribute1 ,
1066: p_attribute2 =>pe_health_rec.attribute2 ,
1067: p_attribute3 =>pe_health_rec.attribute3 ,

Line 1179: IF NOT igs_ad_imp_018.validate_desc_flex(

1175: -- call the validation process
1176: validate_record_health(pe_health_rec, l_error_code);
1177: IF l_error_code IS NULL THEN
1178: BEGIN
1179: IF NOT igs_ad_imp_018.validate_desc_flex(
1180: p_attribute_category =>pe_health_rec.attribute_category,
1181: p_attribute1 =>pe_health_rec.attribute1 ,
1182: p_attribute2 =>pe_health_rec.attribute2 ,
1183: p_attribute3 =>pe_health_rec.attribute3 ,

Line 1476: IF NOT igs_ad_imp_018.validate_desc_flex(

1472: RAISE NO_DATA_FOUND;
1473: END IF;
1474: END IF;
1475:
1476: IF NOT igs_ad_imp_018.validate_desc_flex(
1477: p_attribute_category =>HLTH_INS_REC.attribute_category,
1478: p_attribute1 =>HLTH_INS_REC.attribute1 ,
1479: p_attribute2 =>HLTH_INS_REC.attribute2 ,
1480: p_attribute3 =>HLTH_INS_REC.attribute3 ,

Line 1977: IF NOT igs_ad_imp_018.validate_desc_flex(

1973:
1974: BEGIN
1975:
1976: --validate Alternate Person ID descriptive Flex field
1977: IF NOT igs_ad_imp_018.validate_desc_flex(
1978: p_attribute_category =>p_api_rec.attribute_category,
1979: p_attribute1 =>p_api_rec.attribute1 ,
1980: p_attribute2 =>p_api_rec.attribute2 ,
1981: p_attribute3 =>p_api_rec.attribute3 ,