APPS.PA_ASSIGNMENT_UTILS dependencies on PA_PROJECTS_ALL

Line 45: ( p_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL

41: -- HISTORY
42: -- 17-JUL-2000 R. Krishnamurthy Created
43: --
44: PROCEDURE Validate_Asgmt_Competency
45: ( p_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL
46: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE
47: ,p_competence_id IN per_competences.competence_id%TYPE
48: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
49: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 195: p_project_id IN pa_projects_all.project_id%TYPE,

191: p_token1 IN VARCHAR2 DEFAULT NULL,
192: p_value1 IN VARCHAR2 DEFAULT NULL);
193:
194: FUNCTION is_asgmt_allow_stus_ctl_check(p_asgmt_status_code IN pa_project_statuses.project_status_code%TYPE,
195: p_project_id IN pa_projects_all.project_id%TYPE,
196: p_add_message IN VARCHAR2)
197: RETURN VARCHAR2;
198:
199: PROCEDURE Get_Person_Asgmt

Line 233: ( p_project_id IN pa_projects_all.project_id%TYPE

229: -- HISTORY
230: -- 29-APR-2003 shyugen Created
231: --
232: PROCEDURE Get_Default_Staffing_Owner
233: ( p_project_id IN pa_projects_all.project_id%TYPE
234: ,p_exp_org_id IN pa_project_assignments.expenditure_org_id%TYPE := NULL
235: ,x_person_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
236: ,x_person_name OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
237: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 251: ,p_project_id IN pa_projects_all.project_id%TYPE

247: -- 29-APR-2003 shyugen Created
248: ------------------------------------------------------------------------------
249: PROCEDURE Get_All_Staffing_Owners
250: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
251: ,p_project_id IN pa_projects_all.project_id%TYPE
252: ,x_person_id_tbl OUT NOCOPY system.pa_num_tbl_type --File.Sql.39 bug 4440895
253: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
254: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
255: