eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_COMMUNICATIONS_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< close_communication >-------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE close_communication
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_communication_property_id in number
15: ,p_object_type in varchar2
16: ,p_object_id in number

Line 50: hr_api.constant_to_boolean

46: --
47: -- Convert constant values to their corresponding boolean value
48: --
49: l_validate :=
50: hr_api.constant_to_boolean
51: (p_constant_value => p_validate);
52: --
53: -- Register Surrogate ID or user key values
54: --

Line 124: (p_validate in number default hr_api.g_false_num

120: -- ----------------------------------------------------------------------------
121: -- |--------------------------< update_communication >-------------------------|
122: -- ----------------------------------------------------------------------------
123: PROCEDURE update_communication
124: (p_validate in number default hr_api.g_false_num
125: ,p_effective_date in date
126: ,p_communication_property_id in number
127: ,p_object_type in varchar2
128: ,p_object_id in number

Line 164: hr_api.constant_to_boolean

160: --
161: -- Convert constant values to their corresponding boolean value
162: --
163: l_validate :=
164: hr_api.constant_to_boolean
165: (p_constant_value => p_validate);
166: --
167: -- Register Surrogate ID or user key values
168: --

Line 242: (p_validate in number default hr_api.g_false_num

238: -- ----------------------------------------------------------------------------
239: -- |------------------------< define_comm_properties >------------------------|
240: -- ----------------------------------------------------------------------------
241: PROCEDURE define_comm_properties
242: (p_validate in number default hr_api.g_false_num
243: ,p_effective_date in date
244: ,p_object_type in varchar2
245: ,p_object_id in number
246: ,p_default_comm_status in varchar2

Line 251: ,p_attribute_category in varchar2 default hr_api.g_varchar2

247: ,p_allow_attachment_flag in varchar2
248: ,p_auto_notification_flag in varchar2
249: ,p_allow_add_recipients in varchar2
250: ,p_default_moderator in varchar2
251: ,p_attribute_category in varchar2 default hr_api.g_varchar2
252: ,p_attribute1 in varchar2 default hr_api.g_varchar2
253: ,p_attribute2 in varchar2 default hr_api.g_varchar2
254: ,p_attribute3 in varchar2 default hr_api.g_varchar2
255: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 252: ,p_attribute1 in varchar2 default hr_api.g_varchar2

248: ,p_auto_notification_flag in varchar2
249: ,p_allow_add_recipients in varchar2
250: ,p_default_moderator in varchar2
251: ,p_attribute_category in varchar2 default hr_api.g_varchar2
252: ,p_attribute1 in varchar2 default hr_api.g_varchar2
253: ,p_attribute2 in varchar2 default hr_api.g_varchar2
254: ,p_attribute3 in varchar2 default hr_api.g_varchar2
255: ,p_attribute4 in varchar2 default hr_api.g_varchar2
256: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 253: ,p_attribute2 in varchar2 default hr_api.g_varchar2

249: ,p_allow_add_recipients in varchar2
250: ,p_default_moderator in varchar2
251: ,p_attribute_category in varchar2 default hr_api.g_varchar2
252: ,p_attribute1 in varchar2 default hr_api.g_varchar2
253: ,p_attribute2 in varchar2 default hr_api.g_varchar2
254: ,p_attribute3 in varchar2 default hr_api.g_varchar2
255: ,p_attribute4 in varchar2 default hr_api.g_varchar2
256: ,p_attribute5 in varchar2 default hr_api.g_varchar2
257: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 254: ,p_attribute3 in varchar2 default hr_api.g_varchar2

250: ,p_default_moderator in varchar2
251: ,p_attribute_category in varchar2 default hr_api.g_varchar2
252: ,p_attribute1 in varchar2 default hr_api.g_varchar2
253: ,p_attribute2 in varchar2 default hr_api.g_varchar2
254: ,p_attribute3 in varchar2 default hr_api.g_varchar2
255: ,p_attribute4 in varchar2 default hr_api.g_varchar2
256: ,p_attribute5 in varchar2 default hr_api.g_varchar2
257: ,p_attribute6 in varchar2 default hr_api.g_varchar2
258: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 255: ,p_attribute4 in varchar2 default hr_api.g_varchar2

251: ,p_attribute_category in varchar2 default hr_api.g_varchar2
252: ,p_attribute1 in varchar2 default hr_api.g_varchar2
253: ,p_attribute2 in varchar2 default hr_api.g_varchar2
254: ,p_attribute3 in varchar2 default hr_api.g_varchar2
255: ,p_attribute4 in varchar2 default hr_api.g_varchar2
256: ,p_attribute5 in varchar2 default hr_api.g_varchar2
257: ,p_attribute6 in varchar2 default hr_api.g_varchar2
258: ,p_attribute7 in varchar2 default hr_api.g_varchar2
259: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 256: ,p_attribute5 in varchar2 default hr_api.g_varchar2

252: ,p_attribute1 in varchar2 default hr_api.g_varchar2
253: ,p_attribute2 in varchar2 default hr_api.g_varchar2
254: ,p_attribute3 in varchar2 default hr_api.g_varchar2
255: ,p_attribute4 in varchar2 default hr_api.g_varchar2
256: ,p_attribute5 in varchar2 default hr_api.g_varchar2
257: ,p_attribute6 in varchar2 default hr_api.g_varchar2
258: ,p_attribute7 in varchar2 default hr_api.g_varchar2
259: ,p_attribute8 in varchar2 default hr_api.g_varchar2
260: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 257: ,p_attribute6 in varchar2 default hr_api.g_varchar2

253: ,p_attribute2 in varchar2 default hr_api.g_varchar2
254: ,p_attribute3 in varchar2 default hr_api.g_varchar2
255: ,p_attribute4 in varchar2 default hr_api.g_varchar2
256: ,p_attribute5 in varchar2 default hr_api.g_varchar2
257: ,p_attribute6 in varchar2 default hr_api.g_varchar2
258: ,p_attribute7 in varchar2 default hr_api.g_varchar2
259: ,p_attribute8 in varchar2 default hr_api.g_varchar2
260: ,p_attribute9 in varchar2 default hr_api.g_varchar2
261: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 258: ,p_attribute7 in varchar2 default hr_api.g_varchar2

254: ,p_attribute3 in varchar2 default hr_api.g_varchar2
255: ,p_attribute4 in varchar2 default hr_api.g_varchar2
256: ,p_attribute5 in varchar2 default hr_api.g_varchar2
257: ,p_attribute6 in varchar2 default hr_api.g_varchar2
258: ,p_attribute7 in varchar2 default hr_api.g_varchar2
259: ,p_attribute8 in varchar2 default hr_api.g_varchar2
260: ,p_attribute9 in varchar2 default hr_api.g_varchar2
261: ,p_attribute10 in varchar2 default hr_api.g_varchar2
262: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 259: ,p_attribute8 in varchar2 default hr_api.g_varchar2

255: ,p_attribute4 in varchar2 default hr_api.g_varchar2
256: ,p_attribute5 in varchar2 default hr_api.g_varchar2
257: ,p_attribute6 in varchar2 default hr_api.g_varchar2
258: ,p_attribute7 in varchar2 default hr_api.g_varchar2
259: ,p_attribute8 in varchar2 default hr_api.g_varchar2
260: ,p_attribute9 in varchar2 default hr_api.g_varchar2
261: ,p_attribute10 in varchar2 default hr_api.g_varchar2
262: ,p_information_category in varchar2 default hr_api.g_varchar2
263: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 260: ,p_attribute9 in varchar2 default hr_api.g_varchar2

256: ,p_attribute5 in varchar2 default hr_api.g_varchar2
257: ,p_attribute6 in varchar2 default hr_api.g_varchar2
258: ,p_attribute7 in varchar2 default hr_api.g_varchar2
259: ,p_attribute8 in varchar2 default hr_api.g_varchar2
260: ,p_attribute9 in varchar2 default hr_api.g_varchar2
261: ,p_attribute10 in varchar2 default hr_api.g_varchar2
262: ,p_information_category in varchar2 default hr_api.g_varchar2
263: ,p_information1 in varchar2 default hr_api.g_varchar2
264: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 261: ,p_attribute10 in varchar2 default hr_api.g_varchar2

257: ,p_attribute6 in varchar2 default hr_api.g_varchar2
258: ,p_attribute7 in varchar2 default hr_api.g_varchar2
259: ,p_attribute8 in varchar2 default hr_api.g_varchar2
260: ,p_attribute9 in varchar2 default hr_api.g_varchar2
261: ,p_attribute10 in varchar2 default hr_api.g_varchar2
262: ,p_information_category in varchar2 default hr_api.g_varchar2
263: ,p_information1 in varchar2 default hr_api.g_varchar2
264: ,p_information2 in varchar2 default hr_api.g_varchar2
265: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 262: ,p_information_category in varchar2 default hr_api.g_varchar2

258: ,p_attribute7 in varchar2 default hr_api.g_varchar2
259: ,p_attribute8 in varchar2 default hr_api.g_varchar2
260: ,p_attribute9 in varchar2 default hr_api.g_varchar2
261: ,p_attribute10 in varchar2 default hr_api.g_varchar2
262: ,p_information_category in varchar2 default hr_api.g_varchar2
263: ,p_information1 in varchar2 default hr_api.g_varchar2
264: ,p_information2 in varchar2 default hr_api.g_varchar2
265: ,p_information3 in varchar2 default hr_api.g_varchar2
266: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 263: ,p_information1 in varchar2 default hr_api.g_varchar2

259: ,p_attribute8 in varchar2 default hr_api.g_varchar2
260: ,p_attribute9 in varchar2 default hr_api.g_varchar2
261: ,p_attribute10 in varchar2 default hr_api.g_varchar2
262: ,p_information_category in varchar2 default hr_api.g_varchar2
263: ,p_information1 in varchar2 default hr_api.g_varchar2
264: ,p_information2 in varchar2 default hr_api.g_varchar2
265: ,p_information3 in varchar2 default hr_api.g_varchar2
266: ,p_information4 in varchar2 default hr_api.g_varchar2
267: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 264: ,p_information2 in varchar2 default hr_api.g_varchar2

260: ,p_attribute9 in varchar2 default hr_api.g_varchar2
261: ,p_attribute10 in varchar2 default hr_api.g_varchar2
262: ,p_information_category in varchar2 default hr_api.g_varchar2
263: ,p_information1 in varchar2 default hr_api.g_varchar2
264: ,p_information2 in varchar2 default hr_api.g_varchar2
265: ,p_information3 in varchar2 default hr_api.g_varchar2
266: ,p_information4 in varchar2 default hr_api.g_varchar2
267: ,p_information5 in varchar2 default hr_api.g_varchar2
268: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 265: ,p_information3 in varchar2 default hr_api.g_varchar2

261: ,p_attribute10 in varchar2 default hr_api.g_varchar2
262: ,p_information_category in varchar2 default hr_api.g_varchar2
263: ,p_information1 in varchar2 default hr_api.g_varchar2
264: ,p_information2 in varchar2 default hr_api.g_varchar2
265: ,p_information3 in varchar2 default hr_api.g_varchar2
266: ,p_information4 in varchar2 default hr_api.g_varchar2
267: ,p_information5 in varchar2 default hr_api.g_varchar2
268: ,p_information6 in varchar2 default hr_api.g_varchar2
269: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 266: ,p_information4 in varchar2 default hr_api.g_varchar2

262: ,p_information_category in varchar2 default hr_api.g_varchar2
263: ,p_information1 in varchar2 default hr_api.g_varchar2
264: ,p_information2 in varchar2 default hr_api.g_varchar2
265: ,p_information3 in varchar2 default hr_api.g_varchar2
266: ,p_information4 in varchar2 default hr_api.g_varchar2
267: ,p_information5 in varchar2 default hr_api.g_varchar2
268: ,p_information6 in varchar2 default hr_api.g_varchar2
269: ,p_information7 in varchar2 default hr_api.g_varchar2
270: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 267: ,p_information5 in varchar2 default hr_api.g_varchar2

263: ,p_information1 in varchar2 default hr_api.g_varchar2
264: ,p_information2 in varchar2 default hr_api.g_varchar2
265: ,p_information3 in varchar2 default hr_api.g_varchar2
266: ,p_information4 in varchar2 default hr_api.g_varchar2
267: ,p_information5 in varchar2 default hr_api.g_varchar2
268: ,p_information6 in varchar2 default hr_api.g_varchar2
269: ,p_information7 in varchar2 default hr_api.g_varchar2
270: ,p_information8 in varchar2 default hr_api.g_varchar2
271: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 268: ,p_information6 in varchar2 default hr_api.g_varchar2

264: ,p_information2 in varchar2 default hr_api.g_varchar2
265: ,p_information3 in varchar2 default hr_api.g_varchar2
266: ,p_information4 in varchar2 default hr_api.g_varchar2
267: ,p_information5 in varchar2 default hr_api.g_varchar2
268: ,p_information6 in varchar2 default hr_api.g_varchar2
269: ,p_information7 in varchar2 default hr_api.g_varchar2
270: ,p_information8 in varchar2 default hr_api.g_varchar2
271: ,p_information9 in varchar2 default hr_api.g_varchar2
272: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 269: ,p_information7 in varchar2 default hr_api.g_varchar2

265: ,p_information3 in varchar2 default hr_api.g_varchar2
266: ,p_information4 in varchar2 default hr_api.g_varchar2
267: ,p_information5 in varchar2 default hr_api.g_varchar2
268: ,p_information6 in varchar2 default hr_api.g_varchar2
269: ,p_information7 in varchar2 default hr_api.g_varchar2
270: ,p_information8 in varchar2 default hr_api.g_varchar2
271: ,p_information9 in varchar2 default hr_api.g_varchar2
272: ,p_information10 in varchar2 default hr_api.g_varchar2
273: ,p_communication_property_id in number

Line 270: ,p_information8 in varchar2 default hr_api.g_varchar2

266: ,p_information4 in varchar2 default hr_api.g_varchar2
267: ,p_information5 in varchar2 default hr_api.g_varchar2
268: ,p_information6 in varchar2 default hr_api.g_varchar2
269: ,p_information7 in varchar2 default hr_api.g_varchar2
270: ,p_information8 in varchar2 default hr_api.g_varchar2
271: ,p_information9 in varchar2 default hr_api.g_varchar2
272: ,p_information10 in varchar2 default hr_api.g_varchar2
273: ,p_communication_property_id in number
274: ,p_object_version_number out nocopy number

Line 271: ,p_information9 in varchar2 default hr_api.g_varchar2

267: ,p_information5 in varchar2 default hr_api.g_varchar2
268: ,p_information6 in varchar2 default hr_api.g_varchar2
269: ,p_information7 in varchar2 default hr_api.g_varchar2
270: ,p_information8 in varchar2 default hr_api.g_varchar2
271: ,p_information9 in varchar2 default hr_api.g_varchar2
272: ,p_information10 in varchar2 default hr_api.g_varchar2
273: ,p_communication_property_id in number
274: ,p_object_version_number out nocopy number
275: ,p_return_status out nocopy varchar2

Line 272: ,p_information10 in varchar2 default hr_api.g_varchar2

268: ,p_information6 in varchar2 default hr_api.g_varchar2
269: ,p_information7 in varchar2 default hr_api.g_varchar2
270: ,p_information8 in varchar2 default hr_api.g_varchar2
271: ,p_information9 in varchar2 default hr_api.g_varchar2
272: ,p_information10 in varchar2 default hr_api.g_varchar2
273: ,p_communication_property_id in number
274: ,p_object_version_number out nocopy number
275: ,p_return_status out nocopy varchar2
276: ) is

Line 303: hr_api.constant_to_boolean

299: --
300: -- Convert constant values to their corresponding boolean value
301: --
302: l_validate :=
303: hr_api.constant_to_boolean
304: (p_constant_value => p_validate);
305: --
306: -- Register Surrogate ID or user key values
307: --

Line 402: (p_validate in number default hr_api.g_false_num

398: -- ----------------------------------------------------------------------------
399: -- |--------------------------< create_communication >-------------------------|
400: -- ----------------------------------------------------------------------------
401: PROCEDURE create_communication
402: (p_validate in number default hr_api.g_false_num
403: ,p_effective_date in date
404: ,p_communication_property_id in number
405: ,p_object_type in varchar2
406: ,p_object_id in number

Line 439: hr_api.constant_to_boolean

435: --
436: -- Convert constant values to their corresponding boolean value
437: --
438: l_validate :=
439: hr_api.constant_to_boolean
440: (p_constant_value => p_validate);
441: --
442: -- Register Surrogate ID or user key values
443: --

Line 514: (p_validate in number default hr_api.g_false_num

510: -- ----------------------------------------------------------------------------
511: -- |------------------------< update_comm_properties >------------------------|
512: -- ----------------------------------------------------------------------------
513: PROCEDURE update_comm_properties
514: (p_validate in number default hr_api.g_false_num
515: ,p_effective_date in date
516: ,p_object_type in varchar2
517: ,p_object_id in number
518: ,p_default_comm_status in varchar2

Line 523: ,p_attribute_category in varchar2 default hr_api.g_varchar2

519: ,p_allow_attachment_flag in varchar2
520: ,p_auto_notification_flag in varchar2
521: ,p_allow_add_recipients in varchar2
522: ,p_default_moderator in varchar2
523: ,p_attribute_category in varchar2 default hr_api.g_varchar2
524: ,p_attribute1 in varchar2 default hr_api.g_varchar2
525: ,p_attribute2 in varchar2 default hr_api.g_varchar2
526: ,p_attribute3 in varchar2 default hr_api.g_varchar2
527: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 524: ,p_attribute1 in varchar2 default hr_api.g_varchar2

520: ,p_auto_notification_flag in varchar2
521: ,p_allow_add_recipients in varchar2
522: ,p_default_moderator in varchar2
523: ,p_attribute_category in varchar2 default hr_api.g_varchar2
524: ,p_attribute1 in varchar2 default hr_api.g_varchar2
525: ,p_attribute2 in varchar2 default hr_api.g_varchar2
526: ,p_attribute3 in varchar2 default hr_api.g_varchar2
527: ,p_attribute4 in varchar2 default hr_api.g_varchar2
528: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 525: ,p_attribute2 in varchar2 default hr_api.g_varchar2

521: ,p_allow_add_recipients in varchar2
522: ,p_default_moderator in varchar2
523: ,p_attribute_category in varchar2 default hr_api.g_varchar2
524: ,p_attribute1 in varchar2 default hr_api.g_varchar2
525: ,p_attribute2 in varchar2 default hr_api.g_varchar2
526: ,p_attribute3 in varchar2 default hr_api.g_varchar2
527: ,p_attribute4 in varchar2 default hr_api.g_varchar2
528: ,p_attribute5 in varchar2 default hr_api.g_varchar2
529: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 526: ,p_attribute3 in varchar2 default hr_api.g_varchar2

522: ,p_default_moderator in varchar2
523: ,p_attribute_category in varchar2 default hr_api.g_varchar2
524: ,p_attribute1 in varchar2 default hr_api.g_varchar2
525: ,p_attribute2 in varchar2 default hr_api.g_varchar2
526: ,p_attribute3 in varchar2 default hr_api.g_varchar2
527: ,p_attribute4 in varchar2 default hr_api.g_varchar2
528: ,p_attribute5 in varchar2 default hr_api.g_varchar2
529: ,p_attribute6 in varchar2 default hr_api.g_varchar2
530: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 527: ,p_attribute4 in varchar2 default hr_api.g_varchar2

523: ,p_attribute_category in varchar2 default hr_api.g_varchar2
524: ,p_attribute1 in varchar2 default hr_api.g_varchar2
525: ,p_attribute2 in varchar2 default hr_api.g_varchar2
526: ,p_attribute3 in varchar2 default hr_api.g_varchar2
527: ,p_attribute4 in varchar2 default hr_api.g_varchar2
528: ,p_attribute5 in varchar2 default hr_api.g_varchar2
529: ,p_attribute6 in varchar2 default hr_api.g_varchar2
530: ,p_attribute7 in varchar2 default hr_api.g_varchar2
531: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 528: ,p_attribute5 in varchar2 default hr_api.g_varchar2

524: ,p_attribute1 in varchar2 default hr_api.g_varchar2
525: ,p_attribute2 in varchar2 default hr_api.g_varchar2
526: ,p_attribute3 in varchar2 default hr_api.g_varchar2
527: ,p_attribute4 in varchar2 default hr_api.g_varchar2
528: ,p_attribute5 in varchar2 default hr_api.g_varchar2
529: ,p_attribute6 in varchar2 default hr_api.g_varchar2
530: ,p_attribute7 in varchar2 default hr_api.g_varchar2
531: ,p_attribute8 in varchar2 default hr_api.g_varchar2
532: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 529: ,p_attribute6 in varchar2 default hr_api.g_varchar2

525: ,p_attribute2 in varchar2 default hr_api.g_varchar2
526: ,p_attribute3 in varchar2 default hr_api.g_varchar2
527: ,p_attribute4 in varchar2 default hr_api.g_varchar2
528: ,p_attribute5 in varchar2 default hr_api.g_varchar2
529: ,p_attribute6 in varchar2 default hr_api.g_varchar2
530: ,p_attribute7 in varchar2 default hr_api.g_varchar2
531: ,p_attribute8 in varchar2 default hr_api.g_varchar2
532: ,p_attribute9 in varchar2 default hr_api.g_varchar2
533: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 530: ,p_attribute7 in varchar2 default hr_api.g_varchar2

526: ,p_attribute3 in varchar2 default hr_api.g_varchar2
527: ,p_attribute4 in varchar2 default hr_api.g_varchar2
528: ,p_attribute5 in varchar2 default hr_api.g_varchar2
529: ,p_attribute6 in varchar2 default hr_api.g_varchar2
530: ,p_attribute7 in varchar2 default hr_api.g_varchar2
531: ,p_attribute8 in varchar2 default hr_api.g_varchar2
532: ,p_attribute9 in varchar2 default hr_api.g_varchar2
533: ,p_attribute10 in varchar2 default hr_api.g_varchar2
534: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 531: ,p_attribute8 in varchar2 default hr_api.g_varchar2

527: ,p_attribute4 in varchar2 default hr_api.g_varchar2
528: ,p_attribute5 in varchar2 default hr_api.g_varchar2
529: ,p_attribute6 in varchar2 default hr_api.g_varchar2
530: ,p_attribute7 in varchar2 default hr_api.g_varchar2
531: ,p_attribute8 in varchar2 default hr_api.g_varchar2
532: ,p_attribute9 in varchar2 default hr_api.g_varchar2
533: ,p_attribute10 in varchar2 default hr_api.g_varchar2
534: ,p_information_category in varchar2 default hr_api.g_varchar2
535: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 532: ,p_attribute9 in varchar2 default hr_api.g_varchar2

528: ,p_attribute5 in varchar2 default hr_api.g_varchar2
529: ,p_attribute6 in varchar2 default hr_api.g_varchar2
530: ,p_attribute7 in varchar2 default hr_api.g_varchar2
531: ,p_attribute8 in varchar2 default hr_api.g_varchar2
532: ,p_attribute9 in varchar2 default hr_api.g_varchar2
533: ,p_attribute10 in varchar2 default hr_api.g_varchar2
534: ,p_information_category in varchar2 default hr_api.g_varchar2
535: ,p_information1 in varchar2 default hr_api.g_varchar2
536: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 533: ,p_attribute10 in varchar2 default hr_api.g_varchar2

529: ,p_attribute6 in varchar2 default hr_api.g_varchar2
530: ,p_attribute7 in varchar2 default hr_api.g_varchar2
531: ,p_attribute8 in varchar2 default hr_api.g_varchar2
532: ,p_attribute9 in varchar2 default hr_api.g_varchar2
533: ,p_attribute10 in varchar2 default hr_api.g_varchar2
534: ,p_information_category in varchar2 default hr_api.g_varchar2
535: ,p_information1 in varchar2 default hr_api.g_varchar2
536: ,p_information2 in varchar2 default hr_api.g_varchar2
537: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 534: ,p_information_category in varchar2 default hr_api.g_varchar2

530: ,p_attribute7 in varchar2 default hr_api.g_varchar2
531: ,p_attribute8 in varchar2 default hr_api.g_varchar2
532: ,p_attribute9 in varchar2 default hr_api.g_varchar2
533: ,p_attribute10 in varchar2 default hr_api.g_varchar2
534: ,p_information_category in varchar2 default hr_api.g_varchar2
535: ,p_information1 in varchar2 default hr_api.g_varchar2
536: ,p_information2 in varchar2 default hr_api.g_varchar2
537: ,p_information3 in varchar2 default hr_api.g_varchar2
538: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 535: ,p_information1 in varchar2 default hr_api.g_varchar2

531: ,p_attribute8 in varchar2 default hr_api.g_varchar2
532: ,p_attribute9 in varchar2 default hr_api.g_varchar2
533: ,p_attribute10 in varchar2 default hr_api.g_varchar2
534: ,p_information_category in varchar2 default hr_api.g_varchar2
535: ,p_information1 in varchar2 default hr_api.g_varchar2
536: ,p_information2 in varchar2 default hr_api.g_varchar2
537: ,p_information3 in varchar2 default hr_api.g_varchar2
538: ,p_information4 in varchar2 default hr_api.g_varchar2
539: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 536: ,p_information2 in varchar2 default hr_api.g_varchar2

532: ,p_attribute9 in varchar2 default hr_api.g_varchar2
533: ,p_attribute10 in varchar2 default hr_api.g_varchar2
534: ,p_information_category in varchar2 default hr_api.g_varchar2
535: ,p_information1 in varchar2 default hr_api.g_varchar2
536: ,p_information2 in varchar2 default hr_api.g_varchar2
537: ,p_information3 in varchar2 default hr_api.g_varchar2
538: ,p_information4 in varchar2 default hr_api.g_varchar2
539: ,p_information5 in varchar2 default hr_api.g_varchar2
540: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 537: ,p_information3 in varchar2 default hr_api.g_varchar2

533: ,p_attribute10 in varchar2 default hr_api.g_varchar2
534: ,p_information_category in varchar2 default hr_api.g_varchar2
535: ,p_information1 in varchar2 default hr_api.g_varchar2
536: ,p_information2 in varchar2 default hr_api.g_varchar2
537: ,p_information3 in varchar2 default hr_api.g_varchar2
538: ,p_information4 in varchar2 default hr_api.g_varchar2
539: ,p_information5 in varchar2 default hr_api.g_varchar2
540: ,p_information6 in varchar2 default hr_api.g_varchar2
541: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 538: ,p_information4 in varchar2 default hr_api.g_varchar2

534: ,p_information_category in varchar2 default hr_api.g_varchar2
535: ,p_information1 in varchar2 default hr_api.g_varchar2
536: ,p_information2 in varchar2 default hr_api.g_varchar2
537: ,p_information3 in varchar2 default hr_api.g_varchar2
538: ,p_information4 in varchar2 default hr_api.g_varchar2
539: ,p_information5 in varchar2 default hr_api.g_varchar2
540: ,p_information6 in varchar2 default hr_api.g_varchar2
541: ,p_information7 in varchar2 default hr_api.g_varchar2
542: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 539: ,p_information5 in varchar2 default hr_api.g_varchar2

535: ,p_information1 in varchar2 default hr_api.g_varchar2
536: ,p_information2 in varchar2 default hr_api.g_varchar2
537: ,p_information3 in varchar2 default hr_api.g_varchar2
538: ,p_information4 in varchar2 default hr_api.g_varchar2
539: ,p_information5 in varchar2 default hr_api.g_varchar2
540: ,p_information6 in varchar2 default hr_api.g_varchar2
541: ,p_information7 in varchar2 default hr_api.g_varchar2
542: ,p_information8 in varchar2 default hr_api.g_varchar2
543: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 540: ,p_information6 in varchar2 default hr_api.g_varchar2

536: ,p_information2 in varchar2 default hr_api.g_varchar2
537: ,p_information3 in varchar2 default hr_api.g_varchar2
538: ,p_information4 in varchar2 default hr_api.g_varchar2
539: ,p_information5 in varchar2 default hr_api.g_varchar2
540: ,p_information6 in varchar2 default hr_api.g_varchar2
541: ,p_information7 in varchar2 default hr_api.g_varchar2
542: ,p_information8 in varchar2 default hr_api.g_varchar2
543: ,p_information9 in varchar2 default hr_api.g_varchar2
544: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 541: ,p_information7 in varchar2 default hr_api.g_varchar2

537: ,p_information3 in varchar2 default hr_api.g_varchar2
538: ,p_information4 in varchar2 default hr_api.g_varchar2
539: ,p_information5 in varchar2 default hr_api.g_varchar2
540: ,p_information6 in varchar2 default hr_api.g_varchar2
541: ,p_information7 in varchar2 default hr_api.g_varchar2
542: ,p_information8 in varchar2 default hr_api.g_varchar2
543: ,p_information9 in varchar2 default hr_api.g_varchar2
544: ,p_information10 in varchar2 default hr_api.g_varchar2
545: ,p_communication_property_id in number

Line 542: ,p_information8 in varchar2 default hr_api.g_varchar2

538: ,p_information4 in varchar2 default hr_api.g_varchar2
539: ,p_information5 in varchar2 default hr_api.g_varchar2
540: ,p_information6 in varchar2 default hr_api.g_varchar2
541: ,p_information7 in varchar2 default hr_api.g_varchar2
542: ,p_information8 in varchar2 default hr_api.g_varchar2
543: ,p_information9 in varchar2 default hr_api.g_varchar2
544: ,p_information10 in varchar2 default hr_api.g_varchar2
545: ,p_communication_property_id in number
546: ,p_object_version_number in out nocopy number

Line 543: ,p_information9 in varchar2 default hr_api.g_varchar2

539: ,p_information5 in varchar2 default hr_api.g_varchar2
540: ,p_information6 in varchar2 default hr_api.g_varchar2
541: ,p_information7 in varchar2 default hr_api.g_varchar2
542: ,p_information8 in varchar2 default hr_api.g_varchar2
543: ,p_information9 in varchar2 default hr_api.g_varchar2
544: ,p_information10 in varchar2 default hr_api.g_varchar2
545: ,p_communication_property_id in number
546: ,p_object_version_number in out nocopy number
547: ,p_return_status out nocopy varchar2

Line 544: ,p_information10 in varchar2 default hr_api.g_varchar2

540: ,p_information6 in varchar2 default hr_api.g_varchar2
541: ,p_information7 in varchar2 default hr_api.g_varchar2
542: ,p_information8 in varchar2 default hr_api.g_varchar2
543: ,p_information9 in varchar2 default hr_api.g_varchar2
544: ,p_information10 in varchar2 default hr_api.g_varchar2
545: ,p_communication_property_id in number
546: ,p_object_version_number in out nocopy number
547: ,p_return_status out nocopy varchar2
548: ) is

Line 575: hr_api.constant_to_boolean

571: --
572: -- Convert constant values to their corresponding boolean value
573: --
574: l_validate :=
575: hr_api.constant_to_boolean
576: (p_constant_value => p_validate);
577: --
578: -- Register Surrogate ID or user key values
579: --

Line 670: (p_validate in number default hr_api.g_false_num

666: -- ----------------------------------------------------------------------------
667: -- |------------------------< delete_comm_properties >-------------------------|
668: -- ----------------------------------------------------------------------------
669: PROCEDURE delete_comm_properties
670: (p_validate in number default hr_api.g_false_num
671: ,p_object_version_number in number
672: ,p_communication_property_id in number
673: ,p_effective_date in date default hr_api.g_date
674: ,p_return_status out nocopy varchar2

Line 673: ,p_effective_date in date default hr_api.g_date

669: PROCEDURE delete_comm_properties
670: (p_validate in number default hr_api.g_false_num
671: ,p_object_version_number in number
672: ,p_communication_property_id in number
673: ,p_effective_date in date default hr_api.g_date
674: ,p_return_status out nocopy varchar2
675: ) is
676: --
677: -- Variables for API Boolean parameters

Line 701: hr_api.constant_to_boolean

697: --
698: -- Convert constant values to their corresponding boolean value
699: --
700: l_validate :=
701: hr_api.constant_to_boolean
702: (p_constant_value => p_validate);
703: --
704: -- Register Surrogate ID or user key values
705: --

Line 769: (p_validate in number default hr_api.g_false_num

765: -- |----------------------------< create_comm_topic >------------------------------|
766: -- ----------------------------------------------------------------------------
767: --
768: procedure create_comm_topic
769: (p_validate in number default hr_api.g_false_num
770: ,p_effective_date in date
771: ,p_communication_id in number
772: ,p_subject in varchar2
773: ,p_status in varchar2

Line 804: hr_api.constant_to_boolean

800: --
801: -- Convert constant values to their corresponding boolean value
802: --
803: l_validate :=
804: hr_api.constant_to_boolean
805: (p_constant_value => p_validate);
806: --
807: -- Register Surrogate ID or user key values
808: --

Line 879: (p_validate in number default hr_api.g_false_num

875: -- |----------------------------< CREATE_MESSAGE >-----------------------------|
876: -- ----------------------------------------------------------------------------
877: --
878: procedure create_message
879: (p_validate in number default hr_api.g_false_num
880: ,p_effective_date in date
881: ,p_communication_topic_id in number
882: ,p_parent_id in number default hr_api.g_number
883: ,p_message_subject in varchar2 default hr_api.g_varchar2

Line 882: ,p_parent_id in number default hr_api.g_number

878: procedure create_message
879: (p_validate in number default hr_api.g_false_num
880: ,p_effective_date in date
881: ,p_communication_topic_id in number
882: ,p_parent_id in number default hr_api.g_number
883: ,p_message_subject in varchar2 default hr_api.g_varchar2
884: ,p_message_post_date in date
885: ,p_sender_type in varchar2
886: ,p_sender_id in number

Line 883: ,p_message_subject in varchar2 default hr_api.g_varchar2

879: (p_validate in number default hr_api.g_false_num
880: ,p_effective_date in date
881: ,p_communication_topic_id in number
882: ,p_parent_id in number default hr_api.g_number
883: ,p_message_subject in varchar2 default hr_api.g_varchar2
884: ,p_message_post_date in date
885: ,p_sender_type in varchar2
886: ,p_sender_id in number
887: ,p_message_body in varchar2 default hr_api.g_varchar2

Line 887: ,p_message_body in varchar2 default hr_api.g_varchar2

883: ,p_message_subject in varchar2 default hr_api.g_varchar2
884: ,p_message_post_date in date
885: ,p_sender_type in varchar2
886: ,p_sender_id in number
887: ,p_message_body in varchar2 default hr_api.g_varchar2
888: ,p_document_type in varchar2 default hr_api.g_varchar2
889: ,p_document_id in number default hr_api.g_number
890: ,p_deleted_flag in varchar2 default hr_api.g_varchar2
891: ,p_communication_message_id in number

Line 888: ,p_document_type in varchar2 default hr_api.g_varchar2

884: ,p_message_post_date in date
885: ,p_sender_type in varchar2
886: ,p_sender_id in number
887: ,p_message_body in varchar2 default hr_api.g_varchar2
888: ,p_document_type in varchar2 default hr_api.g_varchar2
889: ,p_document_id in number default hr_api.g_number
890: ,p_deleted_flag in varchar2 default hr_api.g_varchar2
891: ,p_communication_message_id in number
892: ,p_object_version_number out nocopy number

Line 889: ,p_document_id in number default hr_api.g_number

885: ,p_sender_type in varchar2
886: ,p_sender_id in number
887: ,p_message_body in varchar2 default hr_api.g_varchar2
888: ,p_document_type in varchar2 default hr_api.g_varchar2
889: ,p_document_id in number default hr_api.g_number
890: ,p_deleted_flag in varchar2 default hr_api.g_varchar2
891: ,p_communication_message_id in number
892: ,p_object_version_number out nocopy number
893: ,p_return_status out nocopy varchar2

Line 890: ,p_deleted_flag in varchar2 default hr_api.g_varchar2

886: ,p_sender_id in number
887: ,p_message_body in varchar2 default hr_api.g_varchar2
888: ,p_document_type in varchar2 default hr_api.g_varchar2
889: ,p_document_id in number default hr_api.g_number
890: ,p_deleted_flag in varchar2 default hr_api.g_varchar2
891: ,p_communication_message_id in number
892: ,p_object_version_number out nocopy number
893: ,p_return_status out nocopy varchar2
894: ) is

Line 921: hr_api.constant_to_boolean

917: --
918: -- Convert constant values to their corresponding boolean value
919: --
920: l_validate :=
921: hr_api.constant_to_boolean
922: (p_constant_value => p_validate);
923: --
924: -- Register Surrogate ID or user key values
925: --

Line 1003: (p_validate in number default hr_api.g_false_num

999: -- |----------------------------< UPDATE_MESSAGE >----------------------------|
1000: -- ----------------------------------------------------------------------------
1001: --
1002: procedure update_message
1003: (p_validate in number default hr_api.g_false_num
1004: ,p_effective_date in date
1005: ,p_deleted_flag in varchar2 default hr_api.g_varchar2
1006: ,p_communication_message_id in number
1007: ,p_object_version_number in out nocopy number

Line 1005: ,p_deleted_flag in varchar2 default hr_api.g_varchar2

1001: --
1002: procedure update_message
1003: (p_validate in number default hr_api.g_false_num
1004: ,p_effective_date in date
1005: ,p_deleted_flag in varchar2 default hr_api.g_varchar2
1006: ,p_communication_message_id in number
1007: ,p_object_version_number in out nocopy number
1008: ,p_return_status out nocopy varchar2
1009: ) is

Line 1036: hr_api.constant_to_boolean

1032: --
1033: -- Convert constant values to their corresponding boolean value
1034: --
1035: l_validate :=
1036: hr_api.constant_to_boolean
1037: (p_constant_value => p_validate);
1038: l_object_version_number := p_object_version_number;
1039: --
1040: -- Call API

Line 1103: (p_validate in number default hr_api.g_false_num

1099: -- |----------------------------< ADD_RECIPIENT >-----------------------------|
1100: -- ----------------------------------------------------------------------------
1101: --
1102: procedure ADD_RECIPIENT
1103: (p_validate in number default hr_api.g_false_num
1104: ,p_effective_date in date
1105: ,p_communication_object_type in varchar2
1106: ,p_communication_object_id in number
1107: ,p_recipient_type in varchar2

Line 1110: ,p_end_date_active in date default hr_api.g_date

1106: ,p_communication_object_id in number
1107: ,p_recipient_type in varchar2
1108: ,p_recipient_id in number
1109: ,p_start_date_active in date
1110: ,p_end_date_active in date default hr_api.g_date
1111: ,p_primary_flag in varchar2 default hr_api.g_varchar2
1112: ,p_communication_recipient_id in number
1113: ,p_object_version_number out nocopy number
1114: ,p_return_status out nocopy varchar2

Line 1111: ,p_primary_flag in varchar2 default hr_api.g_varchar2

1107: ,p_recipient_type in varchar2
1108: ,p_recipient_id in number
1109: ,p_start_date_active in date
1110: ,p_end_date_active in date default hr_api.g_date
1111: ,p_primary_flag in varchar2 default hr_api.g_varchar2
1112: ,p_communication_recipient_id in number
1113: ,p_object_version_number out nocopy number
1114: ,p_return_status out nocopy varchar2
1115: ) is

Line 1142: hr_api.constant_to_boolean

1138: --
1139: -- Convert constant values to their corresponding boolean value
1140: --
1141: l_validate :=
1142: hr_api.constant_to_boolean
1143: (p_constant_value => p_validate);
1144: --
1145: -- Register Surrogate ID or user key values
1146: --

Line 1225: ,p_validate in number default hr_api.g_false_num

1221: procedure process_com_api
1222: (
1223: p_document in CLOB
1224: ,p_return_status out nocopy VARCHAR2
1225: ,p_validate in number default hr_api.g_false_num
1226: ,p_effective_date in date default null
1227: )
1228: IS
1229: l_postState VARCHAR2(2);