DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_UTILS dependencies on PA_RESOURCES_DENORM

Line 9: g_person_id_wo_name pa_resources_denorm.person_id%TYPE := NULL;

5: g_team_template_name_token PA_TEAM_TEMPLATES.team_template_name%TYPE := NULL;
6: g_team_role_name_token PA_PROJECT_ASSIGNMENTS.assignment_name%TYPE := NULL;
7: g_provisional_hours NUMBER := 0;
8: g_confirmed_hours NUMBER := 0;
9: g_person_id_wo_name pa_resources_denorm.person_id%TYPE := NULL;
10: g_project_id_wo_name pa_project_assignments.project_id%TYPE := NULL;
11: g_ei_date_wo_name DATE := NULL;
12:
13: g_person_id_w_name pa_resources_denorm.person_id%TYPE := NULL;

Line 13: g_person_id_w_name pa_resources_denorm.person_id%TYPE := NULL;

9: g_person_id_wo_name pa_resources_denorm.person_id%TYPE := NULL;
10: g_project_id_wo_name pa_project_assignments.project_id%TYPE := NULL;
11: g_ei_date_wo_name DATE := NULL;
12:
13: g_person_id_w_name pa_resources_denorm.person_id%TYPE := NULL;
14: g_project_id_w_name pa_project_assignments.project_id%TYPE := NULL;
15: g_ei_date_w_name DATE := NULL;
16:
17: g_in_asgmt_name pa_project_assignments.assignment_name%TYPE := NULL;

Line 200: ( p_person_id IN pa_resources_denorm.person_id%TYPE

196: p_add_message IN VARCHAR2)
197: RETURN VARCHAR2;
198:
199: PROCEDURE Get_Person_Asgmt
200: ( p_person_id IN pa_resources_denorm.person_id%TYPE
201: ,p_project_id IN pa_project_assignments.project_id%TYPE
202: ,p_ei_date IN DATE
203: ,x_assignment_name IN OUT NOCOPY pa_project_assignments.assignment_name%TYPE --File.Sql.39 bug 4440895
204: ,x_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895