[Home] [Help]
322: ) RETURN NUMBER IS
323:
324: CURSOR c_formula_id IS
325: SELECT formula_id
326: FROM ff_formulas_f
327: WHERE formula_name = p_new_formula_name
328: AND business_group_id = p_business_group_id
329: AND legislation_code IS NULL;
330:
355: ) RETURN NUMBER IS
356:
357: CURSOR c_formula IS
358: SELECT *
359: FROM ff_formulas_f
360: WHERE formula_id = p_curr_formula_id
361: AND ((business_group_id IS NULL AND legislation_code IS NULL)
362: OR (legislation_code IS NOT NULL
363: AND legislation_code = p_legislation_code)
369: r_curr_formula c_formula%ROWTYPE;
370:
371: -- Local Variables
372: l_new_formula_id NUMBER(15);
373: l_new_formula_name ff_formulas_f.formula_name%TYPE;
374: l_new_row_id ROWID;
375: l_new_last_update_date DATE;
376: l_proc VARCHAR2(72) := g_package||'copy_formula';
377:
397: );
398: l_new_last_update_date := r_curr_formula.last_update_date;
399:
400:
401: BEGIN -- Insert into FF_FORMULAS_F using Row Handler
402: ff_formulas_f_pkg.insert_Row(
403: X_Rowid => l_new_row_id -- IN OUT
404: ,X_Formula_Id => l_new_formula_id -- IN OUT
405: ,X_Effective_Start_Date => r_curr_formula.effective_start_date
398: l_new_last_update_date := r_curr_formula.last_update_date;
399:
400:
401: BEGIN -- Insert into FF_FORMULAS_F using Row Handler
402: ff_formulas_f_pkg.insert_Row(
403: X_Rowid => l_new_row_id -- IN OUT
404: ,X_Formula_Id => l_new_formula_id -- IN OUT
405: ,X_Effective_Start_Date => r_curr_formula.effective_start_date
406: ,X_Effective_End_Date => r_curr_formula.effective_end_date
443: ,p_business_group_id
444: );
445: END IF; -- get_msg_name() <> 'FF52_NAME_ALREADY_USED'
446:
447: END; -- Insert into FF_FORMULAS_F using Row Handler
448:
449: hr_utility.set_location('Leaving:'|| l_proc, 20);
450:
451: RETURN l_new_formula_id;