DBA Data[Home] [Help]

APPS.IRC_COMMUNICATIONS_SWI dependencies on HR_API

Line 27: (p_validate in number default hr_api.g_false_num

23: --
24: -- {End of comments}
25: -- ----------------------------------------------------------------------------
26: PROCEDURE close_communication
27: (p_validate in number default hr_api.g_false_num
28: ,p_effective_date in date
29: ,p_communication_property_id in number
30: ,p_object_type in varchar2
31: ,p_object_id in number

Line 62: (p_validate in number default hr_api.g_false_num

58: --
59: -- {End of comments}
60: -- ----------------------------------------------------------------------------
61: PROCEDURE update_communication
62: (p_validate in number default hr_api.g_false_num
63: ,p_effective_date in date
64: ,p_communication_property_id in number
65: ,p_object_type in varchar2
66: ,p_object_id in number

Line 98: (p_validate in number default hr_api.g_false_num

94: --
95: -- {End of comments}
96: -- ----------------------------------------------------------------------------
97: PROCEDURE define_comm_properties
98: (p_validate in number default hr_api.g_false_num
99: ,p_effective_date in date
100: ,p_object_type in varchar2
101: ,p_object_id in number
102: ,p_default_comm_status in varchar2

Line 107: ,p_attribute_category in varchar2 default hr_api.g_varchar2

103: ,p_allow_attachment_flag in varchar2
104: ,p_auto_notification_flag in varchar2
105: ,p_allow_add_recipients in varchar2
106: ,p_default_moderator in varchar2
107: ,p_attribute_category in varchar2 default hr_api.g_varchar2
108: ,p_attribute1 in varchar2 default hr_api.g_varchar2
109: ,p_attribute2 in varchar2 default hr_api.g_varchar2
110: ,p_attribute3 in varchar2 default hr_api.g_varchar2
111: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 108: ,p_attribute1 in varchar2 default hr_api.g_varchar2

104: ,p_auto_notification_flag in varchar2
105: ,p_allow_add_recipients in varchar2
106: ,p_default_moderator in varchar2
107: ,p_attribute_category in varchar2 default hr_api.g_varchar2
108: ,p_attribute1 in varchar2 default hr_api.g_varchar2
109: ,p_attribute2 in varchar2 default hr_api.g_varchar2
110: ,p_attribute3 in varchar2 default hr_api.g_varchar2
111: ,p_attribute4 in varchar2 default hr_api.g_varchar2
112: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 109: ,p_attribute2 in varchar2 default hr_api.g_varchar2

105: ,p_allow_add_recipients in varchar2
106: ,p_default_moderator in varchar2
107: ,p_attribute_category in varchar2 default hr_api.g_varchar2
108: ,p_attribute1 in varchar2 default hr_api.g_varchar2
109: ,p_attribute2 in varchar2 default hr_api.g_varchar2
110: ,p_attribute3 in varchar2 default hr_api.g_varchar2
111: ,p_attribute4 in varchar2 default hr_api.g_varchar2
112: ,p_attribute5 in varchar2 default hr_api.g_varchar2
113: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 110: ,p_attribute3 in varchar2 default hr_api.g_varchar2

106: ,p_default_moderator in varchar2
107: ,p_attribute_category in varchar2 default hr_api.g_varchar2
108: ,p_attribute1 in varchar2 default hr_api.g_varchar2
109: ,p_attribute2 in varchar2 default hr_api.g_varchar2
110: ,p_attribute3 in varchar2 default hr_api.g_varchar2
111: ,p_attribute4 in varchar2 default hr_api.g_varchar2
112: ,p_attribute5 in varchar2 default hr_api.g_varchar2
113: ,p_attribute6 in varchar2 default hr_api.g_varchar2
114: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 111: ,p_attribute4 in varchar2 default hr_api.g_varchar2

107: ,p_attribute_category in varchar2 default hr_api.g_varchar2
108: ,p_attribute1 in varchar2 default hr_api.g_varchar2
109: ,p_attribute2 in varchar2 default hr_api.g_varchar2
110: ,p_attribute3 in varchar2 default hr_api.g_varchar2
111: ,p_attribute4 in varchar2 default hr_api.g_varchar2
112: ,p_attribute5 in varchar2 default hr_api.g_varchar2
113: ,p_attribute6 in varchar2 default hr_api.g_varchar2
114: ,p_attribute7 in varchar2 default hr_api.g_varchar2
115: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 112: ,p_attribute5 in varchar2 default hr_api.g_varchar2

108: ,p_attribute1 in varchar2 default hr_api.g_varchar2
109: ,p_attribute2 in varchar2 default hr_api.g_varchar2
110: ,p_attribute3 in varchar2 default hr_api.g_varchar2
111: ,p_attribute4 in varchar2 default hr_api.g_varchar2
112: ,p_attribute5 in varchar2 default hr_api.g_varchar2
113: ,p_attribute6 in varchar2 default hr_api.g_varchar2
114: ,p_attribute7 in varchar2 default hr_api.g_varchar2
115: ,p_attribute8 in varchar2 default hr_api.g_varchar2
116: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 113: ,p_attribute6 in varchar2 default hr_api.g_varchar2

109: ,p_attribute2 in varchar2 default hr_api.g_varchar2
110: ,p_attribute3 in varchar2 default hr_api.g_varchar2
111: ,p_attribute4 in varchar2 default hr_api.g_varchar2
112: ,p_attribute5 in varchar2 default hr_api.g_varchar2
113: ,p_attribute6 in varchar2 default hr_api.g_varchar2
114: ,p_attribute7 in varchar2 default hr_api.g_varchar2
115: ,p_attribute8 in varchar2 default hr_api.g_varchar2
116: ,p_attribute9 in varchar2 default hr_api.g_varchar2
117: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 114: ,p_attribute7 in varchar2 default hr_api.g_varchar2

110: ,p_attribute3 in varchar2 default hr_api.g_varchar2
111: ,p_attribute4 in varchar2 default hr_api.g_varchar2
112: ,p_attribute5 in varchar2 default hr_api.g_varchar2
113: ,p_attribute6 in varchar2 default hr_api.g_varchar2
114: ,p_attribute7 in varchar2 default hr_api.g_varchar2
115: ,p_attribute8 in varchar2 default hr_api.g_varchar2
116: ,p_attribute9 in varchar2 default hr_api.g_varchar2
117: ,p_attribute10 in varchar2 default hr_api.g_varchar2
118: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 115: ,p_attribute8 in varchar2 default hr_api.g_varchar2

111: ,p_attribute4 in varchar2 default hr_api.g_varchar2
112: ,p_attribute5 in varchar2 default hr_api.g_varchar2
113: ,p_attribute6 in varchar2 default hr_api.g_varchar2
114: ,p_attribute7 in varchar2 default hr_api.g_varchar2
115: ,p_attribute8 in varchar2 default hr_api.g_varchar2
116: ,p_attribute9 in varchar2 default hr_api.g_varchar2
117: ,p_attribute10 in varchar2 default hr_api.g_varchar2
118: ,p_information_category in varchar2 default hr_api.g_varchar2
119: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 116: ,p_attribute9 in varchar2 default hr_api.g_varchar2

112: ,p_attribute5 in varchar2 default hr_api.g_varchar2
113: ,p_attribute6 in varchar2 default hr_api.g_varchar2
114: ,p_attribute7 in varchar2 default hr_api.g_varchar2
115: ,p_attribute8 in varchar2 default hr_api.g_varchar2
116: ,p_attribute9 in varchar2 default hr_api.g_varchar2
117: ,p_attribute10 in varchar2 default hr_api.g_varchar2
118: ,p_information_category in varchar2 default hr_api.g_varchar2
119: ,p_information1 in varchar2 default hr_api.g_varchar2
120: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 117: ,p_attribute10 in varchar2 default hr_api.g_varchar2

113: ,p_attribute6 in varchar2 default hr_api.g_varchar2
114: ,p_attribute7 in varchar2 default hr_api.g_varchar2
115: ,p_attribute8 in varchar2 default hr_api.g_varchar2
116: ,p_attribute9 in varchar2 default hr_api.g_varchar2
117: ,p_attribute10 in varchar2 default hr_api.g_varchar2
118: ,p_information_category in varchar2 default hr_api.g_varchar2
119: ,p_information1 in varchar2 default hr_api.g_varchar2
120: ,p_information2 in varchar2 default hr_api.g_varchar2
121: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 118: ,p_information_category in varchar2 default hr_api.g_varchar2

114: ,p_attribute7 in varchar2 default hr_api.g_varchar2
115: ,p_attribute8 in varchar2 default hr_api.g_varchar2
116: ,p_attribute9 in varchar2 default hr_api.g_varchar2
117: ,p_attribute10 in varchar2 default hr_api.g_varchar2
118: ,p_information_category in varchar2 default hr_api.g_varchar2
119: ,p_information1 in varchar2 default hr_api.g_varchar2
120: ,p_information2 in varchar2 default hr_api.g_varchar2
121: ,p_information3 in varchar2 default hr_api.g_varchar2
122: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 119: ,p_information1 in varchar2 default hr_api.g_varchar2

115: ,p_attribute8 in varchar2 default hr_api.g_varchar2
116: ,p_attribute9 in varchar2 default hr_api.g_varchar2
117: ,p_attribute10 in varchar2 default hr_api.g_varchar2
118: ,p_information_category in varchar2 default hr_api.g_varchar2
119: ,p_information1 in varchar2 default hr_api.g_varchar2
120: ,p_information2 in varchar2 default hr_api.g_varchar2
121: ,p_information3 in varchar2 default hr_api.g_varchar2
122: ,p_information4 in varchar2 default hr_api.g_varchar2
123: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 120: ,p_information2 in varchar2 default hr_api.g_varchar2

116: ,p_attribute9 in varchar2 default hr_api.g_varchar2
117: ,p_attribute10 in varchar2 default hr_api.g_varchar2
118: ,p_information_category in varchar2 default hr_api.g_varchar2
119: ,p_information1 in varchar2 default hr_api.g_varchar2
120: ,p_information2 in varchar2 default hr_api.g_varchar2
121: ,p_information3 in varchar2 default hr_api.g_varchar2
122: ,p_information4 in varchar2 default hr_api.g_varchar2
123: ,p_information5 in varchar2 default hr_api.g_varchar2
124: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 121: ,p_information3 in varchar2 default hr_api.g_varchar2

117: ,p_attribute10 in varchar2 default hr_api.g_varchar2
118: ,p_information_category in varchar2 default hr_api.g_varchar2
119: ,p_information1 in varchar2 default hr_api.g_varchar2
120: ,p_information2 in varchar2 default hr_api.g_varchar2
121: ,p_information3 in varchar2 default hr_api.g_varchar2
122: ,p_information4 in varchar2 default hr_api.g_varchar2
123: ,p_information5 in varchar2 default hr_api.g_varchar2
124: ,p_information6 in varchar2 default hr_api.g_varchar2
125: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 122: ,p_information4 in varchar2 default hr_api.g_varchar2

118: ,p_information_category in varchar2 default hr_api.g_varchar2
119: ,p_information1 in varchar2 default hr_api.g_varchar2
120: ,p_information2 in varchar2 default hr_api.g_varchar2
121: ,p_information3 in varchar2 default hr_api.g_varchar2
122: ,p_information4 in varchar2 default hr_api.g_varchar2
123: ,p_information5 in varchar2 default hr_api.g_varchar2
124: ,p_information6 in varchar2 default hr_api.g_varchar2
125: ,p_information7 in varchar2 default hr_api.g_varchar2
126: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 123: ,p_information5 in varchar2 default hr_api.g_varchar2

119: ,p_information1 in varchar2 default hr_api.g_varchar2
120: ,p_information2 in varchar2 default hr_api.g_varchar2
121: ,p_information3 in varchar2 default hr_api.g_varchar2
122: ,p_information4 in varchar2 default hr_api.g_varchar2
123: ,p_information5 in varchar2 default hr_api.g_varchar2
124: ,p_information6 in varchar2 default hr_api.g_varchar2
125: ,p_information7 in varchar2 default hr_api.g_varchar2
126: ,p_information8 in varchar2 default hr_api.g_varchar2
127: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 124: ,p_information6 in varchar2 default hr_api.g_varchar2

120: ,p_information2 in varchar2 default hr_api.g_varchar2
121: ,p_information3 in varchar2 default hr_api.g_varchar2
122: ,p_information4 in varchar2 default hr_api.g_varchar2
123: ,p_information5 in varchar2 default hr_api.g_varchar2
124: ,p_information6 in varchar2 default hr_api.g_varchar2
125: ,p_information7 in varchar2 default hr_api.g_varchar2
126: ,p_information8 in varchar2 default hr_api.g_varchar2
127: ,p_information9 in varchar2 default hr_api.g_varchar2
128: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 125: ,p_information7 in varchar2 default hr_api.g_varchar2

121: ,p_information3 in varchar2 default hr_api.g_varchar2
122: ,p_information4 in varchar2 default hr_api.g_varchar2
123: ,p_information5 in varchar2 default hr_api.g_varchar2
124: ,p_information6 in varchar2 default hr_api.g_varchar2
125: ,p_information7 in varchar2 default hr_api.g_varchar2
126: ,p_information8 in varchar2 default hr_api.g_varchar2
127: ,p_information9 in varchar2 default hr_api.g_varchar2
128: ,p_information10 in varchar2 default hr_api.g_varchar2
129: ,p_communication_property_id in number

Line 126: ,p_information8 in varchar2 default hr_api.g_varchar2

122: ,p_information4 in varchar2 default hr_api.g_varchar2
123: ,p_information5 in varchar2 default hr_api.g_varchar2
124: ,p_information6 in varchar2 default hr_api.g_varchar2
125: ,p_information7 in varchar2 default hr_api.g_varchar2
126: ,p_information8 in varchar2 default hr_api.g_varchar2
127: ,p_information9 in varchar2 default hr_api.g_varchar2
128: ,p_information10 in varchar2 default hr_api.g_varchar2
129: ,p_communication_property_id in number
130: ,p_object_version_number out nocopy number

Line 127: ,p_information9 in varchar2 default hr_api.g_varchar2

123: ,p_information5 in varchar2 default hr_api.g_varchar2
124: ,p_information6 in varchar2 default hr_api.g_varchar2
125: ,p_information7 in varchar2 default hr_api.g_varchar2
126: ,p_information8 in varchar2 default hr_api.g_varchar2
127: ,p_information9 in varchar2 default hr_api.g_varchar2
128: ,p_information10 in varchar2 default hr_api.g_varchar2
129: ,p_communication_property_id in number
130: ,p_object_version_number out nocopy number
131: ,p_return_status out nocopy varchar2

Line 128: ,p_information10 in varchar2 default hr_api.g_varchar2

124: ,p_information6 in varchar2 default hr_api.g_varchar2
125: ,p_information7 in varchar2 default hr_api.g_varchar2
126: ,p_information8 in varchar2 default hr_api.g_varchar2
127: ,p_information9 in varchar2 default hr_api.g_varchar2
128: ,p_information10 in varchar2 default hr_api.g_varchar2
129: ,p_communication_property_id in number
130: ,p_object_version_number out nocopy number
131: ,p_return_status out nocopy varchar2
132: );

Line 157: (p_validate in number default hr_api.g_false_num

153: --
154: -- {End of comments}
155: -- ----------------------------------------------------------------------------
156: PROCEDURE create_communication
157: (p_validate in number default hr_api.g_false_num
158: ,p_effective_date in date
159: ,p_communication_property_id in number
160: ,p_object_type in varchar2
161: ,p_object_id in number

Line 192: (p_validate in number default hr_api.g_false_num

188: --
189: -- {End of comments}
190: -- ----------------------------------------------------------------------------
191: PROCEDURE update_comm_properties
192: (p_validate in number default hr_api.g_false_num
193: ,p_effective_date in date
194: ,p_object_type in varchar2
195: ,p_object_id in number
196: ,p_default_comm_status in varchar2

Line 201: ,p_attribute_category in varchar2 default hr_api.g_varchar2

197: ,p_allow_attachment_flag in varchar2
198: ,p_auto_notification_flag in varchar2
199: ,p_allow_add_recipients in varchar2
200: ,p_default_moderator in varchar2
201: ,p_attribute_category in varchar2 default hr_api.g_varchar2
202: ,p_attribute1 in varchar2 default hr_api.g_varchar2
203: ,p_attribute2 in varchar2 default hr_api.g_varchar2
204: ,p_attribute3 in varchar2 default hr_api.g_varchar2
205: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 202: ,p_attribute1 in varchar2 default hr_api.g_varchar2

198: ,p_auto_notification_flag in varchar2
199: ,p_allow_add_recipients in varchar2
200: ,p_default_moderator in varchar2
201: ,p_attribute_category in varchar2 default hr_api.g_varchar2
202: ,p_attribute1 in varchar2 default hr_api.g_varchar2
203: ,p_attribute2 in varchar2 default hr_api.g_varchar2
204: ,p_attribute3 in varchar2 default hr_api.g_varchar2
205: ,p_attribute4 in varchar2 default hr_api.g_varchar2
206: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 203: ,p_attribute2 in varchar2 default hr_api.g_varchar2

199: ,p_allow_add_recipients in varchar2
200: ,p_default_moderator in varchar2
201: ,p_attribute_category in varchar2 default hr_api.g_varchar2
202: ,p_attribute1 in varchar2 default hr_api.g_varchar2
203: ,p_attribute2 in varchar2 default hr_api.g_varchar2
204: ,p_attribute3 in varchar2 default hr_api.g_varchar2
205: ,p_attribute4 in varchar2 default hr_api.g_varchar2
206: ,p_attribute5 in varchar2 default hr_api.g_varchar2
207: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 204: ,p_attribute3 in varchar2 default hr_api.g_varchar2

200: ,p_default_moderator in varchar2
201: ,p_attribute_category in varchar2 default hr_api.g_varchar2
202: ,p_attribute1 in varchar2 default hr_api.g_varchar2
203: ,p_attribute2 in varchar2 default hr_api.g_varchar2
204: ,p_attribute3 in varchar2 default hr_api.g_varchar2
205: ,p_attribute4 in varchar2 default hr_api.g_varchar2
206: ,p_attribute5 in varchar2 default hr_api.g_varchar2
207: ,p_attribute6 in varchar2 default hr_api.g_varchar2
208: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 205: ,p_attribute4 in varchar2 default hr_api.g_varchar2

201: ,p_attribute_category in varchar2 default hr_api.g_varchar2
202: ,p_attribute1 in varchar2 default hr_api.g_varchar2
203: ,p_attribute2 in varchar2 default hr_api.g_varchar2
204: ,p_attribute3 in varchar2 default hr_api.g_varchar2
205: ,p_attribute4 in varchar2 default hr_api.g_varchar2
206: ,p_attribute5 in varchar2 default hr_api.g_varchar2
207: ,p_attribute6 in varchar2 default hr_api.g_varchar2
208: ,p_attribute7 in varchar2 default hr_api.g_varchar2
209: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 206: ,p_attribute5 in varchar2 default hr_api.g_varchar2

202: ,p_attribute1 in varchar2 default hr_api.g_varchar2
203: ,p_attribute2 in varchar2 default hr_api.g_varchar2
204: ,p_attribute3 in varchar2 default hr_api.g_varchar2
205: ,p_attribute4 in varchar2 default hr_api.g_varchar2
206: ,p_attribute5 in varchar2 default hr_api.g_varchar2
207: ,p_attribute6 in varchar2 default hr_api.g_varchar2
208: ,p_attribute7 in varchar2 default hr_api.g_varchar2
209: ,p_attribute8 in varchar2 default hr_api.g_varchar2
210: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 207: ,p_attribute6 in varchar2 default hr_api.g_varchar2

203: ,p_attribute2 in varchar2 default hr_api.g_varchar2
204: ,p_attribute3 in varchar2 default hr_api.g_varchar2
205: ,p_attribute4 in varchar2 default hr_api.g_varchar2
206: ,p_attribute5 in varchar2 default hr_api.g_varchar2
207: ,p_attribute6 in varchar2 default hr_api.g_varchar2
208: ,p_attribute7 in varchar2 default hr_api.g_varchar2
209: ,p_attribute8 in varchar2 default hr_api.g_varchar2
210: ,p_attribute9 in varchar2 default hr_api.g_varchar2
211: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 208: ,p_attribute7 in varchar2 default hr_api.g_varchar2

204: ,p_attribute3 in varchar2 default hr_api.g_varchar2
205: ,p_attribute4 in varchar2 default hr_api.g_varchar2
206: ,p_attribute5 in varchar2 default hr_api.g_varchar2
207: ,p_attribute6 in varchar2 default hr_api.g_varchar2
208: ,p_attribute7 in varchar2 default hr_api.g_varchar2
209: ,p_attribute8 in varchar2 default hr_api.g_varchar2
210: ,p_attribute9 in varchar2 default hr_api.g_varchar2
211: ,p_attribute10 in varchar2 default hr_api.g_varchar2
212: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 209: ,p_attribute8 in varchar2 default hr_api.g_varchar2

205: ,p_attribute4 in varchar2 default hr_api.g_varchar2
206: ,p_attribute5 in varchar2 default hr_api.g_varchar2
207: ,p_attribute6 in varchar2 default hr_api.g_varchar2
208: ,p_attribute7 in varchar2 default hr_api.g_varchar2
209: ,p_attribute8 in varchar2 default hr_api.g_varchar2
210: ,p_attribute9 in varchar2 default hr_api.g_varchar2
211: ,p_attribute10 in varchar2 default hr_api.g_varchar2
212: ,p_information_category in varchar2 default hr_api.g_varchar2
213: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 210: ,p_attribute9 in varchar2 default hr_api.g_varchar2

206: ,p_attribute5 in varchar2 default hr_api.g_varchar2
207: ,p_attribute6 in varchar2 default hr_api.g_varchar2
208: ,p_attribute7 in varchar2 default hr_api.g_varchar2
209: ,p_attribute8 in varchar2 default hr_api.g_varchar2
210: ,p_attribute9 in varchar2 default hr_api.g_varchar2
211: ,p_attribute10 in varchar2 default hr_api.g_varchar2
212: ,p_information_category in varchar2 default hr_api.g_varchar2
213: ,p_information1 in varchar2 default hr_api.g_varchar2
214: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 211: ,p_attribute10 in varchar2 default hr_api.g_varchar2

207: ,p_attribute6 in varchar2 default hr_api.g_varchar2
208: ,p_attribute7 in varchar2 default hr_api.g_varchar2
209: ,p_attribute8 in varchar2 default hr_api.g_varchar2
210: ,p_attribute9 in varchar2 default hr_api.g_varchar2
211: ,p_attribute10 in varchar2 default hr_api.g_varchar2
212: ,p_information_category in varchar2 default hr_api.g_varchar2
213: ,p_information1 in varchar2 default hr_api.g_varchar2
214: ,p_information2 in varchar2 default hr_api.g_varchar2
215: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 212: ,p_information_category in varchar2 default hr_api.g_varchar2

208: ,p_attribute7 in varchar2 default hr_api.g_varchar2
209: ,p_attribute8 in varchar2 default hr_api.g_varchar2
210: ,p_attribute9 in varchar2 default hr_api.g_varchar2
211: ,p_attribute10 in varchar2 default hr_api.g_varchar2
212: ,p_information_category in varchar2 default hr_api.g_varchar2
213: ,p_information1 in varchar2 default hr_api.g_varchar2
214: ,p_information2 in varchar2 default hr_api.g_varchar2
215: ,p_information3 in varchar2 default hr_api.g_varchar2
216: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 213: ,p_information1 in varchar2 default hr_api.g_varchar2

209: ,p_attribute8 in varchar2 default hr_api.g_varchar2
210: ,p_attribute9 in varchar2 default hr_api.g_varchar2
211: ,p_attribute10 in varchar2 default hr_api.g_varchar2
212: ,p_information_category in varchar2 default hr_api.g_varchar2
213: ,p_information1 in varchar2 default hr_api.g_varchar2
214: ,p_information2 in varchar2 default hr_api.g_varchar2
215: ,p_information3 in varchar2 default hr_api.g_varchar2
216: ,p_information4 in varchar2 default hr_api.g_varchar2
217: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 214: ,p_information2 in varchar2 default hr_api.g_varchar2

210: ,p_attribute9 in varchar2 default hr_api.g_varchar2
211: ,p_attribute10 in varchar2 default hr_api.g_varchar2
212: ,p_information_category in varchar2 default hr_api.g_varchar2
213: ,p_information1 in varchar2 default hr_api.g_varchar2
214: ,p_information2 in varchar2 default hr_api.g_varchar2
215: ,p_information3 in varchar2 default hr_api.g_varchar2
216: ,p_information4 in varchar2 default hr_api.g_varchar2
217: ,p_information5 in varchar2 default hr_api.g_varchar2
218: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 215: ,p_information3 in varchar2 default hr_api.g_varchar2

211: ,p_attribute10 in varchar2 default hr_api.g_varchar2
212: ,p_information_category in varchar2 default hr_api.g_varchar2
213: ,p_information1 in varchar2 default hr_api.g_varchar2
214: ,p_information2 in varchar2 default hr_api.g_varchar2
215: ,p_information3 in varchar2 default hr_api.g_varchar2
216: ,p_information4 in varchar2 default hr_api.g_varchar2
217: ,p_information5 in varchar2 default hr_api.g_varchar2
218: ,p_information6 in varchar2 default hr_api.g_varchar2
219: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 216: ,p_information4 in varchar2 default hr_api.g_varchar2

212: ,p_information_category in varchar2 default hr_api.g_varchar2
213: ,p_information1 in varchar2 default hr_api.g_varchar2
214: ,p_information2 in varchar2 default hr_api.g_varchar2
215: ,p_information3 in varchar2 default hr_api.g_varchar2
216: ,p_information4 in varchar2 default hr_api.g_varchar2
217: ,p_information5 in varchar2 default hr_api.g_varchar2
218: ,p_information6 in varchar2 default hr_api.g_varchar2
219: ,p_information7 in varchar2 default hr_api.g_varchar2
220: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 217: ,p_information5 in varchar2 default hr_api.g_varchar2

213: ,p_information1 in varchar2 default hr_api.g_varchar2
214: ,p_information2 in varchar2 default hr_api.g_varchar2
215: ,p_information3 in varchar2 default hr_api.g_varchar2
216: ,p_information4 in varchar2 default hr_api.g_varchar2
217: ,p_information5 in varchar2 default hr_api.g_varchar2
218: ,p_information6 in varchar2 default hr_api.g_varchar2
219: ,p_information7 in varchar2 default hr_api.g_varchar2
220: ,p_information8 in varchar2 default hr_api.g_varchar2
221: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 218: ,p_information6 in varchar2 default hr_api.g_varchar2

214: ,p_information2 in varchar2 default hr_api.g_varchar2
215: ,p_information3 in varchar2 default hr_api.g_varchar2
216: ,p_information4 in varchar2 default hr_api.g_varchar2
217: ,p_information5 in varchar2 default hr_api.g_varchar2
218: ,p_information6 in varchar2 default hr_api.g_varchar2
219: ,p_information7 in varchar2 default hr_api.g_varchar2
220: ,p_information8 in varchar2 default hr_api.g_varchar2
221: ,p_information9 in varchar2 default hr_api.g_varchar2
222: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 219: ,p_information7 in varchar2 default hr_api.g_varchar2

215: ,p_information3 in varchar2 default hr_api.g_varchar2
216: ,p_information4 in varchar2 default hr_api.g_varchar2
217: ,p_information5 in varchar2 default hr_api.g_varchar2
218: ,p_information6 in varchar2 default hr_api.g_varchar2
219: ,p_information7 in varchar2 default hr_api.g_varchar2
220: ,p_information8 in varchar2 default hr_api.g_varchar2
221: ,p_information9 in varchar2 default hr_api.g_varchar2
222: ,p_information10 in varchar2 default hr_api.g_varchar2
223: ,p_communication_property_id in number

Line 220: ,p_information8 in varchar2 default hr_api.g_varchar2

216: ,p_information4 in varchar2 default hr_api.g_varchar2
217: ,p_information5 in varchar2 default hr_api.g_varchar2
218: ,p_information6 in varchar2 default hr_api.g_varchar2
219: ,p_information7 in varchar2 default hr_api.g_varchar2
220: ,p_information8 in varchar2 default hr_api.g_varchar2
221: ,p_information9 in varchar2 default hr_api.g_varchar2
222: ,p_information10 in varchar2 default hr_api.g_varchar2
223: ,p_communication_property_id in number
224: ,p_object_version_number in out nocopy number

Line 221: ,p_information9 in varchar2 default hr_api.g_varchar2

217: ,p_information5 in varchar2 default hr_api.g_varchar2
218: ,p_information6 in varchar2 default hr_api.g_varchar2
219: ,p_information7 in varchar2 default hr_api.g_varchar2
220: ,p_information8 in varchar2 default hr_api.g_varchar2
221: ,p_information9 in varchar2 default hr_api.g_varchar2
222: ,p_information10 in varchar2 default hr_api.g_varchar2
223: ,p_communication_property_id in number
224: ,p_object_version_number in out nocopy number
225: ,p_return_status out nocopy varchar2

Line 222: ,p_information10 in varchar2 default hr_api.g_varchar2

218: ,p_information6 in varchar2 default hr_api.g_varchar2
219: ,p_information7 in varchar2 default hr_api.g_varchar2
220: ,p_information8 in varchar2 default hr_api.g_varchar2
221: ,p_information9 in varchar2 default hr_api.g_varchar2
222: ,p_information10 in varchar2 default hr_api.g_varchar2
223: ,p_communication_property_id in number
224: ,p_object_version_number in out nocopy number
225: ,p_return_status out nocopy varchar2
226: );

Line 251: (p_validate in number default hr_api.g_false_num

247: --
248: -- {End of comments}
249: -- ----------------------------------------------------------------------------
250: PROCEDURE delete_comm_properties
251: (p_validate in number default hr_api.g_false_num
252: ,p_object_version_number in number
253: ,p_communication_property_id in number
254: ,p_effective_date in date default hr_api.g_date
255: ,p_return_status out nocopy varchar2

Line 254: ,p_effective_date in date default hr_api.g_date

250: PROCEDURE delete_comm_properties
251: (p_validate in number default hr_api.g_false_num
252: ,p_object_version_number in number
253: ,p_communication_property_id in number
254: ,p_effective_date in date default hr_api.g_date
255: ,p_return_status out nocopy varchar2
256: );
257:
258: --

Line 264: (p_validate in number default hr_api.g_false_num

260: -- |----------------------------< create_comm_topic >------------------------------|
261: -- ----------------------------------------------------------------------------
262: --
263: procedure create_comm_topic
264: (p_validate in number default hr_api.g_false_num
265: ,p_effective_date in date
266: ,p_communication_id in number
267: ,p_subject in varchar2
268: ,p_status in varchar2

Line 279: (p_validate in number default hr_api.g_false_num

275: -- |----------------------------< CREATE_MESSAGE >-----------------------------|
276: -- ----------------------------------------------------------------------------
277: --
278: procedure create_message
279: (p_validate in number default hr_api.g_false_num
280: ,p_effective_date in date
281: ,p_communication_topic_id in number
282: ,p_parent_id in number default hr_api.g_number
283: ,p_message_subject in varchar2 default hr_api.g_varchar2

Line 282: ,p_parent_id in number default hr_api.g_number

278: procedure create_message
279: (p_validate in number default hr_api.g_false_num
280: ,p_effective_date in date
281: ,p_communication_topic_id in number
282: ,p_parent_id in number default hr_api.g_number
283: ,p_message_subject in varchar2 default hr_api.g_varchar2
284: ,p_message_post_date in date
285: ,p_sender_type in varchar2
286: ,p_sender_id in number

Line 283: ,p_message_subject in varchar2 default hr_api.g_varchar2

279: (p_validate in number default hr_api.g_false_num
280: ,p_effective_date in date
281: ,p_communication_topic_id in number
282: ,p_parent_id in number default hr_api.g_number
283: ,p_message_subject in varchar2 default hr_api.g_varchar2
284: ,p_message_post_date in date
285: ,p_sender_type in varchar2
286: ,p_sender_id in number
287: ,p_message_body in varchar2 default hr_api.g_varchar2

Line 287: ,p_message_body in varchar2 default hr_api.g_varchar2

283: ,p_message_subject in varchar2 default hr_api.g_varchar2
284: ,p_message_post_date in date
285: ,p_sender_type in varchar2
286: ,p_sender_id in number
287: ,p_message_body in varchar2 default hr_api.g_varchar2
288: ,p_document_type in varchar2 default hr_api.g_varchar2
289: ,p_document_id in number default hr_api.g_number
290: ,p_deleted_flag in varchar2 default hr_api.g_varchar2
291: ,p_communication_message_id in number

Line 288: ,p_document_type in varchar2 default hr_api.g_varchar2

284: ,p_message_post_date in date
285: ,p_sender_type in varchar2
286: ,p_sender_id in number
287: ,p_message_body in varchar2 default hr_api.g_varchar2
288: ,p_document_type in varchar2 default hr_api.g_varchar2
289: ,p_document_id in number default hr_api.g_number
290: ,p_deleted_flag in varchar2 default hr_api.g_varchar2
291: ,p_communication_message_id in number
292: ,p_object_version_number out nocopy number

Line 289: ,p_document_id in number default hr_api.g_number

285: ,p_sender_type in varchar2
286: ,p_sender_id in number
287: ,p_message_body in varchar2 default hr_api.g_varchar2
288: ,p_document_type in varchar2 default hr_api.g_varchar2
289: ,p_document_id in number default hr_api.g_number
290: ,p_deleted_flag in varchar2 default hr_api.g_varchar2
291: ,p_communication_message_id in number
292: ,p_object_version_number out nocopy number
293: ,p_return_status out nocopy varchar2

Line 290: ,p_deleted_flag in varchar2 default hr_api.g_varchar2

286: ,p_sender_id in number
287: ,p_message_body in varchar2 default hr_api.g_varchar2
288: ,p_document_type in varchar2 default hr_api.g_varchar2
289: ,p_document_id in number default hr_api.g_number
290: ,p_deleted_flag in varchar2 default hr_api.g_varchar2
291: ,p_communication_message_id in number
292: ,p_object_version_number out nocopy number
293: ,p_return_status out nocopy varchar2
294: );

Line 301: (p_validate in number default hr_api.g_false_num

297: -- |----------------------------< UPDATE_MESSAGE >----------------------------|
298: -- ----------------------------------------------------------------------------
299: --
300: procedure update_message
301: (p_validate in number default hr_api.g_false_num
302: ,p_effective_date in date
303: ,p_deleted_flag in varchar2 default hr_api.g_varchar2
304: ,p_communication_message_id in number
305: ,p_object_version_number in out nocopy number

Line 303: ,p_deleted_flag in varchar2 default hr_api.g_varchar2

299: --
300: procedure update_message
301: (p_validate in number default hr_api.g_false_num
302: ,p_effective_date in date
303: ,p_deleted_flag in varchar2 default hr_api.g_varchar2
304: ,p_communication_message_id in number
305: ,p_object_version_number in out nocopy number
306: ,p_return_status out nocopy varchar2
307: );

Line 314: (p_validate in number default hr_api.g_false_num

310: -- |----------------------------< ADD_RECIPIENT >-----------------------------|
311: -- ----------------------------------------------------------------------------
312: --
313: procedure ADD_RECIPIENT
314: (p_validate in number default hr_api.g_false_num
315: ,p_effective_date in date
316: ,p_communication_object_type in varchar2
317: ,p_communication_object_id in number
318: ,p_recipient_type in varchar2

Line 321: ,p_end_date_active in date default hr_api.g_date

317: ,p_communication_object_id in number
318: ,p_recipient_type in varchar2
319: ,p_recipient_id in number
320: ,p_start_date_active in date
321: ,p_end_date_active in date default hr_api.g_date
322: ,p_primary_flag in varchar2 default hr_api.g_varchar2
323: ,p_communication_recipient_id in number
324: ,p_object_version_number out nocopy number
325: ,p_return_status out nocopy varchar2

Line 322: ,p_primary_flag in varchar2 default hr_api.g_varchar2

318: ,p_recipient_type in varchar2
319: ,p_recipient_id in number
320: ,p_start_date_active in date
321: ,p_end_date_active in date default hr_api.g_date
322: ,p_primary_flag in varchar2 default hr_api.g_varchar2
323: ,p_communication_recipient_id in number
324: ,p_object_version_number out nocopy number
325: ,p_return_status out nocopy varchar2
326: );

Line 336: ,p_validate in number default hr_api.g_false_num

332: procedure process_com_api
333: (
334: p_document in CLOB
335: ,p_return_status out nocopy VARCHAR2
336: ,p_validate in number default hr_api.g_false_num
337: ,p_effective_date in date default null
338: );
339: --
340: -- ----------------------------------------------------------------------------