[Home] [Help]
607: l_api_name CONSTANT VARCHAR2(30) := 'Update_Formula';
608: l_api_version CONSTANT NUMBER := 1.0;
609: l_temp_id NUMBER;
610: l_update_count NUMBER := 0;
611: l_srp_prd_quota_ext_id cn_srp_period_quotas_ext.srp_period_quota_ext_id%TYPE;
612: l_num_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;
613: l_count_formula_input NUMBER := 0;
614: l_plan_elt_tbl CN_CALC_SQL_EXPS_PVT.NUM_TBL_TYPE;
615:
649: l_old_rec get_old_formula_rec%ROWTYPE;
650: /* End - R12 Notes History */
651:
652: CURSOR c_next_srp_qut_id IS
653: SELECT cn_srp_period_quotas_ext_s.NEXTVAL
654: FROM dual;
655:
656: CURSOR c_srp_quota_detail IS
657: select spq.srp_period_quota_id
654: FROM dual;
655:
656: CURSOR c_srp_quota_detail IS
657: select spq.srp_period_quota_id
658: from cn_quotas_v qut, cn_srp_period_quotas spq
659: where qut.quota_id = spq.quota_id
660: and qut.calc_formula_id = p_calc_formula_id;
661:
662: CURSOR c1 IS
790: END IF;
791: END LOOP;
792:
793: -- this is required to support accumulation along multiple dimensions
794: -- for each rec in cn_srp_period_quotas, add p_input_tbl.COUNT - 1 rows into the ext table
795: FOR form_rec IN c_srp_quota_detail LOOP
796: delete from cn_srp_period_quotas_ext where srp_period_quota_id = form_rec.srp_period_quota_id;
797: FOR i in 2.. l_update_count LOOP
798: OPEN c_next_srp_qut_id;
792:
793: -- this is required to support accumulation along multiple dimensions
794: -- for each rec in cn_srp_period_quotas, add p_input_tbl.COUNT - 1 rows into the ext table
795: FOR form_rec IN c_srp_quota_detail LOOP
796: delete from cn_srp_period_quotas_ext where srp_period_quota_id = form_rec.srp_period_quota_id;
797: FOR i in 2.. l_update_count LOOP
798: OPEN c_next_srp_qut_id;
799: FETCH c_next_srp_qut_id INTO l_srp_prd_quota_ext_id;
800: IF (c_next_srp_qut_id%notfound) THEN
802: RAISE no_data_found;
803: END IF;
804: CLOSE c_next_srp_qut_id;
805:
806: insert into cn_srp_period_quotas_ext
807: (srp_period_quota_ext_id,
808: srp_period_quota_id,
809: input_sequence,
810: input_achieved_ptd,