APPS.PA_PROJECT_ASSETS_PUB dependencies on PA_TASKS

Line 309: l_task_id pa_tasks.task_id%TYPE;

305:
306: l_api_name CONSTANT VARCHAR2(30) := 'add_project_asset';
307: l_return_status VARCHAR2(1);
308: l_project_id pa_projects.project_id%TYPE;
309: l_task_id pa_tasks.task_id%TYPE;
310: l_msg_count NUMBER ;
311: l_msg_data VARCHAR2(2000);
312: l_function_allowed VARCHAR2(1);
313: l_resp_id NUMBER := 0;

Line 1986: FROM pa_tasks

1982:
1983: --Used to determine the Top Task ID for a given Task
1984: CURSOR top_task_cur(x_task_id NUMBER) IS
1985: SELECT top_task_id
1986: FROM pa_tasks
1987: WHERE task_id = x_task_id;
1988:
1989: top_task_rec top_task_cur%ROWTYPE;
1990:

Line 1995: FROM pa_tasks

1991:
1992: --Used to determine if the current Task has any children
1993: CURSOR child_task_cur(x_task_id NUMBER) IS
1994: SELECT 'Child Tasks Exist'
1995: FROM pa_tasks
1996: WHERE parent_task_id = x_task_id;
1997:
1998: child_task_rec child_task_cur%ROWTYPE;
1999:

Line 2005: pa_tasks t

2001: --Used to determine if Lowest-Task assignments exist below a given Top Task
2002: CURSOR child_assign_cur(x_task_id NUMBER) IS
2003: SELECT 'Lowest Task Assignments Exist'
2004: FROM pa_project_asset_assignments p,
2005: pa_tasks t
2006: WHERE p.project_id = l_project_id
2007: AND p.task_id = t.task_id
2008: AND t.top_task_id = x_task_id
2009: AND t.top_task_id <> t.task_id; --We don't care if other assignments exist for the top task itself

Line 2018: pa_tasks t

2014: --Used to determine if Top-Task assignments exist above a given Lowest Task
2015: CURSOR top_assign_cur(x_task_id NUMBER) IS
2016: SELECT 'Top Task Assignments Exist'
2017: FROM pa_project_asset_assignments p,
2018: pa_tasks t
2019: WHERE p.project_id = l_project_id
2020: AND p.task_id = t.top_task_id
2021: AND t.task_id = x_task_id
2022: AND p.task_id <> x_task_id; --We don't care if other assignments exist for the lowest task itself

Line 6158: FROM pa_tasks

6154:
6155: --Used to get the Task number for output parameter
6156: CURSOR l_amg_task_csr (l_project_id NUMBER ,l_task_id NUMBER) IS
6157: SELECT task_number
6158: FROM pa_tasks
6159: WHERE project_id = l_project_id
6160: AND task_id = l_task_id;
6161:
6162: l_amg_pa_task_number pa_tasks.task_number%TYPE;

Line 6162: l_amg_pa_task_number pa_tasks.task_number%TYPE;

6158: FROM pa_tasks
6159: WHERE project_id = l_project_id
6160: AND task_id = l_task_id;
6161:
6162: l_amg_pa_task_number pa_tasks.task_number%TYPE;
6163:
6164:
6165: l_api_name CONSTANT VARCHAR2(30) := 'execute_add_project_asset';
6166: