eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_R_PROJECT_RESOURCES_PVT dependencies on FND_PROFILE

Line 17: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

13: G_p_crmwf_id NUMBER := 0;
14:
15: --Forward declaration
16:
17: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
18:
19: PROCEDURE start_crm_workflow ( p_person_id IN NUMBER,
20: p_assignment_start_date IN DATE,
21: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 600: l_calendar_id := fnd_profile.value_specific('PA_PRM_DEFAULT_CALENDAR');

596: pa_debug.g_err_stage := 'Log: Calendar_id null, get from Profile options';
597: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
598: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
599: END IF;
600: l_calendar_id := fnd_profile.value_specific('PA_PRM_DEFAULT_CALENDAR');
601: end if;
602:
603: --Calendar_Id from Profile Options is NULL
604: --raise error

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

804: l_latest_start_date := null;
805: END;
806:
807: BEGIN
808: -- l_earliest_utl_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */
809: l_earliest_utl_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
810: EXCEPTION
811: WHEN OTHERS THEN
812: l_earliest_utl_start_date := null;

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

805: END;
806:
807: BEGIN
808: -- l_earliest_utl_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */
809: l_earliest_utl_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
810: EXCEPTION
811: WHEN OTHERS THEN
812: l_earliest_utl_start_date := null;
813: END;

Line 2581: -- l_prof_date := FND_PROFILE.value('PA_UTL_START_DATE') ; /* commenting for For Bug 7304151 */

2577: --------------------------------------------------------------------
2578: -- Bug Ref # 6411422
2579: -- Adding Profile Date Honoring Logic for Resource
2580: ---------------------------------------------------------------------
2581: -- l_prof_date := FND_PROFILE.value('PA_UTL_START_DATE') ; /* commenting for For Bug 7304151 */
2582: l_prof_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
2583: IF( l_prof_date IS NOT NULL ) THEN
2584: IF ( l_prof_date >= l_assignment_start_date AND l_prof_date <= l_assignment_end_date ) THEN
2585: log_message(' Profile Date is Later than the Employee Start Date');

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

2578: -- Bug Ref # 6411422
2579: -- Adding Profile Date Honoring Logic for Resource
2580: ---------------------------------------------------------------------
2581: -- l_prof_date := FND_PROFILE.value('PA_UTL_START_DATE') ; /* commenting for For Bug 7304151 */
2582: l_prof_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
2583: IF( l_prof_date IS NOT NULL ) THEN
2584: IF ( l_prof_date >= l_assignment_start_date AND l_prof_date <= l_assignment_end_date ) THEN
2585: log_message(' Profile Date is Later than the Employee Start Date');
2586: l_populate_denorm_flag := 'Y' ;

Line 3327: -- l_prof_date := FND_PROFILE.value('PA_UTL_START_DATE') ; /* commenting for For Bug 7304151 */

3323: --------------------------------------------------------------------
3324: -- Bug Ref # 6411422
3325: -- Adding Profile Date Honoring Logic for Resource
3326: ---------------------------------------------------------------------
3327: -- l_prof_date := FND_PROFILE.value('PA_UTL_START_DATE') ; /* commenting for For Bug 7304151 */
3328: l_prof_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
3329: IF ( l_prof_date IS NOT NULL ) THEN
3330: IF ( l_prof_date >= l_assignment_start_date AND l_prof_date <= l_assignment_end_date ) THEN
3331: log_message(' Profile Date is Later than the Employee Start Date');

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

3324: -- Bug Ref # 6411422
3325: -- Adding Profile Date Honoring Logic for Resource
3326: ---------------------------------------------------------------------
3327: -- l_prof_date := FND_PROFILE.value('PA_UTL_START_DATE') ; /* commenting for For Bug 7304151 */
3328: l_prof_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
3329: IF ( l_prof_date IS NOT NULL ) THEN
3330: IF ( l_prof_date >= l_assignment_start_date AND l_prof_date <= l_assignment_end_date ) THEN
3331: log_message(' Profile Date is Later than the Employee Start Date');
3332: l_populate_denorm_flag := 'Y' ;