APPS.CN_QUOTA_RULES_GRP dependencies on CN_TRX_FACTORS

Line 553: UPDATE cn_trx_factors

549: x_loading_status := 'CN_TRX_TYPE_NOT_EXISTS';
550: RAISE fnd_api.g_exc_error;
551: END IF;
552:
553: UPDATE cn_trx_factors
554: SET event_factor = p_trx_factor_rec_tbl (i).event_factor
555: WHERE quota_rule_id = l_pe_rec.quota_rule_id
556: AND quota_id = l_pe_rec.quota_id
557: AND trx_type = p_trx_factor_rec_tbl (i).trx_type;

Line 791: UPDATE cn_trx_factors

787: FOR i IN p_trx_factor_rec_tbl.FIRST .. p_trx_factor_rec_tbl.LAST
788: LOOP
789: IF (p_trx_factor_rec_tbl.EXISTS (i)) AND (p_trx_factor_rec_tbl (i).rev_class_name = l_pe_rec.rev_class_name)
790: THEN
791: UPDATE cn_trx_factors
792: SET event_factor = p_trx_factor_rec_tbl (i).event_factor
793: WHERE quota_rule_id = l_quota_rule_id AND trx_type = p_trx_factor_rec_tbl (i).trx_type;
794: END IF; -- trx Factor Exists
795: END LOOP; -- Trx Loop