APPS.IRC_OFFERS_SWI dependencies on HR_API

Line 27: (p_validate in number default hr_api.g_false_num

23: --
24: -- {End of comments}
25: -- ----------------------------------------------------------------------------
26: PROCEDURE create_offer
27: (p_validate in number default hr_api.g_false_num
28: ,p_effective_date in date default null
29: ,p_offer_status in varchar2
30: ,p_discretionary_job_title in varchar2 default null
31: ,p_offer_extended_method in varchar2 default null

Line 107: (p_validate in number default hr_api.g_false_num

103: --
104: -- {End of comments}
105: -- ----------------------------------------------------------------------------
106: PROCEDURE update_offer
107: (p_validate in number default hr_api.g_false_num
108: ,p_effective_date in date default hr_api.g_date
109: ,p_offer_status in varchar2 default hr_api.g_varchar2
110: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
111: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2

Line 108: ,p_effective_date in date default hr_api.g_date

104: -- {End of comments}
105: -- ----------------------------------------------------------------------------
106: PROCEDURE update_offer
107: (p_validate in number default hr_api.g_false_num
108: ,p_effective_date in date default hr_api.g_date
109: ,p_offer_status in varchar2 default hr_api.g_varchar2
110: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
111: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
112: ,p_respondent_id in number default hr_api.g_number

Line 109: ,p_offer_status in varchar2 default hr_api.g_varchar2

105: -- ----------------------------------------------------------------------------
106: PROCEDURE update_offer
107: (p_validate in number default hr_api.g_false_num
108: ,p_effective_date in date default hr_api.g_date
109: ,p_offer_status in varchar2 default hr_api.g_varchar2
110: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
111: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
112: ,p_respondent_id in number default hr_api.g_number
113: ,p_expiry_date in date default hr_api.g_date

Line 110: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2

106: PROCEDURE update_offer
107: (p_validate in number default hr_api.g_false_num
108: ,p_effective_date in date default hr_api.g_date
109: ,p_offer_status in varchar2 default hr_api.g_varchar2
110: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
111: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
112: ,p_respondent_id in number default hr_api.g_number
113: ,p_expiry_date in date default hr_api.g_date
114: ,p_proposed_start_date in date default hr_api.g_date

Line 111: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2

107: (p_validate in number default hr_api.g_false_num
108: ,p_effective_date in date default hr_api.g_date
109: ,p_offer_status in varchar2 default hr_api.g_varchar2
110: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
111: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
112: ,p_respondent_id in number default hr_api.g_number
113: ,p_expiry_date in date default hr_api.g_date
114: ,p_proposed_start_date in date default hr_api.g_date
115: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2

Line 112: ,p_respondent_id in number default hr_api.g_number

108: ,p_effective_date in date default hr_api.g_date
109: ,p_offer_status in varchar2 default hr_api.g_varchar2
110: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
111: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
112: ,p_respondent_id in number default hr_api.g_number
113: ,p_expiry_date in date default hr_api.g_date
114: ,p_proposed_start_date in date default hr_api.g_date
115: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
116: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2

Line 113: ,p_expiry_date in date default hr_api.g_date

109: ,p_offer_status in varchar2 default hr_api.g_varchar2
110: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
111: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
112: ,p_respondent_id in number default hr_api.g_number
113: ,p_expiry_date in date default hr_api.g_date
114: ,p_proposed_start_date in date default hr_api.g_date
115: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
116: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
117: ,p_offer_shipping_date in date default hr_api.g_date

Line 114: ,p_proposed_start_date in date default hr_api.g_date

110: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
111: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
112: ,p_respondent_id in number default hr_api.g_number
113: ,p_expiry_date in date default hr_api.g_date
114: ,p_proposed_start_date in date default hr_api.g_date
115: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
116: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
117: ,p_offer_shipping_date in date default hr_api.g_date
118: ,p_applicant_assignment_id in number default hr_api.g_number

Line 115: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2

111: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
112: ,p_respondent_id in number default hr_api.g_number
113: ,p_expiry_date in date default hr_api.g_date
114: ,p_proposed_start_date in date default hr_api.g_date
115: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
116: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
117: ,p_offer_shipping_date in date default hr_api.g_date
118: ,p_applicant_assignment_id in number default hr_api.g_number
119: ,p_offer_assignment_id in number default hr_api.g_number

Line 116: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2

112: ,p_respondent_id in number default hr_api.g_number
113: ,p_expiry_date in date default hr_api.g_date
114: ,p_proposed_start_date in date default hr_api.g_date
115: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
116: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
117: ,p_offer_shipping_date in date default hr_api.g_date
118: ,p_applicant_assignment_id in number default hr_api.g_number
119: ,p_offer_assignment_id in number default hr_api.g_number
120: ,p_address_id in number default hr_api.g_number

Line 117: ,p_offer_shipping_date in date default hr_api.g_date

113: ,p_expiry_date in date default hr_api.g_date
114: ,p_proposed_start_date in date default hr_api.g_date
115: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
116: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
117: ,p_offer_shipping_date in date default hr_api.g_date
118: ,p_applicant_assignment_id in number default hr_api.g_number
119: ,p_offer_assignment_id in number default hr_api.g_number
120: ,p_address_id in number default hr_api.g_number
121: ,p_template_id in number default hr_api.g_number

Line 118: ,p_applicant_assignment_id in number default hr_api.g_number

114: ,p_proposed_start_date in date default hr_api.g_date
115: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
116: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
117: ,p_offer_shipping_date in date default hr_api.g_date
118: ,p_applicant_assignment_id in number default hr_api.g_number
119: ,p_offer_assignment_id in number default hr_api.g_number
120: ,p_address_id in number default hr_api.g_number
121: ,p_template_id in number default hr_api.g_number
122: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2

Line 119: ,p_offer_assignment_id in number default hr_api.g_number

115: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
116: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
117: ,p_offer_shipping_date in date default hr_api.g_date
118: ,p_applicant_assignment_id in number default hr_api.g_number
119: ,p_offer_assignment_id in number default hr_api.g_number
120: ,p_address_id in number default hr_api.g_number
121: ,p_template_id in number default hr_api.g_number
122: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
123: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2

Line 120: ,p_address_id in number default hr_api.g_number

116: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
117: ,p_offer_shipping_date in date default hr_api.g_date
118: ,p_applicant_assignment_id in number default hr_api.g_number
119: ,p_offer_assignment_id in number default hr_api.g_number
120: ,p_address_id in number default hr_api.g_number
121: ,p_template_id in number default hr_api.g_number
122: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
123: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
124: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 121: ,p_template_id in number default hr_api.g_number

117: ,p_offer_shipping_date in date default hr_api.g_date
118: ,p_applicant_assignment_id in number default hr_api.g_number
119: ,p_offer_assignment_id in number default hr_api.g_number
120: ,p_address_id in number default hr_api.g_number
121: ,p_template_id in number default hr_api.g_number
122: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
123: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
124: ,p_attribute_category in varchar2 default hr_api.g_varchar2
125: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 122: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2

118: ,p_applicant_assignment_id in number default hr_api.g_number
119: ,p_offer_assignment_id in number default hr_api.g_number
120: ,p_address_id in number default hr_api.g_number
121: ,p_template_id in number default hr_api.g_number
122: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
123: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
124: ,p_attribute_category in varchar2 default hr_api.g_varchar2
125: ,p_attribute1 in varchar2 default hr_api.g_varchar2
126: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 123: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2

119: ,p_offer_assignment_id in number default hr_api.g_number
120: ,p_address_id in number default hr_api.g_number
121: ,p_template_id in number default hr_api.g_number
122: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
123: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
124: ,p_attribute_category in varchar2 default hr_api.g_varchar2
125: ,p_attribute1 in varchar2 default hr_api.g_varchar2
126: ,p_attribute2 in varchar2 default hr_api.g_varchar2
127: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 124: ,p_attribute_category in varchar2 default hr_api.g_varchar2

120: ,p_address_id in number default hr_api.g_number
121: ,p_template_id in number default hr_api.g_number
122: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
123: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
124: ,p_attribute_category in varchar2 default hr_api.g_varchar2
125: ,p_attribute1 in varchar2 default hr_api.g_varchar2
126: ,p_attribute2 in varchar2 default hr_api.g_varchar2
127: ,p_attribute3 in varchar2 default hr_api.g_varchar2
128: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 125: ,p_attribute1 in varchar2 default hr_api.g_varchar2

121: ,p_template_id in number default hr_api.g_number
122: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
123: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
124: ,p_attribute_category in varchar2 default hr_api.g_varchar2
125: ,p_attribute1 in varchar2 default hr_api.g_varchar2
126: ,p_attribute2 in varchar2 default hr_api.g_varchar2
127: ,p_attribute3 in varchar2 default hr_api.g_varchar2
128: ,p_attribute4 in varchar2 default hr_api.g_varchar2
129: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 126: ,p_attribute2 in varchar2 default hr_api.g_varchar2

122: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
123: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
124: ,p_attribute_category in varchar2 default hr_api.g_varchar2
125: ,p_attribute1 in varchar2 default hr_api.g_varchar2
126: ,p_attribute2 in varchar2 default hr_api.g_varchar2
127: ,p_attribute3 in varchar2 default hr_api.g_varchar2
128: ,p_attribute4 in varchar2 default hr_api.g_varchar2
129: ,p_attribute5 in varchar2 default hr_api.g_varchar2
130: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 127: ,p_attribute3 in varchar2 default hr_api.g_varchar2

123: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
124: ,p_attribute_category in varchar2 default hr_api.g_varchar2
125: ,p_attribute1 in varchar2 default hr_api.g_varchar2
126: ,p_attribute2 in varchar2 default hr_api.g_varchar2
127: ,p_attribute3 in varchar2 default hr_api.g_varchar2
128: ,p_attribute4 in varchar2 default hr_api.g_varchar2
129: ,p_attribute5 in varchar2 default hr_api.g_varchar2
130: ,p_attribute6 in varchar2 default hr_api.g_varchar2
131: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 128: ,p_attribute4 in varchar2 default hr_api.g_varchar2

124: ,p_attribute_category in varchar2 default hr_api.g_varchar2
125: ,p_attribute1 in varchar2 default hr_api.g_varchar2
126: ,p_attribute2 in varchar2 default hr_api.g_varchar2
127: ,p_attribute3 in varchar2 default hr_api.g_varchar2
128: ,p_attribute4 in varchar2 default hr_api.g_varchar2
129: ,p_attribute5 in varchar2 default hr_api.g_varchar2
130: ,p_attribute6 in varchar2 default hr_api.g_varchar2
131: ,p_attribute7 in varchar2 default hr_api.g_varchar2
132: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 129: ,p_attribute5 in varchar2 default hr_api.g_varchar2

125: ,p_attribute1 in varchar2 default hr_api.g_varchar2
126: ,p_attribute2 in varchar2 default hr_api.g_varchar2
127: ,p_attribute3 in varchar2 default hr_api.g_varchar2
128: ,p_attribute4 in varchar2 default hr_api.g_varchar2
129: ,p_attribute5 in varchar2 default hr_api.g_varchar2
130: ,p_attribute6 in varchar2 default hr_api.g_varchar2
131: ,p_attribute7 in varchar2 default hr_api.g_varchar2
132: ,p_attribute8 in varchar2 default hr_api.g_varchar2
133: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 130: ,p_attribute6 in varchar2 default hr_api.g_varchar2

126: ,p_attribute2 in varchar2 default hr_api.g_varchar2
127: ,p_attribute3 in varchar2 default hr_api.g_varchar2
128: ,p_attribute4 in varchar2 default hr_api.g_varchar2
129: ,p_attribute5 in varchar2 default hr_api.g_varchar2
130: ,p_attribute6 in varchar2 default hr_api.g_varchar2
131: ,p_attribute7 in varchar2 default hr_api.g_varchar2
132: ,p_attribute8 in varchar2 default hr_api.g_varchar2
133: ,p_attribute9 in varchar2 default hr_api.g_varchar2
134: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 131: ,p_attribute7 in varchar2 default hr_api.g_varchar2

127: ,p_attribute3 in varchar2 default hr_api.g_varchar2
128: ,p_attribute4 in varchar2 default hr_api.g_varchar2
129: ,p_attribute5 in varchar2 default hr_api.g_varchar2
130: ,p_attribute6 in varchar2 default hr_api.g_varchar2
131: ,p_attribute7 in varchar2 default hr_api.g_varchar2
132: ,p_attribute8 in varchar2 default hr_api.g_varchar2
133: ,p_attribute9 in varchar2 default hr_api.g_varchar2
134: ,p_attribute10 in varchar2 default hr_api.g_varchar2
135: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 132: ,p_attribute8 in varchar2 default hr_api.g_varchar2

128: ,p_attribute4 in varchar2 default hr_api.g_varchar2
129: ,p_attribute5 in varchar2 default hr_api.g_varchar2
130: ,p_attribute6 in varchar2 default hr_api.g_varchar2
131: ,p_attribute7 in varchar2 default hr_api.g_varchar2
132: ,p_attribute8 in varchar2 default hr_api.g_varchar2
133: ,p_attribute9 in varchar2 default hr_api.g_varchar2
134: ,p_attribute10 in varchar2 default hr_api.g_varchar2
135: ,p_attribute11 in varchar2 default hr_api.g_varchar2
136: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 133: ,p_attribute9 in varchar2 default hr_api.g_varchar2

129: ,p_attribute5 in varchar2 default hr_api.g_varchar2
130: ,p_attribute6 in varchar2 default hr_api.g_varchar2
131: ,p_attribute7 in varchar2 default hr_api.g_varchar2
132: ,p_attribute8 in varchar2 default hr_api.g_varchar2
133: ,p_attribute9 in varchar2 default hr_api.g_varchar2
134: ,p_attribute10 in varchar2 default hr_api.g_varchar2
135: ,p_attribute11 in varchar2 default hr_api.g_varchar2
136: ,p_attribute12 in varchar2 default hr_api.g_varchar2
137: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 134: ,p_attribute10 in varchar2 default hr_api.g_varchar2

130: ,p_attribute6 in varchar2 default hr_api.g_varchar2
131: ,p_attribute7 in varchar2 default hr_api.g_varchar2
132: ,p_attribute8 in varchar2 default hr_api.g_varchar2
133: ,p_attribute9 in varchar2 default hr_api.g_varchar2
134: ,p_attribute10 in varchar2 default hr_api.g_varchar2
135: ,p_attribute11 in varchar2 default hr_api.g_varchar2
136: ,p_attribute12 in varchar2 default hr_api.g_varchar2
137: ,p_attribute13 in varchar2 default hr_api.g_varchar2
138: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 135: ,p_attribute11 in varchar2 default hr_api.g_varchar2

131: ,p_attribute7 in varchar2 default hr_api.g_varchar2
132: ,p_attribute8 in varchar2 default hr_api.g_varchar2
133: ,p_attribute9 in varchar2 default hr_api.g_varchar2
134: ,p_attribute10 in varchar2 default hr_api.g_varchar2
135: ,p_attribute11 in varchar2 default hr_api.g_varchar2
136: ,p_attribute12 in varchar2 default hr_api.g_varchar2
137: ,p_attribute13 in varchar2 default hr_api.g_varchar2
138: ,p_attribute14 in varchar2 default hr_api.g_varchar2
139: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 136: ,p_attribute12 in varchar2 default hr_api.g_varchar2

132: ,p_attribute8 in varchar2 default hr_api.g_varchar2
133: ,p_attribute9 in varchar2 default hr_api.g_varchar2
134: ,p_attribute10 in varchar2 default hr_api.g_varchar2
135: ,p_attribute11 in varchar2 default hr_api.g_varchar2
136: ,p_attribute12 in varchar2 default hr_api.g_varchar2
137: ,p_attribute13 in varchar2 default hr_api.g_varchar2
138: ,p_attribute14 in varchar2 default hr_api.g_varchar2
139: ,p_attribute15 in varchar2 default hr_api.g_varchar2
140: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 137: ,p_attribute13 in varchar2 default hr_api.g_varchar2

133: ,p_attribute9 in varchar2 default hr_api.g_varchar2
134: ,p_attribute10 in varchar2 default hr_api.g_varchar2
135: ,p_attribute11 in varchar2 default hr_api.g_varchar2
136: ,p_attribute12 in varchar2 default hr_api.g_varchar2
137: ,p_attribute13 in varchar2 default hr_api.g_varchar2
138: ,p_attribute14 in varchar2 default hr_api.g_varchar2
139: ,p_attribute15 in varchar2 default hr_api.g_varchar2
140: ,p_attribute16 in varchar2 default hr_api.g_varchar2
141: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 138: ,p_attribute14 in varchar2 default hr_api.g_varchar2

134: ,p_attribute10 in varchar2 default hr_api.g_varchar2
135: ,p_attribute11 in varchar2 default hr_api.g_varchar2
136: ,p_attribute12 in varchar2 default hr_api.g_varchar2
137: ,p_attribute13 in varchar2 default hr_api.g_varchar2
138: ,p_attribute14 in varchar2 default hr_api.g_varchar2
139: ,p_attribute15 in varchar2 default hr_api.g_varchar2
140: ,p_attribute16 in varchar2 default hr_api.g_varchar2
141: ,p_attribute17 in varchar2 default hr_api.g_varchar2
142: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 139: ,p_attribute15 in varchar2 default hr_api.g_varchar2

135: ,p_attribute11 in varchar2 default hr_api.g_varchar2
136: ,p_attribute12 in varchar2 default hr_api.g_varchar2
137: ,p_attribute13 in varchar2 default hr_api.g_varchar2
138: ,p_attribute14 in varchar2 default hr_api.g_varchar2
139: ,p_attribute15 in varchar2 default hr_api.g_varchar2
140: ,p_attribute16 in varchar2 default hr_api.g_varchar2
141: ,p_attribute17 in varchar2 default hr_api.g_varchar2
142: ,p_attribute18 in varchar2 default hr_api.g_varchar2
143: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 140: ,p_attribute16 in varchar2 default hr_api.g_varchar2

136: ,p_attribute12 in varchar2 default hr_api.g_varchar2
137: ,p_attribute13 in varchar2 default hr_api.g_varchar2
138: ,p_attribute14 in varchar2 default hr_api.g_varchar2
139: ,p_attribute15 in varchar2 default hr_api.g_varchar2
140: ,p_attribute16 in varchar2 default hr_api.g_varchar2
141: ,p_attribute17 in varchar2 default hr_api.g_varchar2
142: ,p_attribute18 in varchar2 default hr_api.g_varchar2
143: ,p_attribute19 in varchar2 default hr_api.g_varchar2
144: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 141: ,p_attribute17 in varchar2 default hr_api.g_varchar2

137: ,p_attribute13 in varchar2 default hr_api.g_varchar2
138: ,p_attribute14 in varchar2 default hr_api.g_varchar2
139: ,p_attribute15 in varchar2 default hr_api.g_varchar2
140: ,p_attribute16 in varchar2 default hr_api.g_varchar2
141: ,p_attribute17 in varchar2 default hr_api.g_varchar2
142: ,p_attribute18 in varchar2 default hr_api.g_varchar2
143: ,p_attribute19 in varchar2 default hr_api.g_varchar2
144: ,p_attribute20 in varchar2 default hr_api.g_varchar2
145: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 142: ,p_attribute18 in varchar2 default hr_api.g_varchar2

138: ,p_attribute14 in varchar2 default hr_api.g_varchar2
139: ,p_attribute15 in varchar2 default hr_api.g_varchar2
140: ,p_attribute16 in varchar2 default hr_api.g_varchar2
141: ,p_attribute17 in varchar2 default hr_api.g_varchar2
142: ,p_attribute18 in varchar2 default hr_api.g_varchar2
143: ,p_attribute19 in varchar2 default hr_api.g_varchar2
144: ,p_attribute20 in varchar2 default hr_api.g_varchar2
145: ,p_attribute21 in varchar2 default hr_api.g_varchar2
146: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 143: ,p_attribute19 in varchar2 default hr_api.g_varchar2

139: ,p_attribute15 in varchar2 default hr_api.g_varchar2
140: ,p_attribute16 in varchar2 default hr_api.g_varchar2
141: ,p_attribute17 in varchar2 default hr_api.g_varchar2
142: ,p_attribute18 in varchar2 default hr_api.g_varchar2
143: ,p_attribute19 in varchar2 default hr_api.g_varchar2
144: ,p_attribute20 in varchar2 default hr_api.g_varchar2
145: ,p_attribute21 in varchar2 default hr_api.g_varchar2
146: ,p_attribute22 in varchar2 default hr_api.g_varchar2
147: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 144: ,p_attribute20 in varchar2 default hr_api.g_varchar2

140: ,p_attribute16 in varchar2 default hr_api.g_varchar2
141: ,p_attribute17 in varchar2 default hr_api.g_varchar2
142: ,p_attribute18 in varchar2 default hr_api.g_varchar2
143: ,p_attribute19 in varchar2 default hr_api.g_varchar2
144: ,p_attribute20 in varchar2 default hr_api.g_varchar2
145: ,p_attribute21 in varchar2 default hr_api.g_varchar2
146: ,p_attribute22 in varchar2 default hr_api.g_varchar2
147: ,p_attribute23 in varchar2 default hr_api.g_varchar2
148: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 145: ,p_attribute21 in varchar2 default hr_api.g_varchar2

141: ,p_attribute17 in varchar2 default hr_api.g_varchar2
142: ,p_attribute18 in varchar2 default hr_api.g_varchar2
143: ,p_attribute19 in varchar2 default hr_api.g_varchar2
144: ,p_attribute20 in varchar2 default hr_api.g_varchar2
145: ,p_attribute21 in varchar2 default hr_api.g_varchar2
146: ,p_attribute22 in varchar2 default hr_api.g_varchar2
147: ,p_attribute23 in varchar2 default hr_api.g_varchar2
148: ,p_attribute24 in varchar2 default hr_api.g_varchar2
149: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 146: ,p_attribute22 in varchar2 default hr_api.g_varchar2

142: ,p_attribute18 in varchar2 default hr_api.g_varchar2
143: ,p_attribute19 in varchar2 default hr_api.g_varchar2
144: ,p_attribute20 in varchar2 default hr_api.g_varchar2
145: ,p_attribute21 in varchar2 default hr_api.g_varchar2
146: ,p_attribute22 in varchar2 default hr_api.g_varchar2
147: ,p_attribute23 in varchar2 default hr_api.g_varchar2
148: ,p_attribute24 in varchar2 default hr_api.g_varchar2
149: ,p_attribute25 in varchar2 default hr_api.g_varchar2
150: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 147: ,p_attribute23 in varchar2 default hr_api.g_varchar2

143: ,p_attribute19 in varchar2 default hr_api.g_varchar2
144: ,p_attribute20 in varchar2 default hr_api.g_varchar2
145: ,p_attribute21 in varchar2 default hr_api.g_varchar2
146: ,p_attribute22 in varchar2 default hr_api.g_varchar2
147: ,p_attribute23 in varchar2 default hr_api.g_varchar2
148: ,p_attribute24 in varchar2 default hr_api.g_varchar2
149: ,p_attribute25 in varchar2 default hr_api.g_varchar2
150: ,p_attribute26 in varchar2 default hr_api.g_varchar2
151: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 148: ,p_attribute24 in varchar2 default hr_api.g_varchar2

144: ,p_attribute20 in varchar2 default hr_api.g_varchar2
145: ,p_attribute21 in varchar2 default hr_api.g_varchar2
146: ,p_attribute22 in varchar2 default hr_api.g_varchar2
147: ,p_attribute23 in varchar2 default hr_api.g_varchar2
148: ,p_attribute24 in varchar2 default hr_api.g_varchar2
149: ,p_attribute25 in varchar2 default hr_api.g_varchar2
150: ,p_attribute26 in varchar2 default hr_api.g_varchar2
151: ,p_attribute27 in varchar2 default hr_api.g_varchar2
152: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 149: ,p_attribute25 in varchar2 default hr_api.g_varchar2

145: ,p_attribute21 in varchar2 default hr_api.g_varchar2
146: ,p_attribute22 in varchar2 default hr_api.g_varchar2
147: ,p_attribute23 in varchar2 default hr_api.g_varchar2
148: ,p_attribute24 in varchar2 default hr_api.g_varchar2
149: ,p_attribute25 in varchar2 default hr_api.g_varchar2
150: ,p_attribute26 in varchar2 default hr_api.g_varchar2
151: ,p_attribute27 in varchar2 default hr_api.g_varchar2
152: ,p_attribute28 in varchar2 default hr_api.g_varchar2
153: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 150: ,p_attribute26 in varchar2 default hr_api.g_varchar2

146: ,p_attribute22 in varchar2 default hr_api.g_varchar2
147: ,p_attribute23 in varchar2 default hr_api.g_varchar2
148: ,p_attribute24 in varchar2 default hr_api.g_varchar2
149: ,p_attribute25 in varchar2 default hr_api.g_varchar2
150: ,p_attribute26 in varchar2 default hr_api.g_varchar2
151: ,p_attribute27 in varchar2 default hr_api.g_varchar2
152: ,p_attribute28 in varchar2 default hr_api.g_varchar2
153: ,p_attribute29 in varchar2 default hr_api.g_varchar2
154: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 151: ,p_attribute27 in varchar2 default hr_api.g_varchar2

147: ,p_attribute23 in varchar2 default hr_api.g_varchar2
148: ,p_attribute24 in varchar2 default hr_api.g_varchar2
149: ,p_attribute25 in varchar2 default hr_api.g_varchar2
150: ,p_attribute26 in varchar2 default hr_api.g_varchar2
151: ,p_attribute27 in varchar2 default hr_api.g_varchar2
152: ,p_attribute28 in varchar2 default hr_api.g_varchar2
153: ,p_attribute29 in varchar2 default hr_api.g_varchar2
154: ,p_attribute30 in varchar2 default hr_api.g_varchar2
155: ,p_change_reason in varchar2 default null

Line 152: ,p_attribute28 in varchar2 default hr_api.g_varchar2

148: ,p_attribute24 in varchar2 default hr_api.g_varchar2
149: ,p_attribute25 in varchar2 default hr_api.g_varchar2
150: ,p_attribute26 in varchar2 default hr_api.g_varchar2
151: ,p_attribute27 in varchar2 default hr_api.g_varchar2
152: ,p_attribute28 in varchar2 default hr_api.g_varchar2
153: ,p_attribute29 in varchar2 default hr_api.g_varchar2
154: ,p_attribute30 in varchar2 default hr_api.g_varchar2
155: ,p_change_reason in varchar2 default null
156: ,p_decline_reason in varchar2 default null

Line 153: ,p_attribute29 in varchar2 default hr_api.g_varchar2

149: ,p_attribute25 in varchar2 default hr_api.g_varchar2
150: ,p_attribute26 in varchar2 default hr_api.g_varchar2
151: ,p_attribute27 in varchar2 default hr_api.g_varchar2
152: ,p_attribute28 in varchar2 default hr_api.g_varchar2
153: ,p_attribute29 in varchar2 default hr_api.g_varchar2
154: ,p_attribute30 in varchar2 default hr_api.g_varchar2
155: ,p_change_reason in varchar2 default null
156: ,p_decline_reason in varchar2 default null
157: ,p_note_text in varchar2 default null

Line 154: ,p_attribute30 in varchar2 default hr_api.g_varchar2

150: ,p_attribute26 in varchar2 default hr_api.g_varchar2
151: ,p_attribute27 in varchar2 default hr_api.g_varchar2
152: ,p_attribute28 in varchar2 default hr_api.g_varchar2
153: ,p_attribute29 in varchar2 default hr_api.g_varchar2
154: ,p_attribute30 in varchar2 default hr_api.g_varchar2
155: ,p_change_reason in varchar2 default null
156: ,p_decline_reason in varchar2 default null
157: ,p_note_text in varchar2 default null
158: ,p_status_change_date in date default null

Line 188: (p_validate in number default hr_api.g_false_num

184: --
185: -- {End of comments}
186: -- ----------------------------------------------------------------------------
187: PROCEDURE delete_offer
188: (p_validate in number default hr_api.g_false_num
189: ,p_object_version_number in number
190: ,p_offer_id in number
191: ,p_effective_date in date default hr_api.g_date
192: ,p_return_status out nocopy varchar2

Line 191: ,p_effective_date in date default hr_api.g_date

187: PROCEDURE delete_offer
188: (p_validate in number default hr_api.g_false_num
189: ,p_object_version_number in number
190: ,p_offer_id in number
191: ,p_effective_date in date default hr_api.g_date
192: ,p_return_status out nocopy varchar2
193: );
194: -- ----------------------------------------------------------------------------
195: -- |------------------------------< close_offer >-----------------------------|

Line 218: (p_validate in number default hr_api.g_false_num

214: --
215: -- {End of comments}
216: -- ----------------------------------------------------------------------------
217: PROCEDURE close_offer
218: (p_validate in number default hr_api.g_false_num
219: ,p_effective_date in date default hr_api.g_date
220: ,p_applicant_assignment_id in number default hr_api.g_number
221: ,p_offer_id in number default hr_api.g_number
222: ,p_respondent_id in number default hr_api.g_number

Line 219: ,p_effective_date in date default hr_api.g_date

215: -- {End of comments}
216: -- ----------------------------------------------------------------------------
217: PROCEDURE close_offer
218: (p_validate in number default hr_api.g_false_num
219: ,p_effective_date in date default hr_api.g_date
220: ,p_applicant_assignment_id in number default hr_api.g_number
221: ,p_offer_id in number default hr_api.g_number
222: ,p_respondent_id in number default hr_api.g_number
223: ,p_change_reason in varchar2 default hr_api.g_varchar2

Line 220: ,p_applicant_assignment_id in number default hr_api.g_number

216: -- ----------------------------------------------------------------------------
217: PROCEDURE close_offer
218: (p_validate in number default hr_api.g_false_num
219: ,p_effective_date in date default hr_api.g_date
220: ,p_applicant_assignment_id in number default hr_api.g_number
221: ,p_offer_id in number default hr_api.g_number
222: ,p_respondent_id in number default hr_api.g_number
223: ,p_change_reason in varchar2 default hr_api.g_varchar2
224: ,p_decline_reason in varchar2 default hr_api.g_varchar2

Line 221: ,p_offer_id in number default hr_api.g_number

217: PROCEDURE close_offer
218: (p_validate in number default hr_api.g_false_num
219: ,p_effective_date in date default hr_api.g_date
220: ,p_applicant_assignment_id in number default hr_api.g_number
221: ,p_offer_id in number default hr_api.g_number
222: ,p_respondent_id in number default hr_api.g_number
223: ,p_change_reason in varchar2 default hr_api.g_varchar2
224: ,p_decline_reason in varchar2 default hr_api.g_varchar2
225: ,p_note_text in varchar2 default hr_api.g_varchar2

Line 222: ,p_respondent_id in number default hr_api.g_number

218: (p_validate in number default hr_api.g_false_num
219: ,p_effective_date in date default hr_api.g_date
220: ,p_applicant_assignment_id in number default hr_api.g_number
221: ,p_offer_id in number default hr_api.g_number
222: ,p_respondent_id in number default hr_api.g_number
223: ,p_change_reason in varchar2 default hr_api.g_varchar2
224: ,p_decline_reason in varchar2 default hr_api.g_varchar2
225: ,p_note_text in varchar2 default hr_api.g_varchar2
226: ,p_status_change_date in date default hr_api.g_date

Line 223: ,p_change_reason in varchar2 default hr_api.g_varchar2

219: ,p_effective_date in date default hr_api.g_date
220: ,p_applicant_assignment_id in number default hr_api.g_number
221: ,p_offer_id in number default hr_api.g_number
222: ,p_respondent_id in number default hr_api.g_number
223: ,p_change_reason in varchar2 default hr_api.g_varchar2
224: ,p_decline_reason in varchar2 default hr_api.g_varchar2
225: ,p_note_text in varchar2 default hr_api.g_varchar2
226: ,p_status_change_date in date default hr_api.g_date
227: ,p_return_status out nocopy varchar2

Line 224: ,p_decline_reason in varchar2 default hr_api.g_varchar2

220: ,p_applicant_assignment_id in number default hr_api.g_number
221: ,p_offer_id in number default hr_api.g_number
222: ,p_respondent_id in number default hr_api.g_number
223: ,p_change_reason in varchar2 default hr_api.g_varchar2
224: ,p_decline_reason in varchar2 default hr_api.g_varchar2
225: ,p_note_text in varchar2 default hr_api.g_varchar2
226: ,p_status_change_date in date default hr_api.g_date
227: ,p_return_status out nocopy varchar2
228: );

Line 225: ,p_note_text in varchar2 default hr_api.g_varchar2

221: ,p_offer_id in number default hr_api.g_number
222: ,p_respondent_id in number default hr_api.g_number
223: ,p_change_reason in varchar2 default hr_api.g_varchar2
224: ,p_decline_reason in varchar2 default hr_api.g_varchar2
225: ,p_note_text in varchar2 default hr_api.g_varchar2
226: ,p_status_change_date in date default hr_api.g_date
227: ,p_return_status out nocopy varchar2
228: );
229: -- ----------------------------------------------------------------------------

Line 226: ,p_status_change_date in date default hr_api.g_date

222: ,p_respondent_id in number default hr_api.g_number
223: ,p_change_reason in varchar2 default hr_api.g_varchar2
224: ,p_decline_reason in varchar2 default hr_api.g_varchar2
225: ,p_note_text in varchar2 default hr_api.g_varchar2
226: ,p_status_change_date in date default hr_api.g_date
227: ,p_return_status out nocopy varchar2
228: );
229: -- ----------------------------------------------------------------------------
230: -- |------------------------------< hold_offer >------------------------------|

Line 253: (p_validate in number default hr_api.g_false_num

249: --
250: -- {End of comments}
251: -- ----------------------------------------------------------------------------
252: PROCEDURE hold_offer
253: (p_validate in number default hr_api.g_false_num
254: ,p_effective_date in date default hr_api.g_date
255: ,p_offer_id in number
256: ,p_respondent_id in number default hr_api.g_number
257: ,p_change_reason in varchar2 default hr_api.g_varchar2

Line 254: ,p_effective_date in date default hr_api.g_date

250: -- {End of comments}
251: -- ----------------------------------------------------------------------------
252: PROCEDURE hold_offer
253: (p_validate in number default hr_api.g_false_num
254: ,p_effective_date in date default hr_api.g_date
255: ,p_offer_id in number
256: ,p_respondent_id in number default hr_api.g_number
257: ,p_change_reason in varchar2 default hr_api.g_varchar2
258: ,p_status_change_date in date default hr_api.g_date

Line 256: ,p_respondent_id in number default hr_api.g_number

252: PROCEDURE hold_offer
253: (p_validate in number default hr_api.g_false_num
254: ,p_effective_date in date default hr_api.g_date
255: ,p_offer_id in number
256: ,p_respondent_id in number default hr_api.g_number
257: ,p_change_reason in varchar2 default hr_api.g_varchar2
258: ,p_status_change_date in date default hr_api.g_date
259: ,p_note_text in varchar2 default hr_api.g_varchar2
260: ,p_object_version_number in out nocopy number

Line 257: ,p_change_reason in varchar2 default hr_api.g_varchar2

253: (p_validate in number default hr_api.g_false_num
254: ,p_effective_date in date default hr_api.g_date
255: ,p_offer_id in number
256: ,p_respondent_id in number default hr_api.g_number
257: ,p_change_reason in varchar2 default hr_api.g_varchar2
258: ,p_status_change_date in date default hr_api.g_date
259: ,p_note_text in varchar2 default hr_api.g_varchar2
260: ,p_object_version_number in out nocopy number
261: ,p_return_status out nocopy varchar2

Line 258: ,p_status_change_date in date default hr_api.g_date

254: ,p_effective_date in date default hr_api.g_date
255: ,p_offer_id in number
256: ,p_respondent_id in number default hr_api.g_number
257: ,p_change_reason in varchar2 default hr_api.g_varchar2
258: ,p_status_change_date in date default hr_api.g_date
259: ,p_note_text in varchar2 default hr_api.g_varchar2
260: ,p_object_version_number in out nocopy number
261: ,p_return_status out nocopy varchar2
262: );

Line 259: ,p_note_text in varchar2 default hr_api.g_varchar2

255: ,p_offer_id in number
256: ,p_respondent_id in number default hr_api.g_number
257: ,p_change_reason in varchar2 default hr_api.g_varchar2
258: ,p_status_change_date in date default hr_api.g_date
259: ,p_note_text in varchar2 default hr_api.g_varchar2
260: ,p_object_version_number in out nocopy number
261: ,p_return_status out nocopy varchar2
262: );
263: -- ----------------------------------------------------------------------------

Line 287: (p_validate in number default hr_api.g_false_num

283: --
284: -- {End of comments}
285: -- ----------------------------------------------------------------------------
286: PROCEDURE release_offer
287: (p_validate in number default hr_api.g_false_num
288: ,p_effective_date in date default hr_api.g_date
289: ,p_offer_id in number
290: ,p_respondent_id in number default hr_api.g_number
291: ,p_change_reason in varchar2 default hr_api.g_varchar2

Line 288: ,p_effective_date in date default hr_api.g_date

284: -- {End of comments}
285: -- ----------------------------------------------------------------------------
286: PROCEDURE release_offer
287: (p_validate in number default hr_api.g_false_num
288: ,p_effective_date in date default hr_api.g_date
289: ,p_offer_id in number
290: ,p_respondent_id in number default hr_api.g_number
291: ,p_change_reason in varchar2 default hr_api.g_varchar2
292: ,p_status_change_date in date default hr_api.g_date

Line 290: ,p_respondent_id in number default hr_api.g_number

286: PROCEDURE release_offer
287: (p_validate in number default hr_api.g_false_num
288: ,p_effective_date in date default hr_api.g_date
289: ,p_offer_id in number
290: ,p_respondent_id in number default hr_api.g_number
291: ,p_change_reason in varchar2 default hr_api.g_varchar2
292: ,p_status_change_date in date default hr_api.g_date
293: ,p_note_text in varchar2 default hr_api.g_varchar2
294: ,p_object_version_number in out nocopy number

Line 291: ,p_change_reason in varchar2 default hr_api.g_varchar2

287: (p_validate in number default hr_api.g_false_num
288: ,p_effective_date in date default hr_api.g_date
289: ,p_offer_id in number
290: ,p_respondent_id in number default hr_api.g_number
291: ,p_change_reason in varchar2 default hr_api.g_varchar2
292: ,p_status_change_date in date default hr_api.g_date
293: ,p_note_text in varchar2 default hr_api.g_varchar2
294: ,p_object_version_number in out nocopy number
295: ,p_return_status out nocopy varchar2

Line 292: ,p_status_change_date in date default hr_api.g_date

288: ,p_effective_date in date default hr_api.g_date
289: ,p_offer_id in number
290: ,p_respondent_id in number default hr_api.g_number
291: ,p_change_reason in varchar2 default hr_api.g_varchar2
292: ,p_status_change_date in date default hr_api.g_date
293: ,p_note_text in varchar2 default hr_api.g_varchar2
294: ,p_object_version_number in out nocopy number
295: ,p_return_status out nocopy varchar2
296: );

Line 293: ,p_note_text in varchar2 default hr_api.g_varchar2

289: ,p_offer_id in number
290: ,p_respondent_id in number default hr_api.g_number
291: ,p_change_reason in varchar2 default hr_api.g_varchar2
292: ,p_status_change_date in date default hr_api.g_date
293: ,p_note_text in varchar2 default hr_api.g_varchar2
294: ,p_object_version_number in out nocopy number
295: ,p_return_status out nocopy varchar2
296: );
297: -- ----------------------------------------------------------------------------

Line 411: ,p_validate in number default hr_api.g_false_num

407: ,p_title in varchar2 default null
408: ,p_validate_df_flex in number default null
409: ,p_object_version_number out nocopy number
410: ,p_effective_date in date
411: ,p_validate in number default hr_api.g_false_num
412: ,p_contract_id in number default null
413: ,p_establishment_id in number default null
414: ,p_collective_agreement_id in number default null
415: ,p_cagr_grade_def_id in number default null

Line 466: ,p_recruiter_id in number default hr_api.g_number

462: (p_assignment_id in out nocopy number
463: ,p_effective_start_date out nocopy date
464: ,p_effective_end_date out nocopy date
465: ,p_business_group_id out nocopy number
466: ,p_recruiter_id in number default hr_api.g_number
467: ,p_grade_id in number default hr_api.g_number
468: ,p_position_id in number default hr_api.g_number
469: ,p_job_id in number default hr_api.g_number
470: ,p_assignment_status_type_id in number default hr_api.g_number

Line 467: ,p_grade_id in number default hr_api.g_number

463: ,p_effective_start_date out nocopy date
464: ,p_effective_end_date out nocopy date
465: ,p_business_group_id out nocopy number
466: ,p_recruiter_id in number default hr_api.g_number
467: ,p_grade_id in number default hr_api.g_number
468: ,p_position_id in number default hr_api.g_number
469: ,p_job_id in number default hr_api.g_number
470: ,p_assignment_status_type_id in number default hr_api.g_number
471: ,p_payroll_id in number default hr_api.g_number

Line 468: ,p_position_id in number default hr_api.g_number

464: ,p_effective_end_date out nocopy date
465: ,p_business_group_id out nocopy number
466: ,p_recruiter_id in number default hr_api.g_number
467: ,p_grade_id in number default hr_api.g_number
468: ,p_position_id in number default hr_api.g_number
469: ,p_job_id in number default hr_api.g_number
470: ,p_assignment_status_type_id in number default hr_api.g_number
471: ,p_payroll_id in number default hr_api.g_number
472: ,p_location_id in number default hr_api.g_number

Line 469: ,p_job_id in number default hr_api.g_number

465: ,p_business_group_id out nocopy number
466: ,p_recruiter_id in number default hr_api.g_number
467: ,p_grade_id in number default hr_api.g_number
468: ,p_position_id in number default hr_api.g_number
469: ,p_job_id in number default hr_api.g_number
470: ,p_assignment_status_type_id in number default hr_api.g_number
471: ,p_payroll_id in number default hr_api.g_number
472: ,p_location_id in number default hr_api.g_number
473: ,p_person_referred_by_id in number default hr_api.g_number

Line 470: ,p_assignment_status_type_id in number default hr_api.g_number

466: ,p_recruiter_id in number default hr_api.g_number
467: ,p_grade_id in number default hr_api.g_number
468: ,p_position_id in number default hr_api.g_number
469: ,p_job_id in number default hr_api.g_number
470: ,p_assignment_status_type_id in number default hr_api.g_number
471: ,p_payroll_id in number default hr_api.g_number
472: ,p_location_id in number default hr_api.g_number
473: ,p_person_referred_by_id in number default hr_api.g_number
474: ,p_supervisor_id in number default hr_api.g_number

Line 471: ,p_payroll_id in number default hr_api.g_number

467: ,p_grade_id in number default hr_api.g_number
468: ,p_position_id in number default hr_api.g_number
469: ,p_job_id in number default hr_api.g_number
470: ,p_assignment_status_type_id in number default hr_api.g_number
471: ,p_payroll_id in number default hr_api.g_number
472: ,p_location_id in number default hr_api.g_number
473: ,p_person_referred_by_id in number default hr_api.g_number
474: ,p_supervisor_id in number default hr_api.g_number
475: ,p_special_ceiling_step_id in number default hr_api.g_number

Line 472: ,p_location_id in number default hr_api.g_number

468: ,p_position_id in number default hr_api.g_number
469: ,p_job_id in number default hr_api.g_number
470: ,p_assignment_status_type_id in number default hr_api.g_number
471: ,p_payroll_id in number default hr_api.g_number
472: ,p_location_id in number default hr_api.g_number
473: ,p_person_referred_by_id in number default hr_api.g_number
474: ,p_supervisor_id in number default hr_api.g_number
475: ,p_special_ceiling_step_id in number default hr_api.g_number
476: ,p_recruitment_activity_id in number default hr_api.g_number

Line 473: ,p_person_referred_by_id in number default hr_api.g_number

469: ,p_job_id in number default hr_api.g_number
470: ,p_assignment_status_type_id in number default hr_api.g_number
471: ,p_payroll_id in number default hr_api.g_number
472: ,p_location_id in number default hr_api.g_number
473: ,p_person_referred_by_id in number default hr_api.g_number
474: ,p_supervisor_id in number default hr_api.g_number
475: ,p_special_ceiling_step_id in number default hr_api.g_number
476: ,p_recruitment_activity_id in number default hr_api.g_number
477: ,p_source_organization_id in number default hr_api.g_number

Line 474: ,p_supervisor_id in number default hr_api.g_number

470: ,p_assignment_status_type_id in number default hr_api.g_number
471: ,p_payroll_id in number default hr_api.g_number
472: ,p_location_id in number default hr_api.g_number
473: ,p_person_referred_by_id in number default hr_api.g_number
474: ,p_supervisor_id in number default hr_api.g_number
475: ,p_special_ceiling_step_id in number default hr_api.g_number
476: ,p_recruitment_activity_id in number default hr_api.g_number
477: ,p_source_organization_id in number default hr_api.g_number
478: ,p_organization_id in number default hr_api.g_number

Line 475: ,p_special_ceiling_step_id in number default hr_api.g_number

471: ,p_payroll_id in number default hr_api.g_number
472: ,p_location_id in number default hr_api.g_number
473: ,p_person_referred_by_id in number default hr_api.g_number
474: ,p_supervisor_id in number default hr_api.g_number
475: ,p_special_ceiling_step_id in number default hr_api.g_number
476: ,p_recruitment_activity_id in number default hr_api.g_number
477: ,p_source_organization_id in number default hr_api.g_number
478: ,p_organization_id in number default hr_api.g_number
479: ,p_people_group_id in number default hr_api.g_number

Line 476: ,p_recruitment_activity_id in number default hr_api.g_number

472: ,p_location_id in number default hr_api.g_number
473: ,p_person_referred_by_id in number default hr_api.g_number
474: ,p_supervisor_id in number default hr_api.g_number
475: ,p_special_ceiling_step_id in number default hr_api.g_number
476: ,p_recruitment_activity_id in number default hr_api.g_number
477: ,p_source_organization_id in number default hr_api.g_number
478: ,p_organization_id in number default hr_api.g_number
479: ,p_people_group_id in number default hr_api.g_number
480: ,p_soft_coding_keyflex_id in number default hr_api.g_number

Line 477: ,p_source_organization_id in number default hr_api.g_number

473: ,p_person_referred_by_id in number default hr_api.g_number
474: ,p_supervisor_id in number default hr_api.g_number
475: ,p_special_ceiling_step_id in number default hr_api.g_number
476: ,p_recruitment_activity_id in number default hr_api.g_number
477: ,p_source_organization_id in number default hr_api.g_number
478: ,p_organization_id in number default hr_api.g_number
479: ,p_people_group_id in number default hr_api.g_number
480: ,p_soft_coding_keyflex_id in number default hr_api.g_number
481: ,p_vacancy_id in number default hr_api.g_number

Line 478: ,p_organization_id in number default hr_api.g_number

474: ,p_supervisor_id in number default hr_api.g_number
475: ,p_special_ceiling_step_id in number default hr_api.g_number
476: ,p_recruitment_activity_id in number default hr_api.g_number
477: ,p_source_organization_id in number default hr_api.g_number
478: ,p_organization_id in number default hr_api.g_number
479: ,p_people_group_id in number default hr_api.g_number
480: ,p_soft_coding_keyflex_id in number default hr_api.g_number
481: ,p_vacancy_id in number default hr_api.g_number
482: ,p_pay_basis_id in number default hr_api.g_number

Line 479: ,p_people_group_id in number default hr_api.g_number

475: ,p_special_ceiling_step_id in number default hr_api.g_number
476: ,p_recruitment_activity_id in number default hr_api.g_number
477: ,p_source_organization_id in number default hr_api.g_number
478: ,p_organization_id in number default hr_api.g_number
479: ,p_people_group_id in number default hr_api.g_number
480: ,p_soft_coding_keyflex_id in number default hr_api.g_number
481: ,p_vacancy_id in number default hr_api.g_number
482: ,p_pay_basis_id in number default hr_api.g_number
483: ,p_assignment_type in varchar2 default hr_api.g_varchar2

Line 480: ,p_soft_coding_keyflex_id in number default hr_api.g_number

476: ,p_recruitment_activity_id in number default hr_api.g_number
477: ,p_source_organization_id in number default hr_api.g_number
478: ,p_organization_id in number default hr_api.g_number
479: ,p_people_group_id in number default hr_api.g_number
480: ,p_soft_coding_keyflex_id in number default hr_api.g_number
481: ,p_vacancy_id in number default hr_api.g_number
482: ,p_pay_basis_id in number default hr_api.g_number
483: ,p_assignment_type in varchar2 default hr_api.g_varchar2
484: ,p_primary_flag in varchar2 default hr_api.g_varchar2

Line 481: ,p_vacancy_id in number default hr_api.g_number

477: ,p_source_organization_id in number default hr_api.g_number
478: ,p_organization_id in number default hr_api.g_number
479: ,p_people_group_id in number default hr_api.g_number
480: ,p_soft_coding_keyflex_id in number default hr_api.g_number
481: ,p_vacancy_id in number default hr_api.g_number
482: ,p_pay_basis_id in number default hr_api.g_number
483: ,p_assignment_type in varchar2 default hr_api.g_varchar2
484: ,p_primary_flag in varchar2 default hr_api.g_varchar2
485: ,p_application_id in number default hr_api.g_number

Line 482: ,p_pay_basis_id in number default hr_api.g_number

478: ,p_organization_id in number default hr_api.g_number
479: ,p_people_group_id in number default hr_api.g_number
480: ,p_soft_coding_keyflex_id in number default hr_api.g_number
481: ,p_vacancy_id in number default hr_api.g_number
482: ,p_pay_basis_id in number default hr_api.g_number
483: ,p_assignment_type in varchar2 default hr_api.g_varchar2
484: ,p_primary_flag in varchar2 default hr_api.g_varchar2
485: ,p_application_id in number default hr_api.g_number
486: ,p_assignment_number in varchar2 default hr_api.g_varchar2

Line 483: ,p_assignment_type in varchar2 default hr_api.g_varchar2

479: ,p_people_group_id in number default hr_api.g_number
480: ,p_soft_coding_keyflex_id in number default hr_api.g_number
481: ,p_vacancy_id in number default hr_api.g_number
482: ,p_pay_basis_id in number default hr_api.g_number
483: ,p_assignment_type in varchar2 default hr_api.g_varchar2
484: ,p_primary_flag in varchar2 default hr_api.g_varchar2
485: ,p_application_id in number default hr_api.g_number
486: ,p_assignment_number in varchar2 default hr_api.g_varchar2
487: ,p_change_reason in varchar2 default hr_api.g_varchar2

Line 484: ,p_primary_flag in varchar2 default hr_api.g_varchar2

480: ,p_soft_coding_keyflex_id in number default hr_api.g_number
481: ,p_vacancy_id in number default hr_api.g_number
482: ,p_pay_basis_id in number default hr_api.g_number
483: ,p_assignment_type in varchar2 default hr_api.g_varchar2
484: ,p_primary_flag in varchar2 default hr_api.g_varchar2
485: ,p_application_id in number default hr_api.g_number
486: ,p_assignment_number in varchar2 default hr_api.g_varchar2
487: ,p_change_reason in varchar2 default hr_api.g_varchar2
488: ,p_comment_id out nocopy number

Line 485: ,p_application_id in number default hr_api.g_number

481: ,p_vacancy_id in number default hr_api.g_number
482: ,p_pay_basis_id in number default hr_api.g_number
483: ,p_assignment_type in varchar2 default hr_api.g_varchar2
484: ,p_primary_flag in varchar2 default hr_api.g_varchar2
485: ,p_application_id in number default hr_api.g_number
486: ,p_assignment_number in varchar2 default hr_api.g_varchar2
487: ,p_change_reason in varchar2 default hr_api.g_varchar2
488: ,p_comment_id out nocopy number
489: ,p_comments in varchar2 default hr_api.g_varchar2

Line 486: ,p_assignment_number in varchar2 default hr_api.g_varchar2

482: ,p_pay_basis_id in number default hr_api.g_number
483: ,p_assignment_type in varchar2 default hr_api.g_varchar2
484: ,p_primary_flag in varchar2 default hr_api.g_varchar2
485: ,p_application_id in number default hr_api.g_number
486: ,p_assignment_number in varchar2 default hr_api.g_varchar2
487: ,p_change_reason in varchar2 default hr_api.g_varchar2
488: ,p_comment_id out nocopy number
489: ,p_comments in varchar2 default hr_api.g_varchar2
490: ,p_date_probation_end in date default hr_api.g_date

Line 487: ,p_change_reason in varchar2 default hr_api.g_varchar2

483: ,p_assignment_type in varchar2 default hr_api.g_varchar2
484: ,p_primary_flag in varchar2 default hr_api.g_varchar2
485: ,p_application_id in number default hr_api.g_number
486: ,p_assignment_number in varchar2 default hr_api.g_varchar2
487: ,p_change_reason in varchar2 default hr_api.g_varchar2
488: ,p_comment_id out nocopy number
489: ,p_comments in varchar2 default hr_api.g_varchar2
490: ,p_date_probation_end in date default hr_api.g_date
491: ,p_default_code_comb_id in number default hr_api.g_number

Line 489: ,p_comments in varchar2 default hr_api.g_varchar2

485: ,p_application_id in number default hr_api.g_number
486: ,p_assignment_number in varchar2 default hr_api.g_varchar2
487: ,p_change_reason in varchar2 default hr_api.g_varchar2
488: ,p_comment_id out nocopy number
489: ,p_comments in varchar2 default hr_api.g_varchar2
490: ,p_date_probation_end in date default hr_api.g_date
491: ,p_default_code_comb_id in number default hr_api.g_number
492: ,p_employment_category in varchar2 default hr_api.g_varchar2
493: ,p_frequency in varchar2 default hr_api.g_varchar2

Line 490: ,p_date_probation_end in date default hr_api.g_date

486: ,p_assignment_number in varchar2 default hr_api.g_varchar2
487: ,p_change_reason in varchar2 default hr_api.g_varchar2
488: ,p_comment_id out nocopy number
489: ,p_comments in varchar2 default hr_api.g_varchar2
490: ,p_date_probation_end in date default hr_api.g_date
491: ,p_default_code_comb_id in number default hr_api.g_number
492: ,p_employment_category in varchar2 default hr_api.g_varchar2
493: ,p_frequency in varchar2 default hr_api.g_varchar2
494: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

Line 491: ,p_default_code_comb_id in number default hr_api.g_number

487: ,p_change_reason in varchar2 default hr_api.g_varchar2
488: ,p_comment_id out nocopy number
489: ,p_comments in varchar2 default hr_api.g_varchar2
490: ,p_date_probation_end in date default hr_api.g_date
491: ,p_default_code_comb_id in number default hr_api.g_number
492: ,p_employment_category in varchar2 default hr_api.g_varchar2
493: ,p_frequency in varchar2 default hr_api.g_varchar2
494: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
495: ,p_manager_flag in varchar2 default hr_api.g_varchar2

Line 492: ,p_employment_category in varchar2 default hr_api.g_varchar2

488: ,p_comment_id out nocopy number
489: ,p_comments in varchar2 default hr_api.g_varchar2
490: ,p_date_probation_end in date default hr_api.g_date
491: ,p_default_code_comb_id in number default hr_api.g_number
492: ,p_employment_category in varchar2 default hr_api.g_varchar2
493: ,p_frequency in varchar2 default hr_api.g_varchar2
494: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
495: ,p_manager_flag in varchar2 default hr_api.g_varchar2
496: ,p_normal_hours in number default hr_api.g_number

Line 493: ,p_frequency in varchar2 default hr_api.g_varchar2

489: ,p_comments in varchar2 default hr_api.g_varchar2
490: ,p_date_probation_end in date default hr_api.g_date
491: ,p_default_code_comb_id in number default hr_api.g_number
492: ,p_employment_category in varchar2 default hr_api.g_varchar2
493: ,p_frequency in varchar2 default hr_api.g_varchar2
494: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
495: ,p_manager_flag in varchar2 default hr_api.g_varchar2
496: ,p_normal_hours in number default hr_api.g_number
497: ,p_perf_review_period in number default hr_api.g_number

Line 494: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

490: ,p_date_probation_end in date default hr_api.g_date
491: ,p_default_code_comb_id in number default hr_api.g_number
492: ,p_employment_category in varchar2 default hr_api.g_varchar2
493: ,p_frequency in varchar2 default hr_api.g_varchar2
494: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
495: ,p_manager_flag in varchar2 default hr_api.g_varchar2
496: ,p_normal_hours in number default hr_api.g_number
497: ,p_perf_review_period in number default hr_api.g_number
498: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

Line 495: ,p_manager_flag in varchar2 default hr_api.g_varchar2

491: ,p_default_code_comb_id in number default hr_api.g_number
492: ,p_employment_category in varchar2 default hr_api.g_varchar2
493: ,p_frequency in varchar2 default hr_api.g_varchar2
494: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
495: ,p_manager_flag in varchar2 default hr_api.g_varchar2
496: ,p_normal_hours in number default hr_api.g_number
497: ,p_perf_review_period in number default hr_api.g_number
498: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
499: ,p_period_of_service_id in number default hr_api.g_number

Line 496: ,p_normal_hours in number default hr_api.g_number

492: ,p_employment_category in varchar2 default hr_api.g_varchar2
493: ,p_frequency in varchar2 default hr_api.g_varchar2
494: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
495: ,p_manager_flag in varchar2 default hr_api.g_varchar2
496: ,p_normal_hours in number default hr_api.g_number
497: ,p_perf_review_period in number default hr_api.g_number
498: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
499: ,p_period_of_service_id in number default hr_api.g_number
500: ,p_probation_period in number default hr_api.g_number

Line 497: ,p_perf_review_period in number default hr_api.g_number

493: ,p_frequency in varchar2 default hr_api.g_varchar2
494: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
495: ,p_manager_flag in varchar2 default hr_api.g_varchar2
496: ,p_normal_hours in number default hr_api.g_number
497: ,p_perf_review_period in number default hr_api.g_number
498: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
499: ,p_period_of_service_id in number default hr_api.g_number
500: ,p_probation_period in number default hr_api.g_number
501: ,p_probation_unit in varchar2 default hr_api.g_varchar2

Line 498: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

494: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
495: ,p_manager_flag in varchar2 default hr_api.g_varchar2
496: ,p_normal_hours in number default hr_api.g_number
497: ,p_perf_review_period in number default hr_api.g_number
498: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
499: ,p_period_of_service_id in number default hr_api.g_number
500: ,p_probation_period in number default hr_api.g_number
501: ,p_probation_unit in varchar2 default hr_api.g_varchar2
502: ,p_sal_review_period in number default hr_api.g_number

Line 499: ,p_period_of_service_id in number default hr_api.g_number

495: ,p_manager_flag in varchar2 default hr_api.g_varchar2
496: ,p_normal_hours in number default hr_api.g_number
497: ,p_perf_review_period in number default hr_api.g_number
498: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
499: ,p_period_of_service_id in number default hr_api.g_number
500: ,p_probation_period in number default hr_api.g_number
501: ,p_probation_unit in varchar2 default hr_api.g_varchar2
502: ,p_sal_review_period in number default hr_api.g_number
503: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

Line 500: ,p_probation_period in number default hr_api.g_number

496: ,p_normal_hours in number default hr_api.g_number
497: ,p_perf_review_period in number default hr_api.g_number
498: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
499: ,p_period_of_service_id in number default hr_api.g_number
500: ,p_probation_period in number default hr_api.g_number
501: ,p_probation_unit in varchar2 default hr_api.g_varchar2
502: ,p_sal_review_period in number default hr_api.g_number
503: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
504: ,p_set_of_books_id in number default hr_api.g_number

Line 501: ,p_probation_unit in varchar2 default hr_api.g_varchar2

497: ,p_perf_review_period in number default hr_api.g_number
498: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
499: ,p_period_of_service_id in number default hr_api.g_number
500: ,p_probation_period in number default hr_api.g_number
501: ,p_probation_unit in varchar2 default hr_api.g_varchar2
502: ,p_sal_review_period in number default hr_api.g_number
503: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
504: ,p_set_of_books_id in number default hr_api.g_number
505: ,p_source_type in varchar2 default hr_api.g_varchar2

Line 502: ,p_sal_review_period in number default hr_api.g_number

498: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
499: ,p_period_of_service_id in number default hr_api.g_number
500: ,p_probation_period in number default hr_api.g_number
501: ,p_probation_unit in varchar2 default hr_api.g_varchar2
502: ,p_sal_review_period in number default hr_api.g_number
503: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
504: ,p_set_of_books_id in number default hr_api.g_number
505: ,p_source_type in varchar2 default hr_api.g_varchar2
506: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

Line 503: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

499: ,p_period_of_service_id in number default hr_api.g_number
500: ,p_probation_period in number default hr_api.g_number
501: ,p_probation_unit in varchar2 default hr_api.g_varchar2
502: ,p_sal_review_period in number default hr_api.g_number
503: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
504: ,p_set_of_books_id in number default hr_api.g_number
505: ,p_source_type in varchar2 default hr_api.g_varchar2
506: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
507: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

Line 504: ,p_set_of_books_id in number default hr_api.g_number

500: ,p_probation_period in number default hr_api.g_number
501: ,p_probation_unit in varchar2 default hr_api.g_varchar2
502: ,p_sal_review_period in number default hr_api.g_number
503: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
504: ,p_set_of_books_id in number default hr_api.g_number
505: ,p_source_type in varchar2 default hr_api.g_varchar2
506: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
507: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
508: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

Line 505: ,p_source_type in varchar2 default hr_api.g_varchar2

501: ,p_probation_unit in varchar2 default hr_api.g_varchar2
502: ,p_sal_review_period in number default hr_api.g_number
503: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
504: ,p_set_of_books_id in number default hr_api.g_number
505: ,p_source_type in varchar2 default hr_api.g_varchar2
506: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
507: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
508: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
509: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2

Line 506: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

502: ,p_sal_review_period in number default hr_api.g_number
503: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
504: ,p_set_of_books_id in number default hr_api.g_number
505: ,p_source_type in varchar2 default hr_api.g_varchar2
506: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
507: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
508: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
509: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
510: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2

Line 507: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

503: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
504: ,p_set_of_books_id in number default hr_api.g_number
505: ,p_source_type in varchar2 default hr_api.g_varchar2
506: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
507: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
508: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
509: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
510: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
511: ,p_request_id in number default hr_api.g_number

Line 508: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

504: ,p_set_of_books_id in number default hr_api.g_number
505: ,p_source_type in varchar2 default hr_api.g_varchar2
506: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
507: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
508: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
509: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
510: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
511: ,p_request_id in number default hr_api.g_number
512: ,p_program_application_id in number default hr_api.g_number

Line 509: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2

505: ,p_source_type in varchar2 default hr_api.g_varchar2
506: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
507: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
508: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
509: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
510: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
511: ,p_request_id in number default hr_api.g_number
512: ,p_program_application_id in number default hr_api.g_number
513: ,p_program_id in number default hr_api.g_number

Line 510: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2

506: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
507: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
508: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
509: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
510: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
511: ,p_request_id in number default hr_api.g_number
512: ,p_program_application_id in number default hr_api.g_number
513: ,p_program_id in number default hr_api.g_number
514: ,p_program_update_date in date default hr_api.g_date

Line 511: ,p_request_id in number default hr_api.g_number

507: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
508: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
509: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
510: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
511: ,p_request_id in number default hr_api.g_number
512: ,p_program_application_id in number default hr_api.g_number
513: ,p_program_id in number default hr_api.g_number
514: ,p_program_update_date in date default hr_api.g_date
515: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

Line 512: ,p_program_application_id in number default hr_api.g_number

508: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
509: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
510: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
511: ,p_request_id in number default hr_api.g_number
512: ,p_program_application_id in number default hr_api.g_number
513: ,p_program_id in number default hr_api.g_number
514: ,p_program_update_date in date default hr_api.g_date
515: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
516: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

Line 513: ,p_program_id in number default hr_api.g_number

509: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
510: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
511: ,p_request_id in number default hr_api.g_number
512: ,p_program_application_id in number default hr_api.g_number
513: ,p_program_id in number default hr_api.g_number
514: ,p_program_update_date in date default hr_api.g_date
515: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
516: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

Line 514: ,p_program_update_date in date default hr_api.g_date

510: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
511: ,p_request_id in number default hr_api.g_number
512: ,p_program_application_id in number default hr_api.g_number
513: ,p_program_id in number default hr_api.g_number
514: ,p_program_update_date in date default hr_api.g_date
515: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
516: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

Line 515: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

511: ,p_request_id in number default hr_api.g_number
512: ,p_program_application_id in number default hr_api.g_number
513: ,p_program_id in number default hr_api.g_number
514: ,p_program_update_date in date default hr_api.g_date
515: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
516: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

Line 516: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

512: ,p_program_application_id in number default hr_api.g_number
513: ,p_program_id in number default hr_api.g_number
514: ,p_program_update_date in date default hr_api.g_date
515: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
516: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

Line 517: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

513: ,p_program_id in number default hr_api.g_number
514: ,p_program_update_date in date default hr_api.g_date
515: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
516: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
521: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

Line 518: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

514: ,p_program_update_date in date default hr_api.g_date
515: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
516: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
521: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
522: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

Line 519: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

515: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
516: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
521: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
522: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
523: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

Line 520: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

516: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
521: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
522: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
523: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
524: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

Line 521: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

517: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
521: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
522: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
523: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
524: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
525: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

Line 522: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

518: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
521: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
522: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
523: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
524: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
525: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
526: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

Line 523: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

519: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
521: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
522: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
523: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
524: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
525: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
526: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
527: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

Line 524: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

520: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
521: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
522: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
523: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
524: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
525: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
526: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
527: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
528: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

Line 525: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

521: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
522: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
523: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
524: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
525: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
526: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
527: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
528: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
529: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

Line 526: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

522: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
523: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
524: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
525: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
526: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
527: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
528: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
529: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
530: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

Line 527: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

523: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
524: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
525: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
526: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
527: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
528: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
529: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
530: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
531: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

Line 528: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

524: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
525: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
526: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
527: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
528: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
529: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
530: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
531: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
532: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

Line 529: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

525: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
526: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
527: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
528: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
529: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
530: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
531: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
532: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
533: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

Line 530: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

526: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
527: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
528: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
529: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
530: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
531: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
532: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
533: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
534: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

Line 531: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

527: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
528: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
529: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
530: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
531: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
532: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
533: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
534: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
535: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

Line 532: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

528: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
529: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
530: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
531: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
532: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
533: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
534: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
535: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
536: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

Line 533: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

529: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
530: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
531: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
532: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
533: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
534: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
535: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
536: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
537: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

Line 534: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

530: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
531: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
532: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
533: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
534: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
535: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
536: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
537: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
538: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

Line 535: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

531: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
532: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
533: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
534: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
535: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
536: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
537: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
538: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
539: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

Line 536: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

532: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
533: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
534: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
535: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
536: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
537: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
538: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
539: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
540: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

Line 537: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

533: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
534: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
535: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
536: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
537: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
538: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
539: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
540: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
541: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

Line 538: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

534: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
535: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
536: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
537: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
538: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
539: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
540: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
541: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
542: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

Line 539: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

535: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
536: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
537: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
538: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
539: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
540: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
541: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
542: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
543: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

Line 540: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

536: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
537: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
538: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
539: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
540: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
541: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
542: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
543: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
544: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

Line 541: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

537: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
538: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
539: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
540: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
541: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
542: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
543: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
544: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
545: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

Line 542: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

538: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
539: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
540: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
541: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
542: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
543: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
544: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
545: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
546: ,p_title in varchar2 default hr_api.g_varchar2

Line 543: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

539: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
540: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
541: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
542: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
543: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
544: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
545: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
546: ,p_title in varchar2 default hr_api.g_varchar2
547: ,p_contract_id in number default hr_api.g_number

Line 544: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

540: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
541: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
542: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
543: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
544: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
545: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
546: ,p_title in varchar2 default hr_api.g_varchar2
547: ,p_contract_id in number default hr_api.g_number
548: ,p_establishment_id in number default hr_api.g_number

Line 545: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

541: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
542: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
543: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
544: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
545: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
546: ,p_title in varchar2 default hr_api.g_varchar2
547: ,p_contract_id in number default hr_api.g_number
548: ,p_establishment_id in number default hr_api.g_number
549: ,p_collective_agreement_id in number default hr_api.g_number

Line 546: ,p_title in varchar2 default hr_api.g_varchar2

542: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
543: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
544: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
545: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
546: ,p_title in varchar2 default hr_api.g_varchar2
547: ,p_contract_id in number default hr_api.g_number
548: ,p_establishment_id in number default hr_api.g_number
549: ,p_collective_agreement_id in number default hr_api.g_number
550: ,p_cagr_grade_def_id in number default hr_api.g_number

Line 547: ,p_contract_id in number default hr_api.g_number

543: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
544: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
545: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
546: ,p_title in varchar2 default hr_api.g_varchar2
547: ,p_contract_id in number default hr_api.g_number
548: ,p_establishment_id in number default hr_api.g_number
549: ,p_collective_agreement_id in number default hr_api.g_number
550: ,p_cagr_grade_def_id in number default hr_api.g_number
551: ,p_cagr_id_flex_num in number default hr_api.g_number

Line 548: ,p_establishment_id in number default hr_api.g_number

544: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
545: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
546: ,p_title in varchar2 default hr_api.g_varchar2
547: ,p_contract_id in number default hr_api.g_number
548: ,p_establishment_id in number default hr_api.g_number
549: ,p_collective_agreement_id in number default hr_api.g_number
550: ,p_cagr_grade_def_id in number default hr_api.g_number
551: ,p_cagr_id_flex_num in number default hr_api.g_number
552: ,p_asg_object_version_number in out nocopy number

Line 549: ,p_collective_agreement_id in number default hr_api.g_number

545: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
546: ,p_title in varchar2 default hr_api.g_varchar2
547: ,p_contract_id in number default hr_api.g_number
548: ,p_establishment_id in number default hr_api.g_number
549: ,p_collective_agreement_id in number default hr_api.g_number
550: ,p_cagr_grade_def_id in number default hr_api.g_number
551: ,p_cagr_id_flex_num in number default hr_api.g_number
552: ,p_asg_object_version_number in out nocopy number
553: ,p_notice_period in number default hr_api.g_number

Line 550: ,p_cagr_grade_def_id in number default hr_api.g_number

546: ,p_title in varchar2 default hr_api.g_varchar2
547: ,p_contract_id in number default hr_api.g_number
548: ,p_establishment_id in number default hr_api.g_number
549: ,p_collective_agreement_id in number default hr_api.g_number
550: ,p_cagr_grade_def_id in number default hr_api.g_number
551: ,p_cagr_id_flex_num in number default hr_api.g_number
552: ,p_asg_object_version_number in out nocopy number
553: ,p_notice_period in number default hr_api.g_number
554: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2

Line 551: ,p_cagr_id_flex_num in number default hr_api.g_number

547: ,p_contract_id in number default hr_api.g_number
548: ,p_establishment_id in number default hr_api.g_number
549: ,p_collective_agreement_id in number default hr_api.g_number
550: ,p_cagr_grade_def_id in number default hr_api.g_number
551: ,p_cagr_id_flex_num in number default hr_api.g_number
552: ,p_asg_object_version_number in out nocopy number
553: ,p_notice_period in number default hr_api.g_number
554: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
555: ,p_employee_category in varchar2 default hr_api.g_varchar2

Line 553: ,p_notice_period in number default hr_api.g_number

549: ,p_collective_agreement_id in number default hr_api.g_number
550: ,p_cagr_grade_def_id in number default hr_api.g_number
551: ,p_cagr_id_flex_num in number default hr_api.g_number
552: ,p_asg_object_version_number in out nocopy number
553: ,p_notice_period in number default hr_api.g_number
554: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
555: ,p_employee_category in varchar2 default hr_api.g_varchar2
556: ,p_work_at_home in varchar2 default hr_api.g_varchar2
557: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2

Line 554: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2

550: ,p_cagr_grade_def_id in number default hr_api.g_number
551: ,p_cagr_id_flex_num in number default hr_api.g_number
552: ,p_asg_object_version_number in out nocopy number
553: ,p_notice_period in number default hr_api.g_number
554: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
555: ,p_employee_category in varchar2 default hr_api.g_varchar2
556: ,p_work_at_home in varchar2 default hr_api.g_varchar2
557: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
558: ,p_posting_content_id in number default hr_api.g_number

Line 555: ,p_employee_category in varchar2 default hr_api.g_varchar2

551: ,p_cagr_id_flex_num in number default hr_api.g_number
552: ,p_asg_object_version_number in out nocopy number
553: ,p_notice_period in number default hr_api.g_number
554: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
555: ,p_employee_category in varchar2 default hr_api.g_varchar2
556: ,p_work_at_home in varchar2 default hr_api.g_varchar2
557: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
558: ,p_posting_content_id in number default hr_api.g_number
559: ,p_placement_date_start in date default hr_api.g_date

Line 556: ,p_work_at_home in varchar2 default hr_api.g_varchar2

552: ,p_asg_object_version_number in out nocopy number
553: ,p_notice_period in number default hr_api.g_number
554: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
555: ,p_employee_category in varchar2 default hr_api.g_varchar2
556: ,p_work_at_home in varchar2 default hr_api.g_varchar2
557: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
558: ,p_posting_content_id in number default hr_api.g_number
559: ,p_placement_date_start in date default hr_api.g_date
560: ,p_vendor_id in number default hr_api.g_number

Line 557: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2

553: ,p_notice_period in number default hr_api.g_number
554: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
555: ,p_employee_category in varchar2 default hr_api.g_varchar2
556: ,p_work_at_home in varchar2 default hr_api.g_varchar2
557: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
558: ,p_posting_content_id in number default hr_api.g_number
559: ,p_placement_date_start in date default hr_api.g_date
560: ,p_vendor_id in number default hr_api.g_number
561: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2

Line 558: ,p_posting_content_id in number default hr_api.g_number

554: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
555: ,p_employee_category in varchar2 default hr_api.g_varchar2
556: ,p_work_at_home in varchar2 default hr_api.g_varchar2
557: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
558: ,p_posting_content_id in number default hr_api.g_number
559: ,p_placement_date_start in date default hr_api.g_date
560: ,p_vendor_id in number default hr_api.g_number
561: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
562: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2

Line 559: ,p_placement_date_start in date default hr_api.g_date

555: ,p_employee_category in varchar2 default hr_api.g_varchar2
556: ,p_work_at_home in varchar2 default hr_api.g_varchar2
557: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
558: ,p_posting_content_id in number default hr_api.g_number
559: ,p_placement_date_start in date default hr_api.g_date
560: ,p_vendor_id in number default hr_api.g_number
561: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
562: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
563: ,p_assignment_category in varchar2 default hr_api.g_varchar2

Line 560: ,p_vendor_id in number default hr_api.g_number

556: ,p_work_at_home in varchar2 default hr_api.g_varchar2
557: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
558: ,p_posting_content_id in number default hr_api.g_number
559: ,p_placement_date_start in date default hr_api.g_date
560: ,p_vendor_id in number default hr_api.g_number
561: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
562: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
563: ,p_assignment_category in varchar2 default hr_api.g_varchar2
564: ,p_project_title in varchar2 default hr_api.g_varchar2

Line 561: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2

557: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
558: ,p_posting_content_id in number default hr_api.g_number
559: ,p_placement_date_start in date default hr_api.g_date
560: ,p_vendor_id in number default hr_api.g_number
561: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
562: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
563: ,p_assignment_category in varchar2 default hr_api.g_varchar2
564: ,p_project_title in varchar2 default hr_api.g_varchar2
565: ,p_applicant_rank in number default hr_api.g_number

Line 562: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2

558: ,p_posting_content_id in number default hr_api.g_number
559: ,p_placement_date_start in date default hr_api.g_date
560: ,p_vendor_id in number default hr_api.g_number
561: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
562: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
563: ,p_assignment_category in varchar2 default hr_api.g_varchar2
564: ,p_project_title in varchar2 default hr_api.g_varchar2
565: ,p_applicant_rank in number default hr_api.g_number
566: ,p_grade_ladder_pgm_id in number default hr_api.g_number

Line 563: ,p_assignment_category in varchar2 default hr_api.g_varchar2

559: ,p_placement_date_start in date default hr_api.g_date
560: ,p_vendor_id in number default hr_api.g_number
561: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
562: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
563: ,p_assignment_category in varchar2 default hr_api.g_varchar2
564: ,p_project_title in varchar2 default hr_api.g_varchar2
565: ,p_applicant_rank in number default hr_api.g_number
566: ,p_grade_ladder_pgm_id in number default hr_api.g_number
567: ,p_supervisor_assignment_id in number default hr_api.g_number

Line 564: ,p_project_title in varchar2 default hr_api.g_varchar2

560: ,p_vendor_id in number default hr_api.g_number
561: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
562: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
563: ,p_assignment_category in varchar2 default hr_api.g_varchar2
564: ,p_project_title in varchar2 default hr_api.g_varchar2
565: ,p_applicant_rank in number default hr_api.g_number
566: ,p_grade_ladder_pgm_id in number default hr_api.g_number
567: ,p_supervisor_assignment_id in number default hr_api.g_number
568: ,p_vendor_site_id in number default hr_api.g_number

Line 565: ,p_applicant_rank in number default hr_api.g_number

561: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
562: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
563: ,p_assignment_category in varchar2 default hr_api.g_varchar2
564: ,p_project_title in varchar2 default hr_api.g_varchar2
565: ,p_applicant_rank in number default hr_api.g_number
566: ,p_grade_ladder_pgm_id in number default hr_api.g_number
567: ,p_supervisor_assignment_id in number default hr_api.g_number
568: ,p_vendor_site_id in number default hr_api.g_number
569: ,p_po_header_id in number default hr_api.g_number

Line 566: ,p_grade_ladder_pgm_id in number default hr_api.g_number

562: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
563: ,p_assignment_category in varchar2 default hr_api.g_varchar2
564: ,p_project_title in varchar2 default hr_api.g_varchar2
565: ,p_applicant_rank in number default hr_api.g_number
566: ,p_grade_ladder_pgm_id in number default hr_api.g_number
567: ,p_supervisor_assignment_id in number default hr_api.g_number
568: ,p_vendor_site_id in number default hr_api.g_number
569: ,p_po_header_id in number default hr_api.g_number
570: ,p_po_line_id in number default hr_api.g_number

Line 567: ,p_supervisor_assignment_id in number default hr_api.g_number

563: ,p_assignment_category in varchar2 default hr_api.g_varchar2
564: ,p_project_title in varchar2 default hr_api.g_varchar2
565: ,p_applicant_rank in number default hr_api.g_number
566: ,p_grade_ladder_pgm_id in number default hr_api.g_number
567: ,p_supervisor_assignment_id in number default hr_api.g_number
568: ,p_vendor_site_id in number default hr_api.g_number
569: ,p_po_header_id in number default hr_api.g_number
570: ,p_po_line_id in number default hr_api.g_number
571: ,p_projected_assignment_end in date default hr_api.g_date

Line 568: ,p_vendor_site_id in number default hr_api.g_number

564: ,p_project_title in varchar2 default hr_api.g_varchar2
565: ,p_applicant_rank in number default hr_api.g_number
566: ,p_grade_ladder_pgm_id in number default hr_api.g_number
567: ,p_supervisor_assignment_id in number default hr_api.g_number
568: ,p_vendor_site_id in number default hr_api.g_number
569: ,p_po_header_id in number default hr_api.g_number
570: ,p_po_line_id in number default hr_api.g_number
571: ,p_projected_assignment_end in date default hr_api.g_date
572: ,p_payroll_id_updated out nocopy number

Line 569: ,p_po_header_id in number default hr_api.g_number

565: ,p_applicant_rank in number default hr_api.g_number
566: ,p_grade_ladder_pgm_id in number default hr_api.g_number
567: ,p_supervisor_assignment_id in number default hr_api.g_number
568: ,p_vendor_site_id in number default hr_api.g_number
569: ,p_po_header_id in number default hr_api.g_number
570: ,p_po_line_id in number default hr_api.g_number
571: ,p_projected_assignment_end in date default hr_api.g_date
572: ,p_payroll_id_updated out nocopy number
573: ,p_validation_start_date out nocopy date

Line 570: ,p_po_line_id in number default hr_api.g_number

566: ,p_grade_ladder_pgm_id in number default hr_api.g_number
567: ,p_supervisor_assignment_id in number default hr_api.g_number
568: ,p_vendor_site_id in number default hr_api.g_number
569: ,p_po_header_id in number default hr_api.g_number
570: ,p_po_line_id in number default hr_api.g_number
571: ,p_projected_assignment_end in date default hr_api.g_date
572: ,p_payroll_id_updated out nocopy number
573: ,p_validation_start_date out nocopy date
574: ,p_validation_end_date out nocopy date

Line 571: ,p_projected_assignment_end in date default hr_api.g_date

567: ,p_supervisor_assignment_id in number default hr_api.g_number
568: ,p_vendor_site_id in number default hr_api.g_number
569: ,p_po_header_id in number default hr_api.g_number
570: ,p_po_line_id in number default hr_api.g_number
571: ,p_projected_assignment_end in date default hr_api.g_date
572: ,p_payroll_id_updated out nocopy number
573: ,p_validation_start_date out nocopy date
574: ,p_validation_end_date out nocopy date
575: ,p_effective_date in date default hr_api.g_date

Line 575: ,p_effective_date in date default hr_api.g_date

571: ,p_projected_assignment_end in date default hr_api.g_date
572: ,p_payroll_id_updated out nocopy number
573: ,p_validation_start_date out nocopy date
574: ,p_validation_end_date out nocopy date
575: ,p_effective_date in date default hr_api.g_date
576: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
577: ,p_validate in number default hr_api.g_false_num
578: ,p_offer_id in out nocopy number
579: ,p_offer_status in varchar2 default null

Line 576: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2

572: ,p_payroll_id_updated out nocopy number
573: ,p_validation_start_date out nocopy date
574: ,p_validation_end_date out nocopy date
575: ,p_effective_date in date default hr_api.g_date
576: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
577: ,p_validate in number default hr_api.g_false_num
578: ,p_offer_id in out nocopy number
579: ,p_offer_status in varchar2 default null
580: ,p_return_status out nocopy varchar2

Line 577: ,p_validate in number default hr_api.g_false_num

573: ,p_validation_start_date out nocopy date
574: ,p_validation_end_date out nocopy date
575: ,p_effective_date in date default hr_api.g_date
576: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
577: ,p_validate in number default hr_api.g_false_num
578: ,p_offer_id in out nocopy number
579: ,p_offer_status in varchar2 default null
580: ,p_return_status out nocopy varchar2
581: );

Line 606: (p_validate in number default hr_api.g_false_num

602: --
603: -- {End of comments}
604: -- ----------------------------------------------------------------------------
605: PROCEDURE delete_offer_assignment
606: (p_validate in number default hr_api.g_false_num
607: ,p_effective_date in date default hr_api.g_date
608: ,p_offer_assignment_id in number
609: ,p_return_status out nocopy varchar2
610: );

Line 607: ,p_effective_date in date default hr_api.g_date

603: -- {End of comments}
604: -- ----------------------------------------------------------------------------
605: PROCEDURE delete_offer_assignment
606: (p_validate in number default hr_api.g_false_num
607: ,p_effective_date in date default hr_api.g_date
608: ,p_offer_assignment_id in number
609: ,p_return_status out nocopy varchar2
610: );
611: -- ----------------------------------------------------------------------------

Line 635: (p_validate in number default hr_api.g_false_num

631: --
632: -- {End of comments}
633: -- ----------------------------------------------------------------------------
634: PROCEDURE upload_offer_letter
635: (p_validate in number default hr_api.g_false_num
636: ,p_offer_letter in BLOB
637: ,p_offer_id in number
638: ,p_object_version_number in number
639: ,p_return_status out nocopy varchar2

Line 666: ,p_effective_end_date in date default hr_api.g_eot

662: -- ----------------------------------------------------------------------------
663: PROCEDURE run_benmgle_for_irec
664: (p_assignment_id in number
665: ,p_effective_start_date in date default trunc(sysdate)
666: ,p_effective_end_date in date default hr_api.g_eot
667: ,p_business_group_id in number
668: ,p_recruiter_id in number default null
669: ,p_grade_id in number default null
670: ,p_position_id in number default null

Line 785: ,p_effective_end_date in date default hr_api.g_eot

781: -- ----------------------------------------------------------------------------
782: PROCEDURE is_run_benmgle_for_irec_reqd
783: (p_assignment_id in number
784: ,p_effective_start_date in date default trunc(sysdate)
785: ,p_effective_end_date in date default hr_api.g_eot
786: ,p_business_group_id in number
787: ,p_recruiter_id in number default null
788: ,p_grade_id in number default null
789: ,p_position_id in number default null

Line 956: ,p_validate in number default hr_api.g_false_num

952: procedure process_offers_api
953: (
954: p_document in CLOB
955: ,p_return_status out nocopy VARCHAR2
956: ,p_validate in number default hr_api.g_false_num
957: ,p_effective_date in date default null
958: );
959:
960: -- ----------------------------------------------------------------------------

Line 968: ,p_validate in number default hr_api.g_false_num

964: procedure process_asg_api
965: (
966: p_document in CLOB
967: ,p_return_status out nocopy VARCHAR2
968: ,p_validate in number default hr_api.g_false_num
969: ,p_effective_date in date default null
970: );
971:
972: -- ----------------------------------------------------------------------------