APPS.ZX_AR_FORMULA_MIG_PKG dependencies on ZX_FORMULA_TL

Line 715: * ZX_FORMULA_TL and ZX_FORMULA_DETAILS. *

711:
712: /****************************************************************************************
713: * Procedure: CREATE_FORMULA *
714: * Based on the input parameters, row(s) would be created in to , *
715: * ZX_FORMULA_TL and ZX_FORMULA_DETAILS. *
716: *****************************************************************************************/
717:
718:
719: PROCEDURE CREATE_FORMULA

Line 829: -- Inserting values in table zx_formula_tl

825: x_return_status := FND_API.G_RET_STS_ERROR;
826:
827: END ;
828:
829: -- Inserting values in table zx_formula_tl
830: BEGIN
831:
832: INSERT INTO zx_formula_tl (
833: formula_id ,

Line 832: INSERT INTO zx_formula_tl (

828:
829: -- Inserting values in table zx_formula_tl
830: BEGIN
831:
832: INSERT INTO zx_formula_tl (
833: formula_id ,
834: formula_name ,
835: created_by ,
836: creation_date ,

Line 862: FROM zx_formula_tl t

858: WHERE l.installed_flag IN ('I', 'B')
859: AND formula.record_type_code = 'MIGRATED'
860: AND formula.formula_code = p_formula_code
861: AND NOT EXISTS(SELECT NULL
862: FROM zx_formula_tl t
863: WHERE t.formula_id = formula.formula_id
864: AND t.language = l.language_code);
865:
866: EXCEPTION WHEN OTHERS THEN