APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on FND_DATE

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

3644: ,p_effective_start_date => l_rec_ele_ent_details.effective_start_date
3645: ,p_effective_end_date => l_rec_ele_ent_details.effective_end_date
3646: ,p_input_value_id => l_input_value_id
3647: );
3648: l_opt_out_date := fnd_date.canonical_to_date(l_char);
3649:
3650: IF g_debug
3651: THEN
3652: l_proc_step := 80;

Line 3762: fnd_date.canonical_to_date(l_char);

3758: ,p_effective_end_date => l_rec_ele_ent_details.effective_end_date
3759: ,p_input_value_id => l_input_value_id
3760: );
3761: l_opt_out_date :=
3762: fnd_date.canonical_to_date(l_char);
3763:
3764: IF g_debug
3765: THEN
3766: l_proc_step := 120;

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

4320: pqp_gb_psi_functions.raise_extract_warning(
4321: p_error_number => 93775
4322: ,p_error_text => 'BEN_93775_EXT_PSI_NOT_PEN_MEMB'
4323: ,p_token1 => p_assignment_id
4324: ,p_token2 => fnd_date.date_to_displaydt(g_effective_date)
4325: );
4326: END IF; -- End if of pension category is null check ...
4327:
4328: get_service_history_code(

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

5624: ,p_effective_start_date => l_rec_ele_ent_info.effective_start_date
5625: ,p_effective_end_date => l_rec_ele_ent_info.effective_end_date
5626: ,p_input_value_id => l_input_value_id
5627: );
5628: l_opt_out_date := fnd_date.canonical_to_date(l_char);
5629:
5630: IF l_opt_out_date IS NULL
5631: THEN
5632: l_ser_start_date :=

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

5749: DEBUG(l_proc_name, l_proc_step);
5750: END IF;
5751:
5752: l_opt_out_date :=
5753: fnd_date.canonical_to_date(l_rec_ele_ent_val.screen_entry_value);
5754:
5755: IF l_opt_out_date IS NOT NULL
5756: AND l_opt_out_date <=
5757: pqp_gb_psi_functions.g_effective_end_date

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

6821: pqp_gb_psi_functions.raise_extract_warning(
6822: p_error_number => 93775
6823: ,p_error_text => 'BEN_93775_EXT_PSI_NOT_PEN_MEMB'
6824: ,p_token1 => p_assignment_id
6825: ,p_token2 => fnd_date.date_to_displaydt(g_effective_date)
6826: );
6827: END IF; -- End if of pension category is null check ...
6828:
6829: get_service_history_code(

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

7183:
7184: -- Return Start Date
7185: IF p_rule_parameter = 'StartDate'
7186: THEN
7187: l_return_value := fnd_date.date_to_canonical(g_ser_start_date);
7188:
7189: IF g_ser_start_date IS NULL
7190: THEN
7191: IF g_debug

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

7206: THEN
7207: IF g_start_reason = 'ZZ' THEN
7208: -- This is a termination event
7209: -- populate end date as well
7210: l_return_value := fnd_date.date_to_canonical(g_ser_start_date);
7211:
7212: IF g_ser_start_date IS NULL
7213: THEN
7214: IF g_debug