DBA Data[Home] [Help]

APPS.PER_NL_DSR_ARCHIVE dependencies on FND_NUMBER

Line 405: RETURN fnd_number.canonical_to_number(r_get_person_eit_details.first_day_si);

401: RETURN get_look_up_value('HR_NL_YES_NO',r_get_person_eit_details.workday_saturday,p_language);
402: WHEN 'workday_sunday' THEN
403: RETURN get_look_up_value('HR_NL_YES_NO',r_get_person_eit_details.workday_sunday,p_language);
404: WHEN 'first_day_si' THEN
405: RETURN fnd_number.canonical_to_number(r_get_person_eit_details.first_day_si);
406: WHEN 'daily_si' THEN
407: RETURN fnd_number.canonical_to_number(r_get_person_eit_details.daily_si);
408: WHEN 'accident' THEN
409: RETURN get_look_up_value('HR_NL_DS_ACCIDENT',r_get_person_eit_details.accident,p_language);

Line 407: RETURN fnd_number.canonical_to_number(r_get_person_eit_details.daily_si);

403: RETURN get_look_up_value('HR_NL_YES_NO',r_get_person_eit_details.workday_sunday,p_language);
404: WHEN 'first_day_si' THEN
405: RETURN fnd_number.canonical_to_number(r_get_person_eit_details.first_day_si);
406: WHEN 'daily_si' THEN
407: RETURN fnd_number.canonical_to_number(r_get_person_eit_details.daily_si);
408: WHEN 'accident' THEN
409: RETURN get_look_up_value('HR_NL_DS_ACCIDENT',r_get_person_eit_details.accident,p_language);
410: WHEN 'work_hours' THEN
411: RETURN fnd_number.canonical_to_number(r_get_person_eit_details.work_hours);

Line 411: RETURN fnd_number.canonical_to_number(r_get_person_eit_details.work_hours);

407: RETURN fnd_number.canonical_to_number(r_get_person_eit_details.daily_si);
408: WHEN 'accident' THEN
409: RETURN get_look_up_value('HR_NL_DS_ACCIDENT',r_get_person_eit_details.accident,p_language);
410: WHEN 'work_hours' THEN
411: RETURN fnd_number.canonical_to_number(r_get_person_eit_details.work_hours);
412: WHEN 'partial_recovery_date' THEN
413: RETURN fnd_date.canonical_to_date (r_get_person_eit_details.partial_recovery_date);
414: WHEN 'termination_notice_date' THEN
415: RETURN fnd_date.canonical_to_date (r_get_person_eit_details.termination_notice_date);

Line 421: RETURN fnd_number.canonical_to_number(r_get_person_eit_details.first_call);

417: RETURN get_look_up_value('HR_NL_YES_NO',r_get_person_eit_details.immediate_termination,p_language);
418: WHEN 'period_lt_3_months' THEN
419: RETURN get_look_up_value('HR_NL_YES_NO',r_get_person_eit_details.period_lt_3_months,p_language);
420: WHEN 'first_call' THEN
421: RETURN fnd_number.canonical_to_number(r_get_person_eit_details.first_call);
422: WHEN 'exceeds_allowed_period' THEN
423: RETURN get_look_up_value('HR_NL_YES_NO',r_get_person_eit_details.exceeds_allowed_period,p_language);
424: WHEN 'temporary_contracts' THEN
425: RETURN fnd_number.canonical_to_number(r_get_person_eit_details.temporary_contracts);

Line 425: RETURN fnd_number.canonical_to_number(r_get_person_eit_details.temporary_contracts);

421: RETURN fnd_number.canonical_to_number(r_get_person_eit_details.first_call);
422: WHEN 'exceeds_allowed_period' THEN
423: RETURN get_look_up_value('HR_NL_YES_NO',r_get_person_eit_details.exceeds_allowed_period,p_language);
424: WHEN 'temporary_contracts' THEN
425: RETURN fnd_number.canonical_to_number(r_get_person_eit_details.temporary_contracts);
426: ELSE
427: RETURN NULL;
428: END CASE;
429: END LOOP;