DBA Data[Home] [Help]

APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on FND_DATE

Line 444: ,p_token3 => fnd_date.date_to_displaydt(p_effective_date)

440: ,p_error_number => 92493
441: ,p_error_text => 'BEN_92493_EXT_PSI_NO_INPUT_VAL'
442: ,p_token1 => p_element_name
443: ,p_token2 => p_input_value_name
444: ,p_token3 => fnd_date.date_to_displaydt(p_effective_date)
445: ,p_error_warning_flag => 'E'
446: );
447: END IF; -- End if of row not found check ...
448:

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

3486: pqp_gb_psi_functions.raise_extract_warning(
3487: p_error_number => 93775
3488: ,p_error_text => 'BEN_93775_EXT_PSI_NOT_PEN_MEMB'
3489: ,p_token1 => p_assignment_id
3490: ,p_token2 => fnd_date.date_to_displaydt(g_effective_date)
3491: );
3492: END IF;
3493: END IF; -- End if of l_include_flag is Y check ...
3494:

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

3630: pqp_gb_psi_functions.raise_extract_warning(
3631: p_error_number => 94480
3632: ,p_error_text => 'BEN_94480_EXT_PSI_NO_NI_ELEMT'
3633: ,p_token1 => p_assignment_id
3634: ,p_token2 => fnd_date.date_to_displaydt(g_effective_date)
3635: );
3636: END IF; -- End if of ni element entry exists check ...
3637:
3638: IF g_debug

Line 5496: fnd_date.date_to_canonical(g_effective_start_date);

5492:
5493: IF p_rule_parameter = 'StartDate'
5494: THEN
5495: l_return_value :=
5496: fnd_date.date_to_canonical(g_effective_start_date);
5497: ELSIF p_rule_parameter = 'EndDate'
5498: THEN
5499:
5500: /*

Line 5510: l_return_value := fnd_date.date_to_canonical(l_actual_term_date);

5506: THEN
5507: l_actual_term_date := l_effective_end_date;
5508: END IF;
5509:
5510: l_return_value := fnd_date.date_to_canonical(l_actual_term_date);
5511: */
5512:
5513: -- bugfix : 5948932
5514: -- The above code was for reporting the actual termination date as the end date.

Line 5517: l_return_value := fnd_date.date_to_canonical(g_effective_end_date);

5513: -- bugfix : 5948932
5514: -- The above code was for reporting the actual termination date as the end date.
5515: -- From this version (115.16) onwards, reverting back to reporting the end date
5516: -- with the value of the period end date.
5517: l_return_value := fnd_date.date_to_canonical(g_effective_end_date);
5518:
5519: ELSIF p_rule_parameter = 'NICategory'
5520: THEN
5521: l_return_value :=