DBA Data[Home] [Help]

APPS.OTA_NHS_UPD dependencies on HR_API

Line 101: p_person_id in number default hr_api.g_number,

97: -- ----------------------------------------------------------------------------
98: Procedure upd
99: (p_effective_date in date,
100: p_nota_history_id in number,
101: p_person_id in number default hr_api.g_number,
102: p_contact_id in number default hr_api.g_number,
103: p_trng_title in varchar2 default hr_api.g_varchar2,
104: p_provider in varchar2 default hr_api.g_varchar2,
105: p_type in varchar2 default hr_api.g_varchar2,

Line 102: p_contact_id in number default hr_api.g_number,

98: Procedure upd
99: (p_effective_date in date,
100: p_nota_history_id in number,
101: p_person_id in number default hr_api.g_number,
102: p_contact_id in number default hr_api.g_number,
103: p_trng_title in varchar2 default hr_api.g_varchar2,
104: p_provider in varchar2 default hr_api.g_varchar2,
105: p_type in varchar2 default hr_api.g_varchar2,
106: p_centre in varchar2 default hr_api.g_varchar2,

Line 103: p_trng_title in varchar2 default hr_api.g_varchar2,

99: (p_effective_date in date,
100: p_nota_history_id in number,
101: p_person_id in number default hr_api.g_number,
102: p_contact_id in number default hr_api.g_number,
103: p_trng_title in varchar2 default hr_api.g_varchar2,
104: p_provider in varchar2 default hr_api.g_varchar2,
105: p_type in varchar2 default hr_api.g_varchar2,
106: p_centre in varchar2 default hr_api.g_varchar2,
107: p_completion_date in date default hr_api.g_date,

Line 104: p_provider in varchar2 default hr_api.g_varchar2,

100: p_nota_history_id in number,
101: p_person_id in number default hr_api.g_number,
102: p_contact_id in number default hr_api.g_number,
103: p_trng_title in varchar2 default hr_api.g_varchar2,
104: p_provider in varchar2 default hr_api.g_varchar2,
105: p_type in varchar2 default hr_api.g_varchar2,
106: p_centre in varchar2 default hr_api.g_varchar2,
107: p_completion_date in date default hr_api.g_date,
108: p_award in varchar2 default hr_api.g_varchar2,

Line 105: p_type in varchar2 default hr_api.g_varchar2,

101: p_person_id in number default hr_api.g_number,
102: p_contact_id in number default hr_api.g_number,
103: p_trng_title in varchar2 default hr_api.g_varchar2,
104: p_provider in varchar2 default hr_api.g_varchar2,
105: p_type in varchar2 default hr_api.g_varchar2,
106: p_centre in varchar2 default hr_api.g_varchar2,
107: p_completion_date in date default hr_api.g_date,
108: p_award in varchar2 default hr_api.g_varchar2,
109: p_rating in varchar2 default hr_api.g_varchar2,

Line 106: p_centre in varchar2 default hr_api.g_varchar2,

102: p_contact_id in number default hr_api.g_number,
103: p_trng_title in varchar2 default hr_api.g_varchar2,
104: p_provider in varchar2 default hr_api.g_varchar2,
105: p_type in varchar2 default hr_api.g_varchar2,
106: p_centre in varchar2 default hr_api.g_varchar2,
107: p_completion_date in date default hr_api.g_date,
108: p_award in varchar2 default hr_api.g_varchar2,
109: p_rating in varchar2 default hr_api.g_varchar2,
110: p_duration in number default hr_api.g_number,

Line 107: p_completion_date in date default hr_api.g_date,

103: p_trng_title in varchar2 default hr_api.g_varchar2,
104: p_provider in varchar2 default hr_api.g_varchar2,
105: p_type in varchar2 default hr_api.g_varchar2,
106: p_centre in varchar2 default hr_api.g_varchar2,
107: p_completion_date in date default hr_api.g_date,
108: p_award in varchar2 default hr_api.g_varchar2,
109: p_rating in varchar2 default hr_api.g_varchar2,
110: p_duration in number default hr_api.g_number,
111: p_duration_units in varchar2 default hr_api.g_varchar2,

Line 108: p_award in varchar2 default hr_api.g_varchar2,

104: p_provider in varchar2 default hr_api.g_varchar2,
105: p_type in varchar2 default hr_api.g_varchar2,
106: p_centre in varchar2 default hr_api.g_varchar2,
107: p_completion_date in date default hr_api.g_date,
108: p_award in varchar2 default hr_api.g_varchar2,
109: p_rating in varchar2 default hr_api.g_varchar2,
110: p_duration in number default hr_api.g_number,
111: p_duration_units in varchar2 default hr_api.g_varchar2,
112: p_activity_version_id in number default hr_api.g_number,

Line 109: p_rating in varchar2 default hr_api.g_varchar2,

105: p_type in varchar2 default hr_api.g_varchar2,
106: p_centre in varchar2 default hr_api.g_varchar2,
107: p_completion_date in date default hr_api.g_date,
108: p_award in varchar2 default hr_api.g_varchar2,
109: p_rating in varchar2 default hr_api.g_varchar2,
110: p_duration in number default hr_api.g_number,
111: p_duration_units in varchar2 default hr_api.g_varchar2,
112: p_activity_version_id in number default hr_api.g_number,
113: p_status in varchar2 default hr_api.g_varchar2,

Line 110: p_duration in number default hr_api.g_number,

106: p_centre in varchar2 default hr_api.g_varchar2,
107: p_completion_date in date default hr_api.g_date,
108: p_award in varchar2 default hr_api.g_varchar2,
109: p_rating in varchar2 default hr_api.g_varchar2,
110: p_duration in number default hr_api.g_number,
111: p_duration_units in varchar2 default hr_api.g_varchar2,
112: p_activity_version_id in number default hr_api.g_number,
113: p_status in varchar2 default hr_api.g_varchar2,
114: p_verified_by_id in number default hr_api.g_number,

Line 111: p_duration_units in varchar2 default hr_api.g_varchar2,

107: p_completion_date in date default hr_api.g_date,
108: p_award in varchar2 default hr_api.g_varchar2,
109: p_rating in varchar2 default hr_api.g_varchar2,
110: p_duration in number default hr_api.g_number,
111: p_duration_units in varchar2 default hr_api.g_varchar2,
112: p_activity_version_id in number default hr_api.g_number,
113: p_status in varchar2 default hr_api.g_varchar2,
114: p_verified_by_id in number default hr_api.g_number,
115: p_nth_information_category in varchar2 default hr_api.g_varchar2,

Line 112: p_activity_version_id in number default hr_api.g_number,

108: p_award in varchar2 default hr_api.g_varchar2,
109: p_rating in varchar2 default hr_api.g_varchar2,
110: p_duration in number default hr_api.g_number,
111: p_duration_units in varchar2 default hr_api.g_varchar2,
112: p_activity_version_id in number default hr_api.g_number,
113: p_status in varchar2 default hr_api.g_varchar2,
114: p_verified_by_id in number default hr_api.g_number,
115: p_nth_information_category in varchar2 default hr_api.g_varchar2,
116: p_nth_information1 in varchar2 default hr_api.g_varchar2,

Line 113: p_status in varchar2 default hr_api.g_varchar2,

109: p_rating in varchar2 default hr_api.g_varchar2,
110: p_duration in number default hr_api.g_number,
111: p_duration_units in varchar2 default hr_api.g_varchar2,
112: p_activity_version_id in number default hr_api.g_number,
113: p_status in varchar2 default hr_api.g_varchar2,
114: p_verified_by_id in number default hr_api.g_number,
115: p_nth_information_category in varchar2 default hr_api.g_varchar2,
116: p_nth_information1 in varchar2 default hr_api.g_varchar2,
117: p_nth_information2 in varchar2 default hr_api.g_varchar2,

Line 114: p_verified_by_id in number default hr_api.g_number,

110: p_duration in number default hr_api.g_number,
111: p_duration_units in varchar2 default hr_api.g_varchar2,
112: p_activity_version_id in number default hr_api.g_number,
113: p_status in varchar2 default hr_api.g_varchar2,
114: p_verified_by_id in number default hr_api.g_number,
115: p_nth_information_category in varchar2 default hr_api.g_varchar2,
116: p_nth_information1 in varchar2 default hr_api.g_varchar2,
117: p_nth_information2 in varchar2 default hr_api.g_varchar2,
118: p_nth_information3 in varchar2 default hr_api.g_varchar2,

Line 115: p_nth_information_category in varchar2 default hr_api.g_varchar2,

111: p_duration_units in varchar2 default hr_api.g_varchar2,
112: p_activity_version_id in number default hr_api.g_number,
113: p_status in varchar2 default hr_api.g_varchar2,
114: p_verified_by_id in number default hr_api.g_number,
115: p_nth_information_category in varchar2 default hr_api.g_varchar2,
116: p_nth_information1 in varchar2 default hr_api.g_varchar2,
117: p_nth_information2 in varchar2 default hr_api.g_varchar2,
118: p_nth_information3 in varchar2 default hr_api.g_varchar2,
119: p_nth_information4 in varchar2 default hr_api.g_varchar2,

Line 116: p_nth_information1 in varchar2 default hr_api.g_varchar2,

112: p_activity_version_id in number default hr_api.g_number,
113: p_status in varchar2 default hr_api.g_varchar2,
114: p_verified_by_id in number default hr_api.g_number,
115: p_nth_information_category in varchar2 default hr_api.g_varchar2,
116: p_nth_information1 in varchar2 default hr_api.g_varchar2,
117: p_nth_information2 in varchar2 default hr_api.g_varchar2,
118: p_nth_information3 in varchar2 default hr_api.g_varchar2,
119: p_nth_information4 in varchar2 default hr_api.g_varchar2,
120: p_nth_information5 in varchar2 default hr_api.g_varchar2,

Line 117: p_nth_information2 in varchar2 default hr_api.g_varchar2,

113: p_status in varchar2 default hr_api.g_varchar2,
114: p_verified_by_id in number default hr_api.g_number,
115: p_nth_information_category in varchar2 default hr_api.g_varchar2,
116: p_nth_information1 in varchar2 default hr_api.g_varchar2,
117: p_nth_information2 in varchar2 default hr_api.g_varchar2,
118: p_nth_information3 in varchar2 default hr_api.g_varchar2,
119: p_nth_information4 in varchar2 default hr_api.g_varchar2,
120: p_nth_information5 in varchar2 default hr_api.g_varchar2,
121: p_nth_information6 in varchar2 default hr_api.g_varchar2,

Line 118: p_nth_information3 in varchar2 default hr_api.g_varchar2,

114: p_verified_by_id in number default hr_api.g_number,
115: p_nth_information_category in varchar2 default hr_api.g_varchar2,
116: p_nth_information1 in varchar2 default hr_api.g_varchar2,
117: p_nth_information2 in varchar2 default hr_api.g_varchar2,
118: p_nth_information3 in varchar2 default hr_api.g_varchar2,
119: p_nth_information4 in varchar2 default hr_api.g_varchar2,
120: p_nth_information5 in varchar2 default hr_api.g_varchar2,
121: p_nth_information6 in varchar2 default hr_api.g_varchar2,
122: p_nth_information7 in varchar2 default hr_api.g_varchar2,

Line 119: p_nth_information4 in varchar2 default hr_api.g_varchar2,

115: p_nth_information_category in varchar2 default hr_api.g_varchar2,
116: p_nth_information1 in varchar2 default hr_api.g_varchar2,
117: p_nth_information2 in varchar2 default hr_api.g_varchar2,
118: p_nth_information3 in varchar2 default hr_api.g_varchar2,
119: p_nth_information4 in varchar2 default hr_api.g_varchar2,
120: p_nth_information5 in varchar2 default hr_api.g_varchar2,
121: p_nth_information6 in varchar2 default hr_api.g_varchar2,
122: p_nth_information7 in varchar2 default hr_api.g_varchar2,
123: p_nth_information8 in varchar2 default hr_api.g_varchar2,

Line 120: p_nth_information5 in varchar2 default hr_api.g_varchar2,

116: p_nth_information1 in varchar2 default hr_api.g_varchar2,
117: p_nth_information2 in varchar2 default hr_api.g_varchar2,
118: p_nth_information3 in varchar2 default hr_api.g_varchar2,
119: p_nth_information4 in varchar2 default hr_api.g_varchar2,
120: p_nth_information5 in varchar2 default hr_api.g_varchar2,
121: p_nth_information6 in varchar2 default hr_api.g_varchar2,
122: p_nth_information7 in varchar2 default hr_api.g_varchar2,
123: p_nth_information8 in varchar2 default hr_api.g_varchar2,
124: p_nth_information9 in varchar2 default hr_api.g_varchar2,

Line 121: p_nth_information6 in varchar2 default hr_api.g_varchar2,

117: p_nth_information2 in varchar2 default hr_api.g_varchar2,
118: p_nth_information3 in varchar2 default hr_api.g_varchar2,
119: p_nth_information4 in varchar2 default hr_api.g_varchar2,
120: p_nth_information5 in varchar2 default hr_api.g_varchar2,
121: p_nth_information6 in varchar2 default hr_api.g_varchar2,
122: p_nth_information7 in varchar2 default hr_api.g_varchar2,
123: p_nth_information8 in varchar2 default hr_api.g_varchar2,
124: p_nth_information9 in varchar2 default hr_api.g_varchar2,
125: p_nth_information10 in varchar2 default hr_api.g_varchar2,

Line 122: p_nth_information7 in varchar2 default hr_api.g_varchar2,

118: p_nth_information3 in varchar2 default hr_api.g_varchar2,
119: p_nth_information4 in varchar2 default hr_api.g_varchar2,
120: p_nth_information5 in varchar2 default hr_api.g_varchar2,
121: p_nth_information6 in varchar2 default hr_api.g_varchar2,
122: p_nth_information7 in varchar2 default hr_api.g_varchar2,
123: p_nth_information8 in varchar2 default hr_api.g_varchar2,
124: p_nth_information9 in varchar2 default hr_api.g_varchar2,
125: p_nth_information10 in varchar2 default hr_api.g_varchar2,
126: p_nth_information11 in varchar2 default hr_api.g_varchar2,

Line 123: p_nth_information8 in varchar2 default hr_api.g_varchar2,

119: p_nth_information4 in varchar2 default hr_api.g_varchar2,
120: p_nth_information5 in varchar2 default hr_api.g_varchar2,
121: p_nth_information6 in varchar2 default hr_api.g_varchar2,
122: p_nth_information7 in varchar2 default hr_api.g_varchar2,
123: p_nth_information8 in varchar2 default hr_api.g_varchar2,
124: p_nth_information9 in varchar2 default hr_api.g_varchar2,
125: p_nth_information10 in varchar2 default hr_api.g_varchar2,
126: p_nth_information11 in varchar2 default hr_api.g_varchar2,
127: p_nth_information12 in varchar2 default hr_api.g_varchar2,

Line 124: p_nth_information9 in varchar2 default hr_api.g_varchar2,

120: p_nth_information5 in varchar2 default hr_api.g_varchar2,
121: p_nth_information6 in varchar2 default hr_api.g_varchar2,
122: p_nth_information7 in varchar2 default hr_api.g_varchar2,
123: p_nth_information8 in varchar2 default hr_api.g_varchar2,
124: p_nth_information9 in varchar2 default hr_api.g_varchar2,
125: p_nth_information10 in varchar2 default hr_api.g_varchar2,
126: p_nth_information11 in varchar2 default hr_api.g_varchar2,
127: p_nth_information12 in varchar2 default hr_api.g_varchar2,
128: p_nth_information13 in varchar2 default hr_api.g_varchar2,

Line 125: p_nth_information10 in varchar2 default hr_api.g_varchar2,

121: p_nth_information6 in varchar2 default hr_api.g_varchar2,
122: p_nth_information7 in varchar2 default hr_api.g_varchar2,
123: p_nth_information8 in varchar2 default hr_api.g_varchar2,
124: p_nth_information9 in varchar2 default hr_api.g_varchar2,
125: p_nth_information10 in varchar2 default hr_api.g_varchar2,
126: p_nth_information11 in varchar2 default hr_api.g_varchar2,
127: p_nth_information12 in varchar2 default hr_api.g_varchar2,
128: p_nth_information13 in varchar2 default hr_api.g_varchar2,
129: p_nth_information15 in varchar2 default hr_api.g_varchar2,

Line 126: p_nth_information11 in varchar2 default hr_api.g_varchar2,

122: p_nth_information7 in varchar2 default hr_api.g_varchar2,
123: p_nth_information8 in varchar2 default hr_api.g_varchar2,
124: p_nth_information9 in varchar2 default hr_api.g_varchar2,
125: p_nth_information10 in varchar2 default hr_api.g_varchar2,
126: p_nth_information11 in varchar2 default hr_api.g_varchar2,
127: p_nth_information12 in varchar2 default hr_api.g_varchar2,
128: p_nth_information13 in varchar2 default hr_api.g_varchar2,
129: p_nth_information15 in varchar2 default hr_api.g_varchar2,
130: p_nth_information16 in varchar2 default hr_api.g_varchar2,

Line 127: p_nth_information12 in varchar2 default hr_api.g_varchar2,

123: p_nth_information8 in varchar2 default hr_api.g_varchar2,
124: p_nth_information9 in varchar2 default hr_api.g_varchar2,
125: p_nth_information10 in varchar2 default hr_api.g_varchar2,
126: p_nth_information11 in varchar2 default hr_api.g_varchar2,
127: p_nth_information12 in varchar2 default hr_api.g_varchar2,
128: p_nth_information13 in varchar2 default hr_api.g_varchar2,
129: p_nth_information15 in varchar2 default hr_api.g_varchar2,
130: p_nth_information16 in varchar2 default hr_api.g_varchar2,
131: p_nth_information17 in varchar2 default hr_api.g_varchar2,

Line 128: p_nth_information13 in varchar2 default hr_api.g_varchar2,

124: p_nth_information9 in varchar2 default hr_api.g_varchar2,
125: p_nth_information10 in varchar2 default hr_api.g_varchar2,
126: p_nth_information11 in varchar2 default hr_api.g_varchar2,
127: p_nth_information12 in varchar2 default hr_api.g_varchar2,
128: p_nth_information13 in varchar2 default hr_api.g_varchar2,
129: p_nth_information15 in varchar2 default hr_api.g_varchar2,
130: p_nth_information16 in varchar2 default hr_api.g_varchar2,
131: p_nth_information17 in varchar2 default hr_api.g_varchar2,
132: p_nth_information18 in varchar2 default hr_api.g_varchar2,

Line 129: p_nth_information15 in varchar2 default hr_api.g_varchar2,

125: p_nth_information10 in varchar2 default hr_api.g_varchar2,
126: p_nth_information11 in varchar2 default hr_api.g_varchar2,
127: p_nth_information12 in varchar2 default hr_api.g_varchar2,
128: p_nth_information13 in varchar2 default hr_api.g_varchar2,
129: p_nth_information15 in varchar2 default hr_api.g_varchar2,
130: p_nth_information16 in varchar2 default hr_api.g_varchar2,
131: p_nth_information17 in varchar2 default hr_api.g_varchar2,
132: p_nth_information18 in varchar2 default hr_api.g_varchar2,
133: p_nth_information19 in varchar2 default hr_api.g_varchar2,

Line 130: p_nth_information16 in varchar2 default hr_api.g_varchar2,

126: p_nth_information11 in varchar2 default hr_api.g_varchar2,
127: p_nth_information12 in varchar2 default hr_api.g_varchar2,
128: p_nth_information13 in varchar2 default hr_api.g_varchar2,
129: p_nth_information15 in varchar2 default hr_api.g_varchar2,
130: p_nth_information16 in varchar2 default hr_api.g_varchar2,
131: p_nth_information17 in varchar2 default hr_api.g_varchar2,
132: p_nth_information18 in varchar2 default hr_api.g_varchar2,
133: p_nth_information19 in varchar2 default hr_api.g_varchar2,
134: p_nth_information20 in varchar2 default hr_api.g_varchar2,

Line 131: p_nth_information17 in varchar2 default hr_api.g_varchar2,

127: p_nth_information12 in varchar2 default hr_api.g_varchar2,
128: p_nth_information13 in varchar2 default hr_api.g_varchar2,
129: p_nth_information15 in varchar2 default hr_api.g_varchar2,
130: p_nth_information16 in varchar2 default hr_api.g_varchar2,
131: p_nth_information17 in varchar2 default hr_api.g_varchar2,
132: p_nth_information18 in varchar2 default hr_api.g_varchar2,
133: p_nth_information19 in varchar2 default hr_api.g_varchar2,
134: p_nth_information20 in varchar2 default hr_api.g_varchar2,
135: p_org_id in number default hr_api.g_number,

Line 132: p_nth_information18 in varchar2 default hr_api.g_varchar2,

128: p_nth_information13 in varchar2 default hr_api.g_varchar2,
129: p_nth_information15 in varchar2 default hr_api.g_varchar2,
130: p_nth_information16 in varchar2 default hr_api.g_varchar2,
131: p_nth_information17 in varchar2 default hr_api.g_varchar2,
132: p_nth_information18 in varchar2 default hr_api.g_varchar2,
133: p_nth_information19 in varchar2 default hr_api.g_varchar2,
134: p_nth_information20 in varchar2 default hr_api.g_varchar2,
135: p_org_id in number default hr_api.g_number,
136: p_object_version_number in out nocopy number,

Line 133: p_nth_information19 in varchar2 default hr_api.g_varchar2,

129: p_nth_information15 in varchar2 default hr_api.g_varchar2,
130: p_nth_information16 in varchar2 default hr_api.g_varchar2,
131: p_nth_information17 in varchar2 default hr_api.g_varchar2,
132: p_nth_information18 in varchar2 default hr_api.g_varchar2,
133: p_nth_information19 in varchar2 default hr_api.g_varchar2,
134: p_nth_information20 in varchar2 default hr_api.g_varchar2,
135: p_org_id in number default hr_api.g_number,
136: p_object_version_number in out nocopy number,
137: p_business_group_id in number default hr_api.g_number,

Line 134: p_nth_information20 in varchar2 default hr_api.g_varchar2,

130: p_nth_information16 in varchar2 default hr_api.g_varchar2,
131: p_nth_information17 in varchar2 default hr_api.g_varchar2,
132: p_nth_information18 in varchar2 default hr_api.g_varchar2,
133: p_nth_information19 in varchar2 default hr_api.g_varchar2,
134: p_nth_information20 in varchar2 default hr_api.g_varchar2,
135: p_org_id in number default hr_api.g_number,
136: p_object_version_number in out nocopy number,
137: p_business_group_id in number default hr_api.g_number,
138: p_nth_information14 in varchar2 default hr_api.g_varchar2,

Line 135: p_org_id in number default hr_api.g_number,

131: p_nth_information17 in varchar2 default hr_api.g_varchar2,
132: p_nth_information18 in varchar2 default hr_api.g_varchar2,
133: p_nth_information19 in varchar2 default hr_api.g_varchar2,
134: p_nth_information20 in varchar2 default hr_api.g_varchar2,
135: p_org_id in number default hr_api.g_number,
136: p_object_version_number in out nocopy number,
137: p_business_group_id in number default hr_api.g_number,
138: p_nth_information14 in varchar2 default hr_api.g_varchar2,
139: p_customer_id in number default hr_api.g_number,

Line 137: p_business_group_id in number default hr_api.g_number,

133: p_nth_information19 in varchar2 default hr_api.g_varchar2,
134: p_nth_information20 in varchar2 default hr_api.g_varchar2,
135: p_org_id in number default hr_api.g_number,
136: p_object_version_number in out nocopy number,
137: p_business_group_id in number default hr_api.g_number,
138: p_nth_information14 in varchar2 default hr_api.g_varchar2,
139: p_customer_id in number default hr_api.g_number,
140: p_organization_id in number default hr_api.g_number
141: );

Line 138: p_nth_information14 in varchar2 default hr_api.g_varchar2,

134: p_nth_information20 in varchar2 default hr_api.g_varchar2,
135: p_org_id in number default hr_api.g_number,
136: p_object_version_number in out nocopy number,
137: p_business_group_id in number default hr_api.g_number,
138: p_nth_information14 in varchar2 default hr_api.g_varchar2,
139: p_customer_id in number default hr_api.g_number,
140: p_organization_id in number default hr_api.g_number
141: );
142: --

Line 139: p_customer_id in number default hr_api.g_number,

135: p_org_id in number default hr_api.g_number,
136: p_object_version_number in out nocopy number,
137: p_business_group_id in number default hr_api.g_number,
138: p_nth_information14 in varchar2 default hr_api.g_varchar2,
139: p_customer_id in number default hr_api.g_number,
140: p_organization_id in number default hr_api.g_number
141: );
142: --
143: end ota_nhs_upd;

Line 140: p_organization_id in number default hr_api.g_number

136: p_object_version_number in out nocopy number,
137: p_business_group_id in number default hr_api.g_number,
138: p_nth_information14 in varchar2 default hr_api.g_varchar2,
139: p_customer_id in number default hr_api.g_number,
140: p_organization_id in number default hr_api.g_number
141: );
142: --
143: end ota_nhs_upd;