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 105: (p_validate in number default hr_api.g_false_num

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

Line 106: ,p_effective_date in date default hr_api.g_date

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

Line 107: ,p_offer_status in varchar2 default hr_api.g_varchar2

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

Line 108: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2

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

Line 109: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2

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

Line 110: ,p_respondent_id in number default hr_api.g_number

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

Line 111: ,p_expiry_date in date default hr_api.g_date

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

Line 112: ,p_proposed_start_date in date default hr_api.g_date

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

Line 113: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2

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

Line 114: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2

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

Line 115: ,p_offer_shipping_date in date default hr_api.g_date

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

Line 116: ,p_applicant_assignment_id in number default hr_api.g_number

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

Line 117: ,p_offer_assignment_id in number default hr_api.g_number

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

Line 118: ,p_address_id in number default hr_api.g_number

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

Line 119: ,p_template_id in number default hr_api.g_number

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

Line 120: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2

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

Line 121: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2

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

Line 122: ,p_attribute_category in varchar2 default hr_api.g_varchar2

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

Line 123: ,p_attribute1 in varchar2 default hr_api.g_varchar2

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

Line 124: ,p_attribute2 in varchar2 default hr_api.g_varchar2

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

Line 125: ,p_attribute3 in varchar2 default hr_api.g_varchar2

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

Line 126: ,p_attribute4 in varchar2 default hr_api.g_varchar2

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

Line 127: ,p_attribute5 in varchar2 default hr_api.g_varchar2

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

Line 128: ,p_attribute6 in varchar2 default hr_api.g_varchar2

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

Line 129: ,p_attribute7 in varchar2 default hr_api.g_varchar2

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

Line 130: ,p_attribute8 in varchar2 default hr_api.g_varchar2

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

Line 131: ,p_attribute9 in varchar2 default hr_api.g_varchar2

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

Line 132: ,p_attribute10 in varchar2 default hr_api.g_varchar2

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

Line 133: ,p_attribute11 in varchar2 default hr_api.g_varchar2

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

Line 134: ,p_attribute12 in varchar2 default hr_api.g_varchar2

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

Line 135: ,p_attribute13 in varchar2 default hr_api.g_varchar2

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

Line 136: ,p_attribute14 in varchar2 default hr_api.g_varchar2

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

Line 137: ,p_attribute15 in varchar2 default hr_api.g_varchar2

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

Line 138: ,p_attribute16 in varchar2 default hr_api.g_varchar2

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

Line 139: ,p_attribute17 in varchar2 default hr_api.g_varchar2

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

Line 140: ,p_attribute18 in varchar2 default hr_api.g_varchar2

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

Line 141: ,p_attribute19 in varchar2 default hr_api.g_varchar2

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

Line 142: ,p_attribute20 in varchar2 default hr_api.g_varchar2

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

Line 143: ,p_attribute21 in varchar2 default hr_api.g_varchar2

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

Line 144: ,p_attribute22 in varchar2 default hr_api.g_varchar2

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

Line 145: ,p_attribute23 in varchar2 default hr_api.g_varchar2

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

Line 146: ,p_attribute24 in varchar2 default hr_api.g_varchar2

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

Line 147: ,p_attribute25 in varchar2 default hr_api.g_varchar2

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

Line 148: ,p_attribute26 in varchar2 default hr_api.g_varchar2

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

Line 149: ,p_attribute27 in varchar2 default hr_api.g_varchar2

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

Line 150: ,p_attribute28 in varchar2 default hr_api.g_varchar2

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

Line 151: ,p_attribute29 in varchar2 default hr_api.g_varchar2

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

Line 152: ,p_attribute30 in varchar2 default hr_api.g_varchar2

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

Line 186: (p_validate in number default hr_api.g_false_num

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

Line 189: ,p_effective_date in date default hr_api.g_date

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

Line 216: (p_validate in number default hr_api.g_false_num

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

Line 217: ,p_effective_date in date default hr_api.g_date

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

Line 218: ,p_applicant_assignment_id in number default hr_api.g_number

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

Line 219: ,p_offer_id in number default hr_api.g_number

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

Line 220: ,p_respondent_id in number default hr_api.g_number

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

Line 221: ,p_change_reason in varchar2 default hr_api.g_varchar2

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

Line 222: ,p_decline_reason in varchar2 default hr_api.g_varchar2

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

Line 223: ,p_note_text in varchar2 default hr_api.g_varchar2

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

Line 224: ,p_status_change_date in date default hr_api.g_date

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

Line 251: (p_validate in number default hr_api.g_false_num

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

Line 252: ,p_effective_date in date default hr_api.g_date

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

Line 254: ,p_respondent_id in number default hr_api.g_number

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

Line 255: ,p_change_reason in varchar2 default hr_api.g_varchar2

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

Line 256: ,p_status_change_date in date default hr_api.g_date

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

Line 257: ,p_note_text in varchar2 default hr_api.g_varchar2

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

Line 285: (p_validate in number default hr_api.g_false_num

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

Line 286: ,p_effective_date in date default hr_api.g_date

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

Line 288: ,p_respondent_id in number default hr_api.g_number

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

Line 289: ,p_change_reason in varchar2 default hr_api.g_varchar2

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

Line 290: ,p_status_change_date in date default hr_api.g_date

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

Line 291: ,p_note_text in varchar2 default hr_api.g_varchar2

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

Line 409: ,p_validate in number default hr_api.g_false_num

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

Line 464: ,p_recruiter_id in number default hr_api.g_number

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

Line 465: ,p_grade_id in number default hr_api.g_number

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

Line 466: ,p_position_id in number default hr_api.g_number

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

Line 467: ,p_job_id in number default hr_api.g_number

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

Line 468: ,p_assignment_status_type_id in number default hr_api.g_number

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

Line 469: ,p_payroll_id in number default hr_api.g_number

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

Line 470: ,p_location_id in number default hr_api.g_number

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

Line 471: ,p_person_referred_by_id in number default hr_api.g_number

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

Line 472: ,p_supervisor_id in number default hr_api.g_number

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

Line 473: ,p_special_ceiling_step_id in number default hr_api.g_number

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

Line 474: ,p_recruitment_activity_id in number default hr_api.g_number

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

Line 475: ,p_source_organization_id in number default hr_api.g_number

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

Line 476: ,p_organization_id in number default hr_api.g_number

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

Line 477: ,p_people_group_id in number default hr_api.g_number

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

Line 478: ,p_soft_coding_keyflex_id in number default hr_api.g_number

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

Line 479: ,p_vacancy_id in number default hr_api.g_number

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

Line 480: ,p_pay_basis_id in number default hr_api.g_number

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

Line 481: ,p_assignment_type in varchar2 default hr_api.g_varchar2

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

Line 482: ,p_primary_flag in varchar2 default hr_api.g_varchar2

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

Line 483: ,p_application_id in number default hr_api.g_number

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

Line 484: ,p_assignment_number in varchar2 default hr_api.g_varchar2

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

Line 485: ,p_change_reason in varchar2 default hr_api.g_varchar2

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

Line 487: ,p_comments in varchar2 default hr_api.g_varchar2

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

Line 488: ,p_date_probation_end in date default hr_api.g_date

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

Line 489: ,p_default_code_comb_id in number default hr_api.g_number

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

Line 490: ,p_employment_category in varchar2 default hr_api.g_varchar2

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

Line 491: ,p_frequency in varchar2 default hr_api.g_varchar2

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

Line 492: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

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

Line 493: ,p_manager_flag in varchar2 default hr_api.g_varchar2

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

Line 494: ,p_normal_hours in number default hr_api.g_number

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

Line 495: ,p_perf_review_period in number default hr_api.g_number

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

Line 496: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

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

Line 497: ,p_period_of_service_id in number default hr_api.g_number

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

Line 498: ,p_probation_period in number default hr_api.g_number

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

Line 499: ,p_probation_unit in varchar2 default hr_api.g_varchar2

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

Line 500: ,p_sal_review_period in number default hr_api.g_number

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

Line 501: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

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

Line 502: ,p_set_of_books_id in number default hr_api.g_number

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

Line 503: ,p_source_type in varchar2 default hr_api.g_varchar2

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

Line 504: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

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

Line 505: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

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

Line 506: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

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

Line 507: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2

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

Line 508: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2

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

Line 509: ,p_request_id in number default hr_api.g_number

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

Line 510: ,p_program_application_id in number default hr_api.g_number

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

Line 511: ,p_program_id in number default hr_api.g_number

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

Line 512: ,p_program_update_date in date default hr_api.g_date

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

Line 513: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

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

Line 514: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

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

Line 515: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

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

Line 516: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

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

Line 517: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

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

Line 518: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

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

Line 519: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

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

Line 520: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

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

Line 521: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

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

Line 522: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

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

Line 523: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

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

Line 524: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

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

Line 525: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

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

Line 526: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

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

Line 527: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

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

Line 528: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

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

Line 529: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

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

Line 530: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

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

Line 531: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

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

Line 532: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

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

Line 533: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

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

Line 534: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

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

Line 535: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

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

Line 536: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

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

Line 537: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

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

Line 538: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

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

Line 539: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

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

Line 540: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

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

Line 541: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

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

Line 542: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

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

Line 543: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

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

Line 544: ,p_title in varchar2 default hr_api.g_varchar2

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

Line 545: ,p_contract_id in number default hr_api.g_number

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

Line 546: ,p_establishment_id in number default hr_api.g_number

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

Line 547: ,p_collective_agreement_id in number default hr_api.g_number

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

Line 548: ,p_cagr_grade_def_id in number default hr_api.g_number

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

Line 549: ,p_cagr_id_flex_num in number default hr_api.g_number

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

Line 551: ,p_notice_period in number default hr_api.g_number

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

Line 552: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2

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

Line 553: ,p_employee_category in varchar2 default hr_api.g_varchar2

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

Line 554: ,p_work_at_home in varchar2 default hr_api.g_varchar2

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

Line 555: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2

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

Line 556: ,p_posting_content_id in number default hr_api.g_number

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

Line 557: ,p_placement_date_start in date default hr_api.g_date

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

Line 558: ,p_vendor_id in number default hr_api.g_number

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

Line 559: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2

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

Line 560: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2

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

Line 561: ,p_assignment_category in varchar2 default hr_api.g_varchar2

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

Line 562: ,p_project_title in varchar2 default hr_api.g_varchar2

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

Line 563: ,p_applicant_rank in number default hr_api.g_number

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

Line 564: ,p_grade_ladder_pgm_id in number default hr_api.g_number

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

Line 565: ,p_supervisor_assignment_id in number default hr_api.g_number

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

Line 566: ,p_vendor_site_id in number default hr_api.g_number

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

Line 567: ,p_po_header_id in number default hr_api.g_number

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

Line 568: ,p_po_line_id in number default hr_api.g_number

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

Line 569: ,p_projected_assignment_end in date default hr_api.g_date

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

Line 573: ,p_effective_date in date default hr_api.g_date

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

Line 574: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2

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

Line 575: ,p_validate in number default hr_api.g_false_num

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

Line 604: (p_validate in number default hr_api.g_false_num

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

Line 605: ,p_effective_date in date default hr_api.g_date

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

Line 633: (p_validate in number default hr_api.g_false_num

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

Line 664: ,p_effective_end_date in date default hr_api.g_eot

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

Line 783: ,p_effective_end_date in date default hr_api.g_eot

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

Line 954: ,p_validate in number default hr_api.g_false_num

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

Line 966: ,p_validate in number default hr_api.g_false_num

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