APPS.PA_SCHEDULE_PUB dependencies on PA_PROJECT_STATUSES

Line 982: l_assignment_status_name pa_project_statuses.project_status_name%TYPE;

978: l_msg_index_out NUMBER;
979: l_shifted_days NUMBER;
980: l_exception_id NUMBER;
981: l_return_status VARCHAR2(1);
982: l_assignment_status_name pa_project_statuses.project_status_name%TYPE;
983:
984: -- For error message tokens
985: l_asgn_req_text VARCHAR2(30);
986: l_a_an_text VARCHAR2(30);

Line 1011: FROM pa_projects_all ppa, pa_project_statuses pps

1007: -- For retrieving project_status_name
1008: -- 3054787: Select from tables directly to improve performance.
1009: CURSOR get_project_status_name IS
1010: SELECT pps.project_status_name
1011: FROM pa_projects_all ppa, pa_project_statuses pps
1012: WHERE ppa.project_id = p_project_id
1013: AND ppa.project_status_code = pps.project_status_code;
1014:
1015: l_project_status_name pa_project_statuses.project_status_name%TYPE;

Line 1015: l_project_status_name pa_project_statuses.project_status_name%TYPE;

1011: FROM pa_projects_all ppa, pa_project_statuses pps
1012: WHERE ppa.project_id = p_project_id
1013: AND ppa.project_status_code = pps.project_status_code;
1014:
1015: l_project_status_name pa_project_statuses.project_status_name%TYPE;
1016:
1017: BEGIN
1018: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
1019:

Line 1128: FROM pa_project_statuses

1124: CLOSE get_project_status_name;
1125:
1126: SELECT project_status_name
1127: INTO l_assignment_status_name
1128: FROM pa_project_statuses
1129: WHERE project_status_code = p_assignment_status_code;
1130:
1131: RAISE l_asgn_stus_not_for_proj_stus;
1132: END IF;

Line 1950: l_assignment_status_name pa_project_statuses.project_status_name%TYPE;

1946: l_person_id NUMBER;
1947: l_msg_index_out NUMBER;
1948: l_exception_id NUMBER;
1949: l_return_status VARCHAR2(1);
1950: l_assignment_status_name pa_project_statuses.project_status_name%TYPE;
1951:
1952: -- For error message tokens
1953: l_asgn_req_text VARCHAR2(30);
1954: l_a_an_text VARCHAR2(30);

Line 1961: FROM pa_projects_all ppa, pa_project_statuses pps

1957: -- For retrieving project_status_name
1958: -- 3054787: Select from tables directly to improve performance.
1959: CURSOR get_project_status_name IS
1960: SELECT pps.project_status_name
1961: FROM pa_projects_all ppa, pa_project_statuses pps
1962: WHERE ppa.project_id = p_project_id
1963: AND ppa.project_status_code = pps.project_status_code;
1964:
1965: l_project_status_name pa_project_statuses.project_status_name%TYPE;

Line 1965: l_project_status_name pa_project_statuses.project_status_name%TYPE;

1961: FROM pa_projects_all ppa, pa_project_statuses pps
1962: WHERE ppa.project_id = p_project_id
1963: AND ppa.project_status_code = pps.project_status_code;
1964:
1965: l_project_status_name pa_project_statuses.project_status_name%TYPE;
1966:
1967: BEGIN
1968: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
1969:

Line 2014: FROM pa_project_statuses

2010: CLOSE get_project_status_name;
2011:
2012: SELECT project_status_name
2013: INTO l_assignment_status_name
2014: FROM pa_project_statuses
2015: WHERE project_status_code = p_assignment_status_code;
2016:
2017: RAISE l_asgn_stus_not_for_proj_stus;
2018: END IF;