APPS.PA_TASK_ASSIGNMENTS_PUB dependencies on PA_PROJECTS_ALL

Line 1336: l_project_id pa_projects_all.project_id%type;

1332: ,x_return_status OUT NOCOPY VARCHAR2
1333: ) IS
1334: l_rlm_id NUMBER;
1335: l_task_elem_version_id NUMBER;
1336: l_project_id pa_projects_all.project_id%type;
1337: l_d_task_id NUMBER;
1338: l_task_assignment_id NUMBER;
1339: l_msg_count NUMBER ;
1340: l_msg_data VARCHAR2(2000);

Line 3549: l_project_id pa_projects_all.project_id%type;

3545: ,x_return_status OUT NOCOPY VARCHAR2
3546: ) IS
3547: l_rlm_id NUMBER;
3548: l_task_elem_version_id NUMBER;
3549: l_project_id pa_projects_all.project_id%type;
3550: l_d_task_id NUMBER;
3551: l_task_assignment_id NUMBER;
3552: l_msg_count NUMBER ;
3553: l_msg_data VARCHAR2(2000);

Line 6318: FROM pa_projects_all

6314: -- Bug 3872176 select more related project information
6315: CURSOR l_project_id_csr
6316: IS
6317: SELECT 'X', template_flag, PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(project_id)
6318: FROM pa_projects_all
6319: where project_id = p_pa_project_id;
6320:
6321: -- 3860640 Added parameter to the cursor
6322: -- and using it in the where condition instead of input parameter

Line 6366: (p_pa_project_id pa_projects_all.project_id%type)

6362:
6363: --needed to get the field values associated to a AMG message
6364:
6365: CURSOR l_amg_project_csr
6366: (p_pa_project_id pa_projects_all.project_id%type)
6367: IS
6368: SELECT segment1
6369: FROM pa_projects_all p
6370: WHERE p.project_id = p_pa_project_id;

Line 6369: FROM pa_projects_all p

6365: CURSOR l_amg_project_csr
6366: (p_pa_project_id pa_projects_all.project_id%type)
6367: IS
6368: SELECT segment1
6369: FROM pa_projects_all p
6370: WHERE p.project_id = p_pa_project_id;
6371:
6372: l_amg_segment1 VARCHAR2(25);
6373: --Added by rtarway for BUG 3872176