APPS.FEM_CREDIT_STATUS_PKG dependencies on FEM_CREDIT_STATUS_TL

Line 49: insert into FEM_CREDIT_STATUS_TL (

45: X_LAST_UPDATED_BY,
46: X_LAST_UPDATE_LOGIN
47: );
48:
49: insert into FEM_CREDIT_STATUS_TL (
50: CREDIT_STATUS_ID,
51: CREDIT_STATUS_NAME,
52: DESCRIPTION,
53: CREATION_DATE,

Line 75: from FEM_CREDIT_STATUS_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_CREDIT_STATUS_TL T
76: where T.CREDIT_STATUS_ID = X_CREDIT_STATUS_ID
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;

Line 114: from FEM_CREDIT_STATUS_TL

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

Line 183: update FEM_CREDIT_STATUS_TL set

179: if (sql%notfound) then
180: raise no_data_found;
181: end if;
182:
183: update FEM_CREDIT_STATUS_TL set
184: CREDIT_STATUS_NAME = X_CREDIT_STATUS_NAME,
185: DESCRIPTION = X_DESCRIPTION,
186: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
187: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 202: delete from FEM_CREDIT_STATUS_TL

198: procedure DELETE_ROW (
199: X_CREDIT_STATUS_ID in NUMBER
200: ) is
201: begin
202: delete from FEM_CREDIT_STATUS_TL
203: where CREDIT_STATUS_ID = X_CREDIT_STATUS_ID;
204:
205: if (sql%notfound) then
206: raise no_data_found;

Line 220: delete from FEM_CREDIT_STATUS_TL T

216:
217: procedure ADD_LANGUAGE
218: is
219: begin
220: delete from FEM_CREDIT_STATUS_TL T
221: where not exists
222: (select NULL
223: from FEM_CREDIT_STATUS_B B
224: where B.CREDIT_STATUS_ID = T.CREDIT_STATUS_ID

Line 227: update FEM_CREDIT_STATUS_TL T set (

223: from FEM_CREDIT_STATUS_B B
224: where B.CREDIT_STATUS_ID = T.CREDIT_STATUS_ID
225: );
226:
227: update FEM_CREDIT_STATUS_TL T set (
228: CREDIT_STATUS_NAME,
229: DESCRIPTION
230: ) = (select
231: B.CREDIT_STATUS_NAME,

Line 233: from FEM_CREDIT_STATUS_TL B

229: DESCRIPTION
230: ) = (select
231: B.CREDIT_STATUS_NAME,
232: B.DESCRIPTION
233: from FEM_CREDIT_STATUS_TL B
234: where B.CREDIT_STATUS_ID = T.CREDIT_STATUS_ID
235: and B.LANGUAGE = T.SOURCE_LANG)
236: where (
237: T.CREDIT_STATUS_ID,

Line 242: from FEM_CREDIT_STATUS_TL SUBB, FEM_CREDIT_STATUS_TL SUBT

238: T.LANGUAGE
239: ) in (select
240: SUBT.CREDIT_STATUS_ID,
241: SUBT.LANGUAGE
242: from FEM_CREDIT_STATUS_TL SUBB, FEM_CREDIT_STATUS_TL SUBT
243: where SUBB.CREDIT_STATUS_ID = SUBT.CREDIT_STATUS_ID
244: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
245: and (SUBB.CREDIT_STATUS_NAME <> SUBT.CREDIT_STATUS_NAME
246: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 249: insert into FEM_CREDIT_STATUS_TL (

245: and (SUBB.CREDIT_STATUS_NAME <> SUBT.CREDIT_STATUS_NAME
246: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
247: ));
248:
249: insert into FEM_CREDIT_STATUS_TL (
250: CREDIT_STATUS_ID,
251: CREDIT_STATUS_NAME,
252: DESCRIPTION,
253: CREATION_DATE,

Line 271: from FEM_CREDIT_STATUS_TL B, FND_LANGUAGES L

267: B.LAST_UPDATE_DATE,
268: B.LAST_UPDATE_LOGIN,
269: L.LANGUAGE_CODE,
270: B.SOURCE_LANG
271: from FEM_CREDIT_STATUS_TL B, FND_LANGUAGES L
272: where L.INSTALLED_FLAG in ('I', 'B')
273: and B.LANGUAGE = userenv('LANG')
274: and not exists
275: (select NULL

Line 276: from FEM_CREDIT_STATUS_TL T

272: where L.INSTALLED_FLAG in ('I', 'B')
273: and B.LANGUAGE = userenv('LANG')
274: and not exists
275: (select NULL
276: from FEM_CREDIT_STATUS_TL T
277: where T.CREDIT_STATUS_ID = B.CREDIT_STATUS_ID
278: and T.LANGUAGE = L.LANGUAGE_CODE);
279: end ADD_LANGUAGE;
280: PROCEDURE TRANSLATE_ROW(

Line 306: from FEM_CREDIT_STATUS_TL

302: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
303: begin
304: select LAST_UPDATED_BY, LAST_UPDATE_DATE
305: into db_luby, db_ludate
306: from FEM_CREDIT_STATUS_TL
307: where CREDIT_STATUS_ID = x_CREDIT_STATUS_ID
308: and LANGUAGE = userenv('LANG');
309:
310: -- Test for customization and version

Line 314: update FEM_CREDIT_STATUS_TL set

310: -- Test for customization and version
311: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
312: db_ludate, x_custom_mode)) then
313: -- Update translations for this language
314: update FEM_CREDIT_STATUS_TL set
315: CREDIT_STATUS_NAME = decode(x_CREDIT_STATUS_NAME,
316: fnd_load_util.null_value, null, -- Real null
317: null, x_CREDIT_STATUS_NAME, -- No change
318: x_CREDIT_STATUS_NAME),