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_PROGRESS_PVT dependencies on PA_PROJ_ELEMENTS_UTILS

Line 1592: --AND PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(element_version_id) = 'N'

1588: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
1589: FROM pa_proj_element_versions
1590: WHERE project_id = p_project_id
1591: AND parent_structure_version_id = p_structure_version_id
1592: --AND PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(element_version_id) = 'N'
1593: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure
1594: AND PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(element_version_id) = 'Y'
1595: AND object_type = 'PA_TASKS'
1596: UNION

Line 1594: AND PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(element_version_id) = 'Y'

1590: WHERE project_id = p_project_id
1591: AND parent_structure_version_id = p_structure_version_id
1592: --AND PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(element_version_id) = 'N'
1593: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure
1594: AND PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(element_version_id) = 'Y'
1595: AND object_type = 'PA_TASKS'
1596: UNION
1597: SELECT l_process_number_temp, p_structure_version_id object_id_from1, 'PA_TASKS', 1
1598: FROM dual

Line 1738: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );

1734: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT', x_Msg =>'l_tsk_base_prog_stat_code_tab('||k||')='||l_tsk_base_prog_stat_code_tab(k), x_Log_Level=> 3);
1735: END IF;
1736: l_tsk_progress_exists := 'N';
1737: l_parent_count := l_parent_count + 1;
1738: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );
1739: l_summary_object_flag := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(l_tsk_object_id_to1_tab(k)); -- 4370746
1740:
1741:
1742: IF g1_debug_mode = 'Y' THEN

Line 1739: l_summary_object_flag := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(l_tsk_object_id_to1_tab(k)); -- 4370746

1735: END IF;
1736: l_tsk_progress_exists := 'N';
1737: l_parent_count := l_parent_count + 1;
1738: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );
1739: l_summary_object_flag := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(l_tsk_object_id_to1_tab(k)); -- 4370746
1740:
1741:
1742: IF g1_debug_mode = 'Y' THEN
1743: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT',x_Msg => 'l_action_allowed='||l_action_allowed, x_Log_Level=> 3);

Line 2147: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );

2143: l_rollup_table1(l_index).DIRTY_FLAG2 := 'Y';
2144:
2145: -- Deliverable Status will not get rolled up for deliverable
2146:
2147: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );
2148:
2149: IF nvl( l_tsk_weighting_percent_tab(k), 0 ) = 0 THEN
2150: l_action_allowed := 'N';
2151: END IF;

Line 2351: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );

2347: -- l_rollup_table1(l_index).DIRTY_FLAG1 := 'N';
2348: -- l_rollup_table1(l_index).DIRTY_FLAG2 := 'N';
2349: -- END IF;
2350:
2351: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );
2352:
2353: IF nvl(l_tsk_weighting_percent_tab(k), 0) = 0 THEN
2354: l_action_allowed := 'N';
2355: END IF;

Line 2405: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );

2401: IF g1_debug_mode = 'Y' THEN
2402: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT', x_Msg => 'Second task cursor for summary task with assignments', x_Log_Level=> 3);
2403: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT', x_Msg => 'cur_tasks_rec.object_id_to1='||cur_tasks_rec.object_id_to1, x_Log_Level=> 3);
2404: END IF;
2405: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );
2406:
2407: l_index := l_index + 1;
2408:
2409: l_rollup_table1(l_index).OBJECT_TYPE := cur_tasks_rec.object_type;

Line 2526: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );

2522: -- l_rollup_table1(l_index).DIRTY_FLAG1 := 'N';
2523: -- l_rollup_table1(l_index).DIRTY_FLAG2 := 'N';
2524: -- END IF;
2525:
2526: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );
2527:
2528: IF nvl( cur_tasks_rec.weighting_percentage, 0 ) = 0 THEN
2529: l_action_allowed := 'N';
2530: END IF;

Line 4191: -- and PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ever.element_version_id) = 'N'

4187: , pa_object_relationships obj
4188: WHERE ever.project_id = p_project_id
4189: and ever.parent_structure_version_id = p_structure_version_id
4190: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure
4191: -- and PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ever.element_version_id) = 'N'
4192: and PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ever.element_version_id) = 'Y'
4193: and ever.object_type = 'PA_TASKS'
4194: AND obj.object_id_to1 = ever.element_version_id
4195: AND obj.relationship_type = 'S'

Line 4192: and PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ever.element_version_id) = 'Y'

4188: WHERE ever.project_id = p_project_id
4189: and ever.parent_structure_version_id = p_structure_version_id
4190: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure
4191: -- and PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ever.element_version_id) = 'N'
4192: and PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ever.element_version_id) = 'Y'
4193: and ever.object_type = 'PA_TASKS'
4194: AND obj.object_id_to1 = ever.element_version_id
4195: AND obj.relationship_type = 'S'
4196: and p_rollup_entire_wbs='Y';

Line 7001: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );

6997: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ASGN_DLV_TO_TASK_ROLLUP_PVT', x_Msg => 'Inside Tasks Loop', x_Log_Level=> 3);
6998: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ASGN_DLV_TO_TASK_ROLLUP_PVT', x_Msg => 'cur_tasks_rec.base_progress_status_code='||cur_tasks_rec.base_progress_status_code, x_Log_Level=> 3);
6999: END IF;
7000:
7001: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );
7002:
7003: -- We only populate the asssignment and deliverable records n the PL/SQL table for the input task
7004: -- , assignments and deliverables of the sub-tasks are not considered. -- Fix for Bug # 4032987.
7005:

Line 7379: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );

7375: l_rollup_table1(l_index).DIRTY_FLAG2 := 'Y';
7376:
7377: -- Deliverable Status will not get rolled up for deliverable
7378:
7379: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );
7380:
7381: IF nvl( l_task_weighting_percentage, 0 ) = 0 THEN
7382: l_action_allowed := 'N';
7383: END IF;

Line 7414: -- l_rollup_table1(l_index).SUMMARY_OBJECT_FLAG := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(cur_tasks_rec.object_id_to1);--4370746

7410: l_rollup_table1(l_index).PARENT_OBJECT_ID := cur_tasks_rec.object_id_from1; --Parent Task Version Id
7411: l_rollup_table1(l_index).WBS_LEVEL := NVL( cur_tasks_rec.wbs_level, 0 );
7412:
7413: -- 4582956 Begin
7414: -- l_rollup_table1(l_index).SUMMARY_OBJECT_FLAG := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(cur_tasks_rec.object_id_to1);--4370746
7415: IF cur_tasks_rec.object_id_to1 = nvl(l_subproj_task_version_id, -789) THEN
7416: -- 4586449 : Passing L for link tasks
7417: l_rollup_table1(l_index).SUMMARY_OBJECT_FLAG := 'L'; --Link task shd be treated as summary task
7418: --l_rollup_table1(l_index).SUMMARY_OBJECT_FLAG := 'Y'; --Link task shd be treated as summary task

Line 7420: l_rollup_table1(l_index).SUMMARY_OBJECT_FLAG := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(cur_tasks_rec.object_id_to1);

7416: -- 4586449 : Passing L for link tasks
7417: l_rollup_table1(l_index).SUMMARY_OBJECT_FLAG := 'L'; --Link task shd be treated as summary task
7418: --l_rollup_table1(l_index).SUMMARY_OBJECT_FLAG := 'Y'; --Link task shd be treated as summary task
7419: ELSE
7420: l_rollup_table1(l_index).SUMMARY_OBJECT_FLAG := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(cur_tasks_rec.object_id_to1);
7421: END IF;
7422: -- 4582956 end
7423:
7424: -- Rollup Percent Complete Rollup

Line 7623: IF PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_version_id ) = 'N'

7619:
7620: /*
7621: --bug 3951982
7622: --populate scheduling pl/sql table with sub-tasks of a summary tasks if it has assignments.
7623: IF PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_version_id ) = 'N'
7624: AND pa_progress_utils.check_assignment_exists(p_project_id,p_task_version_id, 'PA_TASKS') = 'Y'
7625: THEN
7626: -- Loop thru all tasks of a passed task
7627: FOR cur_tasks_rec in cur_tasks( p_task_version_id ) LOOP

Line 7635: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );

7631: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ASGN_DLV_TO_TASK_ROLLUP_PVT', x_Msg => 'Inside Tasks Loop: Second pass', x_Log_Level=> 3);
7632: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ASGN_DLV_TO_TASK_ROLLUP_PVT', x_Msg => 'p_task_version_id='||p_task_version_id, x_Log_Level=> 3);
7633: END IF;
7634:
7635: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );
7636:
7637: IF g1_debug_mode = 'Y' THEN
7638: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ASGN_DLV_TO_TASK_ROLLUP_PVT', x_Msg => 'l_index='||l_index, x_Log_Level=> 3);
7639: END IF;

Line 8124: IF PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(p_task_version_id )= 'Y'

8120: END IF;
8121: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure
8122: -- 4533112 : Now base_progress_status_code is not used
8123: /*
8124: IF PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(p_task_version_id )= 'Y'
8125: THEN
8126: -- l_rolled_up_base_per_comp := nvl(l_cur_pa_rollup1_rec.base_percent_complete,0);
8127: l_rolled_up_base_prog_stat := l_cur_pa_rollup1_rec.base_progress_status_code;
8128: ELSE

Line 11895: AND PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(element_version_id) = 'Y'

11891: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
11892: FROM pa_proj_element_versions
11893: WHERE project_id = p_project_id
11894: AND parent_structure_version_id = p_structure_version_id
11895: AND PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(element_version_id) = 'Y'
11896: AND object_type = 'PA_TASKS'
11897: UNION
11898: SELECT l_process_number_temp, p_structure_version_id object_id_from1, 'PA_TASKS', 1
11899: FROM dual;

Line 12047: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );

12043: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg =>'l_tsk_base_prog_stat_code_tab('||k||')='||l_tsk_base_prog_stat_code_tab(k), x_Log_Level=> 3);
12044: END IF;
12045: l_tsk_progress_exists := 'N';
12046: l_parent_count := l_parent_count + 1;
12047: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );
12048: l_summary_object_flag := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(l_tsk_object_id_to1_tab(k)); -- 4370746
12049:
12050: IF g1_debug_mode = 'Y' THEN
12051: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT',x_Msg => 'l_action_allowed='||l_action_allowed, x_Log_Level=> 3);

Line 12048: l_summary_object_flag := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(l_tsk_object_id_to1_tab(k)); -- 4370746

12044: END IF;
12045: l_tsk_progress_exists := 'N';
12046: l_parent_count := l_parent_count + 1;
12047: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );
12048: l_summary_object_flag := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(l_tsk_object_id_to1_tab(k)); -- 4370746
12049:
12050: IF g1_debug_mode = 'Y' THEN
12051: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT',x_Msg => 'l_action_allowed='||l_action_allowed, x_Log_Level=> 3);
12052: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT',x_Msg => 'l_summary_object_flag='||l_summary_object_flag, x_Log_Level=> 3);

Line 12413: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );

12409: l_rollup_table1(l_index).DIRTY_FLAG2 := 'Y';
12410:
12411: -- Deliverable Status will not get rolled up for deliverable
12412:
12413: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );
12414:
12415: IF nvl( l_tsk_weighting_percent_tab(k), 0 ) = 0 THEN
12416: l_action_allowed := 'N';
12417: END IF;

Line 12581: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );

12577: -- l_rollup_table1(l_index).DIRTY_FLAG1 := 'N';
12578: -- l_rollup_table1(l_index).DIRTY_FLAG2 := 'N';
12579: -- END IF;
12580:
12581: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );
12582:
12583: IF nvl(l_tsk_weighting_percent_tab(k), 0) = 0 THEN
12584: l_action_allowed := 'N';
12585: END IF;

Line 12637: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );

12633: IF g1_debug_mode = 'Y' THEN
12634: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg => 'Second task cursor for summary task with assignments', x_Log_Level=> 3);
12635: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg => 'cur_tasks_rec.object_id_to1='||cur_tasks_rec.object_id_to1, x_Log_Level=> 3);
12636: END IF;
12637: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );
12638:
12639: l_index := l_index + 1;
12640:
12641: l_rollup_table1(l_index).OBJECT_TYPE := cur_tasks_rec.object_type;

Line 12755: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );

12751: -- l_rollup_table1(l_index).DIRTY_FLAG1 := 'N';
12752: -- l_rollup_table1(l_index).DIRTY_FLAG2 := 'N';
12753: -- END IF;
12754:
12755: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );
12756:
12757: IF nvl( cur_tasks_rec.weighting_percentage, 0 ) = 0 THEN
12758: l_action_allowed := 'N';
12759: END IF;

Line 15440: AND PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(element_version_id) = 'Y'

15436: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
15437: FROM pa_proj_element_versions
15438: WHERE project_id = p_project_id
15439: AND parent_structure_version_id = p_structure_version_id
15440: AND PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(element_version_id) = 'Y'
15441: AND object_type = 'PA_TASKS'
15442: UNION
15443: SELECT l_process_number_temp, p_structure_version_id object_id_from1, 'PA_TASKS', 1
15444: FROM dual;*/

Line 15633: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );

15629: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg =>'l_tsk_base_prog_stat_code_tab('||k||')='||l_tsk_base_prog_stat_code_tab(k), x_Log_Level=> 3);
15630: END IF;
15631: l_tsk_progress_exists := 'N';
15632: l_parent_count := l_parent_count + 1;
15633: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );
15634: l_summary_object_flag := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(l_tsk_object_id_to1_tab(k)); -- 4370746
15635:
15636: IF g1_debug_mode = 'Y' THEN
15637: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT',x_Msg => 'l_action_allowed='||l_action_allowed, x_Log_Level=> 3);

Line 15634: l_summary_object_flag := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(l_tsk_object_id_to1_tab(k)); -- 4370746

15630: END IF;
15631: l_tsk_progress_exists := 'N';
15632: l_parent_count := l_parent_count + 1;
15633: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );
15634: l_summary_object_flag := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(l_tsk_object_id_to1_tab(k)); -- 4370746
15635:
15636: IF g1_debug_mode = 'Y' THEN
15637: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT',x_Msg => 'l_action_allowed='||l_action_allowed, x_Log_Level=> 3);
15638: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT',x_Msg => 'l_summary_object_flag='||l_summary_object_flag, x_Log_Level=> 3);

Line 15999: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );

15995: l_rollup_table1(l_index).DIRTY_FLAG2 := 'Y';
15996:
15997: -- Deliverable Status will not get rolled up for deliverable
15998:
15999: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );
16000:
16001: IF nvl( l_tsk_weighting_percent_tab(k), 0 ) = 0 THEN
16002: l_action_allowed := 'N';
16003: END IF;

Line 16167: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );

16163: -- l_rollup_table1(l_index).DIRTY_FLAG1 := 'N';
16164: -- l_rollup_table1(l_index).DIRTY_FLAG2 := 'N';
16165: -- END IF;
16166:
16167: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );
16168:
16169: IF nvl(l_tsk_weighting_percent_tab(k), 0) = 0 THEN
16170: l_action_allowed := 'N';
16171: END IF;

Line 16224: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );

16220: IF g1_debug_mode = 'Y' THEN
16221: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg => 'Second task cursor for summary task with assignments', x_Log_Level=> 3);
16222: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg => 'cur_tasks_rec.object_id_to1='||cur_tasks_rec.object_id_to1, x_Log_Level=> 3);
16223: END IF;
16224: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );
16225:
16226: l_index := l_index + 1;
16227:
16228: l_rollup_table1(l_index).OBJECT_TYPE := cur_tasks_rec.object_type;

Line 16342: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );

16338: -- l_rollup_table1(l_index).DIRTY_FLAG1 := 'N';
16339: -- l_rollup_table1(l_index).DIRTY_FLAG2 := 'N';
16340: -- END IF;
16341:
16342: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );
16343:
16344: IF nvl( cur_tasks_rec.weighting_percentage, 0 ) = 0 THEN
16345: l_action_allowed := 'N';
16346: END IF;