APPS.PA_SCHEDULE_PUB dependencies on PA_PROJECT_STATUSES

Line 1451: l_assignment_status_name pa_project_statuses.project_status_name%TYPE;

1447: l_msg_index_out NUMBER;
1448: l_shifted_days NUMBER;
1449: l_exception_id NUMBER;
1450: l_return_status VARCHAR2(1);
1451: l_assignment_status_name pa_project_statuses.project_status_name%TYPE;
1452:
1453: -- For error message tokens
1454: l_asgn_req_text VARCHAR2(30);
1455: l_a_an_text VARCHAR2(30);

Line 1480: FROM pa_projects_all ppa, pa_project_statuses pps

1476: -- For retrieving project_status_name
1477: -- 3054787: Select from tables directly to improve performance.
1478: CURSOR get_project_status_name IS
1479: SELECT pps.project_status_name
1480: FROM pa_projects_all ppa, pa_project_statuses pps
1481: WHERE ppa.project_id = p_project_id
1482: AND ppa.project_status_code = pps.project_status_code;
1483:
1484: l_project_status_name pa_project_statuses.project_status_name%TYPE;

Line 1484: l_project_status_name pa_project_statuses.project_status_name%TYPE;

1480: FROM pa_projects_all ppa, pa_project_statuses pps
1481: WHERE ppa.project_id = p_project_id
1482: AND ppa.project_status_code = pps.project_status_code;
1483:
1484: l_project_status_name pa_project_statuses.project_status_name%TYPE;
1485:
1486: BEGIN
1487: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
1488:

Line 1599: FROM pa_project_statuses

1595: CLOSE get_project_status_name;
1596:
1597: SELECT project_status_name
1598: INTO l_assignment_status_name
1599: FROM pa_project_statuses
1600: WHERE project_status_code = p_assignment_status_code;
1601:
1602: RAISE l_asgn_stus_not_for_proj_stus;
1603: END IF;

Line 2422: l_assignment_status_name pa_project_statuses.project_status_name%TYPE;

2418: l_person_id NUMBER;
2419: l_msg_index_out NUMBER;
2420: l_exception_id NUMBER;
2421: l_return_status VARCHAR2(1);
2422: l_assignment_status_name pa_project_statuses.project_status_name%TYPE;
2423:
2424: -- For error message tokens
2425: l_asgn_req_text VARCHAR2(30);
2426: l_a_an_text VARCHAR2(30);

Line 2433: FROM pa_projects_all ppa, pa_project_statuses pps

2429: -- For retrieving project_status_name
2430: -- 3054787: Select from tables directly to improve performance.
2431: CURSOR get_project_status_name IS
2432: SELECT pps.project_status_name
2433: FROM pa_projects_all ppa, pa_project_statuses pps
2434: WHERE ppa.project_id = p_project_id
2435: AND ppa.project_status_code = pps.project_status_code;
2436:
2437: l_project_status_name pa_project_statuses.project_status_name%TYPE;

Line 2437: l_project_status_name pa_project_statuses.project_status_name%TYPE;

2433: FROM pa_projects_all ppa, pa_project_statuses pps
2434: WHERE ppa.project_id = p_project_id
2435: AND ppa.project_status_code = pps.project_status_code;
2436:
2437: l_project_status_name pa_project_statuses.project_status_name%TYPE;
2438:
2439: BEGIN
2440: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
2441:

Line 2486: FROM pa_project_statuses

2482: CLOSE get_project_status_name;
2483:
2484: SELECT project_status_name
2485: INTO l_assignment_status_name
2486: FROM pa_project_statuses
2487: WHERE project_status_code = p_assignment_status_code;
2488:
2489: RAISE l_asgn_stus_not_for_proj_stus;
2490: END IF;