eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SE_ALECTA dependencies on FND_DATE

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

537: );
538: --fnd_file.put_line(fnd_file.log,' g_year '|| g_year);
539: --fnd_file.put_line(fnd_file.log,' g_month '|| g_month);
540: l_canonical_start_date :=
541: fnd_date.string_to_date (('01-' || TRUNC (g_month) || '-' || g_year)
542: ,'DD-MM-YYYY'
543: );
544: l_canonical_end_date := LAST_DAY (l_canonical_start_date);
545: l_prepay_action_id := 0;

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

735: ,g_production
736: );
737:
738: g_start_date :=
739: fnd_date.string_to_date (('01-' || TRUNC (g_month) || '-' || g_year)
740: ,'DD-MM-YYYY'
741: );
742: g_end_date := LAST_DAY (g_start_date);
743:

Line 1287: ,p_action_information9 => fnd_date.date_to_canonical

1283: ,p_action_information5 => l_organization_number
1284: ,p_action_information6 => l_cost_centre
1285: ,p_action_information7 => l_agreement_plan_id
1286: ,p_action_information8 => l_employee_pin
1287: ,p_action_information9 => fnd_date.date_to_canonical
1288: (l_time_for_event_in)
1289: ,p_action_information10 => l_last_name
1290: ,p_action_information11 => l_first_name
1291: ,p_action_information12 => l_before_after

Line 1388: ,p_action_information8 => fnd_date.date_to_canonical

1384: ,p_action_information4 => l_new_salary
1385: ,p_action_information5 => l_organization_number
1386: ,p_action_information6 => l_cost_centre
1387: ,p_action_information7 => l_employee_pin
1388: ,p_action_information8 => fnd_date.date_to_canonical
1389: (l_time_for_event_lo)
1390: ,p_action_information9 => l_before_after
1391: ,p_action_information10 => fnd_number.number_to_canonical
1392: (l_yearly_salary_lo)

Line 1501: ,p_action_information9 => fnd_date.date_to_canonical

1497: ,p_action_information5 => l_curr_organization_number
1498: ,p_action_information6 => l_curr_cost_center
1499: ,p_action_information7 => l_agreement_plan_id
1500: ,p_action_information8 => l_employee_pin
1501: ,p_action_information9 => fnd_date.date_to_canonical
1502: (l_time_for_event_fk)
1503: ,p_action_information10 => l_before_after
1504: ,p_action_information11 => fnd_number.number_to_canonical
1505: (l_yearly_salary_fk)

Line 1616: ,p_action_information8 => fnd_date.date_to_canonical

1612: ,p_action_information4 => l_withdrawal
1613: ,p_action_information5 => l_organization_number
1614: ,p_action_information6 => l_cost_centre
1615: ,p_action_information7 => l_employee_pin
1616: ,p_action_information8 => fnd_date.date_to_canonical
1617: (l_time_for_event_av)
1618: ,p_action_information9 => l_reason_for_termination
1619: ,p_action_information10 => fnd_date.date_to_canonical
1620: (l_start_parental_leave)

Line 1619: ,p_action_information10 => fnd_date.date_to_canonical

1615: ,p_action_information7 => l_employee_pin
1616: ,p_action_information8 => fnd_date.date_to_canonical
1617: (l_time_for_event_av)
1618: ,p_action_information9 => l_reason_for_termination
1619: ,p_action_information10 => fnd_date.date_to_canonical
1620: (l_start_parental_leave)
1621: ,p_action_information11 => NULL
1622: ,p_action_information12 => NULL
1623: ,p_action_information13 => NULL

Line 2053: (fnd_date.canonical_to_date

2049: --logger('Before Change of Company +== > ',row_all_employees_for_event.action_information8);
2050: add_tag_value
2051: ('avanmalan:Handelsetidpunkt'
2052: ,TO_CHAR
2053: (fnd_date.canonical_to_date
2054: (row_all_employees_for_event.action_information8)
2055: ,'YYYY-MM-DD'
2056: )
2057: );

Line 2068: (fnd_date.canonical_to_date

2064: THEN
2065: add_tag_value
2066: ('avanmalan:DatumForForalderledighet'
2067: ,TO_CHAR
2068: (fnd_date.canonical_to_date
2069: (row_all_employees_for_event.action_information10)
2070: ,'YYYY-MM-DD'
2071: )
2072: );

Line 2134: (fnd_date.canonical_to_date

2130: );
2131: add_tag_value
2132: ('flyttAnstalldaInomKoncern:Handelsetidpunkt'
2133: ,TO_CHAR
2134: (fnd_date.canonical_to_date
2135: (row_all_employees_for_event.action_information9)
2136: ,'YYYY-MM-DD'
2137: )
2138: );

Line 2227: (fnd_date.canonical_to_date

2223: );
2224: add_tag_value
2225: ('loneandring:Handelsetidpunkt'
2226: ,TO_CHAR
2227: (fnd_date.canonical_to_date
2228: (row_all_employees_for_event.action_information8)
2229: ,'YYYY-MM-DD'
2230: )
2231: );

Line 2329: (fnd_date.canonical_to_date

2325: );
2326: add_tag_value
2327: ('nyanmalan:Handelsetidpunkt'
2328: ,TO_CHAR
2329: (fnd_date.canonical_to_date
2330: (row_all_employees_for_event.action_information9)
2331: ,'YYYY-MM-DD'
2332: )
2333: );

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

3070: AND lr_get_assignments.segment6 IS NOT NULL
3071: THEN
3072: p_withdrawl := 'AV';
3073: p_event_time :=
3074: fnd_date.canonical_to_date (lr_get_assignments.segment6);
3075: p_reason := '1';
3076: ELSE
3077: p_withdrawl := NULL;
3078: p_event_time := NULL;

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

3177: CLOSE csr_get_element;
3178:
3179:
3180: p_event_time :=
3181: fnd_date.canonical_to_date (lr_get_element.screen_entry_value);
3182: END IF;
3183:
3184: IF p_field_code = 'AV2'
3185: THEN

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

3204: CLOSE csr_get_element;
3205:
3206:
3207: p_parental_start_date :=
3208: fnd_date.canonical_to_date (lr_get_element.screen_entry_value);
3209: ELSE
3210: p_parental_start_date := NULL;
3211: END IF;
3212: