DBA Data[Home] [Help]

APPS.PA_DELIVERABLE_PROGRESS_PUB dependencies on PA_PROGRESS_UTILS

Line 285: IF PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, l_task_id)) = 'CANCELLED'

281: -- Bug 3957792 : Commenting this check, deliverable is a separete entity and progress can be entered even if associated task is cancelled
282: /*
283: --Added for BUG 3762650, by rtarway, added check for task's cancelled status
284: --if associated task status is CANCELLED, dlvr progress cant be entered
285: IF PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, l_task_id)) = 'CANCELLED'
286: THEN
287: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
288: ,p_msg_name => 'PA_TP_DLVR_CANT_NTER_PRG_CANCEL');
289: x_msg_data := 'PA_TP_DLVR_CANT_NTER_PRG_CANCEL';

Line 300: l_deliverable_status := PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, p_object_id, 'PA_DELIVERABLES'),'PA_DELIVERABLES');

296: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'l_task_id='||l_task_id, x_Log_Level=> 3);
297: END IF;
298:
299: -- If deliverable is cancelled then progress can not be entered
300: l_deliverable_status := PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, p_object_id, 'PA_DELIVERABLES'),'PA_DELIVERABLES');
301:
302: -- Bug 6497559
303: OPEN cur_get_del_type_prog_attr;
304: FETCH cur_get_del_type_prog_attr INTO l_del_type_prog_enabled , l_dlvr_type_id , l_deliverable_existing_status, l_del_name ; --MSP Messages Change(changed position)

Line 327: PA_PROGRESS_UTILS.get_project_progress_defaults(

323: IF g1_debug_mode = 'Y' THEN
324: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'After Checking Deliverable Cancelled/On Hold Status', x_Log_Level=> 3);
325: END IF;
326:
327: PA_PROGRESS_UTILS.get_project_progress_defaults(
328: p_project_id => p_project_id
329: ,p_structure_type => 'WORKPLAN'
330: ,x_WQ_ENABLED_FLAG => l_wq_enabled_flag
331: ,x_EFFORT_ENABLED_FLAG => l_est_remaining_eff_flag

Line 559: --l_del_status2 := PA_PROGRESS_UTILS.get_system_task_status( p_del_status, 'PA_DELIVERABLES' );

555: -- Moved this from below while fixing for 3668168
556: -- Changed by rtarway for BUG 3668168
557:
558: -- Changed by rtarway for BUG 3668168, should use l_del_status
559: --l_del_status2 := PA_PROGRESS_UTILS.get_system_task_status( p_del_status, 'PA_DELIVERABLES' );
560: l_del_status2 := PA_PROGRESS_UTILS.get_system_task_status( l_del_status, 'PA_DELIVERABLES' );
561:
562: --Added by rtarway for BUG 3668168, if condition
563: IF l_percent_complete_flag = 'Y' THEN

Line 560: l_del_status2 := PA_PROGRESS_UTILS.get_system_task_status( l_del_status, 'PA_DELIVERABLES' );

556: -- Changed by rtarway for BUG 3668168
557:
558: -- Changed by rtarway for BUG 3668168, should use l_del_status
559: --l_del_status2 := PA_PROGRESS_UTILS.get_system_task_status( p_del_status, 'PA_DELIVERABLES' );
560: l_del_status2 := PA_PROGRESS_UTILS.get_system_task_status( l_del_status, 'PA_DELIVERABLES' );
561:
562: --Added by rtarway for BUG 3668168, if condition
563: IF l_percent_complete_flag = 'Y' THEN
564: /* Bug 3606627 Deleiverable Status Should be defaulted as done for tasks*/

Line 749: l_last_progress_date := PA_PROGRESS_UTILS.GET_LATEST_AS_OF_DATE(p_task_id => null, p_project_id=> p_project_id,p_object_id=> p_object_id, p_object_type=>p_object_type, p_structure_type=> p_structure_type );

745: AND project_id = p_project_id
746: AND object_type = p_object_type;
747:
748: -- FPM Dev CR 1 : Passed more parameters in the following call
749: l_last_progress_date := PA_PROGRESS_UTILS.GET_LATEST_AS_OF_DATE(p_task_id => null, p_project_id=> p_project_id,p_object_id=> p_object_id, p_object_type=>p_object_type, p_structure_type=> p_structure_type );
750:
751: l_working_aod := PA_PROGRESS_UTILS.Working_version_exist(
752: --p_task_id => p_object_id --bug# 3764224 Changes for RLM
753: p_task_id => null

Line 751: l_working_aod := PA_PROGRESS_UTILS.Working_version_exist(

747:
748: -- FPM Dev CR 1 : Passed more parameters in the following call
749: l_last_progress_date := PA_PROGRESS_UTILS.GET_LATEST_AS_OF_DATE(p_task_id => null, p_project_id=> p_project_id,p_object_id=> p_object_id, p_object_type=>p_object_type, p_structure_type=> p_structure_type );
750:
751: l_working_aod := PA_PROGRESS_UTILS.Working_version_exist(
752: --p_task_id => p_object_id --bug# 3764224 Changes for RLM
753: p_task_id => null
754: ,p_project_id => p_project_id
755: ,p_object_type => p_object_type

Line 760: l_progress_exists_on_aod := PA_PROGRESS_UTILS.check_prog_exists_on_aod(

756: ,p_object_id => p_object_id --bug# 3764224 Added for RLM
757: ,p_as_of_date => p_as_of_date --bug 4185364 get working records upto passed as of date as we dont want to
758: ); -- update future working records
759:
760: l_progress_exists_on_aod := PA_PROGRESS_UTILS.check_prog_exists_on_aod(
761: --p_task_id => p_object_id --bug# 3764224 Changes for RLM
762: p_task_id => null
763: ,p_as_of_date => p_as_of_date
764: ,p_project_id => p_project_id

Line 811: AND PA_PROGRESS_UTILS.CHECK_VALID_AS_OF_DATE( p_as_of_date, p_project_id, p_object_id, 'PA_DELIVERABLES' ) = 'N'

807:
808: --bug 3994165, commmenting as as of date validation is not required
809: /*IF p_calling_module <> 'AMG' -- Bug 3627315
810: AND p_calling_module <> 'TASK_PROG_DET_PAGE' -- Bug 3627315
811: AND PA_PROGRESS_UTILS.CHECK_VALID_AS_OF_DATE( p_as_of_date, p_project_id, p_object_id, 'PA_DELIVERABLES' ) = 'N'
812: AND trunc(nvl(l_last_progress_date,p_as_of_date + 1 )) <> trunc(p_as_of_date)
813: THEN
814: --Add message
815: --Invalid as of date

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

976: l_current_flag := 'N'; -- FPM Dev CR 1
977: l_rollup_current_flag := 'W'; -- Bug 3879461
978: END IF;
979:
980: l_prog_pa_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date),null);
981: l_prog_gl_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(p_as_of_date),null);
982:
983:
984: IF l_db_action = 'CREATE'

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

977: l_rollup_current_flag := 'W'; -- Bug 3879461
978: END IF;
979:
980: l_prog_pa_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date),null);
981: l_prog_gl_period_name := nvl(PA_PROGRESS_UTILS.Prog_Get_GL_Period_Name(p_as_of_date),null);
982:
983:
984: IF l_db_action = 'CREATE'
985: THEN

Line 1071: l_PROGRESS_ROLLUP_ID := PA_PROGRESS_UTILS.get_prog_rollup_id(

1067: IF g1_debug_mode = 'Y' THEN
1068: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'Getting rollup id', x_Log_Level=> 3);
1069: END IF;
1070:
1071: l_PROGRESS_ROLLUP_ID := PA_PROGRESS_UTILS.get_prog_rollup_id(
1072: p_project_id => p_project_id
1073: ,p_object_id => p_object_id
1074: ,p_object_type => p_object_type
1075: ,p_object_version_id => p_object_version_id

Line 1391: l_percent_complete_id := PA_PROGRESS_UTILS.get_ppc_id(

1387: END IF;
1388:
1389: IF p_percent_complete_id IS NULL OR p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_working_aod IS NULL -- Bug 10225425
1390: THEN
1391: l_percent_complete_id := PA_PROGRESS_UTILS.get_ppc_id(
1392: p_project_id => p_project_id
1393: ,p_object_id => p_object_id
1394: ,p_object_type => p_object_type
1395: ,p_object_version_id => p_object_version_id

Line 1464: l_PROGRESS_ROLLUP_ID := PA_PROGRESS_UTILS.get_prog_rollup_id(

1460: IF Fnd_Msg_Pub.count_msg > 0 THEN
1461: RAISE FND_API.G_EXC_ERROR;
1462: END IF;
1463:
1464: l_PROGRESS_ROLLUP_ID := PA_PROGRESS_UTILS.get_prog_rollup_id(
1465: p_project_id => p_project_id
1466: ,p_object_id => p_object_id
1467: ,p_object_type => p_object_type
1468: ,p_object_version_id => p_object_version_id