17: -- --
18: ---------------------------------------------------------------------------
19: PROCEDURE validate_applicant
20: ( p_business_group_id
21: in per_all_people_f.business_group_id%type default null
22: , p_date_received
23: in date
24: , p_person_type_id
25: in per_all_people_f.person_type_id%type default null
21: in per_all_people_f.business_group_id%type default null
22: , p_date_received
23: in date
24: , p_person_type_id
25: in per_all_people_f.person_type_id%type default null
26: , p_per_information_category
27: in per_all_people_f.per_information_category%type default null
28: , p_per_information4
29: in per_all_people_f.per_information4%type default null
23: in date
24: , p_person_type_id
25: in per_all_people_f.person_type_id%type default null
26: , p_per_information_category
27: in per_all_people_f.per_information_category%type default null
28: , p_per_information4
29: in per_all_people_f.per_information4%type default null
30: );
31: -------------------------------------------------------------------------------
25: in per_all_people_f.person_type_id%type default null
26: , p_per_information_category
27: in per_all_people_f.per_information_category%type default null
28: , p_per_information4
29: in per_all_people_f.per_information4%type default null
30: );
31: -------------------------------------------------------------------------------
32: -- validate_employee
33: -------------------------------------------------------------------------------
44: -- --
45: ---------------------------------------------------------------------------
46: PROCEDURE validate_employee
47: ( p_business_group_id
48: in per_all_people_f.business_group_id%type default null
49: , p_hire_date
50: in date
51: , p_person_type_id
52: in per_all_people_f.person_type_id%type default null
48: in per_all_people_f.business_group_id%type default null
49: , p_hire_date
50: in date
51: , p_person_type_id
52: in per_all_people_f.person_type_id%type default null
53: , p_per_information_category
54: in per_all_people_f.per_information_category%type default null
55: , p_per_information4
56: in per_all_people_f.per_information4%type default null
50: in date
51: , p_person_type_id
52: in per_all_people_f.person_type_id%type default null
53: , p_per_information_category
54: in per_all_people_f.per_information_category%type default null
55: , p_per_information4
56: in per_all_people_f.per_information4%type default null
57: );
58: -------------------------------------------------------------------------------
52: in per_all_people_f.person_type_id%type default null
53: , p_per_information_category
54: in per_all_people_f.per_information_category%type default null
55: , p_per_information4
56: in per_all_people_f.per_information4%type default null
57: );
58: -------------------------------------------------------------------------------
59: -- validate_cwk
60: -------------------------------------------------------------------------------
71: -- --
72: ---------------------------------------------------------------------------
73: PROCEDURE validate_cwk
74: ( p_business_group_id
75: in per_all_people_f.business_group_id%type default null
76: , p_start_date
77: in date
78: , p_person_type_id
79: in per_all_people_f.person_type_id%type default null
75: in per_all_people_f.business_group_id%type default null
76: , p_start_date
77: in date
78: , p_person_type_id
79: in per_all_people_f.person_type_id%type default null
80: , p_per_information_category
81: in per_all_people_f.per_information_category%type default null
82: , p_per_information4
83: in per_all_people_f.per_information4%type default null
77: in date
78: , p_person_type_id
79: in per_all_people_f.person_type_id%type default null
80: , p_per_information_category
81: in per_all_people_f.per_information_category%type default null
82: , p_per_information4
83: in per_all_people_f.per_information4%type default null
84: );
85: -------------------------------------------------------------------------------
79: in per_all_people_f.person_type_id%type default null
80: , p_per_information_category
81: in per_all_people_f.per_information_category%type default null
82: , p_per_information4
83: in per_all_people_f.per_information4%type default null
84: );
85: -------------------------------------------------------------------------------
86: -- validate_person
87: -------------------------------------------------------------------------------
98: -- --
99: ---------------------------------------------------------------------------
100: PROCEDURE validate_person
101: ( p_person_id
102: in per_all_people_f.person_id%type
103: , p_effective_date
104: in date
105: , p_person_type_id
106: in per_all_people_f.person_type_id%type
102: in per_all_people_f.person_id%type
103: , p_effective_date
104: in date
105: , p_person_type_id
106: in per_all_people_f.person_type_id%type
107: , p_per_information_category
108: in per_all_people_f.per_information_category%type
109: , p_per_information4
110: in per_all_people_f.per_information4%type
104: in date
105: , p_person_type_id
106: in per_all_people_f.person_type_id%type
107: , p_per_information_category
108: in per_all_people_f.per_information_category%type
109: , p_per_information4
110: in per_all_people_f.per_information4%type
111: );
112:
106: in per_all_people_f.person_type_id%type
107: , p_per_information_category
108: in per_all_people_f.per_information_category%type
109: , p_per_information4
110: in per_all_people_f.per_information4%type
111: );
112:
113: END per_za_user_hook_pkg;