DBA Data[Home] [Help]

APPS.PER_QH_ACTION dependencies on PER_ALL_ASSIGNMENTS_F

Line 26: ,p_assignment_id per_all_assignments_f.assignment_id%type

22: (p_notification wf_messages.name%type
23: ,p_wf_name wf_item_types.name%type
24: ,p_role varchar2 -- wf_roles.name%type Fix for bug 2741492
25: ,p_person_id per_all_people_f.person_id%type
26: ,p_assignment_id per_all_assignments_f.assignment_id%type
27: ,p_effective_date date
28: ,p_hire_date per_periods_of_service.date_start%type
29: ,p_full_name per_all_people_f.full_name%type
30: ,p_per_effective_start_date per_all_people_f.effective_start_date%type

Line 37: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type

33: ,p_last_name per_all_people_f.last_name%type
34: ,p_employee_number per_all_people_f.employee_number%type
35: ,p_applicant_number per_all_people_f.applicant_number%type
36: ,p_national_identifier per_all_people_f.national_identifier%type
37: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type
38: ,p_organization hr_all_organization_units.name%type
39: ,p_grade per_grades.name%type
40: ,p_job per_jobs.name%type
41: ,p_position hr_all_positions_f.name%type

Line 49: ,p_date_probation_end per_all_assignments_f.date_probation_end%type

45: ,p_location hr_locations.location_code%type
46: ,p_salary per_pay_proposals.proposed_salary_n%type
47: ,p_salary_currency pay_element_types_f.input_currency_code%type
48: ,p_pay_basis hr_lookups.meaning%type
49: ,p_date_probation_end per_all_assignments_f.date_probation_end%type
50: ,p_npw_number per_all_people_f.npw_number%type
51: ,p_vendor po_vendors.vendor_name%type
52: ,p_supplier_reference per_all_assignments_f.vendor_employee_number%type
53: ,p_placement_date_start per_all_assignments_f.period_of_placement_date_start%type

Line 52: ,p_supplier_reference per_all_assignments_f.vendor_employee_number%type

48: ,p_pay_basis hr_lookups.meaning%type
49: ,p_date_probation_end per_all_assignments_f.date_probation_end%type
50: ,p_npw_number per_all_people_f.npw_number%type
51: ,p_vendor po_vendors.vendor_name%type
52: ,p_supplier_reference per_all_assignments_f.vendor_employee_number%type
53: ,p_placement_date_start per_all_assignments_f.period_of_placement_date_start%type
54: ,p_grade_ladder ben_pgm_f.name%type
55: );
56: --

Line 53: ,p_placement_date_start per_all_assignments_f.period_of_placement_date_start%type

49: ,p_date_probation_end per_all_assignments_f.date_probation_end%type
50: ,p_npw_number per_all_people_f.npw_number%type
51: ,p_vendor po_vendors.vendor_name%type
52: ,p_supplier_reference per_all_assignments_f.vendor_employee_number%type
53: ,p_placement_date_start per_all_assignments_f.period_of_placement_date_start%type
54: ,p_grade_ladder ben_pgm_f.name%type
55: );
56: --
57: procedure get_notification_preview

Line 62: ,p_assignment_id in per_all_assignments_f.assignment_id%type

58: (p_notification in wf_messages.name%type
59: ,p_wf_name in wf_item_types.name%type
60: ,p_role in varchar2 -- wf_roles.name%type Fix for bug 2741492
61: ,p_person_id in per_all_people_f.person_id%type
62: ,p_assignment_id in per_all_assignments_f.assignment_id%type
63: ,p_effective_date in date
64: ,p_hire_date in per_periods_of_service.date_start%type
65: ,p_full_name in per_all_people_f.full_name%type
66: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type

Line 73: ,p_asg_effective_start_date in per_all_assignments_f.effective_start_date%type

69: ,p_last_name in per_all_people_f.last_name%type
70: ,p_employee_number in per_all_people_f.employee_number%type
71: ,p_applicant_number in per_all_people_f.applicant_number%type
72: ,p_national_identifier in per_all_people_f.national_identifier%type
73: ,p_asg_effective_start_date in per_all_assignments_f.effective_start_date%type
74: ,p_organization in hr_all_organization_units.name%type
75: ,p_grade in per_grades.name%type
76: ,p_job in per_jobs.name%type
77: ,p_position in hr_all_positions_f.name%type

Line 85: ,p_date_probation_end in per_all_assignments_f.date_probation_end%type

81: ,p_location in hr_locations.location_code%type
82: ,p_salary in per_pay_proposals.proposed_salary_n%type
83: ,p_salary_currency in pay_element_types_f.input_currency_code%type
84: ,p_pay_basis in hr_lookups.meaning%type
85: ,p_date_probation_end in per_all_assignments_f.date_probation_end%type
86: ,p_npw_number in per_all_people_f.npw_number%type
87: ,p_vendor in po_vendors.vendor_name%type
88: ,p_supplier_reference in per_all_assignments_f.vendor_employee_number%type
89: ,p_placement_date_start in per_all_assignments_f.period_of_placement_date_start%type

Line 88: ,p_supplier_reference in per_all_assignments_f.vendor_employee_number%type

84: ,p_pay_basis in hr_lookups.meaning%type
85: ,p_date_probation_end in per_all_assignments_f.date_probation_end%type
86: ,p_npw_number in per_all_people_f.npw_number%type
87: ,p_vendor in po_vendors.vendor_name%type
88: ,p_supplier_reference in per_all_assignments_f.vendor_employee_number%type
89: ,p_placement_date_start in per_all_assignments_f.period_of_placement_date_start%type
90: ,p_grade_ladder in ben_pgm_f.name%type
91: ,p_subject out nocopy varchar2
92: ,p_body out nocopy varchar2

Line 89: ,p_placement_date_start in per_all_assignments_f.period_of_placement_date_start%type

85: ,p_date_probation_end in per_all_assignments_f.date_probation_end%type
86: ,p_npw_number in per_all_people_f.npw_number%type
87: ,p_vendor in po_vendors.vendor_name%type
88: ,p_supplier_reference in per_all_assignments_f.vendor_employee_number%type
89: ,p_placement_date_start in per_all_assignments_f.period_of_placement_date_start%type
90: ,p_grade_ladder in ben_pgm_f.name%type
91: ,p_subject out nocopy varchar2
92: ,p_body out nocopy varchar2
93: );