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_EMP_EXTRACT dependencies on HR_USER_ACCT_UTILITY

Line 213: IF p_run_type = hr_user_acct_utility.g_cr_user_new_hires OR

209: -- contains a value, l_data_pump_pkg_name1 will be null.
210: -- When p_run_type is gv_cr_n_inact_user, then both l_data_pump_pkg_name1
211: -- and l_data_pump_pkg_name2 contain a value.
212: -----------------------------------------------------------------------------
213: IF p_run_type = hr_user_acct_utility.g_cr_user_new_hires OR
214: p_run_type = hr_user_acct_utility.g_cr_user_all_emp
215: THEN
216: l_data_pump_pkg_name1 := g_data_pump_create_user;
217: ELSIF p_run_type = hr_user_acct_utility.g_inactivate_user

Line 214: p_run_type = hr_user_acct_utility.g_cr_user_all_emp

210: -- When p_run_type is gv_cr_n_inact_user, then both l_data_pump_pkg_name1
211: -- and l_data_pump_pkg_name2 contain a value.
212: -----------------------------------------------------------------------------
213: IF p_run_type = hr_user_acct_utility.g_cr_user_new_hires OR
214: p_run_type = hr_user_acct_utility.g_cr_user_all_emp
215: THEN
216: l_data_pump_pkg_name1 := g_data_pump_create_user;
217: ELSIF p_run_type = hr_user_acct_utility.g_inactivate_user
218: THEN

Line 217: ELSIF p_run_type = hr_user_acct_utility.g_inactivate_user

213: IF p_run_type = hr_user_acct_utility.g_cr_user_new_hires OR
214: p_run_type = hr_user_acct_utility.g_cr_user_all_emp
215: THEN
216: l_data_pump_pkg_name1 := g_data_pump_create_user;
217: ELSIF p_run_type = hr_user_acct_utility.g_inactivate_user
218: THEN
219: l_data_pump_pkg_name2 := g_data_pump_upd_user;
220: ELSE -- create and inactivate user accounts
221: l_data_pump_pkg_name1 := g_data_pump_create_user;

Line 310: IF upper(p_run_type) = hr_user_acct_utility.g_cr_user_new_hires OR

306: END IF;
307: --
308: --
309: -- Build a list for ACTIVE assignment status type id.
310: IF upper(p_run_type) = hr_user_acct_utility.g_cr_user_new_hires OR
311: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR
312: upper(p_run_type) = hr_user_acct_utility.g_cr_user_all_emp
313: THEN
314: FOR get_asg_status_type_id in lc_get_asg_status_type_id

Line 311: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR

307: --
308: --
309: -- Build a list for ACTIVE assignment status type id.
310: IF upper(p_run_type) = hr_user_acct_utility.g_cr_user_new_hires OR
311: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR
312: upper(p_run_type) = hr_user_acct_utility.g_cr_user_all_emp
313: THEN
314: FOR get_asg_status_type_id in lc_get_asg_status_type_id
315: (p_per_sys_status => 'ACTIVE_ASSIGN')

Line 312: upper(p_run_type) = hr_user_acct_utility.g_cr_user_all_emp

308: --
309: -- Build a list for ACTIVE assignment status type id.
310: IF upper(p_run_type) = hr_user_acct_utility.g_cr_user_new_hires OR
311: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR
312: upper(p_run_type) = hr_user_acct_utility.g_cr_user_all_emp
313: THEN
314: FOR get_asg_status_type_id in lc_get_asg_status_type_id
315: (p_per_sys_status => 'ACTIVE_ASSIGN')
316: LOOP

Line 329: IF upper(p_run_type) = hr_user_acct_utility.g_cr_user_new_hires OR

325: END IF;
326: --
327: --
328:
329: IF upper(p_run_type) = hr_user_acct_utility.g_cr_user_new_hires OR
330: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user
331: THEN
332: l_asg_status_type_clause := ' AND paf.assignment_status_type_id in ( ' ||
333: l_asg_status_type_id_list || ')';

Line 330: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user

326: --
327: --
328:
329: IF upper(p_run_type) = hr_user_acct_utility.g_cr_user_new_hires OR
330: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user
331: THEN
332: l_asg_status_type_clause := ' AND paf.assignment_status_type_id in ( ' ||
333: l_asg_status_type_id_list || ')';
334: --

Line 405: IF upper(p_run_type) = hr_user_acct_utility.g_cr_user_all_emp

401: l_sql_clause := l_sql_clause ||l_order_by_clause;
402:
403: END IF;
404: --
405: IF upper(p_run_type) = hr_user_acct_utility.g_cr_user_all_emp
406: THEN
407: -- For all employees, we want to select ppf.effective_start_date <=
408: -- p_date_to and ppf.effective_end_date >= p_date_to. This conforms to
409: -- the selection logic in person search for "all employees"

Line 483: IF upper(p_run_type) = hr_user_acct_utility.g_inactivate_user OR

479: l_sql_clause := l_sql_clause || l_org_matching;
480: l_sql_clause := l_sql_clause || l_all_ee_matching;
481: END IF;
482: --
483: IF upper(p_run_type) = hr_user_acct_utility.g_inactivate_user OR
484: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user
485: -- For terminated ee, we want to select ppos.actual_termination_date 1 day
486: -- before the per_all_people_f.effective_start_date where
487: -- ppf.effective_start_date >= p_date_from and ppf.effective_end_date >=

Line 484: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user

480: l_sql_clause := l_sql_clause || l_all_ee_matching;
481: END IF;
482: --
483: IF upper(p_run_type) = hr_user_acct_utility.g_inactivate_user OR
484: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user
485: -- For terminated ee, we want to select ppos.actual_termination_date 1 day
486: -- before the per_all_people_f.effective_start_date where
487: -- ppf.effective_start_date >= p_date_from and ppf.effective_end_date >=
488: -- p_date_to and ppf.person_type_id in system_person_type of 'EX_EMP' or

Line 678: IF upper(p_run_type) = hr_user_acct_utility.g_cr_user_new_hires OR

674: -- 8. Close dynamic cursor
675: --
676: l_dynamic_cursor_id := dbms_sql.open_cursor; -- Step 1
677:
678: IF upper(p_run_type) = hr_user_acct_utility.g_cr_user_new_hires OR
679: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR
680: upper(p_run_type) = hr_user_acct_utility.g_cr_user_all_emp
681: THEN
682: BEGIN

Line 679: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR

675: --
676: l_dynamic_cursor_id := dbms_sql.open_cursor; -- Step 1
677:
678: IF upper(p_run_type) = hr_user_acct_utility.g_cr_user_new_hires OR
679: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR
680: upper(p_run_type) = hr_user_acct_utility.g_cr_user_all_emp
681: THEN
682: BEGIN
683: hr_utility.set_location('In executing create user dynamic sql..', 35);

Line 680: upper(p_run_type) = hr_user_acct_utility.g_cr_user_all_emp

676: l_dynamic_cursor_id := dbms_sql.open_cursor; -- Step 1
677:
678: IF upper(p_run_type) = hr_user_acct_utility.g_cr_user_new_hires OR
679: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR
680: upper(p_run_type) = hr_user_acct_utility.g_cr_user_all_emp
681: THEN
682: BEGIN
683: hr_utility.set_location('In executing create user dynamic sql..', 35);
684:

Line 862: IF upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR

858:
859: END LOOP;
860: END IF;
861:
862: IF upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR
863: upper(p_run_type) = hr_user_acct_utility.g_inactivate_user
864: THEN
865: l_dynamic_cursor_id := 0;
866: l_dynamic_cursor_id := dbms_sql.open_cursor; -- Step 1

Line 863: upper(p_run_type) = hr_user_acct_utility.g_inactivate_user

859: END LOOP;
860: END IF;
861:
862: IF upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR
863: upper(p_run_type) = hr_user_acct_utility.g_inactivate_user
864: THEN
865: l_dynamic_cursor_id := 0;
866: l_dynamic_cursor_id := dbms_sql.open_cursor; -- Step 1
867:

Line 997: IF p_run_type = hr_user_acct_utility.g_cr_user_new_hires OR

993: END LOOP;
994: END IF;
995: --
996:
997: IF p_run_type = hr_user_acct_utility.g_cr_user_new_hires OR
998: p_run_type = hr_user_acct_utility.g_cr_user_all_emp
999: THEN
1000: fnd_message.set_name('PER', 'HR_CREATE_USER_ACCT_COUNT');
1001: l_msg := fnd_message.get || to_char(l_new_user_count);

Line 998: p_run_type = hr_user_acct_utility.g_cr_user_all_emp

994: END IF;
995: --
996:
997: IF p_run_type = hr_user_acct_utility.g_cr_user_new_hires OR
998: p_run_type = hr_user_acct_utility.g_cr_user_all_emp
999: THEN
1000: fnd_message.set_name('PER', 'HR_CREATE_USER_ACCT_COUNT');
1001: l_msg := fnd_message.get || to_char(l_new_user_count);
1002: fnd_file.put_line(FND_FILE.LOG, l_msg);

Line 1003: ELSIF p_run_type = hr_user_acct_utility.g_inactivate_user

999: THEN
1000: fnd_message.set_name('PER', 'HR_CREATE_USER_ACCT_COUNT');
1001: l_msg := fnd_message.get || to_char(l_new_user_count);
1002: fnd_file.put_line(FND_FILE.LOG, l_msg);
1003: ELSIF p_run_type = hr_user_acct_utility.g_inactivate_user
1004: THEN
1005: fnd_message.set_name('PER','HR_INACTIVATE_USER_ACCT_COUNT');
1006: l_msg := fnd_message.get || to_char(l_inactivate_user_count);
1007: fnd_file.put_line(FND_FILE.LOG, l_msg);

Line 1008: ELSIF p_run_type = hr_user_acct_utility.g_cr_n_inact_user

1004: THEN
1005: fnd_message.set_name('PER','HR_INACTIVATE_USER_ACCT_COUNT');
1006: l_msg := fnd_message.get || to_char(l_inactivate_user_count);
1007: fnd_file.put_line(FND_FILE.LOG, l_msg);
1008: ELSIF p_run_type = hr_user_acct_utility.g_cr_n_inact_user
1009: THEN
1010: -- Now print the create user account count
1011: fnd_message.set_name('PER', 'HR_CREATE_USER_ACCT_COUNT');
1012: l_msg := fnd_message.get || to_char(l_new_user_count);