APPS.PA_ASSIGNMENT_UTILS dependencies on PA_PROJECTS_ALL

Line 128: ( p_project_id IN pa_projects_all.project_id%TYPE

124: -- 27-Jul-2001 Vijay Ranganathan Changed API Validate_Asgmt_Competency
125: -- to get project business group
126: -- BUG: 1904822
127: PROCEDURE Validate_Asgmt_Competency
128: ( p_project_id IN pa_projects_all.project_id%TYPE
129: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE
130: ,p_competence_id IN per_competences.competence_id%TYPE
131: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
132: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 750: p_project_id IN pa_projects_all.project_id%TYPE,

746: END Add_Message;
747:
748:
749: FUNCTION is_asgmt_allow_stus_ctl_check(p_asgmt_status_code IN pa_project_statuses.project_status_code%TYPE,
750: p_project_id IN pa_projects_all.project_id%TYPE,
751: p_add_message IN VARCHAR2)
752: RETURN VARCHAR2 IS
753:
754: CURSOR get_status_info IS

Line 756: FROM pa_projects_all proj,

752: RETURN VARCHAR2 IS
753:
754: CURSOR get_status_info IS
755: SELECT proj.project_status_code, ps.project_status_name, ps2.project_system_status_code, ps2.project_status_name
756: FROM pa_projects_all proj,
757: pa_project_statuses ps,
758: pa_project_statuses ps2
759: WHERE project_id = p_project_id
760: AND proj.project_status_code = ps.project_status_code

Line 1080: ( p_project_id IN pa_projects_all.project_id%TYPE

1076: -- 10-JAN-2005 anigam Bug 4103207.Added a condition in the cursor 'get_team_member' to check that current date lies between
1077: -- effective_start_date and effective_end_date. And commented of the condition ROWNUM =1
1078: ------------------------------------------------------------------------------
1079: PROCEDURE Get_Default_Staffing_Owner
1080: ( p_project_id IN pa_projects_all.project_id%TYPE
1081: ,p_exp_org_id IN pa_project_assignments.expenditure_org_id%TYPE := NULL
1082: ,x_person_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1083: ,x_person_name OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1084: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1111: FROM pa_projects_all

1107: BEGIN
1108:
1109: IF p_exp_org_id IS NULL THEN
1110: SELECT carrying_out_organization_id INTO l_exp_org_id
1111: FROM pa_projects_all
1112: WHERE project_id = p_project_id;
1113: ELSE
1114: l_exp_org_id := p_exp_org_id;
1115: END IF;

Line 1159: ,p_project_id IN pa_projects_all.project_id%TYPE

1155: -- 29-APR-2003 shyugen Created
1156: ------------------------------------------------------------------------------
1157: PROCEDURE Get_All_Staffing_Owners
1158: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
1159: ,p_project_id IN pa_projects_all.project_id%TYPE
1160: ,x_person_id_tbl OUT NOCOPY system.pa_num_tbl_type --File.Sql.39 bug 4440895
1161: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1162: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
1163:

Line 1254: from pa_projects_all

1250: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
1251:
1252: cursor get_proj_rec_ver_num is
1253: select record_version_number
1254: from pa_projects_all
1255: where project_id = p_project_id;
1256:
1257: -- for FP-M, person_type is not tracked on a requirement
1258:

Line 1640: FROM pa_projects_all pa,

1636: l_format_used_flag VARCHAR2(1);
1637: BEGIN
1638: SELECT 'Y'
1639: INTO l_format_used_flag
1640: FROM pa_projects_all pa,
1641: pa_proj_fp_options pfo
1642: WHERE (pa.proj_req_res_format_id = p_res_format_id OR pa.proj_asgmt_res_format_id = p_res_format_id)
1643: AND pa.project_id = pfo.project_id
1644: AND pfo.cost_resource_list_id = p_resource_list_id