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.PER_ZA_USER_HOOK_PKG dependencies on PER_ALL_PEOPLE_F

Line 21: in per_all_people_f.business_group_id%type default null

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

Line 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_information2
29: in per_all_people_f.per_information2%type default null

Line 27: in per_all_people_f.per_information_category%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_information2
29: in per_all_people_f.per_information2%type default null
30: , p_per_information4
31: in per_all_people_f.per_information4%type default null

Line 29: in per_all_people_f.per_information2%type default null

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_information2
29: in per_all_people_f.per_information2%type default null
30: , p_per_information4
31: in per_all_people_f.per_information4%type default null
32: , p_per_information10
33: in per_all_people_f.per_information10%type default null

Line 31: in per_all_people_f.per_information4%type default null

27: in per_all_people_f.per_information_category%type default null
28: , p_per_information2
29: in per_all_people_f.per_information2%type default null
30: , p_per_information4
31: in per_all_people_f.per_information4%type default null
32: , p_per_information10
33: in per_all_people_f.per_information10%type default null
34: , p_email_address
35: in per_all_people_f.email_address%type default null

Line 33: in per_all_people_f.per_information10%type default null

29: in per_all_people_f.per_information2%type default null
30: , p_per_information4
31: in per_all_people_f.per_information4%type default null
32: , p_per_information10
33: in per_all_people_f.per_information10%type default null
34: , p_email_address
35: in per_all_people_f.email_address%type default null
36: );
37: -------------------------------------------------------------------------------

Line 35: in per_all_people_f.email_address%type default null

31: in per_all_people_f.per_information4%type default null
32: , p_per_information10
33: in per_all_people_f.per_information10%type default null
34: , p_email_address
35: in per_all_people_f.email_address%type default null
36: );
37: -------------------------------------------------------------------------------
38: -- validate_employee
39: -------------------------------------------------------------------------------

Line 54: in per_all_people_f.business_group_id%type default null

50: -- --
51: ---------------------------------------------------------------------------
52: PROCEDURE validate_employee
53: ( p_business_group_id
54: in per_all_people_f.business_group_id%type default null
55: , p_hire_date
56: in date
57: , p_person_type_id
58: in per_all_people_f.person_type_id%type default null

Line 58: in per_all_people_f.person_type_id%type default null

54: in per_all_people_f.business_group_id%type default null
55: , p_hire_date
56: in date
57: , p_person_type_id
58: in per_all_people_f.person_type_id%type default null
59: , p_per_information_category
60: in per_all_people_f.per_information_category%type default null
61: , p_per_information2
62: in per_all_people_f.per_information2%type default null

Line 60: in per_all_people_f.per_information_category%type default null

56: in date
57: , p_person_type_id
58: in per_all_people_f.person_type_id%type default null
59: , p_per_information_category
60: in per_all_people_f.per_information_category%type default null
61: , p_per_information2
62: in per_all_people_f.per_information2%type default null
63: , p_per_information4
64: in per_all_people_f.per_information4%type default null

Line 62: in per_all_people_f.per_information2%type default null

58: in per_all_people_f.person_type_id%type default null
59: , p_per_information_category
60: in per_all_people_f.per_information_category%type default null
61: , p_per_information2
62: in per_all_people_f.per_information2%type default null
63: , p_per_information4
64: in per_all_people_f.per_information4%type default null
65: , p_per_information10
66: in per_all_people_f.per_information10%type default null

Line 64: in per_all_people_f.per_information4%type default null

60: in per_all_people_f.per_information_category%type default null
61: , p_per_information2
62: in per_all_people_f.per_information2%type default null
63: , p_per_information4
64: in per_all_people_f.per_information4%type default null
65: , p_per_information10
66: in per_all_people_f.per_information10%type default null
67: , p_email_address
68: in per_all_people_f.email_address%type default null

Line 66: in per_all_people_f.per_information10%type default null

62: in per_all_people_f.per_information2%type default null
63: , p_per_information4
64: in per_all_people_f.per_information4%type default null
65: , p_per_information10
66: in per_all_people_f.per_information10%type default null
67: , p_email_address
68: in per_all_people_f.email_address%type default null
69: , p_per_information12
70: in per_all_people_f.per_information12%type default null

Line 68: in per_all_people_f.email_address%type default null

64: in per_all_people_f.per_information4%type default null
65: , p_per_information10
66: in per_all_people_f.per_information10%type default null
67: , p_email_address
68: in per_all_people_f.email_address%type default null
69: , p_per_information12
70: in per_all_people_f.per_information12%type default null
71: , p_last_name
72: in per_all_people_f.last_name%type default null

Line 70: in per_all_people_f.per_information12%type default null

66: in per_all_people_f.per_information10%type default null
67: , p_email_address
68: in per_all_people_f.email_address%type default null
69: , p_per_information12
70: in per_all_people_f.per_information12%type default null
71: , p_last_name
72: in per_all_people_f.last_name%type default null
73: , p_first_name
74: in per_all_people_f.first_name%type default null

Line 72: in per_all_people_f.last_name%type default null

68: in per_all_people_f.email_address%type default null
69: , p_per_information12
70: in per_all_people_f.per_information12%type default null
71: , p_last_name
72: in per_all_people_f.last_name%type default null
73: , p_first_name
74: in per_all_people_f.first_name%type default null
75: , p_middle_names
76: in per_all_people_f.MIDDLE_NAMES%type default null

Line 74: in per_all_people_f.first_name%type default null

70: in per_all_people_f.per_information12%type default null
71: , p_last_name
72: in per_all_people_f.last_name%type default null
73: , p_first_name
74: in per_all_people_f.first_name%type default null
75: , p_middle_names
76: in per_all_people_f.MIDDLE_NAMES%type default null
77: , p_employee_number
78: in per_all_people_f.EMPLOYEE_NUMBER%type default null

Line 76: in per_all_people_f.MIDDLE_NAMES%type default null

72: in per_all_people_f.last_name%type default null
73: , p_first_name
74: in per_all_people_f.first_name%type default null
75: , p_middle_names
76: in per_all_people_f.MIDDLE_NAMES%type default null
77: , p_employee_number
78: in per_all_people_f.EMPLOYEE_NUMBER%type default null
79: , p_national_identifier
80: in per_all_people_f.NATIONAL_IDENTIFIER%type default null

Line 78: in per_all_people_f.EMPLOYEE_NUMBER%type default null

74: in per_all_people_f.first_name%type default null
75: , p_middle_names
76: in per_all_people_f.MIDDLE_NAMES%type default null
77: , p_employee_number
78: in per_all_people_f.EMPLOYEE_NUMBER%type default null
79: , p_national_identifier
80: in per_all_people_f.NATIONAL_IDENTIFIER%type default null
81: , p_per_information1
82: in per_all_people_f.per_information1%type default null

Line 80: in per_all_people_f.NATIONAL_IDENTIFIER%type default null

76: in per_all_people_f.MIDDLE_NAMES%type default null
77: , p_employee_number
78: in per_all_people_f.EMPLOYEE_NUMBER%type default null
79: , p_national_identifier
80: in per_all_people_f.NATIONAL_IDENTIFIER%type default null
81: , p_per_information1
82: in per_all_people_f.per_information1%type default null
83: , p_date_of_birth
84: in per_all_people_f.date_of_birth%type default null

Line 82: in per_all_people_f.per_information1%type default null

78: in per_all_people_f.EMPLOYEE_NUMBER%type default null
79: , p_national_identifier
80: in per_all_people_f.NATIONAL_IDENTIFIER%type default null
81: , p_per_information1
82: in per_all_people_f.per_information1%type default null
83: , p_date_of_birth
84: in per_all_people_f.date_of_birth%type default null
85: );
86: -------------------------------------------------------------------------------

Line 84: in per_all_people_f.date_of_birth%type default null

80: in per_all_people_f.NATIONAL_IDENTIFIER%type default null
81: , p_per_information1
82: in per_all_people_f.per_information1%type default null
83: , p_date_of_birth
84: in per_all_people_f.date_of_birth%type default null
85: );
86: -------------------------------------------------------------------------------
87: -- validate_cwk
88: -------------------------------------------------------------------------------

Line 103: in per_all_people_f.business_group_id%type default null

99: -- --
100: ---------------------------------------------------------------------------
101: PROCEDURE validate_cwk
102: ( p_business_group_id
103: in per_all_people_f.business_group_id%type default null
104: , p_start_date
105: in date
106: , p_person_type_id
107: in per_all_people_f.person_type_id%type default null

Line 107: in per_all_people_f.person_type_id%type default null

103: in per_all_people_f.business_group_id%type default null
104: , p_start_date
105: in date
106: , p_person_type_id
107: in per_all_people_f.person_type_id%type default null
108: , p_per_information_category
109: in per_all_people_f.per_information_category%type default null
110: , p_per_information2
111: in per_all_people_f.per_information2%type default null

Line 109: in per_all_people_f.per_information_category%type default null

105: in date
106: , p_person_type_id
107: in per_all_people_f.person_type_id%type default null
108: , p_per_information_category
109: in per_all_people_f.per_information_category%type default null
110: , p_per_information2
111: in per_all_people_f.per_information2%type default null
112: , p_per_information4
113: in per_all_people_f.per_information4%type default null

Line 111: in per_all_people_f.per_information2%type default null

107: in per_all_people_f.person_type_id%type default null
108: , p_per_information_category
109: in per_all_people_f.per_information_category%type default null
110: , p_per_information2
111: in per_all_people_f.per_information2%type default null
112: , p_per_information4
113: in per_all_people_f.per_information4%type default null
114: , p_per_information10
115: in per_all_people_f.per_information10%type default null

Line 113: in per_all_people_f.per_information4%type default null

109: in per_all_people_f.per_information_category%type default null
110: , p_per_information2
111: in per_all_people_f.per_information2%type default null
112: , p_per_information4
113: in per_all_people_f.per_information4%type default null
114: , p_per_information10
115: in per_all_people_f.per_information10%type default null
116: , p_email_address
117: in per_all_people_f.email_address%type default null

Line 115: in per_all_people_f.per_information10%type default null

111: in per_all_people_f.per_information2%type default null
112: , p_per_information4
113: in per_all_people_f.per_information4%type default null
114: , p_per_information10
115: in per_all_people_f.per_information10%type default null
116: , p_email_address
117: in per_all_people_f.email_address%type default null
118: );
119: -------------------------------------------------------------------------------

Line 117: in per_all_people_f.email_address%type default null

113: in per_all_people_f.per_information4%type default null
114: , p_per_information10
115: in per_all_people_f.per_information10%type default null
116: , p_email_address
117: in per_all_people_f.email_address%type default null
118: );
119: -------------------------------------------------------------------------------
120: -- validate_person
121: -------------------------------------------------------------------------------

Line 136: in per_all_people_f.person_id%type

132: -- --
133: ---------------------------------------------------------------------------
134: PROCEDURE validate_person
135: ( p_person_id
136: in per_all_people_f.person_id%type
137: , p_effective_date
138: in date
139: , p_person_type_id
140: in per_all_people_f.person_type_id%type

Line 140: in per_all_people_f.person_type_id%type

136: in per_all_people_f.person_id%type
137: , p_effective_date
138: in date
139: , p_person_type_id
140: in per_all_people_f.person_type_id%type
141: , p_per_information_category
142: in per_all_people_f.per_information_category%type
143: , p_per_information2
144: in per_all_people_f.per_information2%type default null

Line 142: in per_all_people_f.per_information_category%type

138: in date
139: , p_person_type_id
140: in per_all_people_f.person_type_id%type
141: , p_per_information_category
142: in per_all_people_f.per_information_category%type
143: , p_per_information2
144: in per_all_people_f.per_information2%type default null
145: , p_per_information4
146: in per_all_people_f.per_information4%type

Line 144: in per_all_people_f.per_information2%type default null

140: in per_all_people_f.person_type_id%type
141: , p_per_information_category
142: in per_all_people_f.per_information_category%type
143: , p_per_information2
144: in per_all_people_f.per_information2%type default null
145: , p_per_information4
146: in per_all_people_f.per_information4%type
147: , p_per_information10
148: in per_all_people_f.per_information10%type default null

Line 146: in per_all_people_f.per_information4%type

142: in per_all_people_f.per_information_category%type
143: , p_per_information2
144: in per_all_people_f.per_information2%type default null
145: , p_per_information4
146: in per_all_people_f.per_information4%type
147: , p_per_information10
148: in per_all_people_f.per_information10%type default null
149: , p_email_address
150: in per_all_people_f.email_address%type default null

Line 148: in per_all_people_f.per_information10%type default null

144: in per_all_people_f.per_information2%type default null
145: , p_per_information4
146: in per_all_people_f.per_information4%type
147: , p_per_information10
148: in per_all_people_f.per_information10%type default null
149: , p_email_address
150: in per_all_people_f.email_address%type default null
151: , p_per_information12
152: in per_all_people_f.per_information12%type default null

Line 150: in per_all_people_f.email_address%type default null

146: in per_all_people_f.per_information4%type
147: , p_per_information10
148: in per_all_people_f.per_information10%type default null
149: , p_email_address
150: in per_all_people_f.email_address%type default null
151: , p_per_information12
152: in per_all_people_f.per_information12%type default null
153: , p_last_name
154: in per_all_people_f.last_name%type default null

Line 152: in per_all_people_f.per_information12%type default null

148: in per_all_people_f.per_information10%type default null
149: , p_email_address
150: in per_all_people_f.email_address%type default null
151: , p_per_information12
152: in per_all_people_f.per_information12%type default null
153: , p_last_name
154: in per_all_people_f.last_name%type default null
155: , p_first_name
156: in per_all_people_f.first_name%type default null

Line 154: in per_all_people_f.last_name%type default null

150: in per_all_people_f.email_address%type default null
151: , p_per_information12
152: in per_all_people_f.per_information12%type default null
153: , p_last_name
154: in per_all_people_f.last_name%type default null
155: , p_first_name
156: in per_all_people_f.first_name%type default null
157: , p_middle_names
158: in per_all_people_f.MIDDLE_NAMES%type default null

Line 156: in per_all_people_f.first_name%type default null

152: in per_all_people_f.per_information12%type default null
153: , p_last_name
154: in per_all_people_f.last_name%type default null
155: , p_first_name
156: in per_all_people_f.first_name%type default null
157: , p_middle_names
158: in per_all_people_f.MIDDLE_NAMES%type default null
159: , p_employee_number
160: in per_all_people_f.EMPLOYEE_NUMBER%type default null

Line 158: in per_all_people_f.MIDDLE_NAMES%type default null

154: in per_all_people_f.last_name%type default null
155: , p_first_name
156: in per_all_people_f.first_name%type default null
157: , p_middle_names
158: in per_all_people_f.MIDDLE_NAMES%type default null
159: , p_employee_number
160: in per_all_people_f.EMPLOYEE_NUMBER%type default null
161: , p_national_identifier
162: in per_all_people_f.NATIONAL_IDENTIFIER%type default null

Line 160: in per_all_people_f.EMPLOYEE_NUMBER%type default null

156: in per_all_people_f.first_name%type default null
157: , p_middle_names
158: in per_all_people_f.MIDDLE_NAMES%type default null
159: , p_employee_number
160: in per_all_people_f.EMPLOYEE_NUMBER%type default null
161: , p_national_identifier
162: in per_all_people_f.NATIONAL_IDENTIFIER%type default null
163: , p_per_information1
164: in per_all_people_f.per_information1%type default null

Line 162: in per_all_people_f.NATIONAL_IDENTIFIER%type default null

158: in per_all_people_f.MIDDLE_NAMES%type default null
159: , p_employee_number
160: in per_all_people_f.EMPLOYEE_NUMBER%type default null
161: , p_national_identifier
162: in per_all_people_f.NATIONAL_IDENTIFIER%type default null
163: , p_per_information1
164: in per_all_people_f.per_information1%type default null
165: , p_date_of_birth
166: in per_all_people_f.date_of_birth%type default null

Line 164: in per_all_people_f.per_information1%type default null

160: in per_all_people_f.EMPLOYEE_NUMBER%type default null
161: , p_national_identifier
162: in per_all_people_f.NATIONAL_IDENTIFIER%type default null
163: , p_per_information1
164: in per_all_people_f.per_information1%type default null
165: , p_date_of_birth
166: in per_all_people_f.date_of_birth%type default null
167: );
168: -------------------------------------------------------------------------------

Line 166: in per_all_people_f.date_of_birth%type default null

162: in per_all_people_f.NATIONAL_IDENTIFIER%type default null
163: , p_per_information1
164: in per_all_people_f.per_information1%type default null
165: , p_date_of_birth
166: in per_all_people_f.date_of_birth%type default null
167: );
168: -------------------------------------------------------------------------------
169: -- validate_email_id
170: -------------------------------------------------------------------------------