eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_BPL_FAST_FORMULA dependencies on FF_FORMULAS_F

Line 582: FROM ff_formulas_f

578: CURSOR csr_formula_exists (cp_business_group_id NUMBER
579: ,cp_formula_name VARCHAR2)
580: IS
581: SELECT 'x' l_exists
582: FROM ff_formulas_f
583: WHERE business_group_id = cp_business_group_id
584: AND formula_name = cp_formula_name;
585:
586: t_rec csr_formula_exists%rowtype;

Line 666: ff_formulas_f frm

662: IS
663: --
664: SELECT 'x' l_exists
665: FROM
666: ff_formulas_f frm
667: ,ff_compiled_info_f fcp
668: WHERE frm.formula_id = fcp.formula_id
669: AND frm.business_group_id = cp_business_group_id
670: AND frm.formula_name = cp_formula_name;

Line 740: -- Stores the last_update_date returned by ff_formulas_f_pkg.insert_row

736: PROCEDURE generate_performance_formula(p_business_group_id IN NUMBER
737: ,p_formula_text IN OUT NOCOPY VARCHAR)
738: IS
739: --
740: -- Stores the last_update_date returned by ff_formulas_f_pkg.insert_row
741: --
742: l_last_update_date DATE;
743: --
744: -- Stores the rowid returned by ff_formulas_f_pkg.insert_row

Line 744: -- Stores the rowid returned by ff_formulas_f_pkg.insert_row

740: -- Stores the last_update_date returned by ff_formulas_f_pkg.insert_row
741: --
742: l_last_update_date DATE;
743: --
744: -- Stores the rowid returned by ff_formulas_f_pkg.insert_row
745: --
746: l_Rowid VARCHAR2(240);
747: --
748: -- End of time

Line 752: -- Stores the formula_id returned by ff_formulas_f_pkg.insert_row

748: -- End of time
749: --
750: l_end_date DATE DEFAULT hr_general.end_of_time;
751: --
752: -- Stores the formula_id returned by ff_formulas_f_pkg.insert_row
753: --
754: l_Formula_Id ff_formulas_f.formula_id%TYPE DEFAULT NULL;
755: --
756: -- Stores the name of the fast formula that we are trying to save.

Line 754: l_Formula_Id ff_formulas_f.formula_id%TYPE DEFAULT NULL;

750: l_end_date DATE DEFAULT hr_general.end_of_time;
751: --
752: -- Stores the formula_id returned by ff_formulas_f_pkg.insert_row
753: --
754: l_Formula_Id ff_formulas_f.formula_id%TYPE DEFAULT NULL;
755: --
756: -- Stores the name of the fast formula that we are trying to save.
757: --
758: l_formula_name ff_formulas_f.formula_name%TYPE DEFAULT c_prf_aprsl_ff_name;

Line 758: l_formula_name ff_formulas_f.formula_name%TYPE DEFAULT c_prf_aprsl_ff_name;

754: l_Formula_Id ff_formulas_f.formula_id%TYPE DEFAULT NULL;
755: --
756: -- Stores the name of the fast formula that we are trying to save.
757: --
758: l_formula_name ff_formulas_f.formula_name%TYPE DEFAULT c_prf_aprsl_ff_name;
759: --
760: -- Stores the legislation code for the current business group
761: --
762: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 792: ff_formulas_f_pkg.Insert_Row

788: -- the box. Any user created formula should not have this set, or else the
789: -- formula will not show up on the PUI if the bg's legislation is changed
790: -- l_legislation_code is set to null by default
791: --
792: ff_formulas_f_pkg.Insert_Row
793: (
794: X_Rowid => l_rowid
795: ,X_Formula_Id => l_formula_id
796: ,X_Effective_Start_Date => hr_general.start_of_time

Line 1400: FROM ff_formulas_f

1396: -- find the rowid of the fast_formula that we want to delete
1397: --
1398: CURSOR csr_formula_rowid (cp_business_group_id NUMBER) IS
1399: SELECT rowid
1400: FROM ff_formulas_f
1401: WHERE formula_name = c_prf_aprsl_ff_name
1402: AND business_group_id = cp_business_group_id;
1403: --
1404: l_row_id VARCHAR2(30);

Line 1416: ff_formulas_f_pkg.Delete_Row

1412: CLOSE csr_formula_rowid;
1413: --
1414: -- call API to delete the fast formula
1415: --
1416: ff_formulas_f_pkg.Delete_Row
1417: (
1418: X_Rowid => l_row_id
1419: ,X_Formula_Id => NULL
1420: ,X_Dt_Delete_Mode => 'DELETE'

Line 1455: FROM ff_formulas_f

1451: -- find all performance appraisal fast formulas
1452: --
1453: CURSOR csr_all_prfrmnc_formulas IS
1454: SELECT rowid
1455: FROM ff_formulas_f
1456: WHERE formula_name = c_prf_aprsl_ff_name;
1457: --
1458: l_all_prfrmnc_formulas csr_all_prfrmnc_formulas%ROWTYPE;
1459: --

Line 1467: ff_formulas_f_pkg.Delete_Row

1463: --
1464: FOR l_all_prfrmnc_formulas IN csr_all_prfrmnc_formulas
1465: LOOP
1466: --
1467: ff_formulas_f_pkg.Delete_Row
1468: (
1469: X_Rowid => l_all_prfrmnc_formulas.rowid
1470: ,X_Formula_Id => NULL
1471: ,X_Dt_Delete_Mode => 'DELETE'