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_BALANCE_TYPES_PKG dependencies on PAY_BALANCE_TYPES_TL

Line 44: FROM pay_balance_types_tl bttl,

40: p_reporting_name IN VARCHAR2,
41: p_balance_type_id IN NUMBER,
42: p_mode IN VARCHAR2) IS
43: SELECT 1
44: FROM pay_balance_types_tl bttl,
45: pay_balance_types bt
46: WHERE ((p_mode = 'BALANCE_NAME' and
47: upper(bttl.balance_name) = upper(translate(p_balance_name,
48: '_',' '))) or

Line 575: insert into PAY_BALANCE_TYPES_TL (

571: --
572: -- **************************************************************************
573: -- insert into MLS table (TL)
574: --
575: insert into PAY_BALANCE_TYPES_TL (
576: BALANCE_TYPE_ID,
577: BALANCE_NAME,
578: REPORTING_NAME,
579: LAST_UPDATE_DATE,

Line 595: from PAY_BALANCE_TYPES_TL T

591: from FND_LANGUAGES L
592: where L.INSTALLED_FLAG in ('I', 'B')
593: and not exists
594: (select NULL
595: from PAY_BALANCE_TYPES_TL T
596: where T.BALANCE_TYPE_ID = X_Balance_Type_Id
597: and T.LANGUAGE = L.LANGUAGE_CODE);
598: --
599: --

Line 680: from PAY_BALANCE_TYPES_TL

676: cursor csr_balance_type_tl is
677: select BALANCE_NAME,
678: REPORTING_NAME,
679: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
680: from PAY_BALANCE_TYPES_TL
681: where BALANCE_TYPE_ID = X_BALANCE_TYPE_ID
682: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
683: for update of BALANCE_TYPE_ID nowait;
684: --

Line 1017: update PAY_BALANCE_TYPES_TL

1013: -- ****************************************************************************************
1014: --
1015: -- update MLS table (TL)
1016: --
1017: update PAY_BALANCE_TYPES_TL
1018: set BALANCE_NAME = X_BALANCE_NAME,
1019: REPORTING_NAME = X_REPORTING_NAME,
1020: LAST_UPDATE_DATE = sysdate,
1021: SOURCE_LANG = userenv('LANG')

Line 1078: delete from PAY_BALANCE_TYPES_TL

1074: -- for all other date track modes the data should remain untouched
1075: --
1076: --if p_delete_mode = 'ZAP' then
1077:
1078: delete from PAY_BALANCE_TYPES_TL
1079: where BALANCE_TYPE_ID = X_BALANCE_TYPE_ID;
1080: --
1081: if sql%notfound then -- trap system errors during deletion
1082: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 1098: delete from PAY_BALANCE_TYPES_TL T

1094: ------------------------------------------------------------------------------------
1095: procedure ADD_LANGUAGE
1096: is
1097: begin
1098: delete from PAY_BALANCE_TYPES_TL T
1099: where not exists
1100: (select NULL
1101: from PAY_BALANCE_TYPES B
1102: where B.BALANCE_TYPE_ID = T.BALANCE_TYPE_ID

Line 1105: update PAY_BALANCE_TYPES_TL T set (

1101: from PAY_BALANCE_TYPES B
1102: where B.BALANCE_TYPE_ID = T.BALANCE_TYPE_ID
1103: );
1104:
1105: update PAY_BALANCE_TYPES_TL T set (
1106: BALANCE_NAME,
1107: REPORTING_NAME
1108: ) = (select
1109: B.BALANCE_NAME,

Line 1111: from PAY_BALANCE_TYPES_TL B

1107: REPORTING_NAME
1108: ) = (select
1109: B.BALANCE_NAME,
1110: B.REPORTING_NAME
1111: from PAY_BALANCE_TYPES_TL B
1112: where B.BALANCE_TYPE_ID = T.BALANCE_TYPE_ID
1113: and B.LANGUAGE = T.SOURCE_LANG)
1114: where (
1115: T.BALANCE_TYPE_ID,

Line 1120: from PAY_BALANCE_TYPES_TL SUBB, PAY_BALANCE_TYPES_TL SUBT

1116: T.LANGUAGE
1117: ) in (select
1118: SUBT.BALANCE_TYPE_ID,
1119: SUBT.LANGUAGE
1120: from PAY_BALANCE_TYPES_TL SUBB, PAY_BALANCE_TYPES_TL SUBT
1121: where SUBB.BALANCE_TYPE_ID = SUBT.BALANCE_TYPE_ID
1122: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1123: and (SUBB.BALANCE_NAME <> SUBT.BALANCE_NAME
1124: or SUBB.REPORTING_NAME <> SUBT.REPORTING_NAME

Line 1129: insert into PAY_BALANCE_TYPES_TL (

1125: or (SUBB.REPORTING_NAME is null and SUBT.REPORTING_NAME is not null)
1126: or (SUBB.REPORTING_NAME is not null and SUBT.REPORTING_NAME is null)
1127: ));
1128:
1129: insert into PAY_BALANCE_TYPES_TL (
1130: BALANCE_TYPE_ID,
1131: BALANCE_NAME,
1132: REPORTING_NAME,
1133: LAST_UPDATE_DATE,

Line 1151: from PAY_BALANCE_TYPES_TL B, FND_LANGUAGES L

1147: B.CREATED_BY,
1148: B.CREATION_DATE,
1149: L.LANGUAGE_CODE,
1150: B.SOURCE_LANG
1151: from PAY_BALANCE_TYPES_TL B, FND_LANGUAGES L
1152: where L.INSTALLED_FLAG in ('I', 'B')
1153: and B.LANGUAGE = userenv('LANG')
1154: and not exists
1155: (select NULL

Line 1156: from PAY_BALANCE_TYPES_TL T

1152: where L.INSTALLED_FLAG in ('I', 'B')
1153: and B.LANGUAGE = userenv('LANG')
1154: and not exists
1155: (select NULL
1156: from PAY_BALANCE_TYPES_TL T
1157: where T.BALANCE_TYPE_ID = B.BALANCE_TYPE_ID
1158: and T.LANGUAGE = L.LANGUAGE_CODE);
1159: end ADD_LANGUAGE;
1160: --

Line 1212: from pay_balance_types_tl

1208: ,p_language in varchar2
1209: ) is
1210: select balance_name
1211: , language
1212: from pay_balance_types_tl
1213: where balance_type_id = p_balance_type_id
1214: and p_language in (language, source_lang)
1215: ;
1216: --

Line 1253: UPDATE pay_balance_types_tl

1249: end if;
1250: end loop;
1251: end if;
1252:
1253: UPDATE pay_balance_types_tl
1254: SET balance_name = nvl(x_balance_name,balance_name),
1255: reporting_name = nvl(x_reporting_name,reporting_name),
1256: last_update_date = Sysdate,
1257: last_updated_by = decode(x_owner,'SEED',1,0),