APPS.FF_FORMULAS_F_PKG dependencies on FF_FORMULAS_F_TL

Line 1006: delete from FF_FORMULAS_F_TL T

1002: ---For MLS----------------------------------------------------------------------
1003: procedure ADD_LANGUAGE
1004: is
1005: begin
1006: delete from FF_FORMULAS_F_TL T
1007: where not exists
1008: (select NULL
1009: from FF_FORMULAS_F B
1010: where B.FORMULA_ID = T.FORMULA_ID

Line 1012: update FF_FORMULAS_F_TL T set (

1008: (select NULL
1009: from FF_FORMULAS_F B
1010: where B.FORMULA_ID = T.FORMULA_ID
1011: );
1012: update FF_FORMULAS_F_TL T set (
1013: FORMULA_NAME,
1014: DESCRIPTION
1015: ) = (select
1016: B.FORMULA_NAME,

Line 1018: from FF_FORMULAS_F_TL B

1014: DESCRIPTION
1015: ) = (select
1016: B.FORMULA_NAME,
1017: B.DESCRIPTION
1018: from FF_FORMULAS_F_TL B
1019: where B.FORMULA_ID = T.FORMULA_ID
1020: and B.LANGUAGE = T.SOURCE_LANG)
1021: where (
1022: T.FORMULA_ID,

Line 1027: from FF_FORMULAS_F_TL SUBB, FF_FORMULAS_F_TL SUBT

1023: T.LANGUAGE
1024: ) in (select
1025: SUBT.FORMULA_ID,
1026: SUBT.LANGUAGE
1027: from FF_FORMULAS_F_TL SUBB, FF_FORMULAS_F_TL SUBT
1028: where SUBB.FORMULA_ID = SUBT.FORMULA_ID
1029: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1030: and (SUBB.FORMULA_NAME <> SUBT.FORMULA_NAME
1031: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 1036: insert into FF_FORMULAS_F_TL (

1032: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
1033: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
1034: ));
1035:
1036: insert into FF_FORMULAS_F_TL (
1037: FORMULA_ID,
1038: FORMULA_NAME,
1039: DESCRIPTION,
1040: LAST_UPDATE_DATE,

Line 1058: from FF_FORMULAS_F_TL B, FND_LANGUAGES L

1054: B.CREATED_BY,
1055: B.CREATION_DATE,
1056: L.LANGUAGE_CODE,
1057: B.SOURCE_LANG
1058: from FF_FORMULAS_F_TL B, FND_LANGUAGES L
1059: where L.INSTALLED_FLAG in ('I', 'B')
1060: and B.LANGUAGE = userenv('LANG')
1061: and not exists
1062: (select NULL

Line 1063: from FF_FORMULAS_F_TL T

1059: where L.INSTALLED_FLAG in ('I', 'B')
1060: and B.LANGUAGE = userenv('LANG')
1061: and not exists
1062: (select NULL
1063: from FF_FORMULAS_F_TL T
1064: where T.FORMULA_ID = B.FORMULA_ID
1065: and T.LANGUAGE = L.LANGUAGE_CODE);
1066: end ADD_LANGUAGE;
1067: --

Line 1077: UPDATE ff_formulas_f_tl

1073: X_DESCRIPTION in VARCHAR2,
1074: X_OWNER in VARCHAR2
1075: ) is
1076: begin
1077: UPDATE ff_formulas_f_tl
1078: SET FORMULA_NAME = nvl(X_FORMULA_NAME,FORMULA_NAME),
1079: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
1080: last_update_date = SYSDATE,
1081: last_updated_by = decode(x_owner,'SEED',1,0),

Line 1131: FROM ff_formulas_f_tl fft,

1127: p_formula_id IN NUMBER,
1128: p_bus_grp_id IN NUMBER,
1129: p_leg_code IN varchar2) IS
1130: SELECT 1
1131: FROM ff_formulas_f_tl fft,
1132: ff_formulas_f fff
1133: WHERE upper(fft.formula_name)=upper(p_formula_name)
1134: AND fft.formula_id = fff.formula_id
1135: AND fft.language = p_language