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 580: insert into PAY_BALANCE_TYPES_TL (

576: --
577: -- **************************************************************************
578: -- insert into MLS table (TL)
579: --
580: insert into PAY_BALANCE_TYPES_TL (
581: BALANCE_TYPE_ID,
582: BALANCE_NAME,
583: REPORTING_NAME,
584: LAST_UPDATE_DATE,

Line 600: from PAY_BALANCE_TYPES_TL T

596: from FND_LANGUAGES L
597: where L.INSTALLED_FLAG in ('I', 'B')
598: and not exists
599: (select NULL
600: from PAY_BALANCE_TYPES_TL T
601: where T.BALANCE_TYPE_ID = X_Balance_Type_Id
602: and T.LANGUAGE = L.LANGUAGE_CODE);
603: --
604: --

Line 685: from PAY_BALANCE_TYPES_TL

681: cursor csr_balance_type_tl is
682: select BALANCE_NAME,
683: REPORTING_NAME,
684: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
685: from PAY_BALANCE_TYPES_TL
686: where BALANCE_TYPE_ID = X_BALANCE_TYPE_ID
687: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
688: for update of BALANCE_TYPE_ID nowait;
689: --

Line 1022: update PAY_BALANCE_TYPES_TL

1018: -- ****************************************************************************************
1019: --
1020: -- update MLS table (TL)
1021: --
1022: update PAY_BALANCE_TYPES_TL
1023: set BALANCE_NAME = X_BALANCE_NAME,
1024: REPORTING_NAME = X_REPORTING_NAME,
1025: LAST_UPDATE_DATE = sysdate,
1026: SOURCE_LANG = userenv('LANG')

Line 1083: delete from PAY_BALANCE_TYPES_TL

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

Line 1103: delete from PAY_BALANCE_TYPES_TL T

1099: ------------------------------------------------------------------------------------
1100: procedure ADD_LANGUAGE
1101: is
1102: begin
1103: delete from PAY_BALANCE_TYPES_TL T
1104: where not exists
1105: (select NULL
1106: from PAY_BALANCE_TYPES B
1107: where B.BALANCE_TYPE_ID = T.BALANCE_TYPE_ID

Line 1110: update PAY_BALANCE_TYPES_TL T set (

1106: from PAY_BALANCE_TYPES B
1107: where B.BALANCE_TYPE_ID = T.BALANCE_TYPE_ID
1108: );
1109:
1110: update PAY_BALANCE_TYPES_TL T set (
1111: BALANCE_NAME,
1112: REPORTING_NAME
1113: ) = (select
1114: B.BALANCE_NAME,

Line 1116: from PAY_BALANCE_TYPES_TL B

1112: REPORTING_NAME
1113: ) = (select
1114: B.BALANCE_NAME,
1115: B.REPORTING_NAME
1116: from PAY_BALANCE_TYPES_TL B
1117: where B.BALANCE_TYPE_ID = T.BALANCE_TYPE_ID
1118: and B.LANGUAGE = T.SOURCE_LANG)
1119: where (
1120: T.BALANCE_TYPE_ID,

Line 1125: from PAY_BALANCE_TYPES_TL SUBB, PAY_BALANCE_TYPES_TL SUBT

1121: T.LANGUAGE
1122: ) in (select
1123: SUBT.BALANCE_TYPE_ID,
1124: SUBT.LANGUAGE
1125: from PAY_BALANCE_TYPES_TL SUBB, PAY_BALANCE_TYPES_TL SUBT
1126: where SUBB.BALANCE_TYPE_ID = SUBT.BALANCE_TYPE_ID
1127: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1128: and (SUBB.BALANCE_NAME <> SUBT.BALANCE_NAME
1129: or SUBB.REPORTING_NAME <> SUBT.REPORTING_NAME

Line 1134: insert into PAY_BALANCE_TYPES_TL (

1130: or (SUBB.REPORTING_NAME is null and SUBT.REPORTING_NAME is not null)
1131: or (SUBB.REPORTING_NAME is not null and SUBT.REPORTING_NAME is null)
1132: ));
1133:
1134: insert into PAY_BALANCE_TYPES_TL (
1135: BALANCE_TYPE_ID,
1136: BALANCE_NAME,
1137: REPORTING_NAME,
1138: LAST_UPDATE_DATE,

Line 1156: from PAY_BALANCE_TYPES_TL B, FND_LANGUAGES L

1152: B.CREATED_BY,
1153: B.CREATION_DATE,
1154: L.LANGUAGE_CODE,
1155: B.SOURCE_LANG
1156: from PAY_BALANCE_TYPES_TL B, FND_LANGUAGES L
1157: where L.INSTALLED_FLAG in ('I', 'B')
1158: and B.LANGUAGE = userenv('LANG')
1159: and not exists
1160: (select NULL

Line 1161: from PAY_BALANCE_TYPES_TL T

1157: where L.INSTALLED_FLAG in ('I', 'B')
1158: and B.LANGUAGE = userenv('LANG')
1159: and not exists
1160: (select NULL
1161: from PAY_BALANCE_TYPES_TL T
1162: where T.BALANCE_TYPE_ID = B.BALANCE_TYPE_ID
1163: and T.LANGUAGE = L.LANGUAGE_CODE);
1164: end ADD_LANGUAGE;
1165: --

Line 1217: from pay_balance_types_tl

1213: ,p_language in varchar2
1214: ) is
1215: select balance_name
1216: , language
1217: from pay_balance_types_tl
1218: where balance_type_id = p_balance_type_id
1219: and p_language in (language, source_lang)
1220: ;
1221: --

Line 1258: UPDATE pay_balance_types_tl

1254: end if;
1255: end loop;
1256: end if;
1257:
1258: UPDATE pay_balance_types_tl
1259: SET balance_name = nvl(x_balance_name,balance_name),
1260: reporting_name = nvl(x_reporting_name,reporting_name),
1261: last_update_date = Sysdate,
1262: last_updated_by = decode(x_owner,'SEED',1,0),