APPS.XDO_FONT_MAPPING_SETS_PKG dependencies on XDO_FONT_MAPPING_SETS_TL

Line 33: insert into XDO_FONT_MAPPING_SETS_TL (

29: P_LAST_UPDATED_BY,
30: P_LAST_UPDATE_LOGIN
31: );
32:
33: insert into XDO_FONT_MAPPING_SETS_TL (
34: MAPPING_CODE,
35: MAPPING_NAME,
36: CREATION_DATE,
37: CREATED_BY,

Line 56: from XDO_FONT_MAPPING_SETS_TL T

52: from FND_LANGUAGES L
53: where L.INSTALLED_FLAG in ('I', 'B')
54: and not exists
55: (select NULL
56: from XDO_FONT_MAPPING_SETS_TL T
57: where T.MAPPING_CODE = P_MAPPING_CODE
58: and T.LANGUAGE = L.LANGUAGE_CODE);
59:
60: end INSERT_ROW;

Line 83: update XDO_FONT_MAPPING_SETS_TL set

79: if (sql%notfound) then
80: raise no_data_found;
81: end if;
82:
83: update XDO_FONT_MAPPING_SETS_TL set
84: MAPPING_NAME = P_MAPPING_NAME,
85: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
86: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
87: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,

Line 123: from XDO_FONT_MAPPING_SETS_TL

119:
120: begin
121: select LAST_UPDATED_BY, LAST_UPDATE_DATE
122: into db_luby, db_ludate
123: from XDO_FONT_MAPPING_SETS_TL
124: where MAPPING_CODE = P_MAPPING_CODE
125: and LANGUAGE = userenv('LANG');
126:
127: -- Update record, honoring customization mode.

Line 139: update XDO_FONT_MAPPING_SETS_TL

135: p_db_id => db_luby,
136: p_db_lud => db_ludate,
137: p_custom_mode => p_custom_mode))
138: then
139: update XDO_FONT_MAPPING_SETS_TL
140: set MAPPING_NAME = nvl(p_mapping_name, mapping_name),
141: SOURCE_LANG = userenv('LANG'),
142: LAST_UPDATE_DATE = f_ludate,
143: LAST_UPDATED_BY = f_luby,

Line 156: insert into XDO_FONT_MAPPING_SETS_TL (

152: end TRANSLATE_ROW;
153:
154: procedure ADD_LANGUAGE is
155: begin
156: insert into XDO_FONT_MAPPING_SETS_TL (
157: MAPPING_CODE,
158: MAPPING_NAME,
159: CREATED_BY,
160: CREATION_DATE,

Line 176: from XDO_FONT_MAPPING_SETS_TL B, FND_LANGUAGES L

172: B.LAST_UPDATE_DATE,
173: B.LAST_UPDATE_LOGIN,
174: L.LANGUAGE_CODE,
175: B.SOURCE_LANG
176: from XDO_FONT_MAPPING_SETS_TL B, FND_LANGUAGES L
177: where L.INSTALLED_FLAG in ('I', 'B')
178: and B.LANGUAGE = userenv('LANG')
179: and not exists
180: (select NULL

Line 181: from XDO_FONT_MAPPING_SETS_TL T

177: where L.INSTALLED_FLAG in ('I', 'B')
178: and B.LANGUAGE = userenv('LANG')
179: and not exists
180: (select NULL
181: from XDO_FONT_MAPPING_SETS_TL T
182: where T.MAPPING_CODE = B.MAPPING_CODE
183: and T.LANGUAGE = L.LANGUAGE_CODE);
184: end ADD_LANGUAGE;
185: