451: -- call table handler to create the input records in cn_formula_inputs
452: IF (p_input_tbl.COUNT > 0) THEN
453: FOR i IN p_input_tbl.first..p_input_tbl.last LOOP
454: l_temp_id := NULL;
455: cn_formula_inputs_pkg.insert_row
456: (x_formula_input_id => l_temp_id,
457: x_calc_formula_id => x_calc_formula_id,
458: x_calc_sql_exp_id => p_input_tbl(i).calc_sql_exp_id,
459: x_f_calc_sql_exp_id => p_input_tbl(i).f_calc_sql_exp_id,
753: x_formula_status := 'INCOMPLETE';
754: FOR i IN p_input_tbl.first..p_input_tbl.last LOOP
755: IF (p_input_tbl(i).formula_input_id IS NULL) THEN
756: l_temp_id := NULL;
757: cn_formula_inputs_pkg.insert_row
758: (x_formula_input_id => l_temp_id,
759: x_calc_formula_id => p_calc_formula_id,
760: x_calc_sql_exp_id => p_input_tbl(i).calc_sql_exp_id,
761: x_f_calc_sql_exp_id => p_input_tbl(i).f_calc_sql_exp_id,
768: );
769:
770: l_update_count := l_update_count + 1;
771: ELSIF (p_input_tbl(i).calc_sql_exp_id IS NULL) THEN
772: cn_formula_inputs_pkg.delete_row(p_input_tbl(i).formula_input_id);
773: l_num_dim := l_num_dim - 1;
774: ELSE
775: cn_formula_inputs_pkg.lock_row
776: (x_formula_input_id => p_input_tbl(i).formula_input_id,
771: ELSIF (p_input_tbl(i).calc_sql_exp_id IS NULL) THEN
772: cn_formula_inputs_pkg.delete_row(p_input_tbl(i).formula_input_id);
773: l_num_dim := l_num_dim - 1;
774: ELSE
775: cn_formula_inputs_pkg.lock_row
776: (x_formula_input_id => p_input_tbl(i).formula_input_id,
777: x_object_version_number => p_input_tbl(i).object_version_number);
778:
779: cn_formula_inputs_pkg.update_row
775: cn_formula_inputs_pkg.lock_row
776: (x_formula_input_id => p_input_tbl(i).formula_input_id,
777: x_object_version_number => p_input_tbl(i).object_version_number);
778:
779: cn_formula_inputs_pkg.update_row
780: (x_formula_input_id => p_input_tbl(i).formula_input_id,
781: x_calc_formula_id => p_calc_formula_id,
782: x_calc_sql_exp_id => p_input_tbl(i).calc_sql_exp_id,
783: x_f_calc_sql_exp_id => p_input_tbl(i).f_calc_sql_exp_id,