APPS.PER_CONTACT_RELATIONSHIP_SWI dependencies on HR_API

Line 71: p_validate in number default hr_api.g_false_num,

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

Line 78: p_contact_type in varchar2 default hr_api.g_varchar2,

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 long 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,

Line 79: p_comments in long default hr_api.g_varchar2,

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 long 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,

Line 80: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,

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 long 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,

Line 81: p_request_id in number default hr_api.g_number,

77: p_contact_relationship_id in number,
78: p_contact_type in varchar2 default hr_api.g_varchar2,
79: p_comments in long 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,

Line 82: p_program_application_id in number default hr_api.g_number,

78: p_contact_type in varchar2 default hr_api.g_varchar2,
79: p_comments in long 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,

Line 83: p_program_id in number default hr_api.g_number,

79: p_comments in long 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,

Line 84: p_program_update_date 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,

Line 85: p_date_start in date default hr_api.g_date,

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,

Line 86: p_start_life_reason_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,
90: p_personal_flag in varchar2 default hr_api.g_varchar2,

Line 87: p_date_end in date default hr_api.g_date,

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,

Line 88: p_end_life_reason_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,
92: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,

Line 89: p_rltd_per_rsds_w_dsgntr_flag 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,

Line 90: p_personal_flag 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,

Line 91: p_sequence_number 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,
95: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,

Line 92: p_cont_attribute_category 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,

Line 93: p_cont_attribute1 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,

Line 94: p_cont_attribute2 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,

Line 95: p_cont_attribute3 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,

Line 96: p_cont_attribute4 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,

Line 97: p_cont_attribute5 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,

Line 98: p_cont_attribute6 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,

Line 99: p_cont_attribute7 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,

Line 100: p_cont_attribute8 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,

Line 101: p_cont_attribute9 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,

Line 102: p_cont_attribute10 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,

Line 103: p_cont_attribute11 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,

Line 104: p_cont_attribute12 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,

Line 105: p_cont_attribute13 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,

Line 106: p_cont_attribute14 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,

Line 107: p_cont_attribute15 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,

Line 108: p_cont_attribute16 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,

Line 109: p_cont_attribute17 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,

Line 110: p_cont_attribute18 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,

Line 111: p_cont_attribute19 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,

Line 112: p_cont_attribute20 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,

Line 113: p_cont_information_category 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,

Line 114: p_cont_information1 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,

Line 115: p_cont_information2 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,

Line 116: p_cont_information3 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,

Line 117: p_cont_information4 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,

Line 118: p_cont_information5 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,

Line 119: p_cont_information6 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,

Line 120: p_cont_information7 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,

Line 121: p_cont_information8 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,

Line 122: p_cont_information9 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,

Line 123: p_cont_information10 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,

Line 124: p_cont_information11 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,

Line 125: p_cont_information12 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,

Line 126: p_cont_information13 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,

Line 127: p_cont_information14 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,

Line 128: p_cont_information15 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,

Line 129: p_cont_information16 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,

Line 130: p_cont_information17 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,

Line 131: p_cont_information18 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,

Line 132: p_cont_information19 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,

Line 133: p_cont_information20 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,

Line 134: p_third_party_pay_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,

Line 135: p_bondholder_flag 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,
139: p_effective_date in date,

Line 136: p_dependent_flag 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,
140: p_validate in number default hr_api.g_false_num,

Line 137: p_beneficiary_flag 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,
141: p_return_status out nocopy varchar2

Line 140: p_validate in number default hr_api.g_false_num,

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

Line 148: p_validate in number default hr_api.g_false_num,

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;