136: --
137: l_person_id_canonical := wf_event.getvalueforparameter(
138: p_name => 'PERSONID',
139: p_parameterlist => p_parameters);
140: l_person_id := FND_NUMBER.canonical_to_number(l_person_id_canonical);
141: --
142: -- 3297591
143: --/*
144: l_person_party_id_canonical := wf_event.getvalueforparameter(
143: --/*
144: l_person_party_id_canonical := wf_event.getvalueforparameter(
145: p_name => 'PERSONPARTYID',
146: p_parameterlist => p_parameters);
147: l_person_party_id := FND_NUMBER.canonical_to_number(l_person_party_id_canonical);
148: --*/
149: --
150: -- get the appropriate person record.
151: --
168: l_assignment_id_canonical := wf_event.getvalueforparameter(
169: p_name => 'ASSIGNMENTID',
170: p_parameterlist => p_parameters);
171: --
172: l_assignment_id := FND_NUMBER.canonical_to_number(l_assignment_id_canonical);
173: --
174: -- get the appropriate assignment record
175: --
176: open l_assignment_cur;
262: return;
263: --
264: end if;*/
265: --
266: l_person_id_canonical := FND_NUMBER.number_to_canonical(p_rec.person_id);
267: l_person_party_id_canonical := FND_NUMBER.number_to_canonical(p_rec.party_id); -- 3297591
268: l_start_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_start_date);
269: l_end_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_end_date);
270: -- need to set up display name here - 3297591...
263: --
264: end if;*/
265: --
266: l_person_id_canonical := FND_NUMBER.number_to_canonical(p_rec.person_id);
267: l_person_party_id_canonical := FND_NUMBER.number_to_canonical(p_rec.party_id); -- 3297591
268: l_start_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_start_date);
269: l_end_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_end_date);
270: -- need to set up display name here - 3297591...
271: l_display_name := HR_PERSON_NAME.get_person_name(p_rec.person_id,
608: hr_utility.set_location('Future Assignment ',40);
609: -- This is effective in the future date, Call_back routine must be called.
610: --
611: --
612: l_person_id_canonical := FND_NUMBER.number_to_canonical(p_rec.person_id);
613: l_assignment_id_canonical := FND_NUMBER.number_to_canonical(p_rec.assignment_id);
614: l_start_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_start_date);
615: l_end_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_end_date);
616: --
609: -- This is effective in the future date, Call_back routine must be called.
610: --
611: --
612: l_person_id_canonical := FND_NUMBER.number_to_canonical(p_rec.person_id);
613: l_assignment_id_canonical := FND_NUMBER.number_to_canonical(p_rec.assignment_id);
614: l_start_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_start_date);
615: l_end_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_end_date);
616: --
617: -- assign attributes and values for l_parameters.