eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_CHECK_PVT dependencies on PA_TASKS

Line 73: (p_pa_task_id pa_tasks.task_id%type)

69: FROM pa_projects p
70: WHERE p.project_id = p_pa_project_id;
71:
72: CURSOR l_amg_task_csr
73: (p_pa_task_id pa_tasks.task_id%type)
74: IS
75: SELECT task_number
76: FROM pa_tasks p
77: WHERE p.task_id = p_pa_task_id;

Line 76: FROM pa_tasks p

72: CURSOR l_amg_task_csr
73: (p_pa_task_id pa_tasks.task_id%type)
74: IS
75: SELECT task_number
76: FROM pa_tasks p
77: WHERE p.task_id = p_pa_task_id;
78:
79: --bug 2765115
80: l_structure_version_id NUMBER;

Line 146: PA_TASKS table in the cursor l_task_id_csr. As this was not returning any rows the above error is thrown. The task

142: to determine whether a task can be deleted at all or not. This in turn calls the pa_project_pub.Check_Delete_Task_OK
143: API and that in turn calls the pa_project_check_pvt.Check_Delete_Task_OK_pvt API.
144: In this API the call to PA_PROJECT_PVT.Convert_pm_taskref_to_id_all the structure type is also passed as shown below.
145: As the structure type 'FINANCIAL' was passed the Convert_pm_taskref_to_id_all API was looking for the task in the
146: PA_TASKS table in the cursor l_task_id_csr. As this was not returning any rows the above error is thrown. The task
147: is there but due to the structure type 'WORKPLAN' it is residing in the elements tables as it is not yet published as well.
148: Ideally we should pass 'WORKPLAN' as the structure type. This is being done in the PA_PROJECT_PUB.DELETE_TASK API.
149: -- If the following criteria is satisfied,
150: -- switch flow to WORKPLAN

Line 292: AND l_amg_task_number IS NULL --if the task is not in pa_tasks

288: END IF;
289:
290: IF l_versioning_enabled = 'Y'
291: AND PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id_out ) = 'Y'
292: AND l_amg_task_number IS NULL --if the task is not in pa_tasks
293: THEN
294: --deleting task from a working version when there is a published structure exists
295: null; --in this case there wont be any task in pa_task
296: ELSE

Line 531: (p_pa_task_id pa_tasks.task_id%type)

527: FROM pa_projects p
528: WHERE p.project_id = p_pa_project_id;
529:
530: CURSOR l_amg_task_csr
531: (p_pa_task_id pa_tasks.task_id%type)
532: IS
533: SELECT task_number
534: FROM pa_tasks p
535: WHERE p.task_id = p_pa_task_id;

Line 534: FROM pa_tasks p

530: CURSOR l_amg_task_csr
531: (p_pa_task_id pa_tasks.task_id%type)
532: IS
533: SELECT task_number
534: FROM pa_tasks p
535: WHERE p.task_id = p_pa_task_id;
536:
537: BEGIN
538:

Line 759: FROM pa_tasks

755: CURSOR l_unique_task_ref_csr (p_project_id IN NUMBER
756: ,p_pm_task_reference IN VARCHAR2 )
757: IS
758: SELECT 1
759: FROM pa_tasks
760: WHERE pm_task_reference = p_pm_task_reference
761: AND project_id = p_project_id;
762:
763:

Line 1310: FROM pa_tasks

1306:
1307: BEGIN
1308: SELECT top_task_id
1309: INTO l_top_task_id
1310: FROM pa_tasks
1311: WHERE task_id = l_task_id_out;
1312:
1313: IF (l_task_id_out = l_top_task_id)
1314: THEN

Line 1329: FROM pa_tasks

1325: THEN
1326: BEGIN
1327: SELECT top_task_id
1328: INTO l_new_parent_top_task_id
1329: FROM pa_tasks
1330: WHERE task_id = l_parent_task_id_out;
1331:
1332: IF (l_top_task_id <> l_new_parent_top_task_id )
1333: THEN

Line 1629: FROM pa_tasks

1625: CURSOR l_unique_task_num_csr (p_project_id IN NUMBER
1626: ,p_task_number IN VARCHAR2 )
1627: IS
1628: SELECT 1
1629: FROM pa_tasks
1630: WHERE task_number = p_task_number
1631: AND project_id = p_project_id;
1632:
1633:

Line 1789: (p_pa_task_id pa_tasks.task_id%type)

1785: FROM pa_projects p
1786: WHERE p.project_id = p_pa_project_id;
1787:
1788: CURSOR l_amg_task_csr
1789: (p_pa_task_id pa_tasks.task_id%type)
1790: IS
1791: SELECT task_number
1792: FROM pa_tasks p
1793: WHERE p.task_id = p_pa_task_id;

Line 1792: FROM pa_tasks p

1788: CURSOR l_amg_task_csr
1789: (p_pa_task_id pa_tasks.task_id%type)
1790: IS
1791: SELECT task_number
1792: FROM pa_tasks p
1793: WHERE p.task_id = p_pa_task_id;
1794:
1795: BEGIN
1796:

Line 2128: (p_pa_task_id pa_tasks.task_id%type)

2124: FROM pa_projects p
2125: WHERE p.project_id = p_pa_project_id;
2126:
2127: CURSOR l_amg_task_csr
2128: (p_pa_task_id pa_tasks.task_id%type)
2129: IS
2130: SELECT project_id
2131: FROM pa_tasks p
2132: WHERE p.task_id = p_pa_task_id;

Line 2131: FROM pa_tasks p

2127: CURSOR l_amg_task_csr
2128: (p_pa_task_id pa_tasks.task_id%type)
2129: IS
2130: SELECT project_id
2131: FROM pa_tasks p
2132: WHERE p.task_id = p_pa_task_id;
2133:
2134: BEGIN
2135:

Line 3252: FROM pa_tasks

3248:
3249: CURSOR l_get_task_number_csr (p_task_id IN NUMBER)
3250: IS
3251: SELECT task_number
3252: FROM pa_tasks
3253: WHERE task_id = p_task_id;
3254:
3255: CURSOR l_get_task_id_csr (p_project_id IN NUMBER,
3256: p_task_number IN VARCHAR2 )

Line 3259: FROM pa_tasks

3255: CURSOR l_get_task_id_csr (p_project_id IN NUMBER,
3256: p_task_number IN VARCHAR2 )
3257: IS
3258: SELECT task_id,pm_task_reference
3259: FROM pa_tasks
3260: WHERE project_id = p_project_id
3261: AND task_number = p_task_number ;
3262:
3263: --needed to get the field values associated to a AMG message

Line 3390: UPDATE pa_tasks

3386: := p_array_cell_number;
3387: G_task_num_updated_index_tbl(l_count).task_id
3388: := p_task_id;
3389: -- Now update the processing task number to a temporary value
3390: UPDATE pa_tasks
3391: SET task_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ||
3392: TO_CHAR(G_index_counter)
3393: WHERE task_id = p_task_id;
3394: p_proceed_with_update_flag := 'N';

Line 3446: FROM pa_tasks pt where project_id = p_project_id

3442:
3443: CURSOR l_get_tasks_csr IS
3444: SELECT task_id,parent_task_id,TRUNC(start_date) start_date,TRUNC(completion_date) completion_date,task_name, -- Bug Fix 4705139
3445: pm_task_reference
3446: FROM pa_tasks pt where project_id = p_project_id
3447: AND
3448: (
3449: parent_task_id IS NOT NULL
3450: OR EXISTS

Line 3451: (SELECT 'x' FROM pa_tasks pt2

3447: AND
3448: (
3449: parent_task_id IS NOT NULL
3450: OR EXISTS
3451: (SELECT 'x' FROM pa_tasks pt2
3452: WHERE parent_task_id = pt.task_id));
3453:
3454: CURSOR l_get_child_dates_csr (l_project_id NUMBER,l_task_id NUMBER )
3455: IS

Line 3457: PA_TASKS

3453:
3454: CURSOR l_get_child_dates_csr (l_project_id NUMBER,l_task_id NUMBER )
3455: IS
3456: SELECT min(TRUNC(start_date)),max(TRUNC(completion_date)) FROM -- Bug Fix 4705139
3457: PA_TASKS
3458: WHERE project_id = l_project_id
3459: AND parent_task_id = l_task_id;
3460:
3461: CURSOR l_get_parent_dates_csr (l_project_id NUMBER,l_task_id NUMBER)

Line 3465: PA_TASKS

3461: CURSOR l_get_parent_dates_csr (l_project_id NUMBER,l_task_id NUMBER)
3462: IS
3463: SELECT TRUNC(start_date) start_date,TRUNC(completion_date) completion_date -- Bug Fix 4705139
3464: FROM
3465: PA_TASKS
3466: WHERE project_id = l_project_id
3467: AND task_id = l_task_id;
3468:
3469: l_get_tasks_rec l_get_tasks_csr%rowtype;

Line 3488: (p_pa_task_id pa_tasks.task_id%type)

3484: FROM pa_projects p
3485: WHERE p.project_id = p_pa_project_id;
3486:
3487: CURSOR l_amg_task_csr
3488: (p_pa_task_id pa_tasks.task_id%type)
3489: IS
3490: SELECT task_number
3491: FROM pa_tasks p
3492: WHERE p.task_id = p_pa_task_id;

Line 3491: FROM pa_tasks p

3487: CURSOR l_amg_task_csr
3488: (p_pa_task_id pa_tasks.task_id%type)
3489: IS
3490: SELECT task_number
3491: FROM pa_tasks p
3492: WHERE p.task_id = p_pa_task_id;
3493:
3494: p_multiple_task_msg VARCHAR2(1) := 'T';
3495: