898: X_ATTRIBUTE14 => p_x_rule_rec.ATTRIBUTE14,
899: X_ATTRIBUTE15 => p_x_rule_rec.ATTRIBUTE15,
900: X_DESCRIPTION => p_x_rule_rec.description,
901: X_CREATION_DATE => SYSDATE,
902: X_CREATED_BY => Fnd_Global.USER_ID,
903: X_LAST_UPDATE_DATE => SYSDATE,
904: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
905: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
906:
900: X_DESCRIPTION => p_x_rule_rec.description,
901: X_CREATION_DATE => SYSDATE,
902: X_CREATED_BY => Fnd_Global.USER_ID,
903: X_LAST_UPDATE_DATE => SYSDATE,
904: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
905: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
906:
907: --Insert the Rule statement Records
908: FOR i IN l_rule_stmt_tbl.FIRST..l_rule_stmt_tbl.LAST LOOP
901: X_CREATION_DATE => SYSDATE,
902: X_CREATED_BY => Fnd_Global.USER_ID,
903: X_LAST_UPDATE_DATE => SYSDATE,
904: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
905: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
906:
907: --Insert the Rule statement Records
908: FOR i IN l_rule_stmt_tbl.FIRST..l_rule_stmt_tbl.LAST LOOP
909: AHL_MC_RULE_STMT_PVT.Insert_Rule_Stmt (
1279: X_ATTRIBUTE14 => l_rule_rec.ATTRIBUTE14,
1280: X_ATTRIBUTE15 => l_rule_rec.ATTRIBUTE15,
1281: X_DESCRIPTION => l_rule_rec.description,
1282: X_LAST_UPDATE_DATE => SYSDATE,
1283: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1284: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
1285:
1286: --Delete all the extra Rule statement Records
1287: OPEN get_rule_stmt_ids_csr(l_rule_rec.rule_id);
1280: X_ATTRIBUTE15 => l_rule_rec.ATTRIBUTE15,
1281: X_DESCRIPTION => l_rule_rec.description,
1282: X_LAST_UPDATE_DATE => SYSDATE,
1283: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1284: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
1285:
1286: --Delete all the extra Rule statement Records
1287: OPEN get_rule_stmt_ids_csr(l_rule_rec.rule_id);
1288: LOOP
1629: X_ATTRIBUTE14 => l_rule_rec.ATTRIBUTE14,
1630: X_ATTRIBUTE15 => l_rule_rec.ATTRIBUTE15,
1631: X_DESCRIPTION => l_rule_rec.description,
1632: X_CREATION_DATE => SYSDATE,
1633: X_CREATED_BY => Fnd_Global.USER_ID,
1634: X_LAST_UPDATE_DATE => SYSDATE,
1635: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1636: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
1637:
1631: X_DESCRIPTION => l_rule_rec.description,
1632: X_CREATION_DATE => SYSDATE,
1633: X_CREATED_BY => Fnd_Global.USER_ID,
1634: X_LAST_UPDATE_DATE => SYSDATE,
1635: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1636: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
1637:
1638: OPEN get_rule_stmt_id_csr(l_rule_rec.rule_id);
1639: FETCH get_rule_stmt_id_csr INTO l_stmt_id;
1632: X_CREATION_DATE => SYSDATE,
1633: X_CREATED_BY => Fnd_Global.USER_ID,
1634: X_LAST_UPDATE_DATE => SYSDATE,
1635: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1636: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
1637:
1638: OPEN get_rule_stmt_id_csr(l_rule_rec.rule_id);
1639: FETCH get_rule_stmt_id_csr INTO l_stmt_id;
1640: CLOSE get_rule_stmt_id_csr;