APPS.PA_STATUS_PUB dependencies on PA_EARNED_VALUES

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

962:
963: --
964: -- Name: Update_Earned_Value
965: -- Type: PL/SQL Procedure
966: -- Decscription: This procedure updates the PA_EARNED_VALUES table.
967: --
968: -- Called Subprograms: Convert_Pm_Projref_To_Id
969: -- , Convert_Pm_Taskref_To_Id
970: -- , Convert_List_Name_To_Id

Line 1057: FROM pa_earned_values ev

1053: , l_task_id_out NUMBER
1054: , l_resource_list_member_id_out NUMBER)
1055: IS
1056: SELECT trunc(as_of_date)
1057: FROM pa_earned_values ev
1058: WHERE ev.project_id = l_project_id_out
1059: AND ev.task_id = l_task_id_out
1060: AND ev.resource_list_member_id = l_resource_list_member_id_out
1061: AND ev.current_flag = 'Y'

Line 1313: -- UPDATE Current Flag in PA_EARNED_VALUES

1309: l_baq_current := p_baq_current;
1310: END IF;
1311:
1312: -- ------------------------------------------------------------------------------
1313: -- UPDATE Current Flag in PA_EARNED_VALUES
1314: -- ------------------------------------------------------------------------------
1315:
1316: -- Locking
1317: l_date_computed := NULL;

Line 1341: UPDATE pa_earned_values ev

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

Line 1351: -- INSERT VALUES INTO PA_EARNED_VALUES

1347: END IF;
1348:
1349:
1350: -- ------------------------------------------------------------------------------
1351: -- INSERT VALUES INTO PA_EARNED_VALUES
1352: -- ------------------------------------------------------------------------------
1353:
1354: INSERT INTO pa_earned_values (
1355: PROJECT_ID

Line 1354: INSERT INTO pa_earned_values (

1350: -- ------------------------------------------------------------------------------
1351: -- INSERT VALUES INTO PA_EARNED_VALUES
1352: -- ------------------------------------------------------------------------------
1353:
1354: INSERT INTO pa_earned_values (
1355: PROJECT_ID
1356: , TASK_ID
1357: , RESOURCE_LIST_MEMBER_ID
1358: , AS_OF_DATE