APPS.PA_PROJECT_DATES_UTILS dependencies on FND_PROFILE

Line 564: -- l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */

560: END IF;
561: ELSE
562: l_return_date := l_transaction_date;
563: END IF;
564: -- l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */
565: l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
566: IF( l_util_start_date IS NOT NULL ) THEN
567: IF ( l_util_start_date >= l_return_date ) THEN
568: l_return_date := l_util_start_date ;

Line 565: l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */

561: ELSE
562: l_return_date := l_transaction_date;
563: END IF;
564: -- l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */
565: l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
566: IF( l_util_start_date IS NOT NULL ) THEN
567: IF ( l_util_start_date >= l_return_date ) THEN
568: l_return_date := l_util_start_date ;
569: END IF;

Line 595: -- l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */

591: l_util_start_date DATE;
592:
593: BEGIN
594:
595: -- l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */
596: l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
597: IF( l_util_start_date IS NOT NULL ) THEN
598: l_result_date := l_util_start_date ;
599: END IF;

Line 596: l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */

592:
593: BEGIN
594:
595: -- l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */
596: l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
597: IF( l_util_start_date IS NOT NULL ) THEN
598: l_result_date := l_util_start_date ;
599: END IF;
600: IF ( l_util_start_date IS NOT NULL ) THEN

Line 883: x_validate := FND_PROFILE.value('PA_VALIDATE_ASSIGN_DATES');

879: OPEN l_res_dt_minmax_csr(p_project_id);
880: FETCH l_res_dt_minmax_csr INTO l_res_min_date, l_res_max_date;
881: CLOSE l_res_dt_minmax_csr;
882:
883: x_validate := FND_PROFILE.value('PA_VALIDATE_ASSIGN_DATES');
884: x_start_date_status := 'V';
885: x_end_date_status := 'V';
886:
887: IF NVL(x_validate,'N') in ('Y','W') THEN

Line 1042: x_validate := FND_PROFILE.value('PA_VALIDATE_ASSIGN_DATES');

1038: p_res_max_date:=l_res_max_date;
1039:
1040:
1041:
1042: x_validate := FND_PROFILE.value('PA_VALIDATE_ASSIGN_DATES');
1043: x_start_date_status := 'V';
1044: x_end_date_status := 'V';
1045:
1046: IF NVL(x_validate,'N') in ('Y','W') THEN

Line 1103: x_validate := FND_PROFILE.value('PA_VALIDATE_ASSIGN_DATES');

1099: OPEN l_prj_dt_minmax_csr(p_project_id);
1100: FETCH l_prj_dt_minmax_csr INTO l_prj_min_date, l_prj_max_date;
1101: CLOSE l_prj_dt_minmax_csr;
1102:
1103: x_validate := FND_PROFILE.value('PA_VALIDATE_ASSIGN_DATES');
1104: x_start_date_status := 'V';
1105: x_end_date_status := 'V';
1106:
1107: IF NVL(x_validate,'N') in ('Y','W') THEN

Line 1194: l_validate := FND_PROFILE.value('PA_VALIDATE_ASSIGN_DATES');

1190: FETCH get_team_start_date INTO l_team_start_date;
1191: CLOSE get_team_start_date ;
1192: /*Fix for Bug 6856082 ends*/
1193:
1194: l_validate := FND_PROFILE.value('PA_VALIDATE_ASSIGN_DATES');
1195: --l_validate := 'Y';
1196: x_validate := l_validate;
1197: x_start_date_status := 'V';
1198: x_end_date_status := 'V';