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 212: IF p_run_type = hr_user_acct_utility.g_cr_user_new_hires OR

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

Line 213: p_run_type = hr_user_acct_utility.g_cr_user_all_emp

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

Line 216: ELSIF p_run_type = hr_user_acct_utility.g_inactivate_user

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

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

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

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

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

Line 311: upper(p_run_type) = hr_user_acct_utility.g_cr_user_all_emp

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

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

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

Line 329: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user

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

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

393: l_sql_clause := l_sql_clause || l_org_matching;
394: l_sql_clause := l_sql_clause || l_new_hires_matching;
395: END IF;
396: --
397: IF upper(p_run_type) = hr_user_acct_utility.g_cr_user_all_emp
398: THEN
399: -- For all employees, we want to select ppf.effective_start_date <=
400: -- p_date_to and ppf.effective_end_date >= p_date_to. This conforms to
401: -- the selection logic in person search for "all employees"

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

471: l_sql_clause := l_sql_clause || l_org_matching;
472: l_sql_clause := l_sql_clause || l_all_ee_matching;
473: END IF;
474: --
475: IF upper(p_run_type) = hr_user_acct_utility.g_inactivate_user OR
476: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user
477: -- For terminated ee, we want to select ppos.actual_termination_date 1 day
478: -- before the per_all_people_f.effective_start_date where
479: -- ppf.effective_start_date >= p_date_from and ppf.effective_end_date >=

Line 476: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user

472: l_sql_clause := l_sql_clause || l_all_ee_matching;
473: END IF;
474: --
475: IF upper(p_run_type) = hr_user_acct_utility.g_inactivate_user OR
476: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user
477: -- For terminated ee, we want to select ppos.actual_termination_date 1 day
478: -- before the per_all_people_f.effective_start_date where
479: -- ppf.effective_start_date >= p_date_from and ppf.effective_end_date >=
480: -- p_date_to and ppf.person_type_id in system_person_type of 'EX_EMP' or

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

666: -- 8. Close dynamic cursor
667: --
668: l_dynamic_cursor_id := dbms_sql.open_cursor; -- Step 1
669:
670: IF upper(p_run_type) = hr_user_acct_utility.g_cr_user_new_hires OR
671: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR
672: upper(p_run_type) = hr_user_acct_utility.g_cr_user_all_emp
673: THEN
674: BEGIN

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

667: --
668: l_dynamic_cursor_id := dbms_sql.open_cursor; -- Step 1
669:
670: IF upper(p_run_type) = hr_user_acct_utility.g_cr_user_new_hires OR
671: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR
672: upper(p_run_type) = hr_user_acct_utility.g_cr_user_all_emp
673: THEN
674: BEGIN
675: hr_utility.set_location('In executing create user dynamic sql..', 35);

Line 672: upper(p_run_type) = hr_user_acct_utility.g_cr_user_all_emp

668: l_dynamic_cursor_id := dbms_sql.open_cursor; -- Step 1
669:
670: IF upper(p_run_type) = hr_user_acct_utility.g_cr_user_new_hires OR
671: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR
672: upper(p_run_type) = hr_user_acct_utility.g_cr_user_all_emp
673: THEN
674: BEGIN
675: hr_utility.set_location('In executing create user dynamic sql..', 35);
676:

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

850:
851: END LOOP;
852: END IF;
853:
854: IF upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR
855: upper(p_run_type) = hr_user_acct_utility.g_inactivate_user
856: THEN
857: l_dynamic_cursor_id := 0;
858: l_dynamic_cursor_id := dbms_sql.open_cursor; -- Step 1

Line 855: upper(p_run_type) = hr_user_acct_utility.g_inactivate_user

851: END LOOP;
852: END IF;
853:
854: IF upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR
855: upper(p_run_type) = hr_user_acct_utility.g_inactivate_user
856: THEN
857: l_dynamic_cursor_id := 0;
858: l_dynamic_cursor_id := dbms_sql.open_cursor; -- Step 1
859:

Line 989: IF p_run_type = hr_user_acct_utility.g_cr_user_new_hires OR

985: END LOOP;
986: END IF;
987: --
988:
989: IF p_run_type = hr_user_acct_utility.g_cr_user_new_hires OR
990: p_run_type = hr_user_acct_utility.g_cr_user_all_emp
991: THEN
992: fnd_message.set_name('PER', 'HR_CREATE_USER_ACCT_COUNT');
993: l_msg := fnd_message.get || to_char(l_new_user_count);

Line 990: p_run_type = hr_user_acct_utility.g_cr_user_all_emp

986: END IF;
987: --
988:
989: IF p_run_type = hr_user_acct_utility.g_cr_user_new_hires OR
990: p_run_type = hr_user_acct_utility.g_cr_user_all_emp
991: THEN
992: fnd_message.set_name('PER', 'HR_CREATE_USER_ACCT_COUNT');
993: l_msg := fnd_message.get || to_char(l_new_user_count);
994: fnd_file.put_line(FND_FILE.LOG, l_msg);

Line 995: ELSIF p_run_type = hr_user_acct_utility.g_inactivate_user

991: THEN
992: fnd_message.set_name('PER', 'HR_CREATE_USER_ACCT_COUNT');
993: l_msg := fnd_message.get || to_char(l_new_user_count);
994: fnd_file.put_line(FND_FILE.LOG, l_msg);
995: ELSIF p_run_type = hr_user_acct_utility.g_inactivate_user
996: THEN
997: fnd_message.set_name('PER','HR_INACTIVATE_USER_ACCT_COUNT');
998: l_msg := fnd_message.get || to_char(l_inactivate_user_count);
999: fnd_file.put_line(FND_FILE.LOG, l_msg);

Line 1000: ELSIF p_run_type = hr_user_acct_utility.g_cr_n_inact_user

996: THEN
997: fnd_message.set_name('PER','HR_INACTIVATE_USER_ACCT_COUNT');
998: l_msg := fnd_message.get || to_char(l_inactivate_user_count);
999: fnd_file.put_line(FND_FILE.LOG, l_msg);
1000: ELSIF p_run_type = hr_user_acct_utility.g_cr_n_inact_user
1001: THEN
1002: -- Now print the create user account count
1003: fnd_message.set_name('PER', 'HR_CREATE_USER_ACCT_COUNT');
1004: l_msg := fnd_message.get || to_char(l_new_user_count);