163: if c.p5 is null then
164: L_ASSIGNMENT_ID:=nn;
165: else
166: L_ASSIGNMENT_ID :=
167: hr_pump_get.get_assignment_id
168: (P_ASSIGNMENT_USER_KEY => c.p5);
169: end if;
170: --
171: if c.d6=cn or
177: c.d7 is null then
178: L_CHANGE_REASON:=vh;
179: else
180: L_CHANGE_REASON :=
181: hr_pump_get.GET_CHANGE_REASON
182: (P_CHANGE_REASON => c.p6
183: ,P_ASSIGNMENT_USER_KEY => c.p5
184: ,P_EFFECTIVE_DATE => c.p1
185: ,P_LANGUAGE_CODE => c.p7);
189: c.p1 is null then
190: L_OBJECT_VERSION_NUMBER:=nn;
191: else
192: L_OBJECT_VERSION_NUMBER :=
193: hr_pump_get.GET_ASG_OVN
194: (P_ASSIGNMENT_USER_KEY => c.p5
195: ,P_EFFECTIVE_DATE => c.p1);
196: end if;
197: --
202: c.d7 is null then
203: L_ASSIGNMENT_STATUS_TYPE_ID:=nh;
204: else
205: L_ASSIGNMENT_STATUS_TYPE_ID :=
206: hr_pump_get.get_assignment_status_type_id
207: (P_USER_STATUS => c.p8
208: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
209: ,P_LANGUAGE_CODE => c.p7);
210: end if;