3528: /********** insanity check for the numbers ******
3529: ********* If the display format is a/b/c, then a >= 0 and b>= a and c>= b ****/
3530: IF( (NVL(m_ineff_control(ctr),0) + add_or_deduct_value) < 0 or (NVL(m_ineff_control(ctr),0) + add_or_deduct_value) > m_add_to_eval_ctrls(ctr))
3531: THEN
3532: AMW_FINSTMT_CERT_BES_PKG.G_REFRESH_FLAG := 'Y';
3533: IF AMW_FINSTMT_CERT_BES_PKG.m_certification_list.exists(P_CERTIFICATION_ID) THEN
3534: EXIT;
3535: ELSE
3536: AMW_FINSTMT_CERT_BES_PKG.m_certification_list(AMW_FINSTMT_CERT_BES_PKG.m_certification_list.COUNT+1) := P_CERTIFICATION_ID;
3529: ********* If the display format is a/b/c, then a >= 0 and b>= a and c>= b ****/
3530: IF( (NVL(m_ineff_control(ctr),0) + add_or_deduct_value) < 0 or (NVL(m_ineff_control(ctr),0) + add_or_deduct_value) > m_add_to_eval_ctrls(ctr))
3531: THEN
3532: AMW_FINSTMT_CERT_BES_PKG.G_REFRESH_FLAG := 'Y';
3533: IF AMW_FINSTMT_CERT_BES_PKG.m_certification_list.exists(P_CERTIFICATION_ID) THEN
3534: EXIT;
3535: ELSE
3536: AMW_FINSTMT_CERT_BES_PKG.m_certification_list(AMW_FINSTMT_CERT_BES_PKG.m_certification_list.COUNT+1) := P_CERTIFICATION_ID;
3537: EXIT;
3532: AMW_FINSTMT_CERT_BES_PKG.G_REFRESH_FLAG := 'Y';
3533: IF AMW_FINSTMT_CERT_BES_PKG.m_certification_list.exists(P_CERTIFICATION_ID) THEN
3534: EXIT;
3535: ELSE
3536: AMW_FINSTMT_CERT_BES_PKG.m_certification_list(AMW_FINSTMT_CERT_BES_PKG.m_certification_list.COUNT+1) := P_CERTIFICATION_ID;
3537: EXIT;
3538: END IF;
3539: END IF;
3540:
3895: /********** insanity check for the numbers ******
3896: ********* If the display format is a/b/c, then a >= 0 and b>= a and c>= b ****/
3897: IF( (NVL(m_ineff_control(ctr),0) + add_or_deduct_value) < 0 or (NVL(m_ineff_control(ctr),0) + add_or_deduct_value) > m_add_to_eval_ctrls(ctr))
3898: THEN
3899: AMW_FINSTMT_CERT_BES_PKG.G_REFRESH_FLAG := 'Y';
3900: IF AMW_FINSTMT_CERT_BES_PKG.m_certification_list.exists(P_CERTIFICATION_ID) THEN
3901: EXIT;
3902: ELSE
3903: AMW_FINSTMT_CERT_BES_PKG.m_certification_list(AMW_FINSTMT_CERT_BES_PKG.m_certification_list.COUNT+1) := P_CERTIFICATION_ID;
3896: ********* If the display format is a/b/c, then a >= 0 and b>= a and c>= b ****/
3897: IF( (NVL(m_ineff_control(ctr),0) + add_or_deduct_value) < 0 or (NVL(m_ineff_control(ctr),0) + add_or_deduct_value) > m_add_to_eval_ctrls(ctr))
3898: THEN
3899: AMW_FINSTMT_CERT_BES_PKG.G_REFRESH_FLAG := 'Y';
3900: IF AMW_FINSTMT_CERT_BES_PKG.m_certification_list.exists(P_CERTIFICATION_ID) THEN
3901: EXIT;
3902: ELSE
3903: AMW_FINSTMT_CERT_BES_PKG.m_certification_list(AMW_FINSTMT_CERT_BES_PKG.m_certification_list.COUNT+1) := P_CERTIFICATION_ID;
3904: EXIT;
3899: AMW_FINSTMT_CERT_BES_PKG.G_REFRESH_FLAG := 'Y';
3900: IF AMW_FINSTMT_CERT_BES_PKG.m_certification_list.exists(P_CERTIFICATION_ID) THEN
3901: EXIT;
3902: ELSE
3903: AMW_FINSTMT_CERT_BES_PKG.m_certification_list(AMW_FINSTMT_CERT_BES_PKG.m_certification_list.COUNT+1) := P_CERTIFICATION_ID;
3904: EXIT;
3905: END IF;
3906: END IF;
3907:
4692: /********** insanity check for the numbers ******
4693: ********* If the display format is a/b/c, then a >= 0 and b>= a and c>= b ****/
4694: IF( (NVL(m_ineff_control(ctr),0) + add_or_deduct_value) < 0 or (NVL(m_ineff_control(ctr),0) + add_or_deduct_value) > m_add_to_eval_ctrls(ctr))
4695: THEN
4696: AMW_FINSTMT_CERT_BES_PKG.G_REFRESH_FLAG := 'Y';
4697: IF AMW_FINSTMT_CERT_BES_PKG.m_certification_list.exists(P_CERTIFICATION_ID) THEN
4698: EXIT;
4699: ELSE
4700: AMW_FINSTMT_CERT_BES_PKG.m_certification_list(AMW_FINSTMT_CERT_BES_PKG.m_certification_list.COUNT+1) := P_CERTIFICATION_ID;
4693: ********* If the display format is a/b/c, then a >= 0 and b>= a and c>= b ****/
4694: IF( (NVL(m_ineff_control(ctr),0) + add_or_deduct_value) < 0 or (NVL(m_ineff_control(ctr),0) + add_or_deduct_value) > m_add_to_eval_ctrls(ctr))
4695: THEN
4696: AMW_FINSTMT_CERT_BES_PKG.G_REFRESH_FLAG := 'Y';
4697: IF AMW_FINSTMT_CERT_BES_PKG.m_certification_list.exists(P_CERTIFICATION_ID) THEN
4698: EXIT;
4699: ELSE
4700: AMW_FINSTMT_CERT_BES_PKG.m_certification_list(AMW_FINSTMT_CERT_BES_PKG.m_certification_list.COUNT+1) := P_CERTIFICATION_ID;
4701: EXIT;
4696: AMW_FINSTMT_CERT_BES_PKG.G_REFRESH_FLAG := 'Y';
4697: IF AMW_FINSTMT_CERT_BES_PKG.m_certification_list.exists(P_CERTIFICATION_ID) THEN
4698: EXIT;
4699: ELSE
4700: AMW_FINSTMT_CERT_BES_PKG.m_certification_list(AMW_FINSTMT_CERT_BES_PKG.m_certification_list.COUNT+1) := P_CERTIFICATION_ID;
4701: EXIT;
4702: END IF;
4703: END IF;
4704:
5192: /********** insanity check for the numbers ******
5193: ********* If the display format is a/b/c, then a >= 0 and b>= a and c>= b ****/
5194: IF( (NVL(m_ineff_control(ctr),0) + add_or_deduct_value) < 0 or (NVL(m_ineff_control(ctr),0) + add_or_deduct_value) > m_add_to_eval_ctrls(ctr))
5195: THEN
5196: AMW_FINSTMT_CERT_BES_PKG.G_REFRESH_FLAG := 'Y';
5197: IF AMW_FINSTMT_CERT_BES_PKG.m_certification_list.exists(P_CERTIFICATION_ID) THEN
5198: EXIT;
5199: ELSE
5200: AMW_FINSTMT_CERT_BES_PKG.m_certification_list(AMW_FINSTMT_CERT_BES_PKG.m_certification_list.COUNT+1) := P_CERTIFICATION_ID;
5193: ********* If the display format is a/b/c, then a >= 0 and b>= a and c>= b ****/
5194: IF( (NVL(m_ineff_control(ctr),0) + add_or_deduct_value) < 0 or (NVL(m_ineff_control(ctr),0) + add_or_deduct_value) > m_add_to_eval_ctrls(ctr))
5195: THEN
5196: AMW_FINSTMT_CERT_BES_PKG.G_REFRESH_FLAG := 'Y';
5197: IF AMW_FINSTMT_CERT_BES_PKG.m_certification_list.exists(P_CERTIFICATION_ID) THEN
5198: EXIT;
5199: ELSE
5200: AMW_FINSTMT_CERT_BES_PKG.m_certification_list(AMW_FINSTMT_CERT_BES_PKG.m_certification_list.COUNT+1) := P_CERTIFICATION_ID;
5201: EXIT;
5196: AMW_FINSTMT_CERT_BES_PKG.G_REFRESH_FLAG := 'Y';
5197: IF AMW_FINSTMT_CERT_BES_PKG.m_certification_list.exists(P_CERTIFICATION_ID) THEN
5198: EXIT;
5199: ELSE
5200: AMW_FINSTMT_CERT_BES_PKG.m_certification_list(AMW_FINSTMT_CERT_BES_PKG.m_certification_list.COUNT+1) := P_CERTIFICATION_ID;
5201: EXIT;
5202: END IF;
5203: END IF;
5204: