APPS.PAY_MONETARY_UNITS_PKG dependencies on PAY_MONETARY_UNITS_TL

Line 42: ,pay_monetary_units_tl pmut

38:
39: cursor c3(p_mode in varchar2) is
40: select 'x'
41: from pay_monetary_units pmu
42: ,pay_monetary_units_tl pmut
43: where pmu.currency_code = p_cur_code
44: and ( (p_mode = 'MONETARY_UNIT_NAME'
45: and upper(translate(pmut.monetary_unit_name,'x_','x '))
46: = upper(translate(p_unit_name,'x_','x '))

Line 140: -- Start of Table Handlers for PAY_MONETARY_UNITS and PAY_MONETARY_UNITS_TL.

136: close c5;
137: --
138: end stb_del_valid;
139: --
140: -- Start of Table Handlers for PAY_MONETARY_UNITS and PAY_MONETARY_UNITS_TL.
141: --
142: procedure INSERT_ROW (
143: X_ROWID in out nocopy VARCHAR2,
144: X_MONETARY_UNIT_ID in out nocopy NUMBER,

Line 200: insert into PAY_MONETARY_UNITS_TL (

196: X_LAST_UPDATED_BY,
197: X_LAST_UPDATE_LOGIN
198: );
199:
200: insert into PAY_MONETARY_UNITS_TL (
201: MONETARY_UNIT_ID,
202: MONETARY_UNIT_NAME,
203: LAST_UPDATE_DATE,
204: LAST_UPDATED_BY,

Line 224: from PAY_MONETARY_UNITS_TL T

220: from FND_LANGUAGES L
221: where L.INSTALLED_FLAG in ('I', 'B')
222: and not exists
223: (select NULL
224: from PAY_MONETARY_UNITS_TL T
225: where T.MONETARY_UNIT_ID = X_MONETARY_UNIT_ID
226: and T.LANGUAGE = L.LANGUAGE_CODE);
227:
228: open c;

Line 261: from PAY_MONETARY_UNITS_TL

257:
258: cursor c1 is select
259: MONETARY_UNIT_NAME,
260: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
261: from PAY_MONETARY_UNITS_TL
262: where MONETARY_UNIT_ID = X_MONETARY_UNIT_ID
263: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
264: for update of MONETARY_UNIT_ID nowait;
265: begin

Line 342: update PAY_MONETARY_UNITS_TL set

338: if (sql%notfound) then
339: raise no_data_found;
340: end if;
341:
342: update PAY_MONETARY_UNITS_TL set
343: MONETARY_UNIT_NAME = X_MONETARY_UNIT_NAME,
344: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
345: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
346: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 352: insert into PAY_MONETARY_UNITS_TL

348: where MONETARY_UNIT_ID = X_MONETARY_UNIT_ID
349: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
350: --
351: if (sql%notfound) then
352: insert into PAY_MONETARY_UNITS_TL
353: (MONETARY_UNIT_ID,
354: MONETARY_UNIT_NAME,
355: LANGUAGE,
356: SOURCE_LANG

Line 367: from PAY_MONETARY_UNITS_TL T

363: from FND_LANGUAGES L
364: where L.INSTALLED_FLAG in ('I', 'B')
365: and not exists
366: (select NULL
367: from PAY_MONETARY_UNITS_TL T
368: where T.MONETARY_UNIT_ID = X_MONETARY_UNIT_ID
369: and T.LANGUAGE = L.LANGUAGE_CODE);
370: end if;
371: --

Line 378: delete from PAY_MONETARY_UNITS_TL

374: procedure DELETE_ROW (
375: X_MONETARY_UNIT_ID in NUMBER
376: ) is
377: begin
378: delete from PAY_MONETARY_UNITS_TL
379: where MONETARY_UNIT_ID = X_MONETARY_UNIT_ID;
380:
381: if (sql%notfound) then
382: raise no_data_found;

Line 396: delete from PAY_MONETARY_UNITS_TL T

392: --
393: procedure ADD_LANGUAGE
394: is
395: begin
396: delete from PAY_MONETARY_UNITS_TL T
397: where not exists
398: (select NULL
399: from PAY_MONETARY_UNITS B
400: where B.MONETARY_UNIT_ID = T.MONETARY_UNIT_ID

Line 403: update PAY_MONETARY_UNITS_TL T set (

399: from PAY_MONETARY_UNITS B
400: where B.MONETARY_UNIT_ID = T.MONETARY_UNIT_ID
401: );
402:
403: update PAY_MONETARY_UNITS_TL T set (
404: MONETARY_UNIT_NAME
405: ) = (select
406: B.MONETARY_UNIT_NAME
407: from PAY_MONETARY_UNITS_TL B

Line 407: from PAY_MONETARY_UNITS_TL B

403: update PAY_MONETARY_UNITS_TL T set (
404: MONETARY_UNIT_NAME
405: ) = (select
406: B.MONETARY_UNIT_NAME
407: from PAY_MONETARY_UNITS_TL B
408: where B.MONETARY_UNIT_ID = T.MONETARY_UNIT_ID
409: and B.LANGUAGE = T.SOURCE_LANG)
410: where (
411: T.MONETARY_UNIT_ID,

Line 418: from PAY_MONETARY_UNITS_TL SUBB, PAY_MONETARY_UNITS_TL SUBT

414: ) in (select
415: SUBT.MONETARY_UNIT_ID,
416: SUBT.MONETARY_UNIT_ID,
417: SUBT.LANGUAGE
418: from PAY_MONETARY_UNITS_TL SUBB, PAY_MONETARY_UNITS_TL SUBT
419: where SUBB.MONETARY_UNIT_ID = SUBT.MONETARY_UNIT_ID
420: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
421: and (SUBB.MONETARY_UNIT_NAME <> SUBT.MONETARY_UNIT_NAME
422: ));

Line 424: insert into PAY_MONETARY_UNITS_TL (

420: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
421: and (SUBB.MONETARY_UNIT_NAME <> SUBT.MONETARY_UNIT_NAME
422: ));
423:
424: insert into PAY_MONETARY_UNITS_TL (
425: MONETARY_UNIT_ID,
426: MONETARY_UNIT_NAME,
427: LAST_UPDATE_DATE,
428: LAST_UPDATED_BY,

Line 444: from PAY_MONETARY_UNITS_TL B, FND_LANGUAGES L

440: B.CREATED_BY,
441: B.CREATION_DATE,
442: L.LANGUAGE_CODE,
443: B.SOURCE_LANG
444: from PAY_MONETARY_UNITS_TL B, FND_LANGUAGES L
445: where L.INSTALLED_FLAG in ('I', 'B')
446: and B.LANGUAGE = userenv('LANG')
447: and not exists
448: (select NULL

Line 449: from PAY_MONETARY_UNITS_TL T

445: where L.INSTALLED_FLAG in ('I', 'B')
446: and B.LANGUAGE = userenv('LANG')
447: and not exists
448: (select NULL
449: from PAY_MONETARY_UNITS_TL T
450: where T.MONETARY_UNIT_ID = B.MONETARY_UNIT_ID
451: and T.LANGUAGE = L.LANGUAGE_CODE);
452: end ADD_LANGUAGE;
453: --

Line 485: update PAY_MONETARY_UNITS_TL pmut

481: l_last_updated_by := fnd_global.user_id;
482: l_last_update_login := fnd_global.login_id;
483: l_last_update_date := sysdate;
484: --
485: update PAY_MONETARY_UNITS_TL pmut
486: set pmut.MONETARY_UNIT_NAME = nvl(X_MONETARY_UNIT_NAME,MONETARY_UNIT_NAME)
487: ,pmut.SOURCE_LANG = USERENV('LANG')
488: ,pmut.LAST_UPDATE_DATE = l_last_update_date
489: ,pmut.LAST_UPDATED_BY = l_last_updated_by

Line 639: pay_monetary_units_tl pmut

635: ,p_business_group_id in number
636: ,p_legislation_code in varchar2) is
637: select 1
638: from pay_monetary_units pmu,
639: pay_monetary_units_tl pmut
640: where upper(pmut.monetary_unit_name) = upper(p_monetary_unit_name)
641: and pmu.currency_code = g_currency_code
642: and pmut.language = p_language
643: and pmu.monetary_unit_id = pmut.monetary_unit_id