APPS.FEM_CUST_STAT_PKG dependencies on FEM_CUST_STAT_TL

Line 49: insert into FEM_CUST_STAT_TL (

45: X_LAST_UPDATED_BY,
46: X_LAST_UPDATE_LOGIN
47: );
48:
49: insert into FEM_CUST_STAT_TL (
50: CUSTOMER_STATUS_NAME,
51: DESCRIPTION,
52: CREATION_DATE,
53: CREATED_BY,

Line 75: from FEM_CUST_STAT_TL T

71: from FND_LANGUAGES L
72: where L.INSTALLED_FLAG in ('I', 'B')
73: and not exists
74: (select NULL
75: from FEM_CUST_STAT_TL T
76: where T.CUSTOMER_STATUS_ID = X_CUSTOMER_STATUS_ID
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;

Line 114: from FEM_CUST_STAT_TL

110: cursor c1 is select
111: CUSTOMER_STATUS_NAME,
112: DESCRIPTION,
113: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
114: from FEM_CUST_STAT_TL
115: where CUSTOMER_STATUS_ID = X_CUSTOMER_STATUS_ID
116: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
117: for update of CUSTOMER_STATUS_ID nowait;
118: begin

Line 184: update FEM_CUST_STAT_TL set

180: if (sql%notfound) then
181: raise no_data_found;
182: end if;
183:
184: update FEM_CUST_STAT_TL set
185: CUSTOMER_STATUS_NAME = X_CUSTOMER_STATUS_NAME,
186: DESCRIPTION = X_DESCRIPTION,
187: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
188: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 203: delete from FEM_CUST_STAT_TL

199: procedure DELETE_ROW (
200: X_CUSTOMER_STATUS_ID in NUMBER
201: ) is
202: begin
203: delete from FEM_CUST_STAT_TL
204: where CUSTOMER_STATUS_ID = X_CUSTOMER_STATUS_ID;
205:
206: if (sql%notfound) then
207: raise no_data_found;

Line 221: delete from FEM_CUST_STAT_TL T

217:
218: procedure ADD_LANGUAGE
219: is
220: begin
221: delete from FEM_CUST_STAT_TL T
222: where not exists
223: (select NULL
224: from FEM_CUST_STAT_B B
225: where B.CUSTOMER_STATUS_ID = T.CUSTOMER_STATUS_ID

Line 228: update FEM_CUST_STAT_TL T set (

224: from FEM_CUST_STAT_B B
225: where B.CUSTOMER_STATUS_ID = T.CUSTOMER_STATUS_ID
226: );
227:
228: update FEM_CUST_STAT_TL T set (
229: CUSTOMER_STATUS_NAME,
230: DESCRIPTION
231: ) = (select
232: B.CUSTOMER_STATUS_NAME,

Line 234: from FEM_CUST_STAT_TL B

230: DESCRIPTION
231: ) = (select
232: B.CUSTOMER_STATUS_NAME,
233: B.DESCRIPTION
234: from FEM_CUST_STAT_TL B
235: where B.CUSTOMER_STATUS_ID = T.CUSTOMER_STATUS_ID
236: and B.LANGUAGE = T.SOURCE_LANG)
237: where (
238: T.CUSTOMER_STATUS_ID,

Line 243: from FEM_CUST_STAT_TL SUBB, FEM_CUST_STAT_TL SUBT

239: T.LANGUAGE
240: ) in (select
241: SUBT.CUSTOMER_STATUS_ID,
242: SUBT.LANGUAGE
243: from FEM_CUST_STAT_TL SUBB, FEM_CUST_STAT_TL SUBT
244: where SUBB.CUSTOMER_STATUS_ID = SUBT.CUSTOMER_STATUS_ID
245: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
246: and (SUBB.CUSTOMER_STATUS_NAME <> SUBT.CUSTOMER_STATUS_NAME
247: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 252: insert into FEM_CUST_STAT_TL (

248: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
249: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
250: ));
251:
252: insert into FEM_CUST_STAT_TL (
253: CUSTOMER_STATUS_NAME,
254: DESCRIPTION,
255: CREATION_DATE,
256: CREATED_BY,

Line 274: from FEM_CUST_STAT_TL B, FND_LANGUAGES L

270: B.LAST_UPDATE_LOGIN,
271: B.CUSTOMER_STATUS_ID,
272: L.LANGUAGE_CODE,
273: B.SOURCE_LANG
274: from FEM_CUST_STAT_TL B, FND_LANGUAGES L
275: where L.INSTALLED_FLAG in ('I', 'B')
276: and B.LANGUAGE = userenv('LANG')
277: and not exists
278: (select NULL

Line 279: from FEM_CUST_STAT_TL T

275: where L.INSTALLED_FLAG in ('I', 'B')
276: and B.LANGUAGE = userenv('LANG')
277: and not exists
278: (select NULL
279: from FEM_CUST_STAT_TL T
280: where T.CUSTOMER_STATUS_ID = B.CUSTOMER_STATUS_ID
281: and T.LANGUAGE = L.LANGUAGE_CODE);
282: end ADD_LANGUAGE;
283: PROCEDURE TRANSLATE_ROW(

Line 309: from FEM_CUST_STAT_TL

305: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
306: begin
307: select LAST_UPDATED_BY, LAST_UPDATE_DATE
308: into db_luby, db_ludate
309: from FEM_CUST_STAT_TL
310: where CUSTOMER_STATUS_ID = x_CUSTOMER_STATUS_ID
311: and LANGUAGE = userenv('LANG');
312:
313: -- Test for customization and version

Line 317: update FEM_CUST_STAT_TL set

313: -- Test for customization and version
314: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
315: db_ludate, x_custom_mode)) then
316: -- Update translations for this language
317: update FEM_CUST_STAT_TL set
318: CUSTOMER_STATUS_NAME = decode(x_CUSTOMER_STATUS_NAME,
319: fnd_load_util.null_value, null, -- Real null
320: null, x_CUSTOMER_STATUS_NAME, -- No change
321: x_CUSTOMER_STATUS_NAME),