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_PROGRESS_UTILS

Line 347: AND PA_PROGRESS_UTILS.get_system_task_status( status_code, 'PA_DELIVERABLES') = 'DLVR_IN_PROGRESS'

343: AND object_type = 'PA_DELIVERABLES'
344: AND trunc(date_computed)<= trunc(p_as_of_date)
345: AND structure_type = 'WORKPLAN'
346: AND published_flag = 'Y'
347: AND PA_PROGRESS_UTILS.get_system_task_status( status_code, 'PA_DELIVERABLES') = 'DLVR_IN_PROGRESS'
348: );
349:
350:
351: CURSOR c_get_object_status (l_project_id NUMBER, l_proj_element_id NUMBER)

Line 453: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag) BAC_value

449: , ppr.PROJ_COST_RATE_DATE
450: , ppr.TXN_CURRENCY_CODE
451: , ppr.PROG_PA_PERIOD_NAME
452: , ppr.PROG_GL_PERIOD_NAME
453: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag) BAC_value
454: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag,'N')
455: BAC_value_self -- bug 4493105
456: , null earned_value
457: , to_char(null) task_derivation_method

Line 454: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag,'N')

450: , ppr.TXN_CURRENCY_CODE
451: , ppr.PROG_PA_PERIOD_NAME
452: , ppr.PROG_GL_PERIOD_NAME
453: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag) BAC_value
454: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag,'N')
455: BAC_value_self -- bug 4493105
456: , null earned_value
457: , to_char(null) task_derivation_method
458: , ppr.progress_rollup_id

Line 488: AND ppr.as_of_date = pa_progress_utils.get_max_rollup_asofdate(ppev.project_id,

484: AND ppev.object_type = 'PA_STRUCTURES'
485: AND ppr.project_id = ppev.project_id
486: AND ppr.object_id = ppev.proj_element_id
487: AND ppr.object_type = 'PA_STRUCTURES'
488: AND ppr.as_of_date = pa_progress_utils.get_max_rollup_asofdate(ppev.project_id,
489: ppev.proj_element_id, ppev.object_type,p_as_of_date, ppev.element_version_id, p_structure_type, l_structure_version_id, ppev.proj_element_id/* Bug 3764224 */) -- FPM Dev CR 3
490: AND ppr.current_flag <> 'W'
491: AND ppr.EFF_ROLLUP_PROG_STAT_CODE = pps1.project_status_code(+)
492: AND ppr.progress_status_code = pps2.project_status_code(+)

Line 571: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,

567: , ppr.PROJ_COST_RATE_DATE
568: , ppr.TXN_CURRENCY_CODE
569: , ppr.PROG_PA_PERIOD_NAME
570: , ppr.PROG_GL_PERIOD_NAME
571: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,
572: 'FINANCIAL',p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,
573: p_structure_type,p_working_wp_prog_flag) BAC_value
574: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,
575: 'FINANCIAL',p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,

Line 574: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,

570: , ppr.PROG_GL_PERIOD_NAME
571: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,
572: 'FINANCIAL',p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,
573: p_structure_type,p_working_wp_prog_flag) BAC_value
574: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,
575: 'FINANCIAL',p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,
576: p_structure_type,p_working_wp_prog_flag,'N') BAC_value_self -- bug 4493105
577: , null earned_value
578: , decode(ppe.base_percent_comp_deriv_code, null, ttype.base_percent_comp_deriv_code,'^',ttype.base_percent_comp_deriv_code,ppe.base_percent_comp_deriv_code) task_derivation_method

Line 615: AND ppr.as_of_date = pa_progress_utils.get_max_rollup_asofdate(ppev2.project_id,

611: AND pobj.object_id_from1 = ppev1.element_version_id
612: AND pobj.object_id_to1 = ppev2.element_version_id
613: AND pobj.relationship_type = 'S'
614: AND ppr.project_id = ppev2.project_id
615: AND ppr.as_of_date = pa_progress_utils.get_max_rollup_asofdate(ppev2.project_id,
616: ppev2.proj_element_id, ppev2.object_type,p_as_of_date, ppev2.element_version_id, p_structure_type, l_structure_version_id, ppev2.proj_element_id/*Bug 3764224 */) -- FPM Dev CR 3
617: AND ppr.current_flag <> 'W'
618: AND ppr.object_id = ppev2.proj_element_id
619: AND ppr.project_id = ppev2.project_id

Line 711: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag) BAC_value

707: , to_date(null) PROJ_COST_RATE_DATE
708: , to_char(null) TXN_CURRENCY_CODE
709: , to_char(null) PROG_PA_PERIOD_NAME
710: , to_char(null) PROG_GL_PERIOD_NAME
711: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag) BAC_value
712: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag,'N')
713: BAC_value_self -- bug 4493105
714: , null earned_value
715: , to_char(null) task_derivation_method

Line 712: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag,'N')

708: , to_char(null) TXN_CURRENCY_CODE
709: , to_char(null) PROG_PA_PERIOD_NAME
710: , to_char(null) PROG_GL_PERIOD_NAME
711: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag) BAC_value
712: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag,'N')
713: BAC_value_self -- bug 4493105
714: , null earned_value
715: , to_char(null) task_derivation_method
716: , to_number(null) progress_rollup_id

Line 737: AND pa_progress_utils.get_max_rollup_asofdate(ppev.project_id,

733: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
734: element_version_id = temp.object_id
735: AND temp.process_number = l_process_number_temp
736: AND ppev.object_type = 'PA_STRUCTURES'
737: AND pa_progress_utils.get_max_rollup_asofdate(ppev.project_id,
738: ppev.proj_element_id, ppev.object_type,p_as_of_date, ppev.element_version_id, p_structure_type, l_structure_version_id, ppev.proj_element_id/*Bug 3764224 */)
739: IS NULL
740: AND temp.object_type = 'PA_TASKS' -- cklee bug: 6610612
741: UNION ALL -- Change from Union to Union ALL for 14040849

Line 815: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',

811: , to_date(null) PROJ_COST_RATE_DATE
812: , to_char(null) TXN_CURRENCY_CODE
813: , to_char(null) PROG_PA_PERIOD_NAME
814: , to_char(null) PROG_GL_PERIOD_NAME
815: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',
816: p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,
817: p_structure_type,p_working_wp_prog_flag) BAC_value
818: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',
819: p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,

Line 818: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',

814: , to_char(null) PROG_GL_PERIOD_NAME
815: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',
816: p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,
817: p_structure_type,p_working_wp_prog_flag) BAC_value
818: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',
819: p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,
820: p_structure_type,p_working_wp_prog_flag,'N') BAC_value_self -- bug 4493105
821: , null earned_value
822: , decode(ppe.base_percent_comp_deriv_code, null, ttype.base_percent_comp_deriv_code,'^',ttype.base_percent_comp_deriv_code,ppe.base_percent_comp_deriv_code) task_derivation_method

Line 863: AND pa_progress_utils.get_max_rollup_asofdate(ppev2.project_id,

859: AND ppe.link_task_flag <> 'Y' -- 4392189
860: AND pobj.object_type_to = 'PA_TASKS'
861: AND pobj.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
862: AND ppe.type_id = ttype.task_type_id
863: AND pa_progress_utils.get_max_rollup_asofdate(ppev2.project_id,
864: ppev2.proj_element_id, ppev2.object_type,p_as_of_date, ppev2.element_version_id, p_structure_type, l_structure_version_id, ppev2.proj_element_id/*Bug 3764224 */)
865: IS NULL
866: AND ( (ppev2.financial_task_flag = 'Y' AND p_structure_type = 'FINANCIAL') OR p_structure_type = 'WORKPLAN') -- Bug 4346483
867: AND temp.object_type = 'PA_TASKS' -- cklee bug: 6610612

Line 1063: AND ppr.as_of_date = pa_progress_utils.get_max_rollup_asofdate(asgn.project_id,

1059: AND asgn.RESOURCE_LIST_MEMBER_ID = ppr.object_id -- Bug 3764224
1060: AND asgn.task_id = ppr.proj_element_id -- Bug 3764224
1061: AND ppr.object_type = 'PA_ASSIGNMENTS'
1062: -- AND asgn.ta_display_flag = 'Y' --Bug 4323537.
1063: AND ppr.as_of_date = pa_progress_utils.get_max_rollup_asofdate(asgn.project_id,
1064: asgn.RESOURCE_LIST_MEMBER_ID, 'PA_ASSIGNMENTS',p_as_of_date,asgn.task_version_id, p_structure_type, l_structure_version_id, asgn.task_id) ---Bug 3764224 -- FPM Dev CR 3
1065: AND ppr.current_flag <> 'W'
1066: AND ppr.structure_type = p_structure_type
1067: AND ((l_published_structure = 'Y' AND ppr.structure_version_id is null) OR (l_published_structure = 'N' AND ppr.structure_version_id = p_structure_version_id))

Line 1164: AND pa_progress_utils.get_max_rollup_asofdate(asgn.project_id,

1160: ,asgn.planned_bur_cost_proj_cur) bac_value_in_task_deriv --3801780
1161: FROM
1162: pa_task_asgmts_v asgn
1163: WHERE asgn.task_version_id = c_task_ver_id
1164: AND pa_progress_utils.get_max_rollup_asofdate(asgn.project_id,
1165: asgn.RESOURCE_LIST_MEMBER_ID, 'PA_ASSIGNMENTS',p_as_of_date,asgn.task_version_id, p_structure_type, l_structure_version_id, asgn.task_id ) --- Bug 3764224
1166: IS NULL
1167: --bug 3958686, now hidden assignments should not to be selected
1168: -- AND asgn.ta_display_flag = 'Y' -- Bug 4323537

Line 1210: AND ppr.as_of_date(+) = pa_progress_utils.get_max_rollup_asofdate(c_project_id,

1206: -- AND obj.object_id_to1 = ppr.object_version_id(+)
1207: AND ppr.object_type(+) = 'PA_DELIVERABLES'
1208: AND ppr.project_id(+) = c_project_id
1209: AND ppr.object_id(+) = obj.object_id_to2
1210: AND ppr.as_of_date(+) = pa_progress_utils.get_max_rollup_asofdate(c_project_id,
1211: obj.object_id_to2, 'PA_DELIVERABLES',p_as_of_date,obj.object_id_to1, p_structure_type, l_structure_version_id, obj.object_id_from2 /* Bug 3764224 */) -- FPM Dev CR 3
1212: AND ppr.structure_type(+) = p_structure_type
1213: AND ppr.structure_version_id is null -- deliverable progress for working version is not allowed
1214: AND ppr.base_progress_status_code = pps3.project_status_code(+)

Line 1317: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,

1313: SELECT
1314: ppv2.project_id sub_project_id
1315: ,ppv2.element_version_id sub_structure_ver_id
1316: ,ppv2.proj_element_id sub_proj_element_id
1317: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,
1318: 'WORKPLAN','N') sub_project_bac_value
1319: FROM
1320: pa_proj_element_versions ppv2
1321: ,pa_proj_elem_ver_structure ppevs2

Line 2101: AND (PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, l_tsk_proj_element_id_tab(k))) <> 'CANCELLED')

2097: END IF;
2098:
2099: -- Bug 3957792 : Added check for Cancelled tasks
2100: IF p_structure_type = 'WORKPLAN' AND l_published_structure = 'Y' AND l_tsk_deriv_method_tab(k) = 'DELIVERABLE'
2101: AND (PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, l_tsk_proj_element_id_tab(k))) <> 'CANCELLED')
2102: THEN
2103:
2104: FOR cur_del_rec in cur_deliverables(l_tsk_proj_element_id_tab(k), l_tsk_object_id_to1_tab(k), p_project_id) LOOP -- FPM Change
2105: IF g1_debug_mode = 'Y' THEN

Line 2313: l_rollup_table1(l_index).EARNED_VALUE1 := pa_progress_utils.Get_BAC_Value(p_project_id

2309: -- 4586449 Begin : For link tasks, pass BAC_VALUE in terms of derivation method of the task
2310: -- in earned_value1 set
2311: IF p_structure_type = 'WORKPLAN' AND l_tsk_object_id_to1_tab(k) = nvl(l_subproj_task_version_id, -789) THEN
2312:
2313: l_rollup_table1(l_index).EARNED_VALUE1 := pa_progress_utils.Get_BAC_Value(p_project_id
2314: , l_tsk_deriv_method_tab(k), l_tsk_proj_element_id_tab(k), p_structure_version_id,
2315: 'WORKPLAN','N','Y');
2316: -- Bug 4636100 Issue 1 : We should always pass self plan for link task as 1
2317: --l_rollup_table1(l_index).EARNED_VALUE2 := NVL( l_tsk_bac_self_value_tab(k), 0 );

Line 2392: AND pa_progress_utils.check_assignment_exists(p_project_id,p_task_version_id, 'PA_TASKS') = 'Y'

2388: END LOOP; -- End Tasks Loop
2389:
2390: --begin bug 3951982
2391: IF p_lowest_level_task = 'N' AND p_rollup_entire_wbs = 'N'
2392: AND pa_progress_utils.check_assignment_exists(p_project_id,p_task_version_id, 'PA_TASKS') = 'Y'
2393: AND l_actual_lowest_task = 'N' -- Bug 4392189
2394: THEN
2395: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
2396: SELECT l_process_number_temp, p_task_version_id, 'PA_TASKS', 1

Line 2742: l_prog_pa_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date,l_org_id),null);

2738:
2739:
2740: BEGIN
2741: -- 4746476 : Added org_id in functions call below
2742: l_prog_pa_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date,l_org_id),null);
2743: l_prog_gl_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(p_as_of_date,l_org_id),null);
2744: EXCEPTION
2745: WHEN OTHERS THEN
2746: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 2743: l_prog_gl_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(p_as_of_date,l_org_id),null);

2739:
2740: BEGIN
2741: -- 4746476 : Added org_id in functions call below
2742: l_prog_pa_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date,l_org_id),null);
2743: l_prog_gl_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(p_as_of_date,l_org_id),null);
2744: EXCEPTION
2745: WHEN OTHERS THEN
2746: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2747: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');

Line 3291: l_system_status_code := PA_PROGRESS_UTILS.get_system_task_status( l_status_code ); --Bug#5374114

3287: FETCH c_get_object_status INTO l_existing_object_status;
3288: CLOSE c_get_object_status;
3289:
3290: l_status_code := l_existing_object_status;
3291: l_system_status_code := PA_PROGRESS_UTILS.get_system_task_status( l_status_code ); --Bug#5374114
3292: l_status_code_temp := l_status_code; --Bug#5374114
3293: l_system_status_code_temp := l_system_status_code; --Bug#5374114
3294:
3295: IF ( nvl(l_rollup_table1(i).task_status1,0) <> 0 )

Line 3304: l_system_status_code := PA_PROGRESS_UTILS.get_system_task_status( l_status_code ); -- Bug 3956299

3300: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT', x_Msg => 'l_status_code ='||l_status_code, x_Log_Level=> 3);
3301: END IF;
3302: -- Now Defaulting of Status will happen even if the status is returned by Scheuling API, but it is wrong
3303:
3304: l_system_status_code := PA_PROGRESS_UTILS.get_system_task_status( l_status_code ); -- Bug 3956299
3305: IF g1_debug_mode = 'Y' THEN
3306: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT', x_Msg => 'l_status_code='||l_status_code, x_Log_Level=> 3);
3307: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT', x_Msg => 'l_existing_object_status='||l_existing_object_status, x_Log_Level=> 3);
3308: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT', x_Msg => 'l_system_status_code='||l_system_status_code, x_Log_Level=> 3);

Line 3387: --AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED', 'COMPLETED' )

3383: , actual_finish_date = l_actual_finish_date -- Bug 3956299
3384: WHERE object_id = cur_reverse_tree_rec.proj_element_id
3385: AND object_Type = cur_reverse_tree_rec.object_Type ---4743866
3386: AND project_id = p_project_id
3387: --AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED', 'COMPLETED' )
3388: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' ) -- 02/06/04 Satish
3389: AND structure_type = p_structure_type -- FPM Dev CR 3
3390: AND current_flag = 'N' and published_flag = 'N'
3391: ;

Line 3388: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' ) -- 02/06/04 Satish

3384: WHERE object_id = cur_reverse_tree_rec.proj_element_id
3385: AND object_Type = cur_reverse_tree_rec.object_Type ---4743866
3386: AND project_id = p_project_id
3387: --AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED', 'COMPLETED' )
3388: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' ) -- 02/06/04 Satish
3389: AND structure_type = p_structure_type -- FPM Dev CR 3
3390: AND current_flag = 'N' and published_flag = 'N'
3391: ;
3392:

Line 3401: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' ) -- 02/06/04 Satish

3397: , actual_finish_date = l_actual_finish_date -- Bug 3956299
3398: WHERE object_id = cur_reverse_tree_rec.proj_element_id
3399: AND object_Type = cur_reverse_tree_rec.object_Type ---4743866
3400: AND project_id = p_project_id
3401: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' ) -- 02/06/04 Satish
3402: AND structure_type = p_structure_type -- FPM Dev CR 3
3403: AND published_flag = 'Y' ---4743866
3404: AND current_flag = 'Y'
3405: AND trunc(date_computed) = trunc(p_as_of_date)

Line 3601: l_max_rollup_as_of_date2 := PA_PROGRESS_UTILS.get_max_rollup_asofdate2

3597: AND date_computed <= p_as_of_date);
3598: EXCEPTION WHEN OTHERS THEN
3599: l_percent_complete_id := null;
3600: END;
3601: l_max_rollup_as_of_date2 := PA_PROGRESS_UTILS.get_max_rollup_asofdate2
3602: (p_project_id => p_project_id,
3603: p_object_id => cur_reverse_tree_rec.proj_element_id,
3604: p_object_type => l_rollup_table1(i).object_type,
3605: p_structure_type => p_structure_type,

Line 4673: l_parent_as_of_date := pa_progress_utils.get_next_progress_cycle(

4669: --Commented below code for AWE Performance bug 16230177
4670:
4671: ---4701759, 4701727
4672: /*if (l_child_prog_cycle_id <> l_par_prog_cycle_id) then
4673: l_parent_as_of_date := pa_progress_utils.get_next_progress_cycle(
4674: p_project_id => l_c1rec.parent_project_id
4675: ,p_task_id => l_c1rec.parent_task_id
4676: ,p_start_date => trunc(p_as_of_date)-1);
4677: else

Line 4685: l_parent_as_of_date := pa_progress_utils.get_next_progress_cycle(

4681: open get_parent_max_asofdate(l_c1rec.parent_project_id,l_c1rec.parent_task_id);
4682: fetch get_parent_max_asofdate into l_parent_as_of_date;
4683: close get_parent_max_asofdate;
4684: if (l_parent_as_of_date is null or l_parent_as_of_date < p_as_of_date) then
4685: l_parent_as_of_date := pa_progress_utils.get_next_progress_cycle(
4686: p_project_id => l_c1rec.parent_project_id
4687: ,p_task_id => l_c1rec.parent_task_id
4688: ,p_start_date => trunc(p_as_of_date)-1);
4689: end if;

Line 4746: l_pln_sub_project := pa_progress_utils.Get_BAC_Value(p_project_id => p_project_id

4742: CLOSE c_get_par_task_rollup;
4743:
4744: --bug 4033869
4745: -- Get sub project plan in terms of derivation method of parent task
4746: l_pln_sub_project := pa_progress_utils.Get_BAC_Value(p_project_id => p_project_id
4747: ,p_task_weight_method => l_base_prcnt_comp_drv_code
4748: ,p_proj_element_id => l_sub_project_rec.object_id
4749: ,p_structure_version_id => p_structure_ver_id
4750: ,p_structure_type => 'WORKPLAN');

Line 4811: IF PA_PROGRESS_UTILS.get_system_task_status(l_parent_task_status) NOT IN ( 'CANCELLED', 'ON_HOLD', 'COMPLETED' )

4807: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.PROGRAM_ROLLUP_PVT', x_Msg => 'l_bcwp='||l_bcwp, x_Log_Level=> 3);
4808: END IF;
4809:
4810:
4811: IF PA_PROGRESS_UTILS.get_system_task_status(l_parent_task_status) NOT IN ( 'CANCELLED', 'ON_HOLD', 'COMPLETED' )
4812: --bug 4033869 If parent is ON-HOLD, CANCELLED or COMPLETED then do not rollup any progress attributes.
4813: THEN
4814: --l_parent_progress_status := nvl(l_parent_task_rec.PROGRESS_STATUS_CODE, l_parent_task_rec.EFF_ROLLUP_PROG_STAT_CODE);
4815: --l_child_progress_status := nvl(l_sub_project_rec.PROGRESS_STATUS_CODE, l_sub_project_rec.EFF_ROLLUP_PROG_STAT_CODE);

Line 4920: END IF; --PA_PROGRESS_UTILS.get_system_task_status bug 4033869

4916: END IF;
4917:
4918: -- For Task Status Rollup, we can use PA_SCHEDULE_OBJECTS_PVT.GET_PROGRESS_STATUS
4919: -- First we need to confirm that whether we are inserting/updating in PPC table
4920: END IF; --PA_PROGRESS_UTILS.get_system_task_status bug 4033869
4921: ELSE
4922: IF g1_debug_mode = 'Y' THEN
4923: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.PROGRAM_ROLLUP_PVT', x_Msg => 'Mode is Insert I', x_Log_Level=> 3);
4924: END IF;

Line 4966: l_pln_parent_task := pa_progress_utils.Get_BAC_Value(p_project_id => l_c1rec.parent_project_id

4962: END IF;
4963: */
4964: /*
4965:
4966: l_pln_parent_task := pa_progress_utils.Get_BAC_Value(p_project_id => l_c1rec.parent_project_id
4967: ,p_task_weight_method => l_base_prcnt_comp_drv_code
4968: ,p_proj_element_id => l_c1rec.parent_task_id
4969: ,p_structure_version_id => l_c1rec.parent_structure_ver_id
4970: ,p_structure_type => 'WORKPLAN');

Line 5274: l_parent_as_of_date := pa_progress_utils.get_next_progress_cycle(

5270: AND current_flag = 'Y';
5271: END;
5272: --bug 4033869
5273: --derive as of date for parent task relative to p_as_of_date
5274: l_parent_as_of_date := pa_progress_utils.get_next_progress_cycle(
5275: p_project_id => l_c1rec.parent_project_id
5276: ,p_task_id => l_c1rec.parent_task_id
5277: ,p_start_date => p_as_of_date);
5278: --End bug 4033869

Line 5711: , pa_progress_utils.Get_BAC_Value(ppev.project_id, p_wp_rollup_method, ppev.proj_element_id, ppev.parent_structure_version_id, 'WORKPLAN') BAC_value

5707: , ppr.PROJ_COST_RATE_DATE
5708: , ppr.TXN_CURRENCY_CODE
5709: , ppr.PROG_PA_PERIOD_NAME
5710: , ppr.PROG_GL_PERIOD_NAME
5711: , pa_progress_utils.Get_BAC_Value(ppev.project_id, p_wp_rollup_method, ppev.proj_element_id, ppev.parent_structure_version_id, 'WORKPLAN') BAC_value
5712: , pa_progress_utils.Get_BAC_Value(ppev.project_id, p_wp_rollup_method, ppev.proj_element_id, ppev.parent_structure_version_id, 'WORKPLAN','N','N') BAC_value_self -- bug 4493105
5713: , null earned_value
5714: , ppr.Oth_quantity_to_date
5715: , ppr.Oth_etc_quantity

Line 5712: , pa_progress_utils.Get_BAC_Value(ppev.project_id, p_wp_rollup_method, ppev.proj_element_id, ppev.parent_structure_version_id, 'WORKPLAN','N','N') BAC_value_self -- bug 4493105

5708: , ppr.TXN_CURRENCY_CODE
5709: , ppr.PROG_PA_PERIOD_NAME
5710: , ppr.PROG_GL_PERIOD_NAME
5711: , pa_progress_utils.Get_BAC_Value(ppev.project_id, p_wp_rollup_method, ppev.proj_element_id, ppev.parent_structure_version_id, 'WORKPLAN') BAC_value
5712: , pa_progress_utils.Get_BAC_Value(ppev.project_id, p_wp_rollup_method, ppev.proj_element_id, ppev.parent_structure_version_id, 'WORKPLAN','N','N') BAC_value_self -- bug 4493105
5713: , null earned_value
5714: , ppr.Oth_quantity_to_date
5715: , ppr.Oth_etc_quantity
5716: -- 4533112 : Added base_progress_status_code

Line 5759: -- AND ppr.as_of_date = pa_progress_utils.get_max_rollup_asofdate2(ppev.project_id,

5755: and ppc1.structure_type = 'WORKPLAN'
5756: and ppc1.as_of_date <= p_as_of_date
5757: and ppc1.structure_version_id is null
5758: and ppc1.current_flag = 'W')))
5759: -- AND ppr.as_of_date = pa_progress_utils.get_max_rollup_asofdate2(ppev.project_id,
5760: -- ppev.proj_element_id, ppev.object_type,'WORKPLAN',null, ppev.proj_element_id/* Bug 3764224 */)
5761: AND ppr.EFF_ROLLUP_PROG_STAT_CODE = pps1.project_status_code(+)
5762: AND ppr.progress_status_code = pps2.project_status_code(+)
5763: AND ppr.base_progress_status_code = pps3.project_status_code(+)

Line 5879: , pa_progress_utils.Get_BAC_Value(ppev.project_id, p_wp_rollup_method, ppev.proj_element_id, ppev.parent_structure_version_id, 'WORKPLAN') BAC_value

5875: , to_date(null) PROJ_COST_RATE_DATE
5876: , to_char(null) TXN_CURRENCY_CODE
5877: , to_char(null) PROG_PA_PERIOD_NAME
5878: , to_char(null) PROG_GL_PERIOD_NAME
5879: , pa_progress_utils.Get_BAC_Value(ppev.project_id, p_wp_rollup_method, ppev.proj_element_id, ppev.parent_structure_version_id, 'WORKPLAN') BAC_value
5880: , pa_progress_utils.Get_BAC_Value(ppev.project_id, p_wp_rollup_method, ppev.proj_element_id, ppev.parent_structure_version_id, 'WORKPLAN','N','N') BAC_value_self -- bug 4493105
5881: , null earned_value
5882: , to_number(null) Oth_quantity_to_date
5883: , to_number(null) Oth_etc_quantity

Line 5880: , pa_progress_utils.Get_BAC_Value(ppev.project_id, p_wp_rollup_method, ppev.proj_element_id, ppev.parent_structure_version_id, 'WORKPLAN','N','N') BAC_value_self -- bug 4493105

5876: , to_char(null) TXN_CURRENCY_CODE
5877: , to_char(null) PROG_PA_PERIOD_NAME
5878: , to_char(null) PROG_GL_PERIOD_NAME
5879: , pa_progress_utils.Get_BAC_Value(ppev.project_id, p_wp_rollup_method, ppev.proj_element_id, ppev.parent_structure_version_id, 'WORKPLAN') BAC_value
5880: , pa_progress_utils.Get_BAC_Value(ppev.project_id, p_wp_rollup_method, ppev.proj_element_id, ppev.parent_structure_version_id, 'WORKPLAN','N','N') BAC_value_self -- bug 4493105
5881: , null earned_value
5882: , to_number(null) Oth_quantity_to_date
5883: , to_number(null) Oth_etc_quantity
5884: -- 4533112 : Added base_progress_status_code

Line 5900: -- AND pa_progress_utils.get_max_rollup_asofdate2(ppev.project_id,

5896: AND structure_type = 'WORKPLAN'
5897: AND structure_version_id is null
5898: AND as_of_date <= p_as_of_date
5899: )
5900: -- AND pa_progress_utils.get_max_rollup_asofdate2(ppev.project_id,
5901: -- ppev.proj_element_id, ppev.object_type,'WORKPLAN',null, ppev.proj_element_id/* Bug 3764224 */) IS NULL
5902: -- Bug 3879461 End
5903: -- Begin fix for Bug # 4032987.
5904: -- This query returns the progress of immediate sub-tasks of the input task.

Line 6015: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, p_wp_rollup_method, ppev2.proj_element_id, ppev2.parent_structure_version_id, 'WORKPLAN') BAC_value

6011: , ppr.PROJ_COST_RATE_DATE
6012: , ppr.TXN_CURRENCY_CODE
6013: , ppr.PROG_PA_PERIOD_NAME
6014: , ppr.PROG_GL_PERIOD_NAME
6015: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, p_wp_rollup_method, ppev2.proj_element_id, ppev2.parent_structure_version_id, 'WORKPLAN') BAC_value
6016: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, p_wp_rollup_method, ppev2.proj_element_id, ppev2.parent_structure_version_id, 'WORKPLAN','N','N') BAC_value_self -- bug 4493105
6017: , null earned_value
6018: , ppr.Oth_quantity_to_date
6019: , ppr.Oth_etc_quantity

Line 6016: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, p_wp_rollup_method, ppev2.proj_element_id, ppev2.parent_structure_version_id, 'WORKPLAN','N','N') BAC_value_self -- bug 4493105

6012: , ppr.TXN_CURRENCY_CODE
6013: , ppr.PROG_PA_PERIOD_NAME
6014: , ppr.PROG_GL_PERIOD_NAME
6015: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, p_wp_rollup_method, ppev2.proj_element_id, ppev2.parent_structure_version_id, 'WORKPLAN') BAC_value
6016: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, p_wp_rollup_method, ppev2.proj_element_id, ppev2.parent_structure_version_id, 'WORKPLAN','N','N') BAC_value_self -- bug 4493105
6017: , null earned_value
6018: , ppr.Oth_quantity_to_date
6019: , ppr.Oth_etc_quantity
6020: -- 4533112 : Added base_progress_status_code

Line 6182: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, p_wp_rollup_method, ppev2.proj_element_id, ppev2.parent_structure_version_id, 'WORKPLAN') BAC_value

6178: , to_date(null) PROJ_COST_RATE_DATE
6179: , to_char(null) TXN_CURRENCY_CODE
6180: , to_char(null) PROG_PA_PERIOD_NAME
6181: , to_char(null) PROG_GL_PERIOD_NAME
6182: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, p_wp_rollup_method, ppev2.proj_element_id, ppev2.parent_structure_version_id, 'WORKPLAN') BAC_value
6183: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, p_wp_rollup_method, ppev2.proj_element_id, ppev2.parent_structure_version_id, 'WORKPLAN','N','N') BAC_value_self -- bug 4493105
6184: , null earned_value
6185: , to_number(null) Oth_quantity_to_date
6186: , to_number(null) Oth_etc_quantity

Line 6183: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, p_wp_rollup_method, ppev2.proj_element_id, ppev2.parent_structure_version_id, 'WORKPLAN','N','N') BAC_value_self -- bug 4493105

6179: , to_char(null) TXN_CURRENCY_CODE
6180: , to_char(null) PROG_PA_PERIOD_NAME
6181: , to_char(null) PROG_GL_PERIOD_NAME
6182: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, p_wp_rollup_method, ppev2.proj_element_id, ppev2.parent_structure_version_id, 'WORKPLAN') BAC_value
6183: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, p_wp_rollup_method, ppev2.proj_element_id, ppev2.parent_structure_version_id, 'WORKPLAN','N','N') BAC_value_self -- bug 4493105
6184: , null earned_value
6185: , to_number(null) Oth_quantity_to_date
6186: , to_number(null) Oth_etc_quantity
6187: -- 4533112 : Added base_progress_status_code

Line 6453: AND nvl(ppr.progress_rollup_id,-99) = pa_progress_utils.get_w_pub_prupid_asofdate(p_project_id,asgn.RESOURCE_LIST_MEMBER_ID,'PA_ASSIGNMENTS',asgn.task_id,p_as_of_date);

6449: -- It is to select only the rollup record till passed as of date
6450: AND ppr.structure_type(+) = 'WORKPLAN'
6451: AND ppr.structure_version_id(+) is null
6452: AND ppr.as_of_date(+) <= p_as_of_date
6453: AND nvl(ppr.progress_rollup_id,-99) = pa_progress_utils.get_w_pub_prupid_asofdate(p_project_id,asgn.RESOURCE_LIST_MEMBER_ID,'PA_ASSIGNMENTS',asgn.task_id,p_as_of_date);
6454:
6455: /* (SELECT nvl(max(progress_rollup_id),-99)
6456: FROM pa_progress_rollup
6457: WHERE project_id = p_project_id

Line 6477: -- AND ppr.as_of_date = pa_progress_utils.get_max_rollup_asofdate2(asgn.project_id,

6473: and ppc1.structure_type = 'WORKPLAN'
6474: and ppc1.as_of_date <= p_as_of_date
6475: and ppc1.structure_version_id is null
6476: and ppc1.current_flag = 'W'))))
6477: -- AND ppr.as_of_date = pa_progress_utils.get_max_rollup_asofdate2(asgn.project_id,
6478: -- asgn.RESOURCE_LIST_MEMBER_ID, 'PA_ASSIGNMENTS','WORKPLAN', null, asgn.task_id) ---Bug 3764224
6479: --bug 3958686, hidden assignments should not to be selected
6480: -- AND asgn.ta_display_flag = 'Y' -- Bug 4323537
6481: ; */

Line 6524: AND nvl(ppr.progress_rollup_id,-99) = pa_progress_utils.get_w_pub_prupid_asofdate(c_project_id,obj.object_id_to2,'PA_DELIVERABLES',obj.object_id_from2,p_as_of_date)

6520: AND ppr.object_type(+) = 'PA_DELIVERABLES'
6521: AND ppr.as_of_date(+) <= p_as_of_date
6522: -- Bug 3879461 : After discussion with Sameer Realeraskar, Majid
6523: -- It is to select only the rollup record till passed as of date
6524: AND nvl(ppr.progress_rollup_id,-99) = pa_progress_utils.get_w_pub_prupid_asofdate(c_project_id,obj.object_id_to2,'PA_DELIVERABLES',obj.object_id_from2,p_as_of_date)
6525: AND ppr.base_progress_status_code = pps3.project_status_code(+)
6526: AND ppr.progress_status_code = pps2.project_status_code(+);
6527:
6528: /* (SELECT nvl(max(progress_rollup_id),-99)

Line 6552: -- AND ppr.as_of_date(+) = pa_progress_utils.get_max_rollup_asofdate2(c_project_id,

6548: and ppc1.structure_type = 'WORKPLAN'
6549: and ppc1.as_of_date <= p_as_of_date
6550: and ppc1.structure_version_id is null
6551: and ppc1.current_flag = 'W'))))
6552: -- AND ppr.as_of_date(+) = pa_progress_utils.get_max_rollup_asofdate2(c_project_id,
6553: -- obj.object_id_to2, 'PA_DELIVERABLES','WORKPLAN', null, obj.object_id_from2 ) -- bug 3764224 Bug 3808044 : Changed to2 to from2
6554: AND ppr.structure_type(+) = 'WORKPLAN'
6555: AND ppr.structure_version_id(+) is null
6556: -- AND ppr.current_flag(+) = 'W' --bug 3879461

Line 6745: AND PA_PROGRESS_UTILS.get_system_task_status( status_code, 'PA_DELIVERABLES') = 'DLVR_IN_PROGRESS'

6741: AND task_id = p_task_id
6742: AND object_type = 'PA_DELIVERABLES'
6743: AND trunc(date_computed)<= trunc(p_as_of_date)
6744: AND structure_type = 'WORKPLAN'
6745: AND PA_PROGRESS_UTILS.get_system_task_status( status_code, 'PA_DELIVERABLES') = 'DLVR_IN_PROGRESS'
6746: );
6747:
6748: l_actual_exists VARCHAR2(1):='N';
6749: -- Bug 3922325 End

Line 6757: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,

6753: SELECT
6754: ppv2.project_id sub_project_id
6755: ,ppv2.element_version_id sub_structure_ver_id
6756: ,ppv2.proj_element_id sub_proj_element_id
6757: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,
6758: 'WORKPLAN','N') sub_project_bac_value
6759: FROM
6760: pa_proj_element_versions ppv2
6761: ,pa_proj_elem_ver_structure ppevs2

Line 7504: l_rollup_table1(l_index).EARNED_VALUE1 := pa_progress_utils.Get_BAC_Value(p_project_id

7500: IF cur_tasks_rec.object_id_to1 = nvl(l_subproj_task_version_id, -789)
7501: AND cur_tasks_rec.object_id_to1 = p_task_version_id
7502: THEN
7503:
7504: l_rollup_table1(l_index).EARNED_VALUE1 := pa_progress_utils.Get_BAC_Value(p_project_id
7505: , l_task_derivation_code, p_task_id, p_structure_version_id,
7506: 'WORKPLAN','N','Y');
7507: -- Bug 4636100 Issue 1 : We should always pass self plan for link task as 1
7508: --l_rollup_table1(l_index).EARNED_VALUE2 := NVL( cur_tasks_rec.BAC_VALUE_SELF, 0 );

Line 7624: AND pa_progress_utils.check_assignment_exists(p_project_id,p_task_version_id, 'PA_TASKS') = 'Y'

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
7628: IF cur_tasks_rec.object_type = 'PA_TASKS'

Line 8008: l_prog_pa_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date),null);

8004: END IF;
8005:
8006: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.UPDATE_ASGN_DLV_TO_TASK_ROLLUP_PVT', x_Msg => 'Getting Periods', x_Log_Level=> 3);
8007: BEGIN
8008: l_prog_pa_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date),null);
8009: l_prog_gl_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(p_as_of_date),null);
8010: EXCEPTION
8011: WHEN OTHERS THEN
8012: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 8009: l_prog_gl_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(p_as_of_date),null);

8005:
8006: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.UPDATE_ASGN_DLV_TO_TASK_ROLLUP_PVT', x_Msg => 'Getting Periods', x_Log_Level=> 3);
8007: BEGIN
8008: l_prog_pa_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date),null);
8009: l_prog_gl_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(p_as_of_date),null);
8010: EXCEPTION
8011: WHEN OTHERS THEN
8012: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
8013: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');

Line 8137: l_PROGRESS_ROLLUP_ID := PA_PROGRESS_UTILS.get_prog_rollup_id(

8133: l_rolled_up_base_prog_stat := l_cur_pa_rollup1_rec.base_progress_status_code;
8134:
8135: --Check whether there exists any rollup record for the task.
8136: --if exists then update otherwise create.
8137: l_PROGRESS_ROLLUP_ID := PA_PROGRESS_UTILS.get_prog_rollup_id(
8138: p_project_id => p_project_id
8139: ,p_object_id => p_task_id
8140: ,p_object_type => 'PA_TASKS'
8141: ,p_object_version_id => p_task_version_id

Line 8275: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' )

8271: UPDATE pa_percent_completes
8272: SET status_code = l_status_code
8273: WHERE object_id = p_task_id
8274: AND project_id = p_project_id
8275: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' )
8276: AND structure_type = 'WORKPLAN'
8277: AND current_flag = 'N' and published_flag = 'N';
8278:
8279: END IF;*/

Line 8322: --l_task_system_status_code := PA_PROGRESS_UTILS.get_system_task_status( l_existing_object_status ); Bug 3956299

8318: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.UPDATE_ROLLUP_PROGRESS_PVT', x_Msg => 'l_status_code ='||l_status_code, x_Log_Level=> 3);
8319: END IF; -- Bug 3956299 : Reduced scope of IF.
8320: -- Now Defaulting of Status will happen even if the status is returned by Scheuling API, but it is wrong
8321: --ELSE
8322: --l_task_system_status_code := PA_PROGRESS_UTILS.get_system_task_status( l_existing_object_status ); Bug 3956299
8323: l_task_system_status_code := PA_PROGRESS_UTILS.get_system_task_status( l_status_code ); -- Bug 3956299
8324:
8325: IF g1_debug_mode = 'Y' THEN
8326: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.UPDATE_ASGN_DLV_TO_TASK_ROLLUP_PVT', x_Msg => 'l_status_code='||l_status_code, x_Log_Level=> 3);

Line 8323: l_task_system_status_code := PA_PROGRESS_UTILS.get_system_task_status( l_status_code ); -- Bug 3956299

8319: END IF; -- Bug 3956299 : Reduced scope of IF.
8320: -- Now Defaulting of Status will happen even if the status is returned by Scheuling API, but it is wrong
8321: --ELSE
8322: --l_task_system_status_code := PA_PROGRESS_UTILS.get_system_task_status( l_existing_object_status ); Bug 3956299
8323: l_task_system_status_code := PA_PROGRESS_UTILS.get_system_task_status( l_status_code ); -- Bug 3956299
8324:
8325: IF g1_debug_mode = 'Y' THEN
8326: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.UPDATE_ASGN_DLV_TO_TASK_ROLLUP_PVT', x_Msg => 'l_status_code='||l_status_code, x_Log_Level=> 3);
8327: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.UPDATE_ASGN_DLV_TO_TASK_ROLLUP_PVT', x_Msg => 'l_existing_object_status='||l_existing_object_status, x_Log_Level=> 3);

Line 8404: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' )

8400: , actual_start_date = l_actual_start_date -- Bug 3956299
8401: , actual_finish_date = l_actual_finish_date -- Bug 3956299
8402: WHERE object_id = p_task_id
8403: AND project_id = p_project_id
8404: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' )
8405: AND structure_type = 'WORKPLAN'
8406: AND current_flag = 'N' and published_flag = 'N';
8407: END IF;
8408: -- Bug 3879461 End

Line 8531: IF l_rollup_table1(i).SUMMARY_OBJECT_FLAG = 'N' AND PA_PROGRESS_UTILS.check_assignment_exists(p_project_id, p_task_version_id, 'PA_TASKS') = 'N' THEN

8527: THEN
8528: /* Start of changes for bug 5675437*/
8529: -- For hidden assignment case, we need to get the actuals from submitted record rather than current working one
8530:
8531: IF l_rollup_table1(i).SUMMARY_OBJECT_FLAG = 'N' AND PA_PROGRESS_UTILS.check_assignment_exists(p_project_id, p_task_version_id, 'PA_TASKS') = 'N' THEN
8532:
8533: l_PROGRESS_ROLLUP_ID3 := PA_PROGRESS_UTILS.get_prog_rollup_id(
8534: p_project_id => p_project_id
8535: ,p_object_id => p_task_id

Line 8533: l_PROGRESS_ROLLUP_ID3 := PA_PROGRESS_UTILS.get_prog_rollup_id(

8529: -- For hidden assignment case, we need to get the actuals from submitted record rather than current working one
8530:
8531: IF l_rollup_table1(i).SUMMARY_OBJECT_FLAG = 'N' AND PA_PROGRESS_UTILS.check_assignment_exists(p_project_id, p_task_version_id, 'PA_TASKS') = 'N' THEN
8532:
8533: l_PROGRESS_ROLLUP_ID3 := PA_PROGRESS_UTILS.get_prog_rollup_id(
8534: p_project_id => p_project_id
8535: ,p_object_id => p_task_id
8536: ,p_object_type => 'PA_TASKS'
8537: ,p_object_version_id => p_task_version_id

Line 8722: l_progress_exists_on_aod := PA_PROGRESS_UTILS.check_prog_exists_on_aod(

8718:
8719: --update progress_outdated_flag for summary tasks if there exists any ppc record
8720: --for the summary task
8721:
8722: l_progress_exists_on_aod := PA_PROGRESS_UTILS.check_prog_exists_on_aod(
8723: p_task_id => p_task_id
8724: ,p_object_id => p_task_id -- Bug 3764224
8725: ,p_as_of_date => p_as_of_date
8726: ,p_project_id => p_project_id

Line 8765: l_max_rollup_as_of_date2 := PA_PROGRESS_UTILS.get_max_rollup_asofdate2

8761: END;
8762:
8763: -- Bug 3879461 Begin : Code Not Required now
8764: /*
8765: l_max_rollup_as_of_date2 := PA_PROGRESS_UTILS.get_max_rollup_asofdate2
8766: (p_project_id => p_project_id,
8767: p_object_id => p_task_id,
8768: p_object_type => l_rollup_table1(i).object_type,
8769: p_structure_type => 'WORKPLAN',

Line 8932: l_progress_exists_on_aod := PA_PROGRESS_UTILS.check_prog_exists_on_aod(

8928:
8929: --update progress_outdated_flag for summary tasks if there exists any ppc record
8930: --for the summary task
8931:
8932: l_progress_exists_on_aod := PA_PROGRESS_UTILS.check_prog_exists_on_aod(
8933: p_task_id => p_task_id
8934: ,p_object_id => p_task_id -- Bug 3764224
8935: ,p_as_of_date => p_as_of_date
8936: ,p_project_id => p_project_id

Line 10079: AND 'Y' = PA_PROGRESS_UTILS.check_object_has_prog(

10075: AND target.resource_list_member_id =
10076: decode(l_res_list_mismatch_flag, 'N', source.resource_list_member_id,
10077: l_target_people_rlm_id)
10078: --bug 3956258
10079: AND 'Y' = PA_PROGRESS_UTILS.check_object_has_prog(
10080: source.project_id --p_project_id
10081: ,source.task_id --p_proj_element_id
10082: -- ,decode( source.ta_display_flag, 'N', source.task_id,source.resource_list_member_id) --p_object_id -- Fix for Bug # 4112283.
10083: ,source.resource_list_member_id -- Fix for Bug # 4112283.

Line 10858: AND PA_PROGRESS_UTILS.get_system_task_status( status_code, 'PA_DELIVERABLES') = 'DLVR_IN_PROGRESS'

10854: AND object_type = 'PA_DELIVERABLES'
10855: AND trunc(date_computed)<= trunc(p_as_of_date)
10856: AND structure_type = 'WORKPLAN'
10857: AND published_flag = 'Y'
10858: AND PA_PROGRESS_UTILS.get_system_task_status( status_code, 'PA_DELIVERABLES') = 'DLVR_IN_PROGRESS'
10859: );
10860:
10861:
10862: CURSOR c_get_object_status (l_project_id NUMBER, l_proj_element_id NUMBER)

Line 10964: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag) BAC_value

10960: , ppr.PROJ_COST_RATE_DATE
10961: , ppr.TXN_CURRENCY_CODE
10962: , ppr.PROG_PA_PERIOD_NAME
10963: , ppr.PROG_GL_PERIOD_NAME
10964: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag) BAC_value
10965: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag,'N')
10966: BAC_value_self -- bug 4493105
10967: , null earned_value
10968: , to_char(null) task_derivation_method

Line 10965: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag,'N')

10961: , ppr.TXN_CURRENCY_CODE
10962: , ppr.PROG_PA_PERIOD_NAME
10963: , ppr.PROG_GL_PERIOD_NAME
10964: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag) BAC_value
10965: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag,'N')
10966: BAC_value_self -- bug 4493105
10967: , null earned_value
10968: , to_char(null) task_derivation_method
10969: , ppr.progress_rollup_id

Line 10999: AND ppr.as_of_date = pa_progress_utils.get_max_rollup_asofdate(ppev.project_id,

10995: AND ppev.object_type = 'PA_STRUCTURES'
10996: AND ppr.project_id = ppev.project_id
10997: AND ppr.object_id = ppev.proj_element_id
10998: AND ppr.object_type = 'PA_STRUCTURES'
10999: AND ppr.as_of_date = pa_progress_utils.get_max_rollup_asofdate(ppev.project_id,
11000: ppev.proj_element_id, ppev.object_type,p_as_of_date, ppev.element_version_id, p_structure_type, l_structure_version_id, ppev.proj_element_id/* Bug 3764224 */) -- FPM Dev CR 3
11001: AND ppr.current_flag <> 'W'
11002: AND ppr.EFF_ROLLUP_PROG_STAT_CODE = pps1.project_status_code(+)
11003: AND ppr.progress_status_code = pps2.project_status_code(+)

Line 11082: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,

11078: , ppr.PROJ_COST_RATE_DATE
11079: , ppr.TXN_CURRENCY_CODE
11080: , ppr.PROG_PA_PERIOD_NAME
11081: , ppr.PROG_GL_PERIOD_NAME
11082: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,
11083: 'FINANCIAL',p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,
11084: p_structure_type,p_working_wp_prog_flag) BAC_value
11085: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,
11086: 'FINANCIAL',p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,

Line 11085: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,

11081: , ppr.PROG_GL_PERIOD_NAME
11082: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,
11083: 'FINANCIAL',p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,
11084: p_structure_type,p_working_wp_prog_flag) BAC_value
11085: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,
11086: 'FINANCIAL',p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,
11087: p_structure_type,p_working_wp_prog_flag,'N') BAC_value_self -- bug 4493105
11088: , null earned_value
11089: , decode(ppe.base_percent_comp_deriv_code, null, ttype.base_percent_comp_deriv_code,'^',ttype.base_percent_comp_deriv_code,ppe.base_percent_comp_deriv_code) task_derivation_method

Line 11126: AND ppr.as_of_date = pa_progress_utils.get_max_rollup_asofdate(ppev2.project_id,

11122: AND pobj.object_id_from1 = ppev1.element_version_id
11123: AND pobj.object_id_to1 = ppev2.element_version_id
11124: AND pobj.relationship_type = 'S'
11125: AND ppr.project_id = ppev2.project_id
11126: AND ppr.as_of_date = pa_progress_utils.get_max_rollup_asofdate(ppev2.project_id,
11127: ppev2.proj_element_id, ppev2.object_type,p_as_of_date, ppev2.element_version_id, p_structure_type, l_structure_version_id, ppev2.proj_element_id/*Bug 3764224 */) -- FPM Dev CR 3
11128: AND ppr.current_flag <> 'W'
11129: AND ppr.object_id = ppev2.proj_element_id
11130: AND ppr.project_id = ppev2.project_id

Line 11222: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag) BAC_value

11218: , to_date(null) PROJ_COST_RATE_DATE
11219: , to_char(null) TXN_CURRENCY_CODE
11220: , to_char(null) PROG_PA_PERIOD_NAME
11221: , to_char(null) PROG_GL_PERIOD_NAME
11222: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag) BAC_value
11223: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag,'N')
11224: BAC_value_self -- bug 4493105
11225: , null earned_value
11226: , to_char(null) task_derivation_method

Line 11223: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag,'N')

11219: , to_char(null) TXN_CURRENCY_CODE
11220: , to_char(null) PROG_PA_PERIOD_NAME
11221: , to_char(null) PROG_GL_PERIOD_NAME
11222: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag) BAC_value
11223: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag,'N')
11224: BAC_value_self -- bug 4493105
11225: , null earned_value
11226: , to_char(null) task_derivation_method
11227: , to_number(null) progress_rollup_id

Line 11248: AND pa_progress_utils.get_max_rollup_asofdate(ppev.project_id,

11244: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
11245: element_version_id = temp.object_id
11246: AND temp.process_number = l_process_number_temp
11247: AND ppev.object_type = 'PA_STRUCTURES'
11248: AND pa_progress_utils.get_max_rollup_asofdate(ppev.project_id,
11249: ppev.proj_element_id, ppev.object_type,p_as_of_date, ppev.element_version_id, p_structure_type, l_structure_version_id, ppev.proj_element_id/*Bug 3764224 */)
11250: IS NULL
11251: AND temp.object_type = 'PA_TASKS' -- cklee bug: 6610612
11252: UNION

Line 11326: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',

11322: , to_date(null) PROJ_COST_RATE_DATE
11323: , to_char(null) TXN_CURRENCY_CODE
11324: , to_char(null) PROG_PA_PERIOD_NAME
11325: , to_char(null) PROG_GL_PERIOD_NAME
11326: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',
11327: p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,
11328: p_structure_type,p_working_wp_prog_flag) BAC_value
11329: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',
11330: p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,

Line 11329: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',

11325: , to_char(null) PROG_GL_PERIOD_NAME
11326: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',
11327: p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,
11328: p_structure_type,p_working_wp_prog_flag) BAC_value
11329: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',
11330: p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,
11331: p_structure_type,p_working_wp_prog_flag,'N') BAC_value_self -- bug 4493105
11332: , null earned_value
11333: , decode(ppe.base_percent_comp_deriv_code, null, ttype.base_percent_comp_deriv_code,'^',ttype.base_percent_comp_deriv_code,ppe.base_percent_comp_deriv_code) task_derivation_method

Line 11374: AND pa_progress_utils.get_max_rollup_asofdate(ppev2.project_id,

11370: AND ppe.link_task_flag <> 'Y' -- 4392189
11371: AND pobj.object_type_to = 'PA_TASKS'
11372: AND pobj.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
11373: AND ppe.type_id = ttype.task_type_id
11374: AND pa_progress_utils.get_max_rollup_asofdate(ppev2.project_id,
11375: ppev2.proj_element_id, ppev2.object_type,p_as_of_date, ppev2.element_version_id, p_structure_type, l_structure_version_id, ppev2.proj_element_id/*Bug 3764224 */)
11376: IS NULL
11377: AND ( (ppev2.financial_task_flag = 'Y' AND p_structure_type = 'FINANCIAL') OR p_structure_type = 'WORKPLAN') -- Bug 4346483
11378: AND temp.object_type = 'PA_TASKS' -- cklee bug: 6610612

Line 11479: AND ppr.as_of_date(+) = pa_progress_utils.get_max_rollup_asofdate(c_project_id,

11475: -- AND obj.object_id_to1 = ppr.object_version_id(+)
11476: AND ppr.object_type(+) = 'PA_DELIVERABLES'
11477: AND ppr.project_id(+) = c_project_id
11478: AND ppr.object_id(+) = obj.object_id_to2
11479: AND ppr.as_of_date(+) = pa_progress_utils.get_max_rollup_asofdate(c_project_id,
11480: obj.object_id_to2, 'PA_DELIVERABLES',p_as_of_date,obj.object_id_to1, p_structure_type, l_structure_version_id, obj.object_id_from2 /* Bug 3764224 */) -- FPM Dev CR 3
11481: AND ppr.structure_type(+) = p_structure_type
11482: AND ppr.structure_version_id is null -- deliverable progress for working version is not allowed
11483: AND ppr.base_progress_status_code = pps3.project_status_code(+)

Line 11586: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,

11582: SELECT
11583: ppv2.project_id sub_project_id
11584: ,ppv2.element_version_id sub_structure_ver_id
11585: ,ppv2.proj_element_id sub_proj_element_id
11586: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,
11587: 'WORKPLAN','N') sub_project_bac_value
11588: FROM
11589: pa_proj_element_versions ppv2
11590: ,pa_proj_elem_ver_structure ppevs2

Line 12368: AND (PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, l_tsk_proj_element_id_tab(k))) <> 'CANCELLED')

12364: END IF;
12365:
12366: -- Bug 3957792 : Added check for Cancelled tasks
12367: IF p_structure_type = 'WORKPLAN' AND l_published_structure = 'Y' AND l_tsk_deriv_method_tab(k) = 'DELIVERABLE'
12368: AND (PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, l_tsk_proj_element_id_tab(k))) <> 'CANCELLED')
12369: THEN
12370: FOR cur_del_rec in cur_deliverables(l_tsk_proj_element_id_tab(k), l_tsk_object_id_to1_tab(k), p_project_id) LOOP -- FPM Change
12371: IF g1_debug_mode = 'Y' THEN
12372: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg => 'cur_del_rec.object_id_to1='||cur_del_rec.object_id_to1, x_Log_Level=> 3);

Line 12543: l_rollup_table1(l_index).EARNED_VALUE1 := pa_progress_utils.Get_BAC_Value(p_project_id

12539: -- 4586449 Begin : For link tasks, pass BAC_VALUE in terms of derivation method of the task
12540: -- in earned_value1 set
12541: IF p_structure_type = 'WORKPLAN' AND l_tsk_object_id_to1_tab(k) = nvl(l_subproj_task_version_id, -789) THEN
12542:
12543: l_rollup_table1(l_index).EARNED_VALUE1 := pa_progress_utils.Get_BAC_Value(p_project_id
12544: , l_tsk_deriv_method_tab(k), l_tsk_proj_element_id_tab(k), p_structure_version_id,
12545: 'WORKPLAN','N','Y');
12546: -- Bug 4636100 Issue 1 : We should always pass self plan for link task as 1
12547: --l_rollup_table1(l_index).EARNED_VALUE2 := NVL( l_tsk_bac_self_value_tab(k), 0 );

Line 12624: AND pa_progress_utils.check_assignment_exists(p_project_id,p_task_version_id, 'PA_TASKS') = 'Y'

12620: END LOOP; -- End Tasks Loop
12621:
12622: --begin bug 3951982
12623: IF p_lowest_level_task = 'N' AND p_rollup_entire_wbs = 'N'
12624: AND pa_progress_utils.check_assignment_exists(p_project_id,p_task_version_id, 'PA_TASKS') = 'Y'
12625: AND l_actual_lowest_task = 'N' -- Bug 4392189
12626: THEN
12627: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
12628: SELECT l_process_number_temp, p_task_version_id, 'PA_TASKS', 1

Line 12974: l_prog_pa_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date,l_org_id),null);

12970: END IF;
12971:
12972: BEGIN
12973: -- 4746476 : Added org_id in functions call below
12974: l_prog_pa_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date,l_org_id),null);
12975: l_prog_gl_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(p_as_of_date,l_org_id),null);
12976: EXCEPTION
12977: WHEN OTHERS THEN
12978: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 12975: l_prog_gl_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(p_as_of_date,l_org_id),null);

12971:
12972: BEGIN
12973: -- 4746476 : Added org_id in functions call below
12974: l_prog_pa_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date,l_org_id),null);
12975: l_prog_gl_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(p_as_of_date,l_org_id),null);
12976: EXCEPTION
12977: WHEN OTHERS THEN
12978: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
12979: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');

Line 13376: l_system_status_code := PA_PROGRESS_UTILS.get_system_task_status( l_status_code ); --Bug#5374114

13372: FETCH c_get_object_status INTO l_existing_object_status;
13373: CLOSE c_get_object_status;
13374:
13375: l_status_code := l_existing_object_status;
13376: l_system_status_code := PA_PROGRESS_UTILS.get_system_task_status( l_status_code ); --Bug#5374114
13377: l_status_code_temp := l_status_code; --Bug#5374114
13378: l_system_status_code_temp := l_system_status_code; --Bug#5374114
13379:
13380: IF ( nvl(l_rollup_table1(i).task_status1,0) <> 0)

Line 13389: l_system_status_code := PA_PROGRESS_UTILS.get_system_task_status( l_status_code ); -- Bug 3956299

13385: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg => 'l_status_code ='||l_status_code, x_Log_Level=> 3);
13386: END IF;
13387: -- Now Defaulting of Status will happen even if the status is returned by Scheuling API, but it is wrong
13388:
13389: l_system_status_code := PA_PROGRESS_UTILS.get_system_task_status( l_status_code ); -- Bug 3956299
13390: IF g1_debug_mode = 'Y' THEN
13391: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg => 'l_status_code='||l_status_code, x_Log_Level=> 3);
13392: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg => 'l_existing_object_status='||l_existing_object_status, x_Log_Level=> 3);
13393: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg => 'l_system_status_code='||l_system_status_code, x_Log_Level=> 3);

Line 13472: --AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED', 'COMPLETED' )

13468: , actual_finish_date = l_actual_finish_date -- Bug 3956299
13469: WHERE object_id = cur_reverse_tree_rec.proj_element_id
13470: AND object_Type = cur_reverse_tree_rec.object_Type ---4743866
13471: AND project_id = p_project_id
13472: --AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED', 'COMPLETED' )
13473: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' ) -- 02/06/04 Satish
13474: AND structure_type = p_structure_type -- FPM Dev CR 3
13475: AND current_flag = 'N' and published_flag = 'N';
13476:

Line 13473: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' ) -- 02/06/04 Satish

13469: WHERE object_id = cur_reverse_tree_rec.proj_element_id
13470: AND object_Type = cur_reverse_tree_rec.object_Type ---4743866
13471: AND project_id = p_project_id
13472: --AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED', 'COMPLETED' )
13473: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' ) -- 02/06/04 Satish
13474: AND structure_type = p_structure_type -- FPM Dev CR 3
13475: AND current_flag = 'N' and published_flag = 'N';
13476:
13477: -- 14-Feb-2005 : Added Patched thru Bug 4180026

Line 13485: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' ) -- 02/06/04 Satish

13481: , actual_finish_date = l_actual_finish_date -- Bug 3956299
13482: WHERE object_id = cur_reverse_tree_rec.proj_element_id
13483: AND object_Type = cur_reverse_tree_rec.object_Type ---4743866
13484: AND project_id = p_project_id
13485: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' ) -- 02/06/04 Satish
13486: AND structure_type = p_structure_type -- FPM Dev CR 3
13487: AND published_flag = 'Y' ---4743866
13488: AND current_flag = 'Y'
13489: AND trunc(date_computed) = trunc(p_as_of_date);

Line 13679: l_max_rollup_as_of_date2 := PA_PROGRESS_UTILS.get_max_rollup_asofdate2

13675: AND date_computed <= p_as_of_date);
13676: EXCEPTION WHEN OTHERS THEN
13677: l_percent_complete_id := null;
13678: END;
13679: l_max_rollup_as_of_date2 := PA_PROGRESS_UTILS.get_max_rollup_asofdate2
13680: (p_project_id => p_project_id,
13681: p_object_id => cur_reverse_tree_rec.proj_element_id,
13682: p_object_type => l_rollup_table1(i).object_type,
13683: p_structure_type => p_structure_type,

Line 14418: AND PA_PROGRESS_UTILS.get_system_task_status( status_code, 'PA_DELIVERABLES') = 'DLVR_IN_PROGRESS'

14414: AND object_type = 'PA_DELIVERABLES'
14415: AND trunc(date_computed)<= trunc(p_as_of_date)
14416: AND structure_type = 'WORKPLAN'
14417: AND published_flag = 'Y'
14418: AND PA_PROGRESS_UTILS.get_system_task_status( status_code, 'PA_DELIVERABLES') = 'DLVR_IN_PROGRESS'
14419: );
14420:
14421:
14422: CURSOR c_get_object_status (l_project_id NUMBER, l_proj_element_id NUMBER)

Line 14524: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag) BAC_value

14520: , ppr.PROJ_COST_RATE_DATE
14521: , ppr.TXN_CURRENCY_CODE
14522: , ppr.PROG_PA_PERIOD_NAME
14523: , ppr.PROG_GL_PERIOD_NAME
14524: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag) BAC_value
14525: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag,'N')
14526: BAC_value_self -- bug 4493105
14527: , null earned_value
14528: , to_char(null) task_derivation_method

Line 14525: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag,'N')

14521: , ppr.TXN_CURRENCY_CODE
14522: , ppr.PROG_PA_PERIOD_NAME
14523: , ppr.PROG_GL_PERIOD_NAME
14524: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag) BAC_value
14525: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag,'N')
14526: BAC_value_self -- bug 4493105
14527: , null earned_value
14528: , to_char(null) task_derivation_method
14529: , ppr.progress_rollup_id

Line 14559: AND ppr.as_of_date = pa_progress_utils.get_max_rollup_asofdate(ppev.project_id,

14555: AND ppev.object_type = 'PA_STRUCTURES'
14556: AND ppr.project_id = ppev.project_id
14557: AND ppr.object_id = ppev.proj_element_id
14558: AND ppr.object_type = 'PA_STRUCTURES'
14559: AND ppr.as_of_date = pa_progress_utils.get_max_rollup_asofdate(ppev.project_id,
14560: ppev.proj_element_id, ppev.object_type,p_as_of_date, ppev.element_version_id, p_structure_type, l_structure_version_id, ppev.proj_element_id/* Bug 3764224 */) -- FPM Dev CR 3
14561: AND ppr.current_flag <> 'W'
14562: AND ppr.EFF_ROLLUP_PROG_STAT_CODE = pps1.project_status_code(+)
14563: AND ppr.progress_status_code = pps2.project_status_code(+)

Line 14642: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,

14638: , ppr.PROJ_COST_RATE_DATE
14639: , ppr.TXN_CURRENCY_CODE
14640: , ppr.PROG_PA_PERIOD_NAME
14641: , ppr.PROG_GL_PERIOD_NAME
14642: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,
14643: 'FINANCIAL',p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,
14644: p_structure_type,p_working_wp_prog_flag) BAC_value
14645: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,
14646: 'FINANCIAL',p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,

Line 14645: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,

14641: , ppr.PROG_GL_PERIOD_NAME
14642: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,
14643: 'FINANCIAL',p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,
14644: p_structure_type,p_working_wp_prog_flag) BAC_value
14645: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,
14646: 'FINANCIAL',p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,
14647: p_structure_type,p_working_wp_prog_flag,'N') BAC_value_self -- bug 4493105
14648: , null earned_value
14649: , decode(ppe.base_percent_comp_deriv_code, null, ttype.base_percent_comp_deriv_code,'^',ttype.base_percent_comp_deriv_code,ppe.base_percent_comp_deriv_code) task_derivation_method

Line 14686: AND ppr.as_of_date = pa_progress_utils.get_max_rollup_asofdate(ppev2.project_id,

14682: AND pobj.object_id_from1 = ppev1.element_version_id
14683: AND pobj.object_id_to1 = ppev2.element_version_id
14684: AND pobj.relationship_type = 'S'
14685: AND ppr.project_id = ppev2.project_id
14686: AND ppr.as_of_date = pa_progress_utils.get_max_rollup_asofdate(ppev2.project_id,
14687: ppev2.proj_element_id, ppev2.object_type,p_as_of_date, ppev2.element_version_id, p_structure_type, l_structure_version_id, ppev2.proj_element_id/*Bug 3764224 */) -- FPM Dev CR 3
14688: AND ppr.current_flag <> 'W'
14689: AND ppr.object_id = ppev2.proj_element_id
14690: AND ppr.project_id = ppev2.project_id

Line 14782: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag) BAC_value

14778: , to_date(null) PROJ_COST_RATE_DATE
14779: , to_char(null) TXN_CURRENCY_CODE
14780: , to_char(null) PROG_PA_PERIOD_NAME
14781: , to_char(null) PROG_GL_PERIOD_NAME
14782: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag) BAC_value
14783: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag,'N')
14784: BAC_value_self -- bug 4493105
14785: , null earned_value
14786: , to_char(null) task_derivation_method

Line 14783: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag,'N')

14779: , to_char(null) TXN_CURRENCY_CODE
14780: , to_char(null) PROG_PA_PERIOD_NAME
14781: , to_char(null) PROG_GL_PERIOD_NAME
14782: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag) BAC_value
14783: , pa_progress_utils.Get_BAC_Value(ppev.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',p_fin_rollup_method), ppev.proj_element_id, ppev.element_version_id, p_structure_type,p_working_wp_prog_flag,'N')
14784: BAC_value_self -- bug 4493105
14785: , null earned_value
14786: , to_char(null) task_derivation_method
14787: , to_number(null) progress_rollup_id

Line 14808: AND pa_progress_utils.get_max_rollup_asofdate(ppev.project_id,

14804: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
14805: element_version_id = temp.object_id
14806: AND temp.process_number = l_process_number_temp
14807: AND ppev.object_type = 'PA_STRUCTURES'
14808: AND pa_progress_utils.get_max_rollup_asofdate(ppev.project_id,
14809: ppev.proj_element_id, ppev.object_type,p_as_of_date, ppev.element_version_id, p_structure_type, l_structure_version_id, ppev.proj_element_id/*Bug 3764224 */)
14810: IS NULL
14811: AND temp.object_type = 'PA_TASKS' -- cklee bug: 6610612
14812: UNION

Line 14886: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',

14882: , to_date(null) PROJ_COST_RATE_DATE
14883: , to_char(null) TXN_CURRENCY_CODE
14884: , to_char(null) PROG_PA_PERIOD_NAME
14885: , to_char(null) PROG_GL_PERIOD_NAME
14886: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',
14887: p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,
14888: p_structure_type,p_working_wp_prog_flag) BAC_value
14889: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',
14890: p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,

Line 14889: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',

14885: , to_char(null) PROG_GL_PERIOD_NAME
14886: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',
14887: p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,
14888: p_structure_type,p_working_wp_prog_flag) BAC_value
14889: , pa_progress_utils.Get_BAC_Value(ppev2.project_id, decode(p_structure_type,'WORKPLAN',p_wp_rollup_method,'FINANCIAL',
14890: p_fin_rollup_method), ppev2.proj_element_id, ppev2.parent_structure_version_id,
14891: p_structure_type,p_working_wp_prog_flag,'N') BAC_value_self -- bug 4493105
14892: , null earned_value
14893: , decode(ppe.base_percent_comp_deriv_code, null, ttype.base_percent_comp_deriv_code,'^',ttype.base_percent_comp_deriv_code,ppe.base_percent_comp_deriv_code) task_derivation_method

Line 14934: AND pa_progress_utils.get_max_rollup_asofdate(ppev2.project_id,

14930: AND ppe.link_task_flag <> 'Y' -- 4392189
14931: AND pobj.object_type_to = 'PA_TASKS'
14932: AND pobj.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
14933: AND ppe.type_id = ttype.task_type_id
14934: AND pa_progress_utils.get_max_rollup_asofdate(ppev2.project_id,
14935: ppev2.proj_element_id, ppev2.object_type,p_as_of_date, ppev2.element_version_id, p_structure_type, l_structure_version_id, ppev2.proj_element_id/*Bug 3764224 */)
14936: IS NULL
14937: AND ( (ppev2.financial_task_flag = 'Y' AND p_structure_type = 'FINANCIAL') OR p_structure_type = 'WORKPLAN') -- Bug 4346483
14938: AND temp.object_type = 'PA_TASKS' -- cklee bug: 6610612

Line 15040: AND ppr.as_of_date(+) = pa_progress_utils.get_max_rollup_asofdate(c_project_id,

15036: -- AND obj.object_id_to1 = ppr.object_version_id(+)
15037: AND ppr.object_type(+) = 'PA_DELIVERABLES'
15038: AND ppr.project_id(+) = c_project_id
15039: AND ppr.object_id(+) = obj.object_id_to2
15040: AND ppr.as_of_date(+) = pa_progress_utils.get_max_rollup_asofdate(c_project_id,
15041: obj.object_id_to2, 'PA_DELIVERABLES',p_as_of_date,obj.object_id_to1, p_structure_type, l_structure_version_id, obj.object_id_from2 /* Bug 3764224 */) -- FPM Dev CR 3
15042: AND ppr.structure_type(+) = p_structure_type
15043: AND ppr.structure_version_id is null -- deliverable progress for working version is not allowed
15044: AND ppr.base_progress_status_code = pps3.project_status_code(+)

Line 15147: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,

15143: SELECT
15144: ppv2.project_id sub_project_id
15145: ,ppv2.element_version_id sub_structure_ver_id
15146: ,ppv2.proj_element_id sub_proj_element_id
15147: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,
15148: 'WORKPLAN','N') sub_project_bac_value
15149: FROM
15150: pa_proj_element_versions ppv2
15151: ,pa_proj_elem_ver_structure ppevs2

Line 15954: AND (PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, l_tsk_proj_element_id_tab(k))) <> 'CANCELLED')

15950: END IF;
15951:
15952: -- Bug 3957792 : Added check for Cancelled tasks
15953: IF p_structure_type = 'WORKPLAN' AND l_published_structure = 'Y' AND l_tsk_deriv_method_tab(k) = 'DELIVERABLE'
15954: AND (PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, l_tsk_proj_element_id_tab(k))) <> 'CANCELLED')
15955: THEN
15956: FOR cur_del_rec in cur_deliverables(l_tsk_proj_element_id_tab(k), l_tsk_object_id_to1_tab(k), p_project_id) LOOP -- FPM Change
15957: IF g1_debug_mode = 'Y' THEN
15958: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg => 'cur_del_rec.object_id_to1='||cur_del_rec.object_id_to1, x_Log_Level=> 3);

Line 16129: l_rollup_table1(l_index).EARNED_VALUE1 := pa_progress_utils.Get_BAC_Value(p_project_id

16125: -- 4586449 Begin : For link tasks, pass BAC_VALUE in terms of derivation method of the task
16126: -- in earned_value1 set
16127: IF p_structure_type = 'WORKPLAN' AND l_tsk_object_id_to1_tab(k) = nvl(l_subproj_task_version_id, -789) THEN
16128:
16129: l_rollup_table1(l_index).EARNED_VALUE1 := pa_progress_utils.Get_BAC_Value(p_project_id
16130: , l_tsk_deriv_method_tab(k), l_tsk_proj_element_id_tab(k), p_structure_version_id,
16131: 'WORKPLAN','N','Y');
16132: -- Bug 4636100 Issue 1 : We should always pass self plan for link task as 1
16133: --l_rollup_table1(l_index).EARNED_VALUE2 := NVL( l_tsk_bac_self_value_tab(k), 0 );

Line 16211: AND pa_progress_utils.check_assignment_exists(p_project_id,p_task_version_id, 'PA_TASKS') = 'Y'

16207: END LOOP; -- End Tasks Loop
16208:
16209: --begin bug 3951982
16210: IF p_lowest_level_task = 'N' AND p_rollup_entire_wbs = 'N'
16211: AND pa_progress_utils.check_assignment_exists(p_project_id,p_task_version_id, 'PA_TASKS') = 'Y'
16212: AND l_actual_lowest_task = 'N' -- Bug 4392189
16213: THEN
16214: INSERT INTO pa_proj_rollup_temp(process_number, object_id, object_type, wbs_level)
16215: SELECT l_process_number_temp, p_task_version_id, 'PA_TASKS', 1

Line 16561: l_prog_pa_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date,l_org_id),null);

16557: END IF;
16558:
16559: BEGIN
16560: -- 4746476 : Added org_id in functions call below
16561: l_prog_pa_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date,l_org_id),null);
16562: l_prog_gl_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(p_as_of_date,l_org_id),null);
16563: EXCEPTION
16564: WHEN OTHERS THEN
16565: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 16562: l_prog_gl_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(p_as_of_date,l_org_id),null);

16558:
16559: BEGIN
16560: -- 4746476 : Added org_id in functions call below
16561: l_prog_pa_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date,l_org_id),null);
16562: l_prog_gl_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(p_as_of_date,l_org_id),null);
16563: EXCEPTION
16564: WHEN OTHERS THEN
16565: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
16566: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');

Line 16991: l_system_status_code := PA_PROGRESS_UTILS.get_system_task_status( l_status_code ); --Bug#5374114

16987: FETCH c_get_object_status INTO l_existing_object_status;
16988: CLOSE c_get_object_status;
16989:
16990: l_status_code := l_existing_object_status;
16991: l_system_status_code := PA_PROGRESS_UTILS.get_system_task_status( l_status_code ); --Bug#5374114
16992: l_status_code_temp := l_status_code; --Bug#5374114
16993: l_system_status_code_temp := l_system_status_code; --Bug#5374114
16994:
16995: IF ( nvl(l_rollup_table1(i).task_status1,0) <> 0)

Line 17004: l_system_status_code := PA_PROGRESS_UTILS.get_system_task_status( l_status_code ); -- Bug 3956299

17000: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg => 'l_status_code ='||l_status_code, x_Log_Level=> 3);
17001: END IF;
17002: -- Now Defaulting of Status will happen even if the status is returned by Scheuling API, but it is wrong
17003:
17004: l_system_status_code := PA_PROGRESS_UTILS.get_system_task_status( l_status_code ); -- Bug 3956299
17005: IF g1_debug_mode = 'Y' THEN
17006: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg => 'l_status_code='||l_status_code, x_Log_Level=> 3);
17007: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg => 'l_existing_object_status='||l_existing_object_status, x_Log_Level=> 3);
17008: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg => 'l_system_status_code='||l_system_status_code, x_Log_Level=> 3);

Line 17093: --AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED', 'COMPLETED' )

17089: */
17090: WHERE object_id = l_defer_arr_task_id(l_rollup_table1(i).object_id) -- sridhar_rollup
17091: AND object_Type = l_rollup_table1(i).object_Type -- sridhar_rollup
17092: AND project_id = p_project_id
17093: --AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED', 'COMPLETED' )
17094: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' ) -- 02/06/04 Satish
17095: AND structure_type = p_structure_type -- FPM Dev CR 3
17096: AND current_flag = 'N' and published_flag = 'N';
17097:

Line 17094: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' ) -- 02/06/04 Satish

17090: WHERE object_id = l_defer_arr_task_id(l_rollup_table1(i).object_id) -- sridhar_rollup
17091: AND object_Type = l_rollup_table1(i).object_Type -- sridhar_rollup
17092: AND project_id = p_project_id
17093: --AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED', 'COMPLETED' )
17094: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' ) -- 02/06/04 Satish
17095: AND structure_type = p_structure_type -- FPM Dev CR 3
17096: AND current_flag = 'N' and published_flag = 'N';
17097:
17098: -- 14-Feb-2005 : Added Patched thru Bug 4180026

Line 17106: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' ) -- 02/06/04 Satish

17102: , actual_finish_date = l_actual_finish_date -- Bug 3956299
17103: WHERE object_id = l_defer_arr_task_id(l_rollup_table1(i).object_id) -- sridhar_rollup
17104: AND object_Type = l_rollup_table1(i).object_Type ---4743866 -- sridhar_rollup
17105: AND project_id = p_project_id
17106: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' ) -- 02/06/04 Satish
17107: AND structure_type = p_structure_type -- FPM Dev CR 3
17108: AND published_flag = 'Y' ---4743866
17109: AND current_flag = 'Y'
17110: AND trunc(date_computed) = trunc(p_as_of_date);

Line 17300: l_max_rollup_as_of_date2 := PA_PROGRESS_UTILS.get_max_rollup_asofdate2

17296: AND date_computed <= p_as_of_date);
17297: EXCEPTION WHEN OTHERS THEN
17298: l_percent_complete_id := null;
17299: END;
17300: l_max_rollup_as_of_date2 := PA_PROGRESS_UTILS.get_max_rollup_asofdate2
17301: (p_project_id => p_project_id,
17302: p_object_id => l_defer_arr_task_id(l_rollup_table1(i).object_id), -- sridhar_rollup
17303: p_object_type => l_rollup_table1(i).object_type,
17304: p_structure_type => p_structure_type,