APPS.PA_STATUS_PUB dependencies on PA_EARNED_VALUES

Line 970: -- Decscription: This procedure updates the PA_EARNED_VALUES table.

966:
967: --
968: -- Name: Update_Earned_Value
969: -- Type: PL/SQL Procedure
970: -- Decscription: This procedure updates the PA_EARNED_VALUES table.
971: --
972: -- Called Subprograms: Convert_Pm_Projref_To_Id
973: -- , Convert_Pm_Taskref_To_Id
974: -- , Convert_List_Name_To_Id

Line 1061: FROM pa_earned_values ev

1057: , l_task_id_out NUMBER
1058: , l_resource_list_member_id_out NUMBER)
1059: IS
1060: SELECT trunc(as_of_date)
1061: FROM pa_earned_values ev
1062: WHERE ev.project_id = l_project_id_out
1063: AND ev.task_id = l_task_id_out
1064: AND ev.resource_list_member_id = l_resource_list_member_id_out
1065: AND ev.current_flag = 'Y'

Line 1317: -- UPDATE Current Flag in PA_EARNED_VALUES

1313: l_baq_current := p_baq_current;
1314: END IF;
1315:
1316: -- ------------------------------------------------------------------------------
1317: -- UPDATE Current Flag in PA_EARNED_VALUES
1318: -- ------------------------------------------------------------------------------
1319:
1320: -- Locking
1321: l_date_computed := NULL;

Line 1345: UPDATE pa_earned_values ev

1341: END IF;
1342: CLOSE l_earned_values_csr;
1343:
1344: IF l_current_flag = 'Y' AND l_date_computed IS NOT NULL THEN
1345: UPDATE pa_earned_values ev
1346: SET ev.current_flag = 'N'
1347: WHERE ev.project_id = l_project_id_out
1348: AND ev.task_id = l_task_id_out
1349: AND ev.resource_list_member_id = l_resource_list_member_id_out

Line 1355: -- INSERT VALUES INTO PA_EARNED_VALUES

1351: END IF;
1352:
1353:
1354: -- ------------------------------------------------------------------------------
1355: -- INSERT VALUES INTO PA_EARNED_VALUES
1356: -- ------------------------------------------------------------------------------
1357:
1358: INSERT INTO pa_earned_values (
1359: PROJECT_ID

Line 1358: INSERT INTO pa_earned_values (

1354: -- ------------------------------------------------------------------------------
1355: -- INSERT VALUES INTO PA_EARNED_VALUES
1356: -- ------------------------------------------------------------------------------
1357:
1358: INSERT INTO pa_earned_values (
1359: PROJECT_ID
1360: , TASK_ID
1361: , RESOURCE_LIST_MEMBER_ID
1362: , AS_OF_DATE