APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on FND_DATE

Line 3594: l_opt_out_date := fnd_date.canonical_to_date(l_char);

3590: ,p_effective_start_date => l_rec_ele_ent_details.effective_start_date
3591: ,p_effective_end_date => l_rec_ele_ent_details.effective_end_date
3592: ,p_input_value_id => l_input_value_id
3593: );
3594: l_opt_out_date := fnd_date.canonical_to_date(l_char);
3595:
3596: IF g_debug
3597: THEN
3598: l_proc_step := 80;

Line 3708: fnd_date.canonical_to_date(l_char);

3704: ,p_effective_end_date => l_rec_ele_ent_details.effective_end_date
3705: ,p_input_value_id => l_input_value_id
3706: );
3707: l_opt_out_date :=
3708: fnd_date.canonical_to_date(l_char);
3709:
3710: IF g_debug
3711: THEN
3712: l_proc_step := 120;

Line 4270: ,p_token2 => fnd_date.date_to_displaydt(g_effective_date)

4266: pqp_gb_psi_functions.raise_extract_warning(
4267: p_error_number => 93775
4268: ,p_error_text => 'BEN_93775_EXT_PSI_NOT_PEN_MEMB'
4269: ,p_token1 => p_assignment_id
4270: ,p_token2 => fnd_date.date_to_displaydt(g_effective_date)
4271: );
4272: END IF; -- End if of pension category is null check ...
4273:
4274: get_service_history_code(

Line 5566: l_opt_out_date := fnd_date.canonical_to_date(l_char);

5562: ,p_effective_start_date => l_rec_ele_ent_info.effective_start_date
5563: ,p_effective_end_date => l_rec_ele_ent_info.effective_end_date
5564: ,p_input_value_id => l_input_value_id
5565: );
5566: l_opt_out_date := fnd_date.canonical_to_date(l_char);
5567:
5568: IF l_opt_out_date IS NULL
5569: THEN
5570: l_ser_start_date :=

Line 5691: fnd_date.canonical_to_date(l_rec_ele_ent_val.screen_entry_value);

5687: DEBUG(l_proc_name, l_proc_step);
5688: END IF;
5689:
5690: l_opt_out_date :=
5691: fnd_date.canonical_to_date(l_rec_ele_ent_val.screen_entry_value);
5692:
5693: IF l_opt_out_date IS NOT NULL
5694: AND l_opt_out_date <=
5695: pqp_gb_psi_functions.g_effective_end_date

Line 6745: ,p_token2 => fnd_date.date_to_displaydt(g_effective_date)

6741: pqp_gb_psi_functions.raise_extract_warning(
6742: p_error_number => 93775
6743: ,p_error_text => 'BEN_93775_EXT_PSI_NOT_PEN_MEMB'
6744: ,p_token1 => p_assignment_id
6745: ,p_token2 => fnd_date.date_to_displaydt(g_effective_date)
6746: );
6747: END IF; -- End if of pension category is null check ...
6748:
6749: get_service_history_code(

Line 7107: l_return_value := fnd_date.date_to_canonical(g_ser_start_date);

7103:
7104: -- Return Start Date
7105: IF p_rule_parameter = 'StartDate'
7106: THEN
7107: l_return_value := fnd_date.date_to_canonical(g_ser_start_date);
7108:
7109: IF g_ser_start_date IS NULL
7110: THEN
7111: IF g_debug

Line 7130: l_return_value := fnd_date.date_to_canonical(g_ser_start_date);

7126: THEN
7127: IF g_start_reason = 'ZZ' THEN
7128: -- This is a termination event
7129: -- populate end date as well
7130: l_return_value := fnd_date.date_to_canonical(g_ser_start_date);
7131:
7132: IF g_ser_start_date IS NULL
7133: THEN
7134: IF g_debug