APPS.PAY_SE_ALECTA dependencies on FND_DATE

Line 581: fnd_date.string_to_date (('01-' || TRUNC (g_month) || '-' || g_year)

577: );
578: --fnd_file.put_line(fnd_file.log,' g_year '|| g_year);
579: --fnd_file.put_line(fnd_file.log,' g_month '|| g_month);
580: l_canonical_start_date :=
581: fnd_date.string_to_date (('01-' || TRUNC (g_month) || '-' || g_year)
582: ,'DD-MM-YYYY'
583: );
584: l_canonical_end_date := LAST_DAY (l_canonical_start_date);
585: l_prepay_action_id := 0;

Line 779: fnd_date.string_to_date (('01-' || TRUNC (g_month) || '-' || g_year)

775: ,g_production
776: );
777:
778: g_start_date :=
779: fnd_date.string_to_date (('01-' || TRUNC (g_month) || '-' || g_year)
780: ,'DD-MM-YYYY'
781: );
782: g_end_date := LAST_DAY (g_start_date);
783:

Line 1363: ,p_action_information9 => fnd_date.date_to_canonical

1359: ,p_action_information5 => l_organization_number
1360: ,p_action_information6 => l_cost_centre
1361: ,p_action_information7 => l_agreement_plan_id
1362: ,p_action_information8 => l_employee_pin
1363: ,p_action_information9 => fnd_date.date_to_canonical
1364: (l_time_for_event_in)
1365: ,p_action_information10 => l_last_name
1366: ,p_action_information11 => l_first_name
1367: ,p_action_information12 => l_before_after

Line 1478: ,p_action_information9 => fnd_date.date_to_canonical

1474: ,p_action_information5 => l_curr_organization_number
1475: ,p_action_information6 => l_curr_cost_center
1476: ,p_action_information7 => l_agreement_plan_id
1477: ,p_action_information8 => l_employee_pin
1478: ,p_action_information9 => fnd_date.date_to_canonical
1479: (l_time_for_event_fk)
1480: ,p_action_information10 => l_before_after
1481: ,p_action_information11 => fnd_number.number_to_canonical
1482: (l_yearly_salary_fk)

Line 1583: ,p_action_information8 => fnd_date.date_to_canonical

1579: ,p_action_information4 => l_new_salary
1580: ,p_action_information5 => l_organization_number
1581: ,p_action_information6 => l_cost_centre
1582: ,p_action_information7 => l_employee_pin
1583: ,p_action_information8 => fnd_date.date_to_canonical
1584: (l_time_for_event_lo)
1585: ,p_action_information9 => l_before_after
1586: ,p_action_information10 => fnd_number.number_to_canonical
1587: (l_yearly_salary_lo)

Line 1703: ,p_action_information8 => fnd_date.date_to_canonical

1699: ,p_action_information4 => l_new_salary
1700: ,p_action_information5 => l_organization_number
1701: ,p_action_information6 => l_cost_centre
1702: ,p_action_information7 => l_employee_pin
1703: ,p_action_information8 => fnd_date.date_to_canonical
1704: (l_time_for_event_lo)
1705: ,p_action_information9 => l_before_after
1706: ,p_action_information10 => fnd_number.number_to_canonical
1707: (l_yearly_salary_lo)

Line 1827: ,p_action_information8 => fnd_date.date_to_canonical

1823: ,p_action_information4 => l_withdrawal
1824: ,p_action_information5 => l_organization_number
1825: ,p_action_information6 => l_cost_centre
1826: ,p_action_information7 => l_employee_pin
1827: ,p_action_information8 => fnd_date.date_to_canonical
1828: (l_time_for_event_av)
1829: ,p_action_information9 => l_reason_for_termination
1830: ,p_action_information10 => fnd_date.date_to_canonical
1831: (l_start_parental_leave)

Line 1830: ,p_action_information10 => fnd_date.date_to_canonical

1826: ,p_action_information7 => l_employee_pin
1827: ,p_action_information8 => fnd_date.date_to_canonical
1828: (l_time_for_event_av)
1829: ,p_action_information9 => l_reason_for_termination
1830: ,p_action_information10 => fnd_date.date_to_canonical
1831: (l_start_parental_leave)
1832: ,p_action_information11 => l_before_after -- changes 2009-2010
1833: ,p_action_information12 => NULL
1834: ,p_action_information13 => NULL

Line 2309: (fnd_date.canonical_to_date

2305: );
2306: add_tag_value
2307: ('nyanmalan:Handelsetidpunkt'
2308: ,TO_CHAR
2309: (fnd_date.canonical_to_date
2310: (row_all_employees_for_event.action_information9)
2311: ,'YYYY-MM-DD'
2312: )
2313: );

Line 2459: (fnd_date.canonical_to_date

2455: );
2456: add_tag_value
2457: ('loneandring:Handelsetidpunkt'
2458: ,TO_CHAR
2459: (fnd_date.canonical_to_date
2460: (row_all_employees_for_event.action_information8)
2461: ,'YYYY-MM-DD'
2462: )
2463: );

Line 2630: (fnd_date.canonical_to_date

2626: );
2627: add_tag_value
2628: ('flyttAnstalldaInomKoncern:Handelsetidpunkt'
2629: ,TO_CHAR
2630: (fnd_date.canonical_to_date
2631: (row_all_employees_for_event.action_information9)
2632: ,'YYYY-MM-DD'
2633: )
2634: );

Line 2757: (fnd_date.canonical_to_date

2753: --logger('Before Change of Company +== > ',row_all_employees_for_event.action_information8);
2754: add_tag_value
2755: ('avanmalan:Handelsetidpunkt'
2756: ,TO_CHAR
2757: (fnd_date.canonical_to_date
2758: (row_all_employees_for_event.action_information8)
2759: ,'YYYY-MM-DD'
2760: )
2761: );

Line 2772: (fnd_date.canonical_to_date

2768: THEN
2769: add_tag_value
2770: ('avanmalan:DatumForForalderledighet'
2771: ,TO_CHAR
2772: (fnd_date.canonical_to_date
2773: (row_all_employees_for_event.action_information10)
2774: ,'YYYY-MM-DD'
2775: )
2776: );

Line 3521: fnd_date.canonical_to_date (lr_get_assignments.segment6);

3517: AND lr_get_assignments.segment6 IS NOT NULL
3518: THEN
3519: p_withdrawl := 'AV';
3520: p_event_time :=
3521: fnd_date.canonical_to_date (lr_get_assignments.segment6);
3522: p_reason := '1';
3523: ELSE
3524: p_withdrawl := NULL;
3525: p_event_time := NULL;

Line 3628: fnd_date.canonical_to_date (lr_get_element.screen_entry_value);

3624: CLOSE csr_get_element;
3625:
3626:
3627: p_event_time :=
3628: fnd_date.canonical_to_date (lr_get_element.screen_entry_value);
3629: END IF;
3630:
3631: IF p_field_code = 'AV2'
3632: THEN

Line 3655: fnd_date.canonical_to_date (lr_get_element.screen_entry_value);

3651: CLOSE csr_get_element;
3652:
3653:
3654: p_parental_start_date :=
3655: fnd_date.canonical_to_date (lr_get_element.screen_entry_value);
3656: ELSE
3657: p_parental_start_date := NULL;
3658: END IF;
3659: