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.HR_USER_ACCT_INTERNAL dependencies on HR_API

Line 2300: ,p_old_password in varchar2 default hr_api.g_varchar2

2296: -- ----------------------------------------------------------------------------
2297: --
2298: PROCEDURE update_fnd_user
2299: (p_user_id in number
2300: ,p_old_password in varchar2 default hr_api.g_varchar2
2301: ,p_new_password in varchar2 default hr_api.g_varchar2
2302: ,p_end_date in date default hr_api.g_date
2303: ,p_email_address in varchar2 default hr_api.g_varchar2
2304: ,p_fax in varchar2 default hr_api.g_varchar2

Line 2301: ,p_new_password in varchar2 default hr_api.g_varchar2

2297: --
2298: PROCEDURE update_fnd_user
2299: (p_user_id in number
2300: ,p_old_password in varchar2 default hr_api.g_varchar2
2301: ,p_new_password in varchar2 default hr_api.g_varchar2
2302: ,p_end_date in date default hr_api.g_date
2303: ,p_email_address in varchar2 default hr_api.g_varchar2
2304: ,p_fax in varchar2 default hr_api.g_varchar2
2305: ,p_known_as in varchar2 default hr_api.g_varchar2

Line 2302: ,p_end_date in date default hr_api.g_date

2298: PROCEDURE update_fnd_user
2299: (p_user_id in number
2300: ,p_old_password in varchar2 default hr_api.g_varchar2
2301: ,p_new_password in varchar2 default hr_api.g_varchar2
2302: ,p_end_date in date default hr_api.g_date
2303: ,p_email_address in varchar2 default hr_api.g_varchar2
2304: ,p_fax in varchar2 default hr_api.g_varchar2
2305: ,p_known_as in varchar2 default hr_api.g_varchar2
2306: ,p_language in varchar2 default hr_api.g_varchar2

Line 2303: ,p_email_address in varchar2 default hr_api.g_varchar2

2299: (p_user_id in number
2300: ,p_old_password in varchar2 default hr_api.g_varchar2
2301: ,p_new_password in varchar2 default hr_api.g_varchar2
2302: ,p_end_date in date default hr_api.g_date
2303: ,p_email_address in varchar2 default hr_api.g_varchar2
2304: ,p_fax in varchar2 default hr_api.g_varchar2
2305: ,p_known_as in varchar2 default hr_api.g_varchar2
2306: ,p_language in varchar2 default hr_api.g_varchar2
2307: ,p_host_port in varchar2 default hr_api.g_varchar2

Line 2304: ,p_fax in varchar2 default hr_api.g_varchar2

2300: ,p_old_password in varchar2 default hr_api.g_varchar2
2301: ,p_new_password in varchar2 default hr_api.g_varchar2
2302: ,p_end_date in date default hr_api.g_date
2303: ,p_email_address in varchar2 default hr_api.g_varchar2
2304: ,p_fax in varchar2 default hr_api.g_varchar2
2305: ,p_known_as in varchar2 default hr_api.g_varchar2
2306: ,p_language in varchar2 default hr_api.g_varchar2
2307: ,p_host_port in varchar2 default hr_api.g_varchar2
2308: ,p_employee_id in number default hr_api.g_number

Line 2305: ,p_known_as in varchar2 default hr_api.g_varchar2

2301: ,p_new_password in varchar2 default hr_api.g_varchar2
2302: ,p_end_date in date default hr_api.g_date
2303: ,p_email_address in varchar2 default hr_api.g_varchar2
2304: ,p_fax in varchar2 default hr_api.g_varchar2
2305: ,p_known_as in varchar2 default hr_api.g_varchar2
2306: ,p_language in varchar2 default hr_api.g_varchar2
2307: ,p_host_port in varchar2 default hr_api.g_varchar2
2308: ,p_employee_id in number default hr_api.g_number
2309: ,p_customer_id in number default hr_api.g_number

Line 2306: ,p_language in varchar2 default hr_api.g_varchar2

2302: ,p_end_date in date default hr_api.g_date
2303: ,p_email_address in varchar2 default hr_api.g_varchar2
2304: ,p_fax in varchar2 default hr_api.g_varchar2
2305: ,p_known_as in varchar2 default hr_api.g_varchar2
2306: ,p_language in varchar2 default hr_api.g_varchar2
2307: ,p_host_port in varchar2 default hr_api.g_varchar2
2308: ,p_employee_id in number default hr_api.g_number
2309: ,p_customer_id in number default hr_api.g_number
2310: ,p_supplier_id in number default hr_api.g_number

Line 2307: ,p_host_port in varchar2 default hr_api.g_varchar2

2303: ,p_email_address in varchar2 default hr_api.g_varchar2
2304: ,p_fax in varchar2 default hr_api.g_varchar2
2305: ,p_known_as in varchar2 default hr_api.g_varchar2
2306: ,p_language in varchar2 default hr_api.g_varchar2
2307: ,p_host_port in varchar2 default hr_api.g_varchar2
2308: ,p_employee_id in number default hr_api.g_number
2309: ,p_customer_id in number default hr_api.g_number
2310: ,p_supplier_id in number default hr_api.g_number
2311: ) IS

Line 2308: ,p_employee_id in number default hr_api.g_number

2304: ,p_fax in varchar2 default hr_api.g_varchar2
2305: ,p_known_as in varchar2 default hr_api.g_varchar2
2306: ,p_language in varchar2 default hr_api.g_varchar2
2307: ,p_host_port in varchar2 default hr_api.g_varchar2
2308: ,p_employee_id in number default hr_api.g_number
2309: ,p_customer_id in number default hr_api.g_number
2310: ,p_supplier_id in number default hr_api.g_number
2311: ) IS
2312:

Line 2309: ,p_customer_id in number default hr_api.g_number

2305: ,p_known_as in varchar2 default hr_api.g_varchar2
2306: ,p_language in varchar2 default hr_api.g_varchar2
2307: ,p_host_port in varchar2 default hr_api.g_varchar2
2308: ,p_employee_id in number default hr_api.g_number
2309: ,p_customer_id in number default hr_api.g_number
2310: ,p_supplier_id in number default hr_api.g_number
2311: ) IS
2312:
2313: --

Line 2310: ,p_supplier_id in number default hr_api.g_number

2306: ,p_language in varchar2 default hr_api.g_varchar2
2307: ,p_host_port in varchar2 default hr_api.g_varchar2
2308: ,p_employee_id in number default hr_api.g_number
2309: ,p_customer_id in number default hr_api.g_number
2310: ,p_supplier_id in number default hr_api.g_number
2311: ) IS
2312:
2313: --
2314: CURSOR lc_get_user_data

Line 2352: -- Validate input parameters first, need to convert hr_api default

2348:
2349: BEGIN
2350: hr_utility.set_location('Entering:'|| l_proc, 10);
2351: --
2352: -- Validate input parameters first, need to convert hr_api default
2353: -- value to fnd's api default value.
2354: IF p_old_password = hr_api.g_varchar2
2355: THEN
2356: l_old_password := null ; -- Fix 2951145

Line 2354: IF p_old_password = hr_api.g_varchar2

2350: hr_utility.set_location('Entering:'|| l_proc, 10);
2351: --
2352: -- Validate input parameters first, need to convert hr_api default
2353: -- value to fnd's api default value.
2354: IF p_old_password = hr_api.g_varchar2
2355: THEN
2356: l_old_password := null ; -- Fix 2951145
2357: ELSE
2358: l_old_password := p_old_password;

Line 2377: IF p_end_date = hr_api.g_date

2373: CLOSE lc_get_user_data;
2374: END IF;
2375: --
2376: -- Validate p_user_end_date. If entered, it must be larger than start_date
2377: IF p_end_date = hr_api.g_date
2378: THEN
2379: l_end_date := null ; -- Fix 2951145
2380: ELSE
2381: IF nvl(p_end_date, hr_api.g_eot) >= l_user_data.start_date

Line 2381: IF nvl(p_end_date, hr_api.g_eot) >= l_user_data.start_date

2377: IF p_end_date = hr_api.g_date
2378: THEN
2379: l_end_date := null ; -- Fix 2951145
2380: ELSE
2381: IF nvl(p_end_date, hr_api.g_eot) >= l_user_data.start_date
2382: THEN
2383: l_end_date := p_end_date;
2384: ELSE
2385: hr_utility.set_message(800, 'HR_51070_CAU_START_END');

Line 2391: IF p_host_port = hr_api.g_varchar2

2387: END IF;
2388: END IF;
2389: --
2390: -- Validate host_port
2391: IF p_host_port = hr_api.g_varchar2
2392: THEN
2393: l_host_port := null ; -- Fix 2951145
2394: ELSE
2395: l_host_port := p_host_port;

Line 2399: IF p_email_address = hr_api.g_varchar2

2395: l_host_port := p_host_port;
2396: END IF;
2397: --
2398: -- Validate email address length
2399: IF p_email_address = hr_api.g_varchar2
2400: THEN
2401: l_email_address := null ; -- Fix 2951145
2402: ELSE
2403: IF length(p_email_address) > g_max_email_address_length

Line 2413: IF p_fax = hr_api.g_varchar2

2409: END IF;
2410: END IF;
2411: --
2412: -- Validate fax length
2413: IF p_fax = hr_api.g_varchar2
2414: THEN
2415: l_fax := null ; -- Fix 2951145
2416: ELSE
2417: IF length(p_fax) > g_max_fax_length

Line 2426: IF p_language = hr_api.g_varchar2

2422: l_fax := p_fax;
2423: END IF;
2424: END IF;
2425: --
2426: IF p_language = hr_api.g_varchar2
2427: THEN
2428: l_language := null ; -- Fix 2951145
2429: ELSE
2430: l_language := p_language;

Line 2433: IF p_employee_id = hr_api.g_number

2429: ELSE
2430: l_language := p_language;
2431: END IF;
2432: --
2433: IF p_employee_id = hr_api.g_number
2434: THEN
2435: l_employee_id := null ; -- Fix 2951145
2436: ELSE
2437: -- Check for employee id if it exists

Line 2464: IF p_new_password = hr_api.g_varchar2

2460: l_count := to_number(
2461: nvl(fnd_profile.value('SIGNON_PASSWORD_LENGTH'), '5')
2462: );
2463:
2464: IF p_new_password = hr_api.g_varchar2
2465: THEN
2466: l_new_password := null ; -- Fix 2951145
2467: ELSIF (length(p_new_password) < l_count)
2468: THEN

Line 2543: ,p_start_date in date default hr_api.g_date

2539: (p_user_id in number
2540: ,p_responsibility_id in number
2541: ,p_resp_application_id in number
2542: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type
2543: ,p_start_date in date default hr_api.g_date
2544: ,p_end_date in date default hr_api.g_date
2545: ,p_description in varchar2 default hr_api.g_varchar2
2546: ) IS
2547: --

Line 2544: ,p_end_date in date default hr_api.g_date

2540: ,p_responsibility_id in number
2541: ,p_resp_application_id in number
2542: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type
2543: ,p_start_date in date default hr_api.g_date
2544: ,p_end_date in date default hr_api.g_date
2545: ,p_description in varchar2 default hr_api.g_varchar2
2546: ) IS
2547: --
2548: CURSOR lc_get_user_id IS

Line 2545: ,p_description in varchar2 default hr_api.g_varchar2

2541: ,p_resp_application_id in number
2542: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type
2543: ,p_start_date in date default hr_api.g_date
2544: ,p_end_date in date default hr_api.g_date
2545: ,p_description in varchar2 default hr_api.g_varchar2
2546: ) IS
2547: --
2548: CURSOR lc_get_user_id IS
2549: SELECT user_id

Line 2740: -- Convert hr_api default values to null values

2736: FETCH lc_user_resp_row into l_fnd_user_resp_data;
2737: CLOSE lc_user_resp_row;
2738: END IF;
2739:
2740: -- Convert hr_api default values to null values
2741: IF p_start_date = hr_api.g_date
2742: THEN
2743: l_start_date := l_fnd_user_resp_data.start_date;
2744: ELSE

Line 2741: IF p_start_date = hr_api.g_date

2737: CLOSE lc_user_resp_row;
2738: END IF;
2739:
2740: -- Convert hr_api default values to null values
2741: IF p_start_date = hr_api.g_date
2742: THEN
2743: l_start_date := l_fnd_user_resp_data.start_date;
2744: ELSE
2745: l_start_date := p_start_date;

Line 2749: IF p_end_date = hr_api.g_date

2745: l_start_date := p_start_date;
2746: END IF;
2747:
2748: -- Validate End Date must be >= Start Date
2749: IF p_end_date = hr_api.g_date
2750: THEN
2751: l_end_date := l_fnd_user_resp_data.end_date;
2752: ELSIF p_end_date IS NULL
2753: THEN

Line 2769: IF p_description = hr_api.g_varchar2

2765: hr_utility.raise_error;
2766: END IF;
2767: END IF;
2768: --
2769: IF p_description = hr_api.g_varchar2
2770: THEN
2771: l_description := l_fnd_user_resp_data.description;
2772: ELSE
2773: l_description := p_description;