[Home] [Help]
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
1371: END IF;
1372:
1373: l_org_id := igs_ge_gen_003.get_org_id;
1374:
1375: IGS_PE_HLTH_INS_PKG.INSERT_ROW (
1376: x_ROWID => l_rowid,
1377: x_HEALTH_INS_ID => l_hlth_id ,
1378: x_PERSON_ID => HLTH_INS_REC.PERSON_ID ,
1379: x_INSURANCE_CD => HLTH_INS_REC.INSURANCE_CD ,
1683: CLOSE chk_dup_pe_hlthins;
1684: IF dup_pe_hlthins_rec.insurance_cd IS NOT NULL THEN
1685: IF l_rule = 'I' THEN
1686: BEGIN
1687: igs_pe_hlth_ins_pkg.update_row(
1688: x_rowid=>dup_pe_hlthins_rec.rowid,
1689: x_health_ins_id=>dup_pe_hlthins_rec.health_ins_id,
1690: x_person_id=>dup_pe_hlthins_rec.person_id,
1691: x_insurance_provider=> NVL(hlth_ins_rec.insurance_provider,dup_pe_hlthins_rec.insurance_provider),
1753: END;
1754: ELSIF l_rule = 'R' THEN
1755: IF hlth_ins_rec.MATCH_IND = '21' THEN
1756: BEGIN
1757: igs_pe_hlth_ins_pkg.update_row(
1758: x_rowid=>dup_pe_hlthins_rec.rowid,
1759: x_health_ins_id=>dup_pe_hlthins_rec.health_ins_id,
1760: x_person_id=>dup_pe_hlthins_rec.person_id,
1761: x_insurance_cd=> NVL(hlth_ins_rec.insurance_cd,dup_pe_hlthins_rec.insurance_cd),