726:
727: /****************************************************************************************
728: * Procedure: CREATE_FORMULA *
729: * Based on the input parameters, row(s) would be created in to , *
730: * ZX_FORMULA_TL and ZX_FORMULA_DETAILS. *
731: *****************************************************************************************/
732:
733:
734: PROCEDURE CREATE_FORMULA
838: x_return_status := FND_API.G_RET_STS_ERROR;
839:
840: END ;
841:
842: -- Inserting values in table zx_formula_tl
843: BEGIN
844:
845: INSERT INTO zx_formula_tl (
846: formula_id,
841:
842: -- Inserting values in table zx_formula_tl
843: BEGIN
844:
845: INSERT INTO zx_formula_tl (
846: formula_id,
847: formula_name,
848: created_by,
849: creation_date,
871: WHERE l.installed_flag IN ('I', 'B')
872: AND formula.record_type_code = 'MIGRATED'
873: AND formula.formula_code = p_formula_code
874: AND NOT EXISTS(SELECT NULL
875: FROM zx_formula_tl t
876: WHERE t.formula_id = formula.formula_id
877: AND t.language = l.language_code);
878:
879: EXCEPTION WHEN OTHERS THEN