67: p_dependent_flag in varchar2 default 'N',
68: p_beneficiary_flag in varchar2 default 'N',
69: p_object_version_number out nocopy number,
70: p_effective_date in date default null,
71: p_validate in number default hr_api.g_false_num,
72: p_return_status out nocopy varchar2
73: );
74:
75: ----------------------------------------------------------------------------
74:
75: ----------------------------------------------------------------------------
76: Procedure upd (
77: p_contact_relationship_id in number,
78: p_contact_type in varchar2 default hr_api.g_varchar2,
79: p_comments in per_contact_relationships.comments%TYPE default hr_api.g_varchar2,
80: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
81: p_request_id in number default hr_api.g_number,
82: p_program_application_id in number default hr_api.g_number,
75: ----------------------------------------------------------------------------
76: Procedure upd (
77: p_contact_relationship_id in number,
78: p_contact_type in varchar2 default hr_api.g_varchar2,
79: p_comments in per_contact_relationships.comments%TYPE default hr_api.g_varchar2,
80: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
81: p_request_id in number default hr_api.g_number,
82: p_program_application_id in number default hr_api.g_number,
83: p_program_id in number default hr_api.g_number,
76: Procedure upd (
77: p_contact_relationship_id in number,
78: p_contact_type in varchar2 default hr_api.g_varchar2,
79: p_comments in per_contact_relationships.comments%TYPE default hr_api.g_varchar2,
80: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
81: p_request_id in number default hr_api.g_number,
82: p_program_application_id in number default hr_api.g_number,
83: p_program_id in number default hr_api.g_number,
84: p_program_update_date in date default hr_api.g_date,
77: p_contact_relationship_id in number,
78: p_contact_type in varchar2 default hr_api.g_varchar2,
79: p_comments in per_contact_relationships.comments%TYPE default hr_api.g_varchar2,
80: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
81: p_request_id in number default hr_api.g_number,
82: p_program_application_id in number default hr_api.g_number,
83: p_program_id in number default hr_api.g_number,
84: p_program_update_date in date default hr_api.g_date,
85: p_date_start in date default hr_api.g_date,
78: p_contact_type in varchar2 default hr_api.g_varchar2,
79: p_comments in per_contact_relationships.comments%TYPE default hr_api.g_varchar2,
80: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
81: p_request_id in number default hr_api.g_number,
82: p_program_application_id in number default hr_api.g_number,
83: p_program_id in number default hr_api.g_number,
84: p_program_update_date in date default hr_api.g_date,
85: p_date_start in date default hr_api.g_date,
86: p_start_life_reason_id in number default hr_api.g_number,
79: p_comments in per_contact_relationships.comments%TYPE default hr_api.g_varchar2,
80: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
81: p_request_id in number default hr_api.g_number,
82: p_program_application_id in number default hr_api.g_number,
83: p_program_id in number default hr_api.g_number,
84: p_program_update_date in date default hr_api.g_date,
85: p_date_start in date default hr_api.g_date,
86: p_start_life_reason_id in number default hr_api.g_number,
87: p_date_end in date default hr_api.g_date,
80: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
81: p_request_id in number default hr_api.g_number,
82: p_program_application_id in number default hr_api.g_number,
83: p_program_id in number default hr_api.g_number,
84: p_program_update_date in date default hr_api.g_date,
85: p_date_start in date default hr_api.g_date,
86: p_start_life_reason_id in number default hr_api.g_number,
87: p_date_end in date default hr_api.g_date,
88: p_end_life_reason_id in number default hr_api.g_number,
81: p_request_id in number default hr_api.g_number,
82: p_program_application_id in number default hr_api.g_number,
83: p_program_id in number default hr_api.g_number,
84: p_program_update_date in date default hr_api.g_date,
85: p_date_start in date default hr_api.g_date,
86: p_start_life_reason_id in number default hr_api.g_number,
87: p_date_end in date default hr_api.g_date,
88: p_end_life_reason_id in number default hr_api.g_number,
89: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
82: p_program_application_id in number default hr_api.g_number,
83: p_program_id in number default hr_api.g_number,
84: p_program_update_date in date default hr_api.g_date,
85: p_date_start in date default hr_api.g_date,
86: p_start_life_reason_id in number default hr_api.g_number,
87: p_date_end in date default hr_api.g_date,
88: p_end_life_reason_id in number default hr_api.g_number,
89: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
90: p_personal_flag in varchar2 default hr_api.g_varchar2,
83: p_program_id in number default hr_api.g_number,
84: p_program_update_date in date default hr_api.g_date,
85: p_date_start in date default hr_api.g_date,
86: p_start_life_reason_id in number default hr_api.g_number,
87: p_date_end in date default hr_api.g_date,
88: p_end_life_reason_id in number default hr_api.g_number,
89: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
90: p_personal_flag in varchar2 default hr_api.g_varchar2,
91: p_sequence_number in number default hr_api.g_number,
84: p_program_update_date in date default hr_api.g_date,
85: p_date_start in date default hr_api.g_date,
86: p_start_life_reason_id in number default hr_api.g_number,
87: p_date_end in date default hr_api.g_date,
88: p_end_life_reason_id in number default hr_api.g_number,
89: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
90: p_personal_flag in varchar2 default hr_api.g_varchar2,
91: p_sequence_number in number default hr_api.g_number,
92: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
85: p_date_start in date default hr_api.g_date,
86: p_start_life_reason_id in number default hr_api.g_number,
87: p_date_end in date default hr_api.g_date,
88: p_end_life_reason_id in number default hr_api.g_number,
89: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
90: p_personal_flag in varchar2 default hr_api.g_varchar2,
91: p_sequence_number in number default hr_api.g_number,
92: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
93: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
86: p_start_life_reason_id in number default hr_api.g_number,
87: p_date_end in date default hr_api.g_date,
88: p_end_life_reason_id in number default hr_api.g_number,
89: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
90: p_personal_flag in varchar2 default hr_api.g_varchar2,
91: p_sequence_number in number default hr_api.g_number,
92: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
93: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
94: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
87: p_date_end in date default hr_api.g_date,
88: p_end_life_reason_id in number default hr_api.g_number,
89: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
90: p_personal_flag in varchar2 default hr_api.g_varchar2,
91: p_sequence_number in number default hr_api.g_number,
92: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
93: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
94: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
95: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
88: p_end_life_reason_id in number default hr_api.g_number,
89: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
90: p_personal_flag in varchar2 default hr_api.g_varchar2,
91: p_sequence_number in number default hr_api.g_number,
92: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
93: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
94: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
95: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
96: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
89: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
90: p_personal_flag in varchar2 default hr_api.g_varchar2,
91: p_sequence_number in number default hr_api.g_number,
92: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
93: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
94: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
95: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
96: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
97: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
90: p_personal_flag in varchar2 default hr_api.g_varchar2,
91: p_sequence_number in number default hr_api.g_number,
92: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
93: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
94: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
95: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
96: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
97: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
98: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
91: p_sequence_number in number default hr_api.g_number,
92: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
93: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
94: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
95: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
96: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
97: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
98: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
99: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
92: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
93: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
94: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
95: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
96: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
97: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
98: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
99: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
100: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
93: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
94: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
95: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
96: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
97: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
98: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
99: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
100: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
101: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
94: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
95: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
96: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
97: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
98: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
99: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
100: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
101: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
102: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
95: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
96: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
97: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
98: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
99: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
100: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
101: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
102: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
103: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
96: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
97: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
98: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
99: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
100: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
101: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
102: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
103: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
104: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
97: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
98: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
99: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
100: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
101: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
102: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
103: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
104: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
105: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
98: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
99: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
100: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
101: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
102: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
103: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
104: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
105: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
106: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
99: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
100: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
101: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
102: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
103: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
104: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
105: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
106: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
107: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
100: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
101: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
102: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
103: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
104: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
105: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
106: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
107: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
108: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
101: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
102: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
103: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
104: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
105: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
106: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
107: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
108: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
109: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
102: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
103: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
104: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
105: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
106: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
107: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
108: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
109: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
110: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
103: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
104: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
105: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
106: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
107: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
108: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
109: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
110: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
111: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
104: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
105: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
106: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
107: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
108: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
109: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
110: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
111: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
112: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
105: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
106: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
107: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
108: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
109: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
110: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
111: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
112: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
113: p_cont_information_category in varchar2 default hr_api.g_varchar2,
106: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
107: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
108: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
109: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
110: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
111: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
112: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
113: p_cont_information_category in varchar2 default hr_api.g_varchar2,
114: p_cont_information1 in varchar2 default hr_api.g_varchar2,
107: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
108: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
109: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
110: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
111: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
112: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
113: p_cont_information_category in varchar2 default hr_api.g_varchar2,
114: p_cont_information1 in varchar2 default hr_api.g_varchar2,
115: p_cont_information2 in varchar2 default hr_api.g_varchar2,
108: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
109: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
110: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
111: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
112: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
113: p_cont_information_category in varchar2 default hr_api.g_varchar2,
114: p_cont_information1 in varchar2 default hr_api.g_varchar2,
115: p_cont_information2 in varchar2 default hr_api.g_varchar2,
116: p_cont_information3 in varchar2 default hr_api.g_varchar2,
109: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
110: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
111: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
112: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
113: p_cont_information_category in varchar2 default hr_api.g_varchar2,
114: p_cont_information1 in varchar2 default hr_api.g_varchar2,
115: p_cont_information2 in varchar2 default hr_api.g_varchar2,
116: p_cont_information3 in varchar2 default hr_api.g_varchar2,
117: p_cont_information4 in varchar2 default hr_api.g_varchar2,
110: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
111: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
112: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
113: p_cont_information_category in varchar2 default hr_api.g_varchar2,
114: p_cont_information1 in varchar2 default hr_api.g_varchar2,
115: p_cont_information2 in varchar2 default hr_api.g_varchar2,
116: p_cont_information3 in varchar2 default hr_api.g_varchar2,
117: p_cont_information4 in varchar2 default hr_api.g_varchar2,
118: p_cont_information5 in varchar2 default hr_api.g_varchar2,
111: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
112: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
113: p_cont_information_category in varchar2 default hr_api.g_varchar2,
114: p_cont_information1 in varchar2 default hr_api.g_varchar2,
115: p_cont_information2 in varchar2 default hr_api.g_varchar2,
116: p_cont_information3 in varchar2 default hr_api.g_varchar2,
117: p_cont_information4 in varchar2 default hr_api.g_varchar2,
118: p_cont_information5 in varchar2 default hr_api.g_varchar2,
119: p_cont_information6 in varchar2 default hr_api.g_varchar2,
112: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
113: p_cont_information_category in varchar2 default hr_api.g_varchar2,
114: p_cont_information1 in varchar2 default hr_api.g_varchar2,
115: p_cont_information2 in varchar2 default hr_api.g_varchar2,
116: p_cont_information3 in varchar2 default hr_api.g_varchar2,
117: p_cont_information4 in varchar2 default hr_api.g_varchar2,
118: p_cont_information5 in varchar2 default hr_api.g_varchar2,
119: p_cont_information6 in varchar2 default hr_api.g_varchar2,
120: p_cont_information7 in varchar2 default hr_api.g_varchar2,
113: p_cont_information_category in varchar2 default hr_api.g_varchar2,
114: p_cont_information1 in varchar2 default hr_api.g_varchar2,
115: p_cont_information2 in varchar2 default hr_api.g_varchar2,
116: p_cont_information3 in varchar2 default hr_api.g_varchar2,
117: p_cont_information4 in varchar2 default hr_api.g_varchar2,
118: p_cont_information5 in varchar2 default hr_api.g_varchar2,
119: p_cont_information6 in varchar2 default hr_api.g_varchar2,
120: p_cont_information7 in varchar2 default hr_api.g_varchar2,
121: p_cont_information8 in varchar2 default hr_api.g_varchar2,
114: p_cont_information1 in varchar2 default hr_api.g_varchar2,
115: p_cont_information2 in varchar2 default hr_api.g_varchar2,
116: p_cont_information3 in varchar2 default hr_api.g_varchar2,
117: p_cont_information4 in varchar2 default hr_api.g_varchar2,
118: p_cont_information5 in varchar2 default hr_api.g_varchar2,
119: p_cont_information6 in varchar2 default hr_api.g_varchar2,
120: p_cont_information7 in varchar2 default hr_api.g_varchar2,
121: p_cont_information8 in varchar2 default hr_api.g_varchar2,
122: p_cont_information9 in varchar2 default hr_api.g_varchar2,
115: p_cont_information2 in varchar2 default hr_api.g_varchar2,
116: p_cont_information3 in varchar2 default hr_api.g_varchar2,
117: p_cont_information4 in varchar2 default hr_api.g_varchar2,
118: p_cont_information5 in varchar2 default hr_api.g_varchar2,
119: p_cont_information6 in varchar2 default hr_api.g_varchar2,
120: p_cont_information7 in varchar2 default hr_api.g_varchar2,
121: p_cont_information8 in varchar2 default hr_api.g_varchar2,
122: p_cont_information9 in varchar2 default hr_api.g_varchar2,
123: p_cont_information10 in varchar2 default hr_api.g_varchar2,
116: p_cont_information3 in varchar2 default hr_api.g_varchar2,
117: p_cont_information4 in varchar2 default hr_api.g_varchar2,
118: p_cont_information5 in varchar2 default hr_api.g_varchar2,
119: p_cont_information6 in varchar2 default hr_api.g_varchar2,
120: p_cont_information7 in varchar2 default hr_api.g_varchar2,
121: p_cont_information8 in varchar2 default hr_api.g_varchar2,
122: p_cont_information9 in varchar2 default hr_api.g_varchar2,
123: p_cont_information10 in varchar2 default hr_api.g_varchar2,
124: p_cont_information11 in varchar2 default hr_api.g_varchar2,
117: p_cont_information4 in varchar2 default hr_api.g_varchar2,
118: p_cont_information5 in varchar2 default hr_api.g_varchar2,
119: p_cont_information6 in varchar2 default hr_api.g_varchar2,
120: p_cont_information7 in varchar2 default hr_api.g_varchar2,
121: p_cont_information8 in varchar2 default hr_api.g_varchar2,
122: p_cont_information9 in varchar2 default hr_api.g_varchar2,
123: p_cont_information10 in varchar2 default hr_api.g_varchar2,
124: p_cont_information11 in varchar2 default hr_api.g_varchar2,
125: p_cont_information12 in varchar2 default hr_api.g_varchar2,
118: p_cont_information5 in varchar2 default hr_api.g_varchar2,
119: p_cont_information6 in varchar2 default hr_api.g_varchar2,
120: p_cont_information7 in varchar2 default hr_api.g_varchar2,
121: p_cont_information8 in varchar2 default hr_api.g_varchar2,
122: p_cont_information9 in varchar2 default hr_api.g_varchar2,
123: p_cont_information10 in varchar2 default hr_api.g_varchar2,
124: p_cont_information11 in varchar2 default hr_api.g_varchar2,
125: p_cont_information12 in varchar2 default hr_api.g_varchar2,
126: p_cont_information13 in varchar2 default hr_api.g_varchar2,
119: p_cont_information6 in varchar2 default hr_api.g_varchar2,
120: p_cont_information7 in varchar2 default hr_api.g_varchar2,
121: p_cont_information8 in varchar2 default hr_api.g_varchar2,
122: p_cont_information9 in varchar2 default hr_api.g_varchar2,
123: p_cont_information10 in varchar2 default hr_api.g_varchar2,
124: p_cont_information11 in varchar2 default hr_api.g_varchar2,
125: p_cont_information12 in varchar2 default hr_api.g_varchar2,
126: p_cont_information13 in varchar2 default hr_api.g_varchar2,
127: p_cont_information14 in varchar2 default hr_api.g_varchar2,
120: p_cont_information7 in varchar2 default hr_api.g_varchar2,
121: p_cont_information8 in varchar2 default hr_api.g_varchar2,
122: p_cont_information9 in varchar2 default hr_api.g_varchar2,
123: p_cont_information10 in varchar2 default hr_api.g_varchar2,
124: p_cont_information11 in varchar2 default hr_api.g_varchar2,
125: p_cont_information12 in varchar2 default hr_api.g_varchar2,
126: p_cont_information13 in varchar2 default hr_api.g_varchar2,
127: p_cont_information14 in varchar2 default hr_api.g_varchar2,
128: p_cont_information15 in varchar2 default hr_api.g_varchar2,
121: p_cont_information8 in varchar2 default hr_api.g_varchar2,
122: p_cont_information9 in varchar2 default hr_api.g_varchar2,
123: p_cont_information10 in varchar2 default hr_api.g_varchar2,
124: p_cont_information11 in varchar2 default hr_api.g_varchar2,
125: p_cont_information12 in varchar2 default hr_api.g_varchar2,
126: p_cont_information13 in varchar2 default hr_api.g_varchar2,
127: p_cont_information14 in varchar2 default hr_api.g_varchar2,
128: p_cont_information15 in varchar2 default hr_api.g_varchar2,
129: p_cont_information16 in varchar2 default hr_api.g_varchar2,
122: p_cont_information9 in varchar2 default hr_api.g_varchar2,
123: p_cont_information10 in varchar2 default hr_api.g_varchar2,
124: p_cont_information11 in varchar2 default hr_api.g_varchar2,
125: p_cont_information12 in varchar2 default hr_api.g_varchar2,
126: p_cont_information13 in varchar2 default hr_api.g_varchar2,
127: p_cont_information14 in varchar2 default hr_api.g_varchar2,
128: p_cont_information15 in varchar2 default hr_api.g_varchar2,
129: p_cont_information16 in varchar2 default hr_api.g_varchar2,
130: p_cont_information17 in varchar2 default hr_api.g_varchar2,
123: p_cont_information10 in varchar2 default hr_api.g_varchar2,
124: p_cont_information11 in varchar2 default hr_api.g_varchar2,
125: p_cont_information12 in varchar2 default hr_api.g_varchar2,
126: p_cont_information13 in varchar2 default hr_api.g_varchar2,
127: p_cont_information14 in varchar2 default hr_api.g_varchar2,
128: p_cont_information15 in varchar2 default hr_api.g_varchar2,
129: p_cont_information16 in varchar2 default hr_api.g_varchar2,
130: p_cont_information17 in varchar2 default hr_api.g_varchar2,
131: p_cont_information18 in varchar2 default hr_api.g_varchar2,
124: p_cont_information11 in varchar2 default hr_api.g_varchar2,
125: p_cont_information12 in varchar2 default hr_api.g_varchar2,
126: p_cont_information13 in varchar2 default hr_api.g_varchar2,
127: p_cont_information14 in varchar2 default hr_api.g_varchar2,
128: p_cont_information15 in varchar2 default hr_api.g_varchar2,
129: p_cont_information16 in varchar2 default hr_api.g_varchar2,
130: p_cont_information17 in varchar2 default hr_api.g_varchar2,
131: p_cont_information18 in varchar2 default hr_api.g_varchar2,
132: p_cont_information19 in varchar2 default hr_api.g_varchar2,
125: p_cont_information12 in varchar2 default hr_api.g_varchar2,
126: p_cont_information13 in varchar2 default hr_api.g_varchar2,
127: p_cont_information14 in varchar2 default hr_api.g_varchar2,
128: p_cont_information15 in varchar2 default hr_api.g_varchar2,
129: p_cont_information16 in varchar2 default hr_api.g_varchar2,
130: p_cont_information17 in varchar2 default hr_api.g_varchar2,
131: p_cont_information18 in varchar2 default hr_api.g_varchar2,
132: p_cont_information19 in varchar2 default hr_api.g_varchar2,
133: p_cont_information20 in varchar2 default hr_api.g_varchar2,
126: p_cont_information13 in varchar2 default hr_api.g_varchar2,
127: p_cont_information14 in varchar2 default hr_api.g_varchar2,
128: p_cont_information15 in varchar2 default hr_api.g_varchar2,
129: p_cont_information16 in varchar2 default hr_api.g_varchar2,
130: p_cont_information17 in varchar2 default hr_api.g_varchar2,
131: p_cont_information18 in varchar2 default hr_api.g_varchar2,
132: p_cont_information19 in varchar2 default hr_api.g_varchar2,
133: p_cont_information20 in varchar2 default hr_api.g_varchar2,
134: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
127: p_cont_information14 in varchar2 default hr_api.g_varchar2,
128: p_cont_information15 in varchar2 default hr_api.g_varchar2,
129: p_cont_information16 in varchar2 default hr_api.g_varchar2,
130: p_cont_information17 in varchar2 default hr_api.g_varchar2,
131: p_cont_information18 in varchar2 default hr_api.g_varchar2,
132: p_cont_information19 in varchar2 default hr_api.g_varchar2,
133: p_cont_information20 in varchar2 default hr_api.g_varchar2,
134: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
135: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
128: p_cont_information15 in varchar2 default hr_api.g_varchar2,
129: p_cont_information16 in varchar2 default hr_api.g_varchar2,
130: p_cont_information17 in varchar2 default hr_api.g_varchar2,
131: p_cont_information18 in varchar2 default hr_api.g_varchar2,
132: p_cont_information19 in varchar2 default hr_api.g_varchar2,
133: p_cont_information20 in varchar2 default hr_api.g_varchar2,
134: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
135: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
136: p_dependent_flag in varchar2 default hr_api.g_varchar2,
129: p_cont_information16 in varchar2 default hr_api.g_varchar2,
130: p_cont_information17 in varchar2 default hr_api.g_varchar2,
131: p_cont_information18 in varchar2 default hr_api.g_varchar2,
132: p_cont_information19 in varchar2 default hr_api.g_varchar2,
133: p_cont_information20 in varchar2 default hr_api.g_varchar2,
134: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
135: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
136: p_dependent_flag in varchar2 default hr_api.g_varchar2,
137: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
130: p_cont_information17 in varchar2 default hr_api.g_varchar2,
131: p_cont_information18 in varchar2 default hr_api.g_varchar2,
132: p_cont_information19 in varchar2 default hr_api.g_varchar2,
133: p_cont_information20 in varchar2 default hr_api.g_varchar2,
134: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
135: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
136: p_dependent_flag in varchar2 default hr_api.g_varchar2,
137: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
138: p_object_version_number in out nocopy number,
131: p_cont_information18 in varchar2 default hr_api.g_varchar2,
132: p_cont_information19 in varchar2 default hr_api.g_varchar2,
133: p_cont_information20 in varchar2 default hr_api.g_varchar2,
134: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
135: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
136: p_dependent_flag in varchar2 default hr_api.g_varchar2,
137: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
138: p_object_version_number in out nocopy number,
139: p_effective_date in date,
132: p_cont_information19 in varchar2 default hr_api.g_varchar2,
133: p_cont_information20 in varchar2 default hr_api.g_varchar2,
134: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
135: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
136: p_dependent_flag in varchar2 default hr_api.g_varchar2,
137: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
138: p_object_version_number in out nocopy number,
139: p_effective_date in date,
140: p_validate in number default hr_api.g_false_num,
133: p_cont_information20 in varchar2 default hr_api.g_varchar2,
134: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
135: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
136: p_dependent_flag in varchar2 default hr_api.g_varchar2,
137: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
138: p_object_version_number in out nocopy number,
139: p_effective_date in date,
140: p_validate in number default hr_api.g_false_num,
141: p_return_status out nocopy varchar2
136: p_dependent_flag in varchar2 default hr_api.g_varchar2,
137: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
138: p_object_version_number in out nocopy number,
139: p_effective_date in date,
140: p_validate in number default hr_api.g_false_num,
141: p_return_status out nocopy varchar2
142: );
143:
144: ----------------------------------------------------------------------------
144: ----------------------------------------------------------------------------
145: procedure del (
146: p_contact_relationship_id in number,
147: p_object_version_number in number,
148: p_validate in number default hr_api.g_false_num,
149: p_return_status out nocopy varchar2
150: );
151:
152: end per_contact_relationship_swi;