eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PAYMENT_TYPES_PKG dependencies on PAY_PAYMENT_TYPES_TL

Line 97: insert into PAY_PAYMENT_TYPES_TL (

93: --
94: -- **************************************************************************
95: -- insert into MLS table (TL)
96: --
97: insert into PAY_PAYMENT_TYPES_TL (
98: PAYMENT_TYPE_ID,
99: PAYMENT_TYPE_NAME,
100: DESCRIPTION,
101: LAST_UPDATE_DATE,

Line 117: from PAY_PAYMENT_TYPES_TL T

113: from FND_LANGUAGES L
114: where L.INSTALLED_FLAG in ('I', 'B')
115: and not exists
116: (select NULL
117: from PAY_PAYMENT_TYPES_TL T
118: where T.PAYMENT_TYPE_ID = X_PAYMENT_TYPE_ID
119: and T.LANGUAGE = L.LANGUAGE_CODE);
120: --
121: --

Line 161: FROM pay_payment_types_tl

157:
158: cursor c_translation_exists(p_language IN VARCHAR2,
159: p_payment_type_name IN VARCHAR2) IS
160: SELECT 1
161: FROM pay_payment_types_tl
162: WHERE language = p_language
163: AND upper(payment_type_name) = upper(p_payment_type_name);
164:
165: --

Line 175: FROM pay_payment_types_tl ptt,

171: cursor c_trans_check(p_language IN VARCHAR2,
172: p_payment_type_name IN VARCHAR2,
173: p_payment_type_id IN NUMBER) IS
174: SELECT 1
175: FROM pay_payment_types_tl ptt,
176: pay_payment_types pty
177: WHERE upper(ptt.payment_type_name)=upper(p_payment_type_name)
178: AND ptt.payment_type_id = pty.payment_type_id
179: AND ptt.language = p_language

Line 254: from PAY_PAYMENT_TYPES_TL

250: cursor csr_payment_type_tl is select
251: PAYMENT_TYPE_NAME,
252: DESCRIPTION,
253: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
254: from PAY_PAYMENT_TYPES_TL
255: where PAYMENT_TYPE_ID = X_PAYMENT_TYPE_ID
256: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
257: for update of PAYMENT_TYPE_ID nowait;
258: --

Line 410: update PAY_PAYMENT_TYPES_TL

406: -- ****************************************************************************************
407: --
408: -- update MLS table (TL)
409: --
410: update PAY_PAYMENT_TYPES_TL
411: set PAYMENT_TYPE_NAME = X_PAYMENT_TYPE_NAME,
412: DESCRIPTION = X_DESCRIPTION,
413: LAST_UPDATE_DATE = sysdate,
414: SOURCE_LANG = userenv('LANG')

Line 443: delete from PAY_PAYMENT_TYPES_TL

439: -- ********************************************************************************
440: --
441: -- delete from MLS table (TL)
442: --
443: delete from PAY_PAYMENT_TYPES_TL
444: where PAYMENT_TYPE_ID = X_PAYMENT_TYPE_ID;
445: --
446: if sql%notfound then -- trap system errors during deletion
447: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 459: delete from PAY_PAYMENT_TYPES_TL T

455: ----------------------------------------------------------------------------------
456: procedure ADD_LANGUAGE
457: is
458: begin
459: delete from PAY_PAYMENT_TYPES_TL T
460: where not exists
461: (select NULL
462: from PAY_PAYMENT_TYPES B
463: where B.PAYMENT_TYPE_ID = T.PAYMENT_TYPE_ID

Line 466: update PAY_PAYMENT_TYPES_TL T set (

462: from PAY_PAYMENT_TYPES B
463: where B.PAYMENT_TYPE_ID = T.PAYMENT_TYPE_ID
464: );
465:
466: update PAY_PAYMENT_TYPES_TL T set (
467: PAYMENT_TYPE_NAME,
468: DESCRIPTION
469: ) = (select
470: B.PAYMENT_TYPE_NAME,

Line 472: from PAY_PAYMENT_TYPES_TL B

468: DESCRIPTION
469: ) = (select
470: B.PAYMENT_TYPE_NAME,
471: B.DESCRIPTION
472: from PAY_PAYMENT_TYPES_TL B
473: where B.PAYMENT_TYPE_ID = T.PAYMENT_TYPE_ID
474: and B.LANGUAGE = T.SOURCE_LANG)
475: where (
476: T.PAYMENT_TYPE_ID,

Line 481: from PAY_PAYMENT_TYPES_TL SUBB, PAY_PAYMENT_TYPES_TL SUBT

477: T.LANGUAGE
478: ) in (select
479: SUBT.PAYMENT_TYPE_ID,
480: SUBT.LANGUAGE
481: from PAY_PAYMENT_TYPES_TL SUBB, PAY_PAYMENT_TYPES_TL SUBT
482: where SUBB.PAYMENT_TYPE_ID = SUBT.PAYMENT_TYPE_ID
483: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
484: and (SUBB.PAYMENT_TYPE_NAME <> SUBT.PAYMENT_TYPE_NAME
485: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 490: insert into PAY_PAYMENT_TYPES_TL (

486: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
487: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
488: ));
489:
490: insert into PAY_PAYMENT_TYPES_TL (
491: PAYMENT_TYPE_ID,
492: PAYMENT_TYPE_NAME,
493: DESCRIPTION,
494: LAST_UPDATE_DATE,

Line 512: from PAY_PAYMENT_TYPES_TL B, FND_LANGUAGES L

508: B.CREATED_BY,
509: B.CREATION_DATE,
510: L.LANGUAGE_CODE,
511: B.SOURCE_LANG
512: from PAY_PAYMENT_TYPES_TL B, FND_LANGUAGES L
513: where L.INSTALLED_FLAG in ('I', 'B')
514: and B.LANGUAGE = userenv('LANG')
515: and not exists
516: (select NULL

Line 517: from PAY_PAYMENT_TYPES_TL T

513: where L.INSTALLED_FLAG in ('I', 'B')
514: and B.LANGUAGE = userenv('LANG')
515: and not exists
516: (select NULL
517: from PAY_PAYMENT_TYPES_TL T
518: where T.PAYMENT_TYPE_ID = B.PAYMENT_TYPE_ID
519: and T.LANGUAGE = L.LANGUAGE_CODE);
520: end ADD_LANGUAGE;
521: ------------------------------------------------------------------------------

Line 554: UPDATE pay_payment_types_tl

550: is
551: begin
552: -- unique_chk(x_b_payment_type_name,x_territory_code);
553: --
554: UPDATE pay_payment_types_tl
555: SET description = nvl(x_description,description),
556: payment_type_name = nvl(x_payment_type_name,payment_type_name),
557: last_update_date = SYSDATE,
558: last_updated_by = decode(x_owner,'SEED',1,0),

Line 658: INSERT INTO pay_payment_types_tl(

654: decode(x_owner,'SEED',1,0),
655: SYSDATE,
656: X_RECONCILIATION_FUNCTION
657: );
658: INSERT INTO pay_payment_types_tl(
659: PAYMENT_TYPE_ID,
660: PAYMENT_TYPE_NAME,
661: DESCRIPTION,
662: LANGUAGE,

Line 684: from pay_payment_types_tl T

680: from FND_LANGUAGES L
681: where L.INSTALLED_FLAG in ('I', 'B')
682: and not exists
683: (select NULL
684: from pay_payment_types_tl T
685: where T.PAYMENT_TYPE_ID = X_PAYMENT_TYPE_ID
686: and T.LANGUAGE = L.LANGUAGE_CODE);
687: OPEN C;
688: FETCH C INTO X_PAYMENT_TYPE_ID;

Line 699: -- Added else part to update the pay_payment_types_tl table if the above

695: null;
696: end if;
697: CLOSE C;
698: -- Bug # 6124985.
699: -- Added else part to update the pay_payment_types_tl table if the above
700: -- update is successful.
701: else
702: UPDATE pay_payment_types_tl
703: SET description = nvl(x_description,description),

Line 702: UPDATE pay_payment_types_tl

698: -- Bug # 6124985.
699: -- Added else part to update the pay_payment_types_tl table if the above
700: -- update is successful.
701: else
702: UPDATE pay_payment_types_tl
703: SET description = nvl(x_description,description),
704: payment_type_name = nvl(x_payment_type_name,payment_type_name),
705: last_update_date = SYSDATE,
706: last_updated_by = decode(x_owner,'SEED',1,0),