DBA Data[Home] [Help]

APPS.PAY_SE_SLSA_ARCHIVE dependencies on FND_DATE

Line 125: p_start_date := fnd_date.canonical_to_date (lr_parameter_info.eff_start_date);

121: FETCH csr_parameter_info INTO lr_parameter_info;
122: CLOSE csr_parameter_info;
123: p_legal_employer_id := lr_parameter_info.legal;
124: p_request_for_all_or_not := lr_parameter_info.request_for;
125: p_start_date := fnd_date.canonical_to_date (lr_parameter_info.eff_start_date);
126: p_end_date := fnd_date.canonical_to_date (lr_parameter_info.eff_end_date);
127: p_effective_date := lr_parameter_info.effective_date;
128: p_business_group_id := lr_parameter_info.bg_id;
129:

Line 126: p_end_date := fnd_date.canonical_to_date (lr_parameter_info.eff_end_date);

122: CLOSE csr_parameter_info;
123: p_legal_employer_id := lr_parameter_info.legal;
124: p_request_for_all_or_not := lr_parameter_info.request_for;
125: p_start_date := fnd_date.canonical_to_date (lr_parameter_info.eff_start_date);
126: p_end_date := fnd_date.canonical_to_date (lr_parameter_info.eff_end_date);
127: p_effective_date := lr_parameter_info.effective_date;
128: p_business_group_id := lr_parameter_info.bg_id;
129:
130: IF g_debug THEN

Line 636: p_action_information10 => fnd_date.date_to_canonical (p_effective_start_date),

632: p_action_information6 => fnd_number.number_to_canonical (l_curr_week_hours),
633: p_action_information7 => fnd_number.number_to_canonical (l_curr_daily_hours),
634: p_action_information8 => fnd_number.number_to_canonical (l_curr_days_per_year),
635: p_action_information9 => fnd_number.number_to_canonical (l_curr_hours_per_year),
636: p_action_information10 => fnd_date.date_to_canonical (p_effective_start_date),
637: p_action_information11 => fnd_date.date_to_canonical (p_effective_end_date)
638: );
639: /* Get the Element Type Id for the given element Name */
640: OPEN csr_element_type ('Sickness Group Details', p_effective_end_date);

Line 637: p_action_information11 => fnd_date.date_to_canonical (p_effective_end_date)

633: p_action_information7 => fnd_number.number_to_canonical (l_curr_daily_hours),
634: p_action_information8 => fnd_number.number_to_canonical (l_curr_days_per_year),
635: p_action_information9 => fnd_number.number_to_canonical (l_curr_hours_per_year),
636: p_action_information10 => fnd_date.date_to_canonical (p_effective_start_date),
637: p_action_information11 => fnd_date.date_to_canonical (p_effective_end_date)
638: );
639: /* Get the Element Type Id for the given element Name */
640: OPEN csr_element_type ('Sickness Group Details', p_effective_end_date);
641: FETCH csr_element_type INTO l_element_type_id;

Line 973: p_action_information5 => fnd_date.date_to_canonical (g_start_date),

969: p_action_information1 => 'PYSESLSA',
970: p_action_information2 => hr_general.decode_lookup ('SE_TAX_CARD_REQUEST_LEVEL', g_request_for),
971: p_action_information3 => g_legal_employer_id,
972: p_action_information4 => l_legal_employer_details.legal_employer_name,
973: p_action_information5 => fnd_date.date_to_canonical (g_start_date),
974: p_action_information6 => fnd_date.date_to_canonical (g_end_date),
975: p_action_information7 => NULL,
976: p_action_information8 => NULL,
977: p_action_information9 => NULL,

Line 974: p_action_information6 => fnd_date.date_to_canonical (g_end_date),

970: p_action_information2 => hr_general.decode_lookup ('SE_TAX_CARD_REQUEST_LEVEL', g_request_for),
971: p_action_information3 => g_legal_employer_id,
972: p_action_information4 => l_legal_employer_details.legal_employer_name,
973: p_action_information5 => fnd_date.date_to_canonical (g_start_date),
974: p_action_information6 => fnd_date.date_to_canonical (g_end_date),
975: p_action_information7 => NULL,
976: p_action_information8 => NULL,
977: p_action_information9 => NULL,
978: p_action_information10 => NULL