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.PQP_HROSS_INTEGRATION dependencies on PER_ALL_ASSIGNMENTS_F

Line 12: l_asg_rec per_all_assignments_f%ROWTYPE;

8: g_leg_code Varchar2(5);
9: g_emp_num_gen Varchar2(5);
10: g_debug_on Boolean;
11: l_per_rec per_all_people_f%ROWTYPE;
12: l_asg_rec per_all_assignments_f%ROWTYPE;
13: l_add_rec per_addresses%ROWTYPE;
14: l_cntct_rec per_contact_relationships%ROWTYPE;
15: l_phones_rec per_phones%ROWTYPE;
16: l_hr_soft_rec hr_soft_coding_keyflex%ROWTYPE;

Line 21: ,assignment_id per_all_assignments_f.assignment_id%TYPE

17: l_ppl_grp_rec pay_people_groups%ROWTYPE;
18:
19: TYPE t_hrEmpApi IS RECORD
20: (person_id per_all_people_f.person_id%TYPE
21: ,assignment_id per_all_assignments_f.assignment_id%TYPE
22: ,per_object_version_number per_all_people_f.object_version_number%TYPE
23: ,asg_object_version_number per_all_assignments_f.object_version_number%TYPE
24: ,per_effective_start_date Date
25: ,per_effective_end_date Date

Line 23: ,asg_object_version_number per_all_assignments_f.object_version_number%TYPE

19: TYPE t_hrEmpApi IS RECORD
20: (person_id per_all_people_f.person_id%TYPE
21: ,assignment_id per_all_assignments_f.assignment_id%TYPE
22: ,per_object_version_number per_all_people_f.object_version_number%TYPE
23: ,asg_object_version_number per_all_assignments_f.object_version_number%TYPE
24: ,per_effective_start_date Date
25: ,per_effective_end_date Date
26: ,full_name per_all_people_f.full_name%TYPE
27: ,per_comment_id per_all_people_f.comment_id%TYPE

Line 28: ,assignment_sequence per_all_assignments_f.assignment_sequence%TYPE

24: ,per_effective_start_date Date
25: ,per_effective_end_date Date
26: ,full_name per_all_people_f.full_name%TYPE
27: ,per_comment_id per_all_people_f.comment_id%TYPE
28: ,assignment_sequence per_all_assignments_f.assignment_sequence%TYPE
29: ,assignment_number per_all_assignments_f.assignment_number%TYPE
30: ,name_combination_warning Boolean
31: ,assign_payroll_warning Boolean
32: ,orig_hire_warning Boolean

Line 29: ,assignment_number per_all_assignments_f.assignment_number%TYPE

25: ,per_effective_end_date Date
26: ,full_name per_all_people_f.full_name%TYPE
27: ,per_comment_id per_all_people_f.comment_id%TYPE
28: ,assignment_sequence per_all_assignments_f.assignment_sequence%TYPE
29: ,assignment_number per_all_assignments_f.assignment_number%TYPE
30: ,name_combination_warning Boolean
31: ,assign_payroll_warning Boolean
32: ,orig_hire_warning Boolean
33: );

Line 36: (asg_object_version_number per_all_assignments_f.object_version_number%TYPE

32: ,orig_hire_warning Boolean
33: );
34:
35: TYPE t_AsgUpdCrit_Api IS RECORD
36: (asg_object_version_number per_all_assignments_f.object_version_number%TYPE
37: ,special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE
38: ,people_group_id per_all_assignments_f.people_group_id%TYPE
39: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
40: ,group_name pay_people_groups.group_name%TYPE

Line 37: ,special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE

33: );
34:
35: TYPE t_AsgUpdCrit_Api IS RECORD
36: (asg_object_version_number per_all_assignments_f.object_version_number%TYPE
37: ,special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE
38: ,people_group_id per_all_assignments_f.people_group_id%TYPE
39: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
40: ,group_name pay_people_groups.group_name%TYPE
41: ,asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE

Line 38: ,people_group_id per_all_assignments_f.people_group_id%TYPE

34:
35: TYPE t_AsgUpdCrit_Api IS RECORD
36: (asg_object_version_number per_all_assignments_f.object_version_number%TYPE
37: ,special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE
38: ,people_group_id per_all_assignments_f.people_group_id%TYPE
39: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
40: ,group_name pay_people_groups.group_name%TYPE
41: ,asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
42: ,asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE

Line 39: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

35: TYPE t_AsgUpdCrit_Api IS RECORD
36: (asg_object_version_number per_all_assignments_f.object_version_number%TYPE
37: ,special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE
38: ,people_group_id per_all_assignments_f.people_group_id%TYPE
39: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
40: ,group_name pay_people_groups.group_name%TYPE
41: ,asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
42: ,asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
43: ,org_now_no_manager_warning Boolean

Line 41: ,asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE

37: ,special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE
38: ,people_group_id per_all_assignments_f.people_group_id%TYPE
39: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
40: ,group_name pay_people_groups.group_name%TYPE
41: ,asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
42: ,asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
43: ,org_now_no_manager_warning Boolean
44: ,other_manager_warning Boolean
45: ,spp_delete_warning Boolean

Line 42: ,asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE

38: ,people_group_id per_all_assignments_f.people_group_id%TYPE
39: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
40: ,group_name pay_people_groups.group_name%TYPE
41: ,asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
42: ,asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
43: ,org_now_no_manager_warning Boolean
44: ,other_manager_warning Boolean
45: ,spp_delete_warning Boolean
46: ,entries_changed_warning Varchar2(50)

Line 54: (cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE

50: ,comment_id per_assignments_f.comment_id%TYPE
51: );
52:
53: TYPE t_Upd_Emp_Asg_Api IS RECORD
54: (cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE
55: ,cagr_concatenated_segments Varchar2(2000)
56: ,concatenated_segments Varchar2(2000)
57: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
58: ,comment_id per_all_assignments_f.comment_id%TYPE

Line 57: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE

53: TYPE t_Upd_Emp_Asg_Api IS RECORD
54: (cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE
55: ,cagr_concatenated_segments Varchar2(2000)
56: ,concatenated_segments Varchar2(2000)
57: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
58: ,comment_id per_all_assignments_f.comment_id%TYPE
59: ,effective_start_date per_all_assignments_f.effective_start_date%TYPE
60: ,effective_end_date per_all_assignments_f.effective_end_date%TYPE
61: ,no_managers_warning Boolean

Line 58: ,comment_id per_all_assignments_f.comment_id%TYPE

54: (cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE
55: ,cagr_concatenated_segments Varchar2(2000)
56: ,concatenated_segments Varchar2(2000)
57: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
58: ,comment_id per_all_assignments_f.comment_id%TYPE
59: ,effective_start_date per_all_assignments_f.effective_start_date%TYPE
60: ,effective_end_date per_all_assignments_f.effective_end_date%TYPE
61: ,no_managers_warning Boolean
62: ,other_manager_warning Boolean

Line 59: ,effective_start_date per_all_assignments_f.effective_start_date%TYPE

55: ,cagr_concatenated_segments Varchar2(2000)
56: ,concatenated_segments Varchar2(2000)
57: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
58: ,comment_id per_all_assignments_f.comment_id%TYPE
59: ,effective_start_date per_all_assignments_f.effective_start_date%TYPE
60: ,effective_end_date per_all_assignments_f.effective_end_date%TYPE
61: ,no_managers_warning Boolean
62: ,other_manager_warning Boolean
63: ,hourly_salaried_warning Boolean

Line 60: ,effective_end_date per_all_assignments_f.effective_end_date%TYPE

56: ,concatenated_segments Varchar2(2000)
57: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
58: ,comment_id per_all_assignments_f.comment_id%TYPE
59: ,effective_start_date per_all_assignments_f.effective_start_date%TYPE
60: ,effective_end_date per_all_assignments_f.effective_end_date%TYPE
61: ,no_managers_warning Boolean
62: ,other_manager_warning Boolean
63: ,hourly_salaried_warning Boolean
64: ,gsp_post_process_warning Varchar2(2000)

Line 68: (assignment_id per_all_assignments_f.assignment_id%TYPE

64: ,gsp_post_process_warning Varchar2(2000)
65: );
66:
67: TYPE t_RehireEmp_Api IS RECORD
68: (assignment_id per_all_assignments_f.assignment_id%TYPE
69: ,asg_object_version_number per_all_assignments_f.object_version_number%TYPE
70: ,per_effective_start_date per_all_people_f.effective_start_date%TYPE
71: ,per_effective_end_date per_all_people_f.effective_end_date%TYPE
72: ,assignment_sequence per_all_assignments_f.assignment_sequence%TYPE

Line 69: ,asg_object_version_number per_all_assignments_f.object_version_number%TYPE

65: );
66:
67: TYPE t_RehireEmp_Api IS RECORD
68: (assignment_id per_all_assignments_f.assignment_id%TYPE
69: ,asg_object_version_number per_all_assignments_f.object_version_number%TYPE
70: ,per_effective_start_date per_all_people_f.effective_start_date%TYPE
71: ,per_effective_end_date per_all_people_f.effective_end_date%TYPE
72: ,assignment_sequence per_all_assignments_f.assignment_sequence%TYPE
73: ,assignment_number per_all_assignments_f.assignment_number%TYPE

Line 72: ,assignment_sequence per_all_assignments_f.assignment_sequence%TYPE

68: (assignment_id per_all_assignments_f.assignment_id%TYPE
69: ,asg_object_version_number per_all_assignments_f.object_version_number%TYPE
70: ,per_effective_start_date per_all_people_f.effective_start_date%TYPE
71: ,per_effective_end_date per_all_people_f.effective_end_date%TYPE
72: ,assignment_sequence per_all_assignments_f.assignment_sequence%TYPE
73: ,assignment_number per_all_assignments_f.assignment_number%TYPE
74: ,assign_payroll_warning Boolean
75: );
76:

Line 73: ,assignment_number per_all_assignments_f.assignment_number%TYPE

69: ,asg_object_version_number per_all_assignments_f.object_version_number%TYPE
70: ,per_effective_start_date per_all_people_f.effective_start_date%TYPE
71: ,per_effective_end_date per_all_people_f.effective_end_date%TYPE
72: ,assignment_sequence per_all_assignments_f.assignment_sequence%TYPE
73: ,assignment_number per_all_assignments_f.assignment_number%TYPE
74: ,assign_payroll_warning Boolean
75: );
76:
77: TYPE t_UpdEmp_Api IS RECORD

Line 90: ,assignment_id per_all_assignments_f.assignment_id%TYPE

86:
87: TYPE t_HrToJob_Api IS RECORD
88: (effective_start_date per_all_people_f.effective_start_date%TYPE
89: ,effective_end_date per_all_people_f.effective_end_date%TYPE
90: ,assignment_id per_all_assignments_f.assignment_id%TYPE
91: ,assign_payroll_warning Boolean
92: ,orig_hire_warning Boolean
93: );
94:

Line 588: FROM per_all_assignments_f paf

584: CURSOR csr_asg (c_effective_date IN Date
585: ,c_assignment_id IN Number
586: ,c_business_group_id IN Number)IS
587: SELECT *
588: FROM per_all_assignments_f paf
589: WHERE paf.assignment_id = c_assignment_id
590: AND paf.business_group_id = c_business_group_id
591: AND c_effective_date BETWEEN paf.effective_start_date
592: AND paf.effective_end_date;

Line 658: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'

654: l_asg_rec.soft_coding_keyflex_id, 40);
655:
656: Dt_Api.Find_DT_Upd_Modes
657: (p_effective_date => p_effective_date
658: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
659: ,p_base_key_column => 'ASSIGNMENT_ID'
660: ,p_base_key_value => l_asg_rec.assignment_id
661: ,p_correction => l_dt_correction
662: ,p_update => l_dt_update

Line 1094: FROM per_all_assignments_f paf

1090: SELECT paf.assignment_id
1091: ,ppf.person_id
1092: ,ppf.object_version_number per_ovn
1093: ,paf.object_version_number asg_ovn
1094: FROM per_all_assignments_f paf
1095: ,per_all_people_f ppf
1096: WHERE paf.person_id = c_person_id
1097: AND paf.business_group_id = c_business_group_id
1098: AND paf.assignment_type = c_asg_type

Line 1178: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'

1174: -- as accepted as of the hire date.
1175: hr_utility.set_location(' Asg Id NOT Accepted : ' || p_assignment_id, 40);
1176: Dt_Api.Find_DT_Upd_Modes
1177: (p_effective_date => p_hire_date
1178: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
1179: ,p_base_key_column => 'ASSIGNMENT_ID'
1180: ,p_base_key_value => p_assignment_id
1181: ,p_correction => l_dt_correction
1182: ,p_update => l_dt_update

Line 1610: FROM per_all_assignments_f paf

1606: ,c_business_group_id IN Number
1607: ,c_effective_date IN Date) IS
1608: SELECT paf.assignment_id,
1609: ppf.object_version_number
1610: FROM per_all_assignments_f paf
1611: ,per_all_people_f ppf
1612: WHERE paf.person_id = c_person_id
1613: AND paf.business_group_id = c_business_group_id
1614: AND paf.person_id = ppf.person_id

Line 2238: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

2234: ,p_per_comments Varchar2 DEFAULT NULL
2235: ,p_emp_api_out OUT NOCOPY t_hrEmpApi)AS
2236:
2237: l_person_id per_all_people_f.person_id%TYPE;
2238: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2239: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
2240: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
2241: l_per_effective_start_date Date;
2242: l_per_effective_end_date Date;

Line 2240: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

2236:
2237: l_person_id per_all_people_f.person_id%TYPE;
2238: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2239: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
2240: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
2241: l_per_effective_start_date Date;
2242: l_per_effective_end_date Date;
2243: l_full_name per_all_people_f.full_name%TYPE;
2244: l_per_comment_id per_all_people_f.comment_id%TYPE;

Line 2245: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

2241: l_per_effective_start_date Date;
2242: l_per_effective_end_date Date;
2243: l_full_name per_all_people_f.full_name%TYPE;
2244: l_per_comment_id per_all_people_f.comment_id%TYPE;
2245: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
2246: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
2247: l_name_combination_warning Boolean;
2248: l_assign_payroll_warning Boolean;
2249: l_orig_hire_warning Boolean;

Line 2246: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

2242: l_per_effective_end_date Date;
2243: l_full_name per_all_people_f.full_name%TYPE;
2244: l_per_comment_id per_all_people_f.comment_id%TYPE;
2245: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
2246: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
2247: l_name_combination_warning Boolean;
2248: l_assign_payroll_warning Boolean;
2249: l_orig_hire_warning Boolean;
2250:

Line 2698: FROM per_all_assignments_f paf

2694: ,c_business_group_id IN Number
2695: ,c_effective_date IN Date) IS
2696: SELECT paf.assignment_id,
2697: ppf.object_version_number
2698: FROM per_all_assignments_f paf
2699: ,per_all_people_f ppf
2700: WHERE paf.person_id = c_person_id
2701: AND paf.business_group_id = c_business_group_id
2702: AND paf.person_id = ppf.person_id

Line 3441: -- ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'

3437: -- l_asg_rec.assignment_id, 6);
3438:
3439: -- Dt_Api.Find_DT_Upd_Modes
3440: -- (p_effective_date => l_per_rec.start_date
3441: -- ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
3442: -- ,p_base_key_column => 'ASSIGNMENT_ID'
3443: -- ,p_base_key_value => l_asg_rec.assignment_id
3444: -- ,p_correction => l_dt_correction
3445: -- ,p_update => l_dt_update