DBA Data[Home] [Help]

APPS.PER_HRWF_SYNCH dependencies on FND_DATE

Line 136: l_start_date := FND_DATE.canonical_to_date(l_start_date_canonical);

132: l_end_date_canonical := wf_event.getvalueforparameter(
133: p_name => 'ENDDATE',
134: p_parameterlist => p_parameters);
135:
136: l_start_date := FND_DATE.canonical_to_date(l_start_date_canonical);
137: l_end_date := FND_DATE.canonical_to_date(l_end_date_canonical);
138: hr_utility.set_location('End assign Values from param_list '||l_proc,30);
139: --
140: if l_entity = 'PERSON' then

Line 137: l_end_date := FND_DATE.canonical_to_date(l_end_date_canonical);

133: p_name => 'ENDDATE',
134: p_parameterlist => p_parameters);
135:
136: l_start_date := FND_DATE.canonical_to_date(l_start_date_canonical);
137: l_end_date := FND_DATE.canonical_to_date(l_end_date_canonical);
138: hr_utility.set_location('End assign Values from param_list '||l_proc,30);
139: --
140: if l_entity = 'PERSON' then
141: --

Line 315: l_start_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_start_date);

311: end if;*/
312: --
313: l_person_id_canonical := FND_NUMBER.number_to_canonical(p_rec.person_id);
314: l_person_party_id_canonical := FND_NUMBER.number_to_canonical(p_rec.party_id); -- 3297591
315: l_start_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_start_date);
316: l_end_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_end_date);
317: -- need to set up display name here - 3297591...
318: begin
319: l_display_name := HR_PERSON_NAME.get_person_name(p_rec.person_id,

Line 316: l_end_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_end_date);

312: --
313: l_person_id_canonical := FND_NUMBER.number_to_canonical(p_rec.person_id);
314: l_person_party_id_canonical := FND_NUMBER.number_to_canonical(p_rec.party_id); -- 3297591
315: l_start_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_start_date);
316: l_end_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_end_date);
317: -- need to set up display name here - 3297591...
318: begin
319: l_display_name := HR_PERSON_NAME.get_person_name(p_rec.person_id,
320: p_rec.effective_start_date,

Line 468: -- l_expiration_date := FND_DATE.date_to_canonical(p_rec.effective_end_date);

464: p_name => 'orclIsEnabled',
465: p_value => 'ACTIVE',
466: p_parameterlist => l_parameters);
467: -- bug 4635241 commented out the following line and set the value to Null.
468: -- l_expiration_date := FND_DATE.date_to_canonical(p_rec.effective_end_date);
469: l_expiration_date := NULL;
470: wf_event.addparametertolist(
471: p_name => 'ExpirationDate',
472: p_value => l_expiration_date,

Line 708: l_start_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_start_date);

704: --
705: --
706: l_person_id_canonical := FND_NUMBER.number_to_canonical(p_rec.person_id);
707: l_assignment_id_canonical := FND_NUMBER.number_to_canonical(p_rec.assignment_id);
708: l_start_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_start_date);
709: l_end_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_end_date);
710: --
711: -- assign attributes and values for l_parameters.
712: --

Line 709: l_end_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_end_date);

705: --
706: l_person_id_canonical := FND_NUMBER.number_to_canonical(p_rec.person_id);
707: l_assignment_id_canonical := FND_NUMBER.number_to_canonical(p_rec.assignment_id);
708: l_start_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_start_date);
709: l_end_date_canonical := FND_DATE.date_to_canonical(p_rec.effective_end_date);
710: --
711: -- assign attributes and values for l_parameters.
712: --
713: --

Line 877: l_start_date_canonical := FND_DATE.date_to_canonical(p_rec.date_start);

873: p_attributes => l_parameters,
874: p_start_date => p_rec.actual_termination_date+1,
875: p_expiration_date => l_perrole_date);
876: else
877: l_start_date_canonical := FND_DATE.date_to_canonical(p_rec.date_start);
878: l_end_date_canonical := FND_DATE.date_to_canonical(l_perrole_date);
879: l_person_id_canonical := FND_NUMBER.number_to_canonical(p_rec.person_id);
880:
881: wf_event.addparametertolist(p_name => 'CONTEXT',

Line 878: l_end_date_canonical := FND_DATE.date_to_canonical(l_perrole_date);

874: p_start_date => p_rec.actual_termination_date+1,
875: p_expiration_date => l_perrole_date);
876: else
877: l_start_date_canonical := FND_DATE.date_to_canonical(p_rec.date_start);
878: l_end_date_canonical := FND_DATE.date_to_canonical(l_perrole_date);
879: l_person_id_canonical := FND_NUMBER.number_to_canonical(p_rec.person_id);
880:
881: wf_event.addparametertolist(p_name => 'CONTEXT',
882: p_value => 'PERSON:TERMINATION',