APPS.PA_TASK_ASSIGNMENTS_PUB dependencies on PA_PROJECTS_ALL

Line 1353: l_project_id pa_projects_all.project_id%type;

1349: ,x_return_status OUT NOCOPY VARCHAR2
1350: ) IS
1351: l_rlm_id NUMBER;
1352: l_task_elem_version_id NUMBER;
1353: l_project_id pa_projects_all.project_id%type;
1354: l_d_task_id NUMBER;
1355: l_task_assignment_id NUMBER;
1356: l_msg_count NUMBER ;
1357: l_msg_data VARCHAR2(2000);

Line 3790: l_project_id pa_projects_all.project_id%type;

3786: ,x_return_status OUT NOCOPY VARCHAR2
3787: ) IS
3788: l_rlm_id NUMBER;
3789: l_task_elem_version_id NUMBER;
3790: l_project_id pa_projects_all.project_id%type;
3791: l_d_task_id NUMBER;
3792: l_task_assignment_id NUMBER;
3793: l_msg_count NUMBER ;
3794: l_msg_data VARCHAR2(2000);

Line 7023: FROM pa_projects_all

7019: -- Bug 3872176 select more related project information
7020: CURSOR l_project_id_csr
7021: IS
7022: SELECT 'X', template_flag, PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(project_id)
7023: FROM pa_projects_all
7024: where project_id = p_pa_project_id;
7025:
7026: -- 3860640 Added parameter to the cursor
7027: -- and using it in the where condition instead of input parameter

Line 7072: (p_pa_project_id pa_projects_all.project_id%type)

7068:
7069: --needed to get the field values associated to a AMG message
7070:
7071: CURSOR l_amg_project_csr
7072: (p_pa_project_id pa_projects_all.project_id%type)
7073: IS
7074: SELECT segment1
7075: FROM pa_projects_all p
7076: WHERE p.project_id = p_pa_project_id;

Line 7075: FROM pa_projects_all p

7071: CURSOR l_amg_project_csr
7072: (p_pa_project_id pa_projects_all.project_id%type)
7073: IS
7074: SELECT segment1
7075: FROM pa_projects_all p
7076: WHERE p.project_id = p_pa_project_id;
7077:
7078: l_amg_segment1 VARCHAR2(25);
7079: --Added by rtarway for BUG 3872176