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_US_PAYROLL_UTILS dependencies on FND_LOOKUP_VALUES

Line 1136: l_lookup_type fnd_lookup_values.lookup_type%TYPE;

1132:
1133: /* Declaration of local Variables */
1134: l_sysdate DATE := TRUNC(SYSDATE);
1135: l_app_user fnd_user.user_name%TYPE;
1136: l_lookup_type fnd_lookup_values.lookup_type%TYPE;
1137: l_view_application_id fnd_lookup_values.view_application_id%TYPE;
1138: l_lookup_code fnd_lookup_values.lookup_code%TYPE;
1139: l_security_group_id fnd_lookup_values.security_group_id%TYPE;
1140: l_language fnd_lookup_values.language%TYPE;

Line 1137: l_view_application_id fnd_lookup_values.view_application_id%TYPE;

1133: /* Declaration of local Variables */
1134: l_sysdate DATE := TRUNC(SYSDATE);
1135: l_app_user fnd_user.user_name%TYPE;
1136: l_lookup_type fnd_lookup_values.lookup_type%TYPE;
1137: l_view_application_id fnd_lookup_values.view_application_id%TYPE;
1138: l_lookup_code fnd_lookup_values.lookup_code%TYPE;
1139: l_security_group_id fnd_lookup_values.security_group_id%TYPE;
1140: l_language fnd_lookup_values.language%TYPE;
1141: l_state_name pay_us_states.state_name%TYPE;

Line 1138: l_lookup_code fnd_lookup_values.lookup_code%TYPE;

1134: l_sysdate DATE := TRUNC(SYSDATE);
1135: l_app_user fnd_user.user_name%TYPE;
1136: l_lookup_type fnd_lookup_values.lookup_type%TYPE;
1137: l_view_application_id fnd_lookup_values.view_application_id%TYPE;
1138: l_lookup_code fnd_lookup_values.lookup_code%TYPE;
1139: l_security_group_id fnd_lookup_values.security_group_id%TYPE;
1140: l_language fnd_lookup_values.language%TYPE;
1141: l_state_name pay_us_states.state_name%TYPE;
1142: l_application_id fnd_application.application_id%TYPE;

Line 1139: l_security_group_id fnd_lookup_values.security_group_id%TYPE;

1135: l_app_user fnd_user.user_name%TYPE;
1136: l_lookup_type fnd_lookup_values.lookup_type%TYPE;
1137: l_view_application_id fnd_lookup_values.view_application_id%TYPE;
1138: l_lookup_code fnd_lookup_values.lookup_code%TYPE;
1139: l_security_group_id fnd_lookup_values.security_group_id%TYPE;
1140: l_language fnd_lookup_values.language%TYPE;
1141: l_state_name pay_us_states.state_name%TYPE;
1142: l_application_id fnd_application.application_id%TYPE;
1143: l_security_group_id1 fnd_security_groups.security_group_id%TYPE;

Line 1140: l_language fnd_lookup_values.language%TYPE;

1136: l_lookup_type fnd_lookup_values.lookup_type%TYPE;
1137: l_view_application_id fnd_lookup_values.view_application_id%TYPE;
1138: l_lookup_code fnd_lookup_values.lookup_code%TYPE;
1139: l_security_group_id fnd_lookup_values.security_group_id%TYPE;
1140: l_language fnd_lookup_values.language%TYPE;
1141: l_state_name pay_us_states.state_name%TYPE;
1142: l_application_id fnd_application.application_id%TYPE;
1143: l_security_group_id1 fnd_security_groups.security_group_id%TYPE;
1144: l_procedure_name VARCHAR2(50) := 'update_state_or_local_wh_link';

Line 1154: FROM fnd_lookup_values

1150: view_application_id,
1151: lookup_code,
1152: security_group_id,
1153: language
1154: FROM fnd_lookup_values
1155: WHERE lookup_type = v_lookup_type
1156: AND lookup_code = v_lookup_code
1157: AND language = userenv ('LANG');
1158:

Line 1202: UPDATE fnd_lookup_values

1198: IF get_lookup_value_cur%FOUND THEN
1199: hr_utility.set_location(gv_package || '.' || l_procedure_name, 40);
1200:
1201: /* Update the State Link for the Lookup */
1202: UPDATE fnd_lookup_values
1203: SET description = p_link,
1204: meaning = 'User updated: ' || LTRIM(meaning, 'User updated: '),
1205: last_updated_by = l_app_user,
1206: last_update_date = l_sysdate

Line 1252: INSERT INTO fnd_lookup_values

1248: FETCH get_security_group_id_cur into l_security_group_id1;
1249: CLOSE get_security_group_id_cur;
1250:
1251: /* Insert the new Lookup Code */
1252: INSERT INTO fnd_lookup_values
1253: ( lookup_type
1254: ,language
1255: ,lookup_code
1256: ,meaning

Line 1289: UPDATE fnd_lookup_values

1285: ELSE
1286: hr_utility.set_location(gv_package || '.' || l_procedure_name, 110);
1287:
1288: /* Update the Local Link for the Lookup */
1289: UPDATE fnd_lookup_values
1290: SET description = p_link,
1291: last_updated_by = l_app_user,
1292: last_update_date = l_sysdate
1293: WHERE lookup_type = l_lookup_type