50: -- Login person id is say employee who is adding the phones to his contact.
51: --
52: , p_login_person_id NUMBER default null
53: , p_business_group_id number default null
54: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
55: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
56: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
57: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
58: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
51: --
52: , p_login_person_id NUMBER default null
53: , p_business_group_id number default null
54: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
55: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
56: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
57: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
58: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
59: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
52: , p_login_person_id NUMBER default null
53: , p_business_group_id number default null
54: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
55: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
56: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
57: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
58: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
59: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
60: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
53: , p_business_group_id number default null
54: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
55: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
56: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
57: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
58: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
59: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
60: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
61: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
54: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
55: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
56: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
57: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
58: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
59: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
60: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
61: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
62: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
55: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
56: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
57: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
58: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
59: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
60: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
61: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
62: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
63: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
56: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
57: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
58: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
59: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
60: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
61: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
62: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
63: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
64: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
57: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
58: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
59: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
60: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
61: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
62: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
63: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
64: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
65: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
58: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
59: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
60: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
61: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
62: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
63: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
64: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
65: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
66: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
59: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
60: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
61: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
62: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
63: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
64: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
65: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
66: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
67: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
60: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
61: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
62: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
63: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
64: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
65: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
66: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
67: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
68: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
61: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
62: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
63: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
64: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
65: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
66: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
67: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
68: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
69: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
62: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
63: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
64: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
65: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
66: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
67: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
68: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
69: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
70: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
63: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
64: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
65: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
66: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
67: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
68: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
69: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
70: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
71: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
64: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
65: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
66: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
67: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
68: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
69: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
70: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
71: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
72: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
65: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
66: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
67: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
68: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
69: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
70: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
71: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
72: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
73: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
66: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
67: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
68: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
69: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
70: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
71: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
72: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
73: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
74: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
67: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
68: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
69: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
70: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
71: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
72: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
73: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
74: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
75: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
68: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
69: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
70: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
71: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
72: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
73: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
74: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
75: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
76: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
69: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
70: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
71: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
72: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
73: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
74: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
75: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
76: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
77: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
70: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
71: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
72: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
73: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
74: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
75: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
76: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
77: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
78: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
71: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
72: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
73: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
74: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
75: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
76: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
77: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
78: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
79: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
72: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
73: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
74: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
75: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
76: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
77: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
78: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
79: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
80: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
73: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
74: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
75: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
76: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
77: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
78: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
79: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
80: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
81: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
74: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
75: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
76: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
77: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
78: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
79: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
80: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
81: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
82: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
75: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
76: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
77: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
78: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
79: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
80: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
81: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
82: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
83: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
76: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
77: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
78: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
79: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
80: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
81: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
82: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
83: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
84: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
77: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
78: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
79: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
80: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
81: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
82: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
83: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
84: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
85: -- StartRegistration
78: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
79: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
80: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
81: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
82: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
83: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
84: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
85: -- StartRegistration
86: ,p_per_or_contact varchar2 default null
79: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
80: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
81: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
82: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
83: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
84: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
85: -- StartRegistration
86: ,p_per_or_contact varchar2 default null
87: -- EndRegistration
80: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
81: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
82: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
83: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
84: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
85: -- StartRegistration
86: ,p_per_or_contact varchar2 default null
87: -- EndRegistration
88: , p_validate number default 0
94: , p_activity_id in number
95: , p_phone_type_meaning in varchar2
96: , p_save_mode in varchar2 default null
97: , p_error_message out nocopy varchar2
98: , p_contact_relationship_id in number default hr_api.g_number
99: );
100:
101: /*
102: ||===========================================================================
130: ||===========================================================================
131: */
132:
133: procedure update_phone(p_phone_id NUMBER
134: , p_date_from date default hr_api.g_date
135: , p_date_to date default hr_api.g_date
136: , p_phone_type VARCHAR2 default hr_api.g_varchar2
137: , p_phone_number VARCHAR2 default hr_api.g_number
138: , p_per_or_contact varchar2 default null
131: */
132:
133: procedure update_phone(p_phone_id NUMBER
134: , p_date_from date default hr_api.g_date
135: , p_date_to date default hr_api.g_date
136: , p_phone_type VARCHAR2 default hr_api.g_varchar2
137: , p_phone_number VARCHAR2 default hr_api.g_number
138: , p_per_or_contact varchar2 default null
139: --
132:
133: procedure update_phone(p_phone_id NUMBER
134: , p_date_from date default hr_api.g_date
135: , p_date_to date default hr_api.g_date
136: , p_phone_type VARCHAR2 default hr_api.g_varchar2
137: , p_phone_number VARCHAR2 default hr_api.g_number
138: , p_per_or_contact varchar2 default null
139: --
140: -- PB Add :
133: procedure update_phone(p_phone_id NUMBER
134: , p_date_from date default hr_api.g_date
135: , p_date_to date default hr_api.g_date
136: , p_phone_type VARCHAR2 default hr_api.g_varchar2
137: , p_phone_number VARCHAR2 default hr_api.g_number
138: , p_per_or_contact varchar2 default null
139: --
140: -- PB Add :
141: -- The transaction steps have to be created by the login personid.
141: -- The transaction steps have to be created by the login personid.
142: -- In case of adding phones for contacts parent_is is contact_person_id.
143: -- Login person id is say employee who is adding the phones to his contact.
144: --
145: , p_login_person_id NUMBER default hr_api.g_number
146: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
147: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
148: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
149: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
142: -- In case of adding phones for contacts parent_is is contact_person_id.
143: -- Login person id is say employee who is adding the phones to his contact.
144: --
145: , p_login_person_id NUMBER default hr_api.g_number
146: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
147: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
148: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
149: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
150: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
143: -- Login person id is say employee who is adding the phones to his contact.
144: --
145: , p_login_person_id NUMBER default hr_api.g_number
146: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
147: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
148: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
149: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
150: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
144: --
145: , p_login_person_id NUMBER default hr_api.g_number
146: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
147: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
148: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
149: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
150: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
145: , p_login_person_id NUMBER default hr_api.g_number
146: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
147: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
148: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
149: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
150: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
146: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
147: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
148: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
149: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
150: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
147: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
148: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
149: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
150: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
148: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
149: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
150: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
149: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
150: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
150: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
173: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
173: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
174: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
173: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
174: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
175: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
173: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
174: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
175: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
176: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
173: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
174: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
175: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
176: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
177: , p_object_version_number in out nocopy NUMBER
170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
173: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
174: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
175: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
176: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
177: , p_object_version_number in out nocopy NUMBER
178: , p_validate number default 0
171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
173: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
174: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
175: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
176: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
177: , p_object_version_number in out nocopy NUMBER
178: , p_validate number default 0
179: , p_effective_date date
172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
173: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
174: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
175: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
176: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
177: , p_object_version_number in out nocopy NUMBER
178: , p_validate number default 0
179: , p_effective_date date
180: , p_parent_id NUMBER
183: , p_activity_id in number
184: , p_phone_type_meaning in varchar2
185: , p_save_mode in varchar2 default null
186: , p_error_message out nocopy varchar2
187: , p_contact_relationship_id in number default hr_api.g_number
188: );
189:
190: /*
191: ||===========================================================================
228: -- The transaction steps have to be created by the login personid.
229: -- In case of adding phones for contacts parent_is is contact_person_id.
230: -- Login person id is say employee who is adding the phones to his contact.
231: --
232: , p_login_person_id NUMBER default hr_api.g_number
233: , p_item_type in varchar2
234: , p_item_key in varchar2
235: , p_activity_id in number
236: , p_phone_type_meaning in varchar2
280: , p_phone_number VARCHAR2
281: , p_parent_id NUMBER
282: , p_parent_table VARCHAR2
283: , p_attribute_category VARCHAR2
284: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
285: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
286: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
287: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
288: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
281: , p_parent_id NUMBER
282: , p_parent_table VARCHAR2
283: , p_attribute_category VARCHAR2
284: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
285: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
286: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
287: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
288: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
289: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
282: , p_parent_table VARCHAR2
283: , p_attribute_category VARCHAR2
284: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
285: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
286: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
287: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
288: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
289: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
290: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
283: , p_attribute_category VARCHAR2
284: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
285: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
286: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
287: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
288: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
289: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
290: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
291: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
284: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
285: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
286: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
287: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
288: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
289: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
290: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
291: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
292: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
285: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
286: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
287: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
288: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
289: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
290: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
291: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
292: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
293: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
286: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
287: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
288: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
289: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
290: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
291: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
292: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
293: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
294: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
287: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
288: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
289: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
290: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
291: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
292: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
293: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
294: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
295: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
288: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
289: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
290: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
291: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
292: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
293: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
294: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
295: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
296: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
289: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
290: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
291: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
292: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
293: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
294: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
295: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
296: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
297: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
290: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
291: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
292: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
293: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
294: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
295: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
296: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
297: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
298: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
291: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
292: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
293: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
294: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
295: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
296: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
297: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
298: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
299: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
292: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
293: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
294: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
295: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
296: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
297: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
298: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
299: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
300: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
293: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
294: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
295: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
296: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
297: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
298: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
299: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
300: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
301: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
294: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
295: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
296: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
297: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
298: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
299: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
300: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
301: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
302: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
295: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
296: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
297: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
298: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
299: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
300: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
301: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
302: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
303: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
296: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
297: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
298: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
299: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
300: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
301: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
302: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
303: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
304: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
297: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
298: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
299: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
300: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
301: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
302: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
303: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
304: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
305: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
298: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
299: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
300: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
301: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
302: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
303: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
304: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
305: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
306: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
299: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
300: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
301: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
302: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
303: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
304: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
305: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
306: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
307: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
300: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
301: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
302: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
303: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
304: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
305: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
306: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
307: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
308: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
301: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
302: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
303: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
304: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
305: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
306: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
307: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
308: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
309: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
302: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
303: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
304: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
305: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
306: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
307: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
308: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
309: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
310: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
303: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
304: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
305: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
306: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
307: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
308: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
309: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
310: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
311: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
304: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
305: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
306: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
307: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
308: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
309: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
310: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
311: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
312: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
305: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
306: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
307: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
308: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
309: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
310: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
311: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
312: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
313: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
306: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
307: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
308: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
309: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
310: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
311: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
312: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
313: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
314: , p_validate number
307: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
308: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
309: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
310: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
311: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
312: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
313: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
314: , p_validate number
315: , p_effective_date date
308: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
309: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
310: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
311: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
312: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
313: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
314: , p_validate number
315: , p_effective_date date
316: , p_item_type in varchar2
309: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
310: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
311: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
312: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
313: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
314: , p_validate number
315: , p_effective_date date
316: , p_item_type in varchar2
317: , p_item_key in varchar2