754: X_Description VARCHAR2,
755: X_Formula_Text VARCHAR2,
756: X_Sticky_Flag VARCHAR2,
757: X_Last_Update_Date IN OUT NOCOPY DATE,
758: X_Base_Formula_Name VARCHAR2 default hr_api.g_varchar2,
759: X_Base_Description VARCHAR2 default hr_api.g_varchar2) IS
760: --
761: CURSOR C IS SELECT last_update_date FROM ff_formulas_f
762: WHERE rowid = x_rowid;
755: X_Formula_Text VARCHAR2,
756: X_Sticky_Flag VARCHAR2,
757: X_Last_Update_Date IN OUT NOCOPY DATE,
758: X_Base_Formula_Name VARCHAR2 default hr_api.g_varchar2,
759: X_Base_Description VARCHAR2 default hr_api.g_varchar2) IS
760: --
761: CURSOR C IS SELECT last_update_date FROM ff_formulas_f
762: WHERE rowid = x_rowid;
763: --
769: BEGIN
770: --
771: --
772: --Fixed for bug 4348013--
773: /* Checking if the Base values of formula_name and description are of type hr_api.g_varchar2 i.e.
774: the procedure is not being called from the form but from outside then copy the translated
775: values into them.*/
776:
777: l_formula_name := X_Base_Formula_Name;
776:
777: l_formula_name := X_Base_Formula_Name;
778: l_description := X_Base_Description;
779:
780: if(l_formula_name = hr_api.g_varchar2) then
781: l_formula_name := X_Formula_Name;
782: end if;
783: if( l_description = hr_api.g_varchar2 ) then
784: l_description := X_Description;
779:
780: if(l_formula_name = hr_api.g_varchar2) then
781: l_formula_name := X_Formula_Name;
782: end if;
783: if( l_description = hr_api.g_varchar2 ) then
784: l_description := X_Description;
785: end if;
786: ----
787: UPDATE ff_formulas_f