APPS.HR_PROCESS_PHONE_NUMBERS_SS dependencies on HR_API

Line 54: , p_attribute_category VARCHAR2 default hr_api.g_varchar2

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

Line 55: , p_attribute1 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

Line 56: , p_attribute2 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

Line 57: , p_attribute3 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

Line 58: , p_attribute4 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

Line 59: , p_attribute5 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

Line 60: , p_attribute6 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

Line 61: , p_attribute7 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

Line 62: , p_attribute8 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

Line 63: , p_attribute9 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

Line 64: , p_attribute10 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

Line 65: , p_attribute11 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

Line 66: , p_attribute12 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

Line 67: , p_attribute13 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

Line 68: , p_attribute14 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

Line 69: , p_attribute15 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

Line 70: , p_attribute16 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

Line 71: , p_attribute17 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

Line 72: , p_attribute18 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

Line 73: , p_attribute19 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

Line 74: , p_attribute20 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

Line 75: , p_attribute21 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

Line 76: , p_attribute22 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

Line 77: , p_attribute23 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

Line 78: , p_attribute24 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

Line 79: , p_attribute25 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

Line 80: , p_attribute26 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

Line 81: , p_attribute27 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

Line 82: , p_attribute28 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
86: ,p_per_or_contact varchar2 default null

Line 83: , p_attribute29 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
87: -- EndRegistration

Line 84: , p_attribute30 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
88: , p_validate number default 0

Line 98: , p_contact_relationship_id in number default hr_api.g_number

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: ||===========================================================================

Line 134: , p_date_from date default hr_api.g_date

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

Line 135: , p_date_to date default hr_api.g_date

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: --

Line 136: , p_phone_type VARCHAR2 default hr_api.g_varchar2

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 :

Line 137: , p_phone_number VARCHAR2 default hr_api.g_number

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.

Line 145: , p_login_person_id NUMBER default hr_api.g_number

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

Line 146: , p_attribute_category 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

Line 147: , p_attribute1 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

Line 148: , p_attribute2 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

Line 149: , p_attribute3 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

Line 150: , p_attribute4 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

Line 151: , p_attribute5 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

Line 152: , p_attribute6 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

Line 153: , p_attribute7 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

Line 154: , p_attribute8 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

Line 155: , p_attribute9 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

Line 156: , p_attribute10 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

Line 157: , p_attribute11 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

Line 158: , p_attribute12 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

Line 159: , p_attribute13 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

Line 160: , p_attribute14 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

Line 161: , p_attribute15 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

Line 162: , p_attribute16 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

Line 163: , p_attribute17 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

Line 164: , p_attribute18 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

Line 165: , p_attribute19 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

Line 166: , p_attribute20 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

Line 167: , p_attribute21 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

Line 168: , p_attribute22 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

Line 169: , p_attribute23 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

Line 170: , p_attribute24 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

Line 171: , p_attribute25 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

Line 172: , p_attribute26 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

Line 173: , p_attribute27 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

Line 174: , p_attribute28 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
178: , p_validate number default 0

Line 175: , p_attribute29 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
179: , p_effective_date date

Line 176: , p_attribute30 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
180: , p_parent_id NUMBER

Line 187: , p_contact_relationship_id in number default hr_api.g_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: ||===========================================================================

Line 232: , p_login_person_id NUMBER default hr_api.g_number

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

Line 284: , p_attribute1 VARCHAR2 default hr_api.g_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

Line 285: , p_attribute2 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

Line 286: , p_attribute3 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

Line 287: , p_attribute4 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

Line 288: , p_attribute5 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

Line 289: , p_attribute6 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

Line 290: , p_attribute7 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

Line 291: , p_attribute8 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

Line 292: , p_attribute9 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

Line 293: , p_attribute10 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

Line 294: , p_attribute11 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

Line 295: , p_attribute12 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

Line 296: , p_attribute13 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

Line 297: , p_attribute14 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

Line 298: , p_attribute15 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

Line 299: , p_attribute16 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

Line 300: , p_attribute17 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

Line 301: , p_attribute18 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

Line 302: , p_attribute19 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

Line 303: , p_attribute20 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

Line 304: , p_attribute21 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

Line 305: , p_attribute22 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

Line 306: , p_attribute23 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

Line 307: , p_attribute24 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

Line 308: , p_attribute25 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

Line 309: , p_attribute26 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

Line 310: , p_attribute27 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

Line 311: , p_attribute28 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
315: , p_effective_date date

Line 312: , p_attribute29 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
316: , p_item_type in varchar2

Line 313: , p_attribute30 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
317: , p_item_key in varchar2