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_ASSIGNMENT_PROGRESS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8


PROCEDURE UPDATE_ASSIGNMENT_PROGRESS(
 p_api_version             IN NUMBER    := 1.0                             ,
 p_init_msg_list           IN VARCHAR2  := FND_API.G_TRUE                  ,
 p_commit                  IN VARCHAR2  := FND_API.G_FALSE                 ,
 p_validate_only           IN VARCHAR2  := FND_API.G_TRUE                  ,
 p_validation_level        IN NUMBER    := FND_API.G_VALID_LEVEL_FULL      ,
 p_calling_module          IN VARCHAR2  := 'SELF_SERVICE'                  ,
 p_action                  IN VARCHAR2  := 'SAVE'                          ,
 p_bulk_load_flag          IN VARCHAR2  := 'N'                             ,
 p_progress_mode           IN VARCHAR2  := 'FUTURE'                        ,
 p_percent_complete_id     IN NUMBER         := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM      ,
 p_project_id              IN NUMBER         := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM      ,
 p_object_id               IN NUMBER         := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM      ,
 p_object_version_id       IN NUMBER         := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM      ,
 p_task_id                 IN NUMBER         := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM      ,
 p_as_of_date                 IN   DATE      := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE     ,
 p_progress_comment           IN   VARCHAR2  := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR     ,
 p_brief_overview             IN   VARCHAR2  := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR     ,
 p_actual_start_date          IN   DATE      := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE     ,
 p_actual_finish_date         IN   DATE      := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE     ,
 p_estimated_start_date       IN   DATE      := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE     ,
 p_estimated_finish_date      IN   DATE      := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE     ,
 p_record_version_number      IN   NUMBER    := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM      ,
 p_pm_product_code            IN   VARCHAR2  := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR     ,
 p_rate_based_flag            IN   VARCHAR2  := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR     ,
 p_resource_class_code        IN   VARCHAR2  := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR     ,
 p_txn_currency_code          IN        VARCHAR2        := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR         ,
 p_rbs_element_id             IN        NUMBER          := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM          ,
 --p_resource_list_member_id    IN        NUMBER          := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM          , --bug# 3764224
 p_resource_assignment_id    IN        NUMBER          := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM          ,
 p_actual_cost                IN        NUMBER          := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM          , -- Bug3621404 This parameter represents raw cost
 p_actual_effort              IN        NUMBER          := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM          ,
 p_planned_cost               IN   NUMBER         := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM      , -- Bug3621404 This parameter represents raw cost
 p_planned_effort             IN   NUMBER         := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM      ,
 p_structure_type             IN   VARCHAR2       := 'WORKPLAN'                                ,
 p_structure_version_id       IN   NUMBER         := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM      ,
 p_actual_cost_this_period    IN   NUMBER         := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM      , -- Bug3621404 This parameter represents raw cost
 p_actual_effort_this_period  IN   NUMBER         := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM      ,
 p_etc_cost_this_period       IN   NUMBER         := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM      , -- Though the name of this column is this period but it is cumulative -- Bug3621404 This parameter represents raw cost
 p_etc_effort_this_period     IN   NUMBER         := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM      , -- Though the name of this column is this period but it is cumulative
 p_scheduled_start_date       IN   DATE           := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE     ,
 p_scheduled_finish_date      IN   DATE           := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE     ,
 x_return_status              OUT  NOCOPY VARCHAR2                                                    , --File.Sql.39 bug 4440895
 x_msg_count                  OUT  NOCOPY NUMBER                                                      , --File.Sql.39 bug 4440895
 x_msg_data                   OUT  NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
IS

   l_api_name                      CONSTANT VARCHAR(30) := 'UPDATE_ASSIGNMENT_PROGRESS'             ;

Line: 211


   SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N')
   FROM pa_proj_elem_ver_structure str, pa_project_statuses status
   where str.element_version_id = c_structure_version_id
   AND str.project_id = c_project_id
   AND str.status_code = status.project_status_code;

Line: 229


    SELECT decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_rawcost_to_date_tc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_rawcost_to_date_tc,0), nvl(ppr.oth_act_rawcost_to_date_tc,0)) tc_raw_cost,
         decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_rawcost_to_date_pc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_rawcost_to_date_pc,0), nvl(ppr.oth_act_rawcost_to_date_pc,0)) pc_raw_cost,
         decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_rawcost_to_date_fc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_rawcost_to_date_fc,0), nvl(ppr.oth_act_rawcost_to_date_fc,0)) fc_raw_cost,
         decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_cost_to_date_tc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_cost_to_date_tc,0), nvl(ppr.oth_act_cost_to_date_tc,0)) tc_bur_cost,
         decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_cost_to_date_pc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_cost_to_date_pc,0), nvl(ppr.oth_act_cost_to_date_pc,0)) pc_bur_cost,
         decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_cost_to_date_fc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_cost_to_date_fc,0), nvl(ppr.oth_act_cost_to_date_fc,0)) fc_bur_cost,
         decode(c_resource_class_code, 'PEOPLE', nvl(ppr.PPL_ACT_EFFORT_TO_DATE,0), 'EQUIPMENT', nvl(ppr.EQPMT_ACT_EFFORT_TO_DATE,0), nvl(ppr.OTH_QUANTITY_TO_DATE,0)) act_effort -- 3696572 OTH_QUANTITY_TO_DATE shd also be considered here
     FROM pa_progress_rollup ppr
    WHERE  ppr.project_id = c_project_id
     AND   ppr.object_id  = c_object_id
     AND   ppr.structure_type = c_structure_type
     AND   ppr.structure_version_id is null        --bug# 3821106 Satish
     AND   ppr.object_type = 'PA_ASSIGNMENTS'
     AND   ppr.proj_element_id = p_task_id    --bug 3861360
     AND   ppr.current_flag <> 'W'   -- Bug 3879461
	 AND   NVL(ppr.cbs_element_id,-1) = NVL(c_cbs_element_id,-1) -- Added for 16200605
     --bug# 3821106 Satish
     /*AND   ppr.as_of_date = ( SELECT max(as_of_date)
                           from pa_progress_rollup ppr2
                          WHERE ppr2.as_of_date < c_as_of_date
                           AND  ppr2.project_id = c_project_id
                           AND ppr2.object_id  = c_object_id
                           AND ppr2.object_type = 'PA_ASSIGNMENTS'
                           AND ppr2.structure_type = c_structure_type
                       );*/

Line: 254


     AND   ppr.as_of_date = ( SELECT max(as_of_date)
                           from pa_progress_rollup ppr2
                          WHERE ppr2.as_of_date < c_as_of_date ---4290592
                           AND  ppr2.project_id = c_project_id
                           AND ppr2.object_id  = c_object_id
                           AND ppr2.object_type = 'PA_ASSIGNMENTS'
                           AND ppr2.structure_type = c_structure_type
			   AND ppr2.structure_version_id is null
                           AND ppr2.proj_element_id = p_task_id    --bug 3861360
			   AND ppr2.current_flag <> 'W'   -- Bug 3879461
			    AND   NVL(ppr2.cbs_element_id,-1) = NVL(c_cbs_element_id,-1) -- Added for 16200605
			   -- Bug 3879461 : Not exists is not required now
--			   AND NOT EXISTS (
--					    SELECT 'X' FROM pa_percent_completes ppc
--					    WHERE ppc.date_computed = ppr2.as_of_date
--					    AND   ppc.project_id = c_project_id
--					    AND   ppc.object_id  = c_object_id
--					    AND   ppc.object_type = 'PA_ASSIGNMENTS'
--					    AND   ppc.structure_type = c_structure_type
--					    AND   ppc.published_flag = 'N'
--                                             AND  ppc.task_id = p_task_id   --3861360
--					  )
                       );

Line: 280


    SELECT decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_rawcost_to_date_tc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_rawcost_to_date_tc,0), nvl(ppr.oth_act_rawcost_to_date_tc,0)) tc_raw_cost,
         decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_rawcost_to_date_pc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_rawcost_to_date_pc,0), nvl(ppr.oth_act_rawcost_to_date_pc,0)) pc_raw_cost,
         decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_rawcost_to_date_fc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_rawcost_to_date_fc,0), nvl(ppr.oth_act_rawcost_to_date_fc,0)) fc_raw_cost,
         decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_cost_to_date_tc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_cost_to_date_tc,0), nvl(ppr.oth_act_cost_to_date_tc,0)) tc_bur_cost,
         decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_cost_to_date_pc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_cost_to_date_pc,0), nvl(ppr.oth_act_cost_to_date_pc,0)) pc_bur_cost,
         decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_cost_to_date_fc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_cost_to_date_fc,0), nvl(ppr.oth_act_cost_to_date_fc,0)) fc_bur_cost,
         decode(c_resource_class_code, 'PEOPLE', nvl(ppr.PPL_ACT_EFFORT_TO_DATE,0), 'EQUIPMENT', nvl(ppr.EQPMT_ACT_EFFORT_TO_DATE,0), nvl(ppr.OTH_QUANTITY_TO_DATE,0)) act_effort -- 3696572 OTH_QUANTITY_TO_DATE shd also be considered here
     FROM pa_progress_rollup ppr
    WHERE  ppr.project_id = c_project_id
     AND   ppr.object_id  = c_object_id
     AND   ppr.structure_type = c_structure_type
     AND   ppr.structure_version_id is null        --bug# 3821106 Satish
     AND   ppr.object_type = 'PA_ASSIGNMENTS'
     AND   ppr.proj_element_id = p_task_id    --bug 3861360
     AND   ppr.current_flag <> 'W'   -- Bug 3879461
	 AND   NVL(ppr.cbs_element_id,-1) = NVL(c_cbs_element_id,-1) -- Added for 16200605
     --bug# 3821106 Satish
     AND   ppr.as_of_date = ( SELECT max(as_of_date)
                           from pa_progress_rollup ppr2
                          WHERE ppr2.as_of_date <= c_as_of_date ---4290592
                           AND  ppr2.project_id = c_project_id
                           AND ppr2.object_id  = c_object_id
                           AND ppr2.object_type = 'PA_ASSIGNMENTS'
                           AND ppr2.structure_type = c_structure_type
						   AND   NVL(ppr2.cbs_element_id,-1) = NVL(c_cbs_element_id,-1) -- Added for 16200605
			   AND ppr2.structure_version_id is null
                           AND ppr2.proj_element_id = p_task_id    --bug 3861360
			   AND ppr2.current_flag <> 'W'   -- Bug 3879461
                       );

Line: 312


    SELECT decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_rawcost_to_date_tc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_rawcost_to_date_tc,0), nvl(ppr.oth_act_rawcost_to_date_tc,0)) tc_raw_cost,
         decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_rawcost_to_date_pc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_rawcost_to_date_pc,0), nvl(ppr.oth_act_rawcost_to_date_pc,0)) pc_raw_cost,
         decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_rawcost_to_date_fc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_rawcost_to_date_fc,0), nvl(ppr.oth_act_rawcost_to_date_fc,0)) fc_raw_cost,
         decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_cost_to_date_tc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_cost_to_date_tc,0), nvl(ppr.oth_act_cost_to_date_tc,0)) tc_bur_cost,
         decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_cost_to_date_pc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_cost_to_date_pc,0), nvl(ppr.oth_act_cost_to_date_pc,0)) pc_bur_cost,
         decode(c_resource_class_code, 'PEOPLE', nvl(ppr.ppl_act_cost_to_date_fc,0), 'EQUIPMENT', nvl(ppr.eqpmt_act_cost_to_date_fc,0), nvl(ppr.oth_act_cost_to_date_fc,0)) fc_bur_cost,
         decode(c_resource_class_code, 'PEOPLE', nvl(ppr.PPL_ACT_EFFORT_TO_DATE,0), 'EQUIPMENT', nvl(ppr.EQPMT_ACT_EFFORT_TO_DATE,0), nvl(ppr.OTH_QUANTITY_TO_DATE,0)) act_effort
     FROM pa_progress_rollup ppr
    WHERE  ppr.project_id = c_project_id
     AND   ppr.object_id  = c_object_id
     AND   ppr.structure_type = c_structure_type
     AND   ppr.structure_version_id is null        --bug# 3821106 Satish
     AND   ppr.object_type = 'PA_ASSIGNMENTS'
     AND   ppr.proj_element_id = p_task_id    --bug 3861360
     AND   ppr.current_flag <> 'W'   -- Bug 3879461
	  AND   NVL(ppr.cbs_element_id,-1) = NVL(c_cbs_element_id,-1) -- Added for 16200605
     AND   ppr.as_of_date = c_as_of_date;

Line: 396


    SELECT
     planned_quantity,
     planned_bur_cost_txn_cur,
     planned_bur_cost_projfunc,
     planned_bur_cost_proj_cur,
     planned_raw_cost_txn_cur,
     planned_raw_cost_proj_cur,
     planned_raw_cost_projfunc,
     budget_version_id       ---4372462
     FROM
     pa_task_asgmts_v
     WHERE
     RESOURCE_LIST_MEMBER_ID = l_resource_list_member_id
     AND
     RESOURCE_ASSIGNMENT_ID  = l_resource_assignment_id
     AND
     PROJECT_ID = l_project_id;

Line: 416


     SELECT 'x' FROM dual
     WHERE EXISTS
     (
      SELECT 'y' FROM PA_PROGRESS_ROLLUP
      WHERE OBJECT_ID = l_object_id
      AND PROJECT_ID = l_project_id
      AND OBJECT_TYPE = 'PA_ASSIGNMENTS'
      AND STRUCTURE_TYPE = 'WORKPLAN'
      and proj_element_id = l_task_id  --3818384
      AND current_flag <> 'W'   -- Bug 3879461
	  AND NVL(CBS_ELEMENT_ID,-1) = NVL(c_cbs_element_id,-1) --Added for CBS 16200605
      AND
      (
       ( l_published_structure = 'Y' AND STRUCTURE_VERSION_ID IS NULL)
       OR
       ( l_published_structure = 'N' AND STRUCTURE_VERSION_ID = l_structure_version_id)
      )
     );

Line: 455


     SELECT ta_display_flag
     FROM pa_task_assignments_v
     WHERE RESOURCE_LIST_MEMBER_ID = l_resource_list_member_id  AND
           RESOURCE_ASSIGNMENT_ID  = l_resource_assignment_id   AND
	   TASK_ID                 = l_task_id                  AND
           PROJECT_ID              = l_project_id               AND
	   STRUCTURE_VERSION_ID    = l_structure_version_id;

Line: 468


SELECT decode(ppr.base_progress_status_code,'Y','Y','N') date_override_flag
, ppr.estimated_start_date
, ppr.estimated_finish_date
, ppr.actual_start_date
, ppr.actual_finish_date
, ppe.status_code
FROM pa_progress_rollup ppr
, pa_proj_elements ppe
WHERE ppr.project_id = c_project_id
AND ppr.object_id = c_object_id
AND ppr.object_type = c_object_type
AND ppr.structure_type = 'WORKPLAN'
AND ppr.structure_version_id is null
AND trunc(ppr.as_of_date) <= trunc(c_as_of_date)
AND ppr.current_flag IN ('Y', 'N')
AND ppr.proj_element_id = ppe.proj_element_id
AND ppr.cbs_element_id = c_cbs_element_id  --Added for 16200605
ORDER by as_of_date desc;

Line: 505


SELECT CBS_ELEMENT_ID
FROM PA_RESOURCE_ASSIGNMENTS
WHERE project_id=p_project_id
AND resource_assignment_id = p_resource_assignment_id;

Line: 520


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'ENTERED', x_Log_Level=> 3);

Line: 524


       pa_debug.init_err_stack ('PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS');

Line: 528


      savepoint UPDATE_ASSIGNMENT_PROGRESS;

Line: 540


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_task_id: '||p_task_id, x_Log_Level=> 3);

Line: 541


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_object_version_id: '||p_object_version_id, x_Log_Level=> 3);

Line: 542


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_project_id: '||p_project_id, x_Log_Level=> 3);

Line: 543


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_object_id: '||p_object_id, x_Log_Level=> 3);

Line: 544


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_as_of_date: '||p_as_of_date, x_Log_Level=> 3);

Line: 545


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_percent_complete_id: '||p_percent_complete_id, x_Log_Level=> 3);

Line: 546


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_actual_start_date: '||p_actual_start_date, x_Log_Level=> 3);

Line: 547


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_actual_finish_date: '||p_actual_finish_date, x_Log_Level=> 3);

Line: 548


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_estimated_start_date: '||p_estimated_start_date, x_Log_Level=> 3);

Line: 549


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_estimated_finish_date: '||p_estimated_finish_date, x_Log_Level=> 3);

Line: 550


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_record_version_number: '||p_record_version_number, x_Log_Level=> 3);

Line: 551


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_actual_cost_this_period: '||p_actual_cost_this_period, x_Log_Level=> 3);

Line: 552


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_actual_effort_this_period: '||p_actual_effort_this_period, x_Log_Level=> 3);

Line: 553


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_etc_cost_this_period: '||p_etc_cost_this_period, x_Log_Level=> 3);

Line: 554


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_etc_effort_this_period: '||p_etc_effort_this_period, x_Log_Level=> 3);

Line: 555


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_structure_type: '||p_structure_type, x_Log_Level=> 3);

Line: 556


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_structure_version_id: '||p_structure_version_id, x_Log_Level=> 3);

Line: 557


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_resource_class_code: '||p_resource_class_code, x_Log_Level=> 3);

Line: 558


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_rate_based_flag: '||p_rate_based_flag, x_Log_Level=> 3);

Line: 584


SELECT DECODE(ptt.REMAIN_EFFORT_ENABLE_FLAG, 'Y', DECODE(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', 'Y', 'N'), 'N')
INTO   l_est_remaining_eff_flag
FROM   pa_proj_elements ppe,
       pa_task_types ptt   ,
       pa_proj_progress_attr pppa
WHERE  ppe.proj_element_id = p_task_id
   AND ppe.type_id         = ptt.task_type_id
   AND pppa.project_id     = ppe.project_id
   AND pppa.structure_type = 'WORKPLAN'; -- For Bug 8887270

Line: 613


    SELECT project_currency_code, projfunc_currency_code  INTO  l_prj_currency_code, l_prjfunc_currency_code  FROM pa_projects_all WHERE project_id = p_project_id;

Line: 771


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_ta_display_flag '||l_ta_display_flag, x_Log_Level=> 3);

Line: 776


  /*--3779387, 3958686 this error should not be raised for hidden assignment as in this case it is being called from update_task_progress
    IF l_actual_effort_this_period < 0 AND  l_ta_display_flag = 'Y'
    THEN
        PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
                             ,p_msg_name       => 'PA_TP_NO_NEG_ACT');

Line: 935


		       ,p_msg_name       => 'PA_WP_VD_CANT_UPDATE_ETC');

Line: 936


		x_msg_data := 'PA_WP_VD_CANT_UPDATE_ETC';

Line: 967


    SELECT structure_sharing_code
    INTO l_structure_sharing_code
    FROM pa_projects_all
    WHERE project_id = p_project_id;

Line: 1046


       delete from pa_percent_completes
       where project_id= p_project_id
         and object_id = p_object_id
         and published_flag = 'N'
         and task_id = p_task_id
         and structure_type = p_structure_type
         and NVL(cbs_element_id,-1) = NVL(l_cbs_element_id,-1)	--Added for 16200605
		 ;

Line: 1055


       delete from pa_progress_rollup
       where project_id= p_project_id
         and object_id = p_object_id
         and current_flag = 'W'
         and proj_element_id = p_task_id
         and structure_type = p_structure_type
         and structure_version_id is null
		and NVL(cbs_element_id,-1) = NVL(l_cbs_element_id,-1)	--Added for 16200605
         ;

Line: 1072


       delete from pa_percent_completes
       where project_id= p_project_id
         and object_id = p_object_id
         and published_flag = 'N'
         and date_computed <= p_as_of_date      --bug 4247839, modified so that two records are not created for same as of date
         and task_id = p_task_id
         and structure_type = p_structure_type
		 and NVL(cbs_element_id,-1) = NVL(l_cbs_element_id,-1)	--Added for 16200605
	-- DJ::: NEED TO ADD CBS_ELEMENT_ID
         ;

Line: 1083


       delete from pa_progress_rollup
       where project_id= p_project_id
         and object_id = p_object_id
         and current_flag = 'W'
         and as_of_date < p_as_of_date
         and proj_element_id = p_task_id
         and structure_type = p_structure_type
         and structure_version_id is null
        and NVL(cbs_element_id,-1) = NVL(l_cbs_element_id,-1)	--Added for 16200605
         -- DJ::: NEED TO ADD CBS_ELEMENT_ID
         ;

Line: 1102


          SELECT rate_based_flag, resource_class_code, txn_currency_code,
               rbs_element_id, resource_list_member_id, assignment_start_date, assignment_end_date -- Bug 3956299 : Added assignment_end_date
          INTO l_rate_based_flag, l_resource_class_code, l_txn_currency_code,
               l_rbs_element_id, l_resource_list_member_id, l_scheduled_start_date, l_scheduled_finish_date -- Bug 3956299 : Added l_scheduled_finish_date
          FROM pa_task_assignments_v
          WHERE --resource_assignment_id = l_assignment_id Bug 3799841
	  resource_list_member_id = l_resource_list_member_id -- Bug 3799841
          AND structure_version_id = p_structure_version_id
          AND task_version_id = l_object_version_id;

Line: 1113


          SELECT rate_based_flag,
                 resource_class_code,
                 PA_TASK_ASSIGNMENT_UTILS.get_planned_currency_info(pra.resource_assignment_id, pra.project_id, 'txn_currency_code') as txn_currency_code,
                 rbs_element_id,
                 resource_list_member_id,
                 schedule_start_date,
                 schedule_end_date,
		 pra.resource_assignment_id -- Bug 4186007 : Derive res_assignment_id from AMG, it can be null
            INTO l_rate_based_flag, l_resource_class_code, l_txn_currency_code,
                 l_rbs_element_id, l_resource_list_member_id, l_scheduled_start_date,
                 l_scheduled_finish_date,
		 l_assignment_id -- Bug 4186007 : Derive res_assignment_id from AMG, it can be null
            FROM pa_resource_assignments pra,
                 PA_PROJ_ELEMENT_VERSIONS PPEV
           where resource_list_member_id = l_resource_list_member_id
             AND PPEV.PROJECT_ID = p_project_id
             AND PPEV.PARENT_STRUCTURE_VERSION_ID = p_structure_version_id
             AND pra.TASK_ID = PPEV.PROJ_ELEMENT_ID
             AND pra.wbs_element_version_id = ppev.element_version_id
             --Added following conditions bug4110593, rtarway
             AND pra.task_id = p_task_id
             AND pra.wbs_element_version_id = p_object_version_id
			 AND NVL(pra.cbs_element_id,-1)=NVL(l_cbs_element_id,-1);

Line: 1280


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'Client Extension Logic Starts', x_Log_Level=> 3);

Line: 1294


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_db_date_override_flag='||l_db_date_override_flag, x_Log_Level=> 3);

Line: 1295


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_db_estimated_start_date='||l_db_estimated_start_date, x_Log_Level=> 3);

Line: 1296


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_db_estimated_finish_date='||l_db_estimated_finish_date, x_Log_Level=> 3);

Line: 1297


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_db_actual_start_date='||l_db_actual_start_date, x_Log_Level=> 3);

Line: 1298


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_db_actual_finish_date='||l_db_actual_finish_date, x_Log_Level=> 3);

Line: 1299


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_task_status_code='||l_task_status_code, x_Log_Level=> 3);

Line: 1300


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'Calling PA_PROGRESS_CLIENT_EXTN.GET_TASK_RES_OVERRIDE_INFO with following params', x_Log_Level=> 3);

Line: 1301


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);

Line: 1302


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);

Line: 1303


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_object_type='||l_object_type, x_Log_Level=> 3);

Line: 1304


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_object_version_id='||l_object_version_id, x_Log_Level=> 3);

Line: 1305


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_resource_list_member_id='||l_resource_list_member_id, x_Log_Level=> 3);

Line: 1306


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_task_id='||p_task_id, x_Log_Level=> 3);

Line: 1307


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_estimated_start_date='||l_estimated_start_date, x_Log_Level=> 3);

Line: 1308


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_estimated_finish_date='||l_estimated_finish_date, x_Log_Level=> 3);

Line: 1309


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_actual_start_date='||l_actual_start_date, x_Log_Level=> 3);

Line: 1310


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_actual_finish_date='||l_actual_finish_date, x_Log_Level=> 3);

Line: 1340


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'After Call PA_PROGRESS_CLIENT_EXTN.GET_TASK_RES_OVERRIDE_INFO x_return_status='||x_return_status, x_Log_Level=> 3);

Line: 1341


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_clex_estimated_start_date='||l_clex_estimated_start_date, x_Log_Level=> 3);

Line: 1342


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_clex_estimated_finish_date='||l_clex_estimated_finish_date, x_Log_Level=> 3);

Line: 1343


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_clex_actual_start_date='||l_clex_actual_start_date, x_Log_Level=> 3);

Line: 1344


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_clex_actual_finish_date='||l_clex_actual_finish_date, x_Log_Level=> 3);

Line: 1381


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_date_override_flag='||l_date_override_flag, x_Log_Level=> 3);

Line: 1382


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_estimated_start_date='||l_estimated_start_date, x_Log_Level=> 3);

Line: 1383


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_estimated_finish_date='||l_estimated_finish_date, x_Log_Level=> 3);

Line: 1384


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_actual_start_date='||l_actual_start_date, x_Log_Level=> 3);

Line: 1385


		pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_actual_finish_date='||l_actual_finish_date, x_Log_Level=> 3);

Line: 1418


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_last_progress_date: '||l_last_progress_date, x_Log_Level=> 3);

Line: 1429


				                                           -- as we dont want to update future working records.

    IF g1_debug_mode  = 'Y' THEN
       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_working_aod: '||l_working_aod, x_Log_Level=> 3);

Line: 1449


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_progress_exists_on_aod: '||l_progress_exists_on_aod, x_Log_Level=> 3);

Line: 1469


          l_db_action := 'UPDATE';

Line: 1513


           l_db_action := 'UPDATE';

Line: 1521


		l_db_action := 'UPDATE';

Line: 1533


                l_db_action := 'UPDATE';

Line: 1539


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_db_action: '||l_db_action, x_Log_Level=> 3);

Line: 1548


        UPDATE pa_percent_completes
        SET current_flag = 'N'
        WHERE project_id = p_project_id
        --AND object_id = l_assignment_id  --bug# 3764224 Changes for RLM
        AND object_id = l_resource_list_member_id
        AND task_id = l_task_id    --maansari7/21 bug# 3764224 Changes for RLM
        AND current_flag = 'Y'
        AND object_type = l_object_type
		AND CBS_ELEMENT_ID = L_CBS_ELEMENT_ID; --Added for 16200605

Line: 1558


        UPDATE pa_progress_rollup
        SET current_flag = 'N'
        WHERE project_id = p_project_id
        --AND object_id = l_assignment_id --bug# 3764224 Changes for RLM
        AND object_id = l_resource_list_member_id
        AND proj_element_id = l_task_id    --maansari7/21 bug# 3764224 Changes for RLM
        AND current_flag = 'Y'
        AND object_type = l_object_type
	    AND structure_version_id is null -- Bug 3846353 : *** AMKSINGH  08/24/04 09:53 am ***  Issue F - 2
		AND CBS_ELEMENT_ID = L_CBS_ELEMENT_ID; -- Added for 16200605

Line: 1572


		-- Delete the published progress record on the same as of date
		DELETE FROM pa_progress_rollup
		where project_id = p_project_id
		and object_id = l_resource_list_member_id
		and proj_element_id = l_task_id
		and object_type = l_object_type
		and structure_version_id is null
		and structure_type = 'WORKPLAN'
		and current_flag = 'Y'
		and trunc(as_of_date) = trunc(p_as_of_date)
		and exists(select 1
				from pa_progress_rollup
				where project_id = p_project_id
				and object_id = l_resource_list_member_id
				and proj_element_id = l_task_id
				and object_type = l_object_type
				and structure_version_id is null
				and structure_type = 'WORKPLAN'
				and current_flag = 'W'
				and trunc(as_of_date) = trunc(p_as_of_date)
		  	   );

Line: 1593


		-- Update the  working progress record on the same as of date as published progress
		-- so that while updating rollup record its values can be considered
		-- Basically this is done so get_prog_rollup_id can return this row for update mode

		Update pa_progress_rollup
		set current_flag = 'Y'
		where project_id = p_project_id
		and object_id = l_resource_list_member_id
		and proj_element_id = l_task_id
		and object_type = l_object_type
		and structure_version_id is null
		and structure_type = 'WORKPLAN'
		and current_flag = 'W'
		and trunc(as_of_date) = trunc(p_as_of_date);

Line: 1609


		Delete from pa_progress_rollup
		where project_id = p_project_id
		and object_id = l_resource_list_member_id
		and proj_element_id = l_task_id
		and object_type = l_object_type
		and structure_version_id is null
		and structure_type = 'WORKPLAN'
		and current_flag = 'W'
		and trunc(as_of_date) <= trunc(p_as_of_date)
		and NVL(cbs_element_id,-1) = NVL(l_cbs_element_id,-1)	--Added for 16200605
		;

Line: 1666


          pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'Calling Get_Res_txn_Cost_Rate', x_Log_Level=> 3);

Line: 1688


            pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => ' Before conversion l_res_raw_rate'||l_res_raw_rate, x_Log_Level=> 3);

Line: 1689


            pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'Before conversion l_res_burden_rate'||l_res_burden_rate, x_Log_Level=> 3);

Line: 1690


            pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'Before conversion l_res_cur_code'||l_res_cur_code, x_Log_Level=> 3);

Line: 1697


                            p_procedure_name =>        'UPDATE_ASSIGNMENT_PROGRESS',
                            p_error_text     => SUBSTRB('PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier1:'||SQLERRM,1,240));

Line: 1784


         pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => ' After conversion l_res_raw_rate'||l_res_raw_rate, x_Log_Level=> 3);

Line: 1785


         pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'After conversion l_res_burden_rate'||l_res_burden_rate, x_Log_Level=> 3);

Line: 1814


         pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'Before conversion l_plan_res_raw_rate'||l_plan_res_raw_rate, x_Log_Level=> 3);

Line: 1815


         pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'Before conversion l_plan_res_burden_rate'||l_plan_res_burden_rate, x_Log_Level=> 3);

Line: 1816


         pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_plan_res_cur_code'||l_plan_res_cur_code, x_Log_Level=> 3);

Line: 1822


                            p_procedure_name =>        'UPDATE_ASSIGNMENT_PROGRESS',
                            p_error_text     => SUBSTRB('PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier2:'||SQLERRM,1,240));

Line: 1912


         pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => ' After conversion l_plan_res_raw_rate'||l_plan_res_raw_rate, x_Log_Level=> 3);

Line: 1913


         pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'After conversion l_plan_res_burden_rate'||l_plan_res_burden_rate, x_Log_Level=> 3);

Line: 1940


                  pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'calling effort to cost for actual', x_Log_Level=> 3);

Line: 1980


           UPDATE pa_proj_elements
              SET progress_outdated_flag = 'Y'
            WHERE project_id=p_project_id
             and object_type= 'PA_TASKS'
             and proj_element_id = p_task_id
             and progress_outdated_flag = 'N'
             ;

Line: 2000


                  pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'calling effort to cost for etc', x_Log_Level=> 3);

Line: 2043


            pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_etc_txn_raw_cost'||l_etc_txn_raw_cost, x_Log_Level=> 3);

Line: 2044


            pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_etc_txn_bur_cost'||l_etc_txn_bur_cost, x_Log_Level=> 3);

Line: 2165


          pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_act_project_raw_cost'||l_act_project_raw_cost, x_Log_Level=> 3);

Line: 2166


          pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_act_projfunc_raw_cost'||l_act_projfunc_raw_cost, x_Log_Level=> 3);

Line: 2254


          pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_etc_project_raw_cost'||l_etc_project_raw_cost, x_Log_Level=> 3);

Line: 2255


          pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_etc_projfunc_raw_cost'||l_etc_projfunc_raw_cost, x_Log_Level=> 3);

Line: 2256


          pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_project_rate_type'||l_project_rate_type, x_Log_Level=> 3);

Line: 2257


          pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_project_rate_date'||l_project_rate_date, x_Log_Level=> 3);

Line: 2258


          pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_project_exch_rate'||l_project_exch_rate, x_Log_Level=> 3);

Line: 2259


          pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_projfunc_cost_rate_type'||l_projfunc_cost_rate_type, x_Log_Level=> 3);

Line: 2260


          pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_projfunc_cost_rate_date'||l_projfunc_cost_rate_date, x_Log_Level=> 3);

Line: 2261


          pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_projfunc_cost_exch_rate'||l_projfunc_cost_exch_rate, x_Log_Level=> 3);

Line: 2262


          pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_act_effort_last_subm'||l_act_effort_last_subm, x_Log_Level=> 3);

Line: 2263


          pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_act_raw_cost_last_subm_tc'||l_act_raw_cost_last_subm_tc, x_Log_Level=> 3);

Line: 2535


       pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'calling api to push actuals ', x_Log_Level=> 3);

Line: 2609


	pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_etc_effort_last ='||l_etc_effort_last, x_Log_Level=> 3);

Line: 2610


	pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_etc_txn_raw_cost_last ='||l_etc_txn_raw_cost_last, x_Log_Level=> 3);

Line: 2611


	pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_etc_txn_bur_cost_last ='||l_etc_txn_bur_cost_last, x_Log_Level=> 3);

Line: 2620


	pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'Checking the cursor l_progress_exists='||l_progress_exists, x_Log_Level=> 3);

Line: 2638


		  pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'Progress does not exist', x_Log_Level=> 3);

Line: 2659


	      pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'Progress  exists', x_Log_Level=> 3);

Line: 2704


	      pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_etc_txn_raw_cost_this_period '||l_etc_txn_raw_cost_this_period, x_Log_Level=> 3);

Line: 2705


	      pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_etc_txn_bur_cost_this_period '||l_etc_txn_bur_cost_this_period, x_Log_Level=> 3);

Line: 2706


	      pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_etc_effort_incr '||l_etc_effort_incr, x_Log_Level=> 3);

Line: 2809


        PA_PERCENT_COMPLETES_PKG.INSERT_ROW(
                      p_TASK_ID                  => l_task_id
                      ,p_DATE_COMPUTED           => p_as_of_date
                      ,p_LAST_UPDATE_DATE        => SYSDATE
                      ,p_LAST_UPDATED_BY         => l_user_id
                      ,p_CREATION_DATE           => SYSDATE
                      ,p_CREATED_BY              => l_user_id
                      ,p_LAST_UPDATE_LOGIN       => l_login_id
                ,p_COMPLETED_PERCENTAGE    => l_percent_complete
                      ,p_DESCRIPTION             => l_brief_overview
                      ,p_PROJECT_ID              => p_project_id
                      ,p_PM_PRODUCT_CODE         => l_pm_product_code
                      ,p_CURRENT_FLAG            => l_current_flag
                      ,p_OBJECT_TYPE             => l_object_type
                      --,p_OBJECT_ID               => l_assignment_id     --bug# 3764224 Changes for RLM
                      ,p_OBJECT_ID               => l_resource_list_member_id
                ,p_OBJECT_VERSION_ID       => l_object_version_id
                ,p_PROGRESS_STATUS_CODE    => l_progress_status_code
                      ,p_ACTUAL_START_DATE       => l_actual_start_date
                      ,p_ACTUAL_FINISH_DATE      => l_actual_finish_date
                      ,p_ESTIMATED_START_DATE    => l_estimated_start_date
                      ,p_ESTIMATED_FINISH_DATE   => l_estimated_finish_date
                      ,p_PUBLISHED_FLAG          => l_published_flag
                      ,p_PUBLISHED_BY_PARTY_ID   => l_published_by_party_id
                      ,p_PROGRESS_COMMENT        => l_progress_comment
                      ,p_HISTORY_FLAG            => 'N'
                ,p_status_code             => l_task_status
                      ,x_PERCENT_COMPLETE_ID     => l_percent_complete_id
                      ,p_ATTRIBUTE_CATEGORY      => null
                      ,p_ATTRIBUTE1              => null
                      ,p_ATTRIBUTE2              => null
                      ,p_ATTRIBUTE3              => null
                      ,p_ATTRIBUTE4              => null
                      ,p_ATTRIBUTE5              => null
                      ,p_ATTRIBUTE6              => null
                      ,p_ATTRIBUTE7              => null
                      ,p_ATTRIBUTE8              => null
                      ,p_ATTRIBUTE9              => null
                      ,p_ATTRIBUTE10             => null
                      ,p_ATTRIBUTE11             => null
                      ,p_ATTRIBUTE12             => null
                      ,p_ATTRIBUTE13             => null
                      ,p_ATTRIBUTE14             => null
                      ,p_ATTRIBUTE15             => null
                ,p_structure_type        => p_structure_type
				,X_CBS_ELEMENT_ID					=> l_cbs_element_id --Added for 16200605
        );

Line: 2865


            pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'INSERTED IN PPC', x_Log_Level=> 3);

Line: 2888


            pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_PROGRESS_ROLLUP_ID '||l_PROGRESS_ROLLUP_ID, x_Log_Level=> 3);

Line: 2895


               pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'INSERTING IN PPR', x_Log_Level=> 3);

Line: 2898


            PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
                       X_PROGRESS_ROLLUP_ID              => l_PROGRESS_ROLLUP_ID
                      ,X_PROJECT_ID                      => p_project_id
                      --,X_OBJECT_ID                       => l_assignment_id    --bug# 3764224 Changes for RLM
                      ,X_OBJECT_ID                       => l_resource_list_member_id
                      ,X_OBJECT_TYPE                     => l_object_type
                      ,X_AS_OF_DATE                      => p_as_of_date
		,X_OBJECT_VERSION_ID          => l_object_version_id
                      ,X_LAST_UPDATE_DATE                => SYSDATE
                      ,X_LAST_UPDATED_BY                 => l_user_id
                      ,X_CREATION_DATE                   => SYSDATE
                      ,X_CREATED_BY                      => l_user_id
                ,X_PROGRESS_STATUS_CODE            => l_rollup_progress_status
                      ,X_LAST_UPDATE_LOGIN               => l_login_id
                      ,X_INCREMENTAL_WORK_QTY            => l_INCREMENTAL_WORK_QTY
                      ,X_CUMULATIVE_WORK_QTY             => l_CUMULATIVE_WORK_QTY
                      ,X_BASE_PERCENT_COMPLETE           => l_BASE_PERCENT_COMPLETE
                      ,X_EFF_ROLLUP_PERCENT_COMP         => l_EFF_ROLLUP_PERCENT_COMP
                      ,X_COMPLETED_PERCENTAGE            => l_rollup_completed_percentage
                      ,X_ESTIMATED_START_DATE            => l_estimated_start_date
                      ,X_ESTIMATED_FINISH_DATE           => l_estimated_finish_date
                      ,X_ACTUAL_START_DATE               => l_actual_start_date
                      ,X_ACTUAL_FINISH_DATE              => l_actual_finish_date
                      ,X_EST_REMAINING_EFFORT            => l_ppl_etc_effort
                      ,X_BASE_PERCENT_COMP_DERIV_CODE    => l_BASE_PERCENT_COMP_DERIV_CODE
                      ,X_BASE_PROGRESS_STATUS_CODE       => l_date_override_flag -- 4533112 l_BASE_PROGRESS_STATUS_CODE
                      ,X_EFF_ROLLUP_PROG_STAT_CODE       => l_EFF_ROLLUP_PROG_STAT_CODE
                ,x_percent_complete_id             => l_percent_complete_id
                ,X_STRUCTURE_TYPE                  => p_structure_type
                ,X_PROJ_ELEMENT_ID                 => p_task_id
                      ,X_STRUCTURE_VERSION_ID            => l_structure_version_id
                      ,X_PPL_ACT_EFFORT_TO_DATE          => l_ppl_act_effort_to_date
                      ,X_EQPMT_ACT_EFFORT_TO_DATE        => l_eqpmt_act_effort_to_date
                      ,X_EQPMT_ETC_EFFORT                => l_eqpmt_etc_effort
                      ,X_OTH_ACT_COST_TO_DATE_TC   => l_oth_act_bur_cost_to_date_tc
                      ,X_OTH_ACT_COST_TO_DATE_FC   => l_oth_act_bur_cost_to_date_fc
                      ,X_OTH_ACT_COST_TO_DATE_PC   => l_oth_act_bur_cost_to_date_pc
                      ,X_OTH_ETC_COST_TC                 => l_oth_etc_bur_cost_tc
                      ,X_OTH_ETC_COST_FC                 => l_oth_etc_bur_cost_fc
                      ,X_OTH_ETC_COST_PC                 => l_oth_etc_bur_cost_pc
                      ,X_PPL_ACT_COST_TO_DATE_TC   => l_ppl_act_bur_cost_to_date_tc
                      ,X_PPL_ACT_COST_TO_DATE_FC   => l_ppl_act_bur_cost_to_date_fc
                      ,X_PPL_ACT_COST_TO_DATE_PC   => l_ppl_act_bur_cost_to_date_pc
                      ,X_PPL_ETC_COST_TC                 => l_ppl_etc_bur_cost_tc
                      ,X_PPL_ETC_COST_FC                 => l_ppl_etc_bur_cost_fc
                      ,X_PPL_ETC_COST_PC                 => l_ppl_etc_bur_cost_pc
                      ,X_EQPMT_ACT_COST_TO_DATE_TC      => l_eqp_act_bur_cost_to_date_tc
                      ,X_EQPMT_ACT_COST_TO_DATE_FC      => l_eqp_act_bur_cost_to_date_fc
                      ,X_EQPMT_ACT_COST_TO_DATE_PC      => l_eqp_act_bur_cost_to_date_pc
                      ,X_EQPMT_ETC_COST_TC               => l_eqpmt_etc_bur_cost_tc
                      ,X_EQPMT_ETC_COST_FC               => l_eqpmt_etc_bur_cost_fc
                      ,X_EQPMT_ETC_COST_PC               => l_eqpmt_etc_bur_cost_pc
                      ,X_EARNED_VALUE                    => null
                      ,X_TASK_WT_BASIS_CODE              => null
                      ,X_SUBPRJ_PPL_ACT_EFFORT           => null
                      ,X_SUBPRJ_EQPMT_ACT_EFFORT         => null
                      ,X_SUBPRJ_PPL_ETC_EFFORT           => null
                      ,X_SUBPRJ_EQPMT_ETC_EFFORT         => null
                      ,X_SBPJ_OTH_ACT_COST_TO_DATE_TC    => null
                      ,X_SBPJ_OTH_ACT_COST_TO_DATE_FC    => null
                      ,X_SBPJ_OTH_ACT_COST_TO_DATE_PC    => null
                      ,X_SUBPRJ_PPL_ACT_COST_TC          => null
                      ,X_SUBPRJ_PPL_ACT_COST_FC          => null
                      ,X_SUBPRJ_PPL_ACT_COST_PC          => null
                      ,X_SUBPRJ_EQPMT_ACT_COST_TC        => null
                      ,X_SUBPRJ_EQPMT_ACT_COST_FC        => null
                      ,X_SUBPRJ_EQPMT_ACT_COST_PC        => null
                      ,X_SUBPRJ_OTH_ETC_COST_TC          => null
                      ,X_SUBPRJ_OTH_ETC_COST_FC          => null
                      ,X_SUBPRJ_OTH_ETC_COST_PC          => null
                      ,X_SUBPRJ_PPL_ETC_COST_TC          => null
                      ,X_SUBPRJ_PPL_ETC_COST_FC          => null
                      ,X_SUBPRJ_PPL_ETC_COST_PC          => null
                      ,X_SUBPRJ_EQPMT_ETC_COST_TC        => null
                      ,X_SUBPRJ_EQPMT_ETC_COST_FC        => null
                      ,X_SUBPRJ_EQPMT_ETC_COST_PC        => null
                ,X_SUBPRJ_EARNED_VALUE             => null
                ,X_CURRENT_FLAG               => l_rollup_current_flag -- Bug 3879461 l_current_flag
                ,X_PROJFUNC_COST_RATE_TYPE         => l_projfunc_cost_rate_type
                ,X_PROJFUNC_COST_EXCHANGE_RATE     => l_projfunc_cost_exch_rate
                ,X_PROJFUNC_COST_RATE_DATE         => l_projfunc_cost_rate_date
                ,X_PROJ_COST_RATE_TYPE             => l_project_rate_type
                ,X_PROJ_COST_EXCHANGE_RATE         => l_project_exch_rate
                ,X_PROJ_COST_RATE_DATE             => l_project_rate_date
                ,X_TXN_CURRENCY_CODE          =>  l_txn_currency_code -- Fix for Bug # 3988457.
						  -- p_txn_currency_code    --maansari4/30
                ,X_PROG_PA_PERIOD_NAME        => l_prog_pa_period_name
                ,X_PROG_GL_PERIOD_NAME        => l_prog_gl_period_name
                --bug 3608801
                ,X_OTH_QUANTITY_TO_DATE            => l_oth_quantity_to_date  -- bug no.3608801
                     ,X_OTH_ETC_QUANTITY                => l_oth_etc_quantity
                --bug 3608801
                      ,X_OTH_ACT_RAWCOST_TO_DATE_TC     => l_oth_act_raw_cost_to_date_tc
                      ,X_OTH_ACT_RAWCOST_TO_DATE_FC     => l_oth_act_raw_cost_to_date_fc
                      ,X_OTH_ACT_RAWCOST_TO_DATE_PC     => l_oth_act_raw_cost_to_date_pc
                      ,X_OTH_ETC_RAWCOST_TC        => l_oth_etc_raw_cost_tc
                      ,X_OTH_ETC_RAWCOST_FC        => l_oth_etc_raw_cost_fc
                      ,X_OTH_ETC_RAWCOST_PC        => l_oth_etc_raw_cost_pc
                      ,X_PPL_ACT_RAWCOST_TO_DATE_TC     => l_ppl_act_raw_cost_to_date_tc
                      ,X_PPL_ACT_RAWCOST_TO_DATE_FC     => l_ppl_act_raw_cost_to_date_fc
                      ,X_PPL_ACT_RAWCOST_TO_DATE_PC     => l_ppl_act_raw_cost_to_date_pc
                      ,X_PPL_ETC_RAWCOST_TC        => l_ppl_etc_raw_cost_tc
                      ,X_PPL_ETC_RAWCOST_FC        => l_ppl_etc_raw_cost_fc
                      ,X_PPL_ETC_RAWCOST_PC        => l_ppl_etc_raw_cost_pc
                      ,X_EQPMT_ACT_RAWCOST_TO_DATE_TC   => l_eqp_act_raw_cost_to_date_tc
                      ,X_EQPMT_ACT_RAWCOST_TO_DATE_FC   => l_eqp_act_raw_cost_to_date_fc
                      ,X_EQPMT_ACT_RAWCOST_TO_DATE_PC   => l_eqp_act_raw_cost_to_date_pc
                      ,X_EQPMT_ETC_RAWCOST_TC           => l_eqpmt_etc_raw_cost_tc
                      ,X_EQPMT_ETC_RAWCOST_FC           => l_eqpmt_etc_raw_cost_fc
                      ,X_EQPMT_ETC_RAWCOST_PC           => l_eqpmt_etc_raw_cost_pc
                      ,X_SP_OTH_ACT_RAWCOST_TODATE_TC   => null
                      ,X_SP_OTH_ACT_RAWCOST_TODATE_FC   => null
                      ,X_SP_OTH_ACT_RAWCOST_TODATE_PC   => null
                      ,X_SUBPRJ_PPL_ACT_RAWCOST_TC      => null
                      ,X_SUBPRJ_PPL_ACT_RAWCOST_FC      => null
                      ,X_SUBPRJ_PPL_ACT_RAWCOST_PC      => null
                      ,X_SUBPRJ_EQPMT_ACT_RAWCOST_TC    => null
                      ,X_SUBPRJ_EQPMT_ACT_RAWCOST_FC    => null
                      ,X_SUBPRJ_EQPMT_ACT_RAWCOST_PC    => null
                      ,X_SUBPRJ_OTH_ETC_RAWCOST_TC      => null
                      ,X_SUBPRJ_OTH_ETC_RAWCOST_FC      => null
                      ,X_SUBPRJ_OTH_ETC_RAWCOST_PC      => null
                      ,X_SUBPRJ_PPL_ETC_RAWCOST_TC      => null
                      ,X_SUBPRJ_PPL_ETC_RAWCOST_FC      => null
                      ,X_SUBPRJ_PPL_ETC_RAWCOST_PC      => null
                      ,X_SUBPRJ_EQPMT_ETC_RAWCOST_TC    => null
                      ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC    => null
                      ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC    => null
					  ,X_CBS_ELEMENT_ID					=> l_cbs_element_id --Added for 16200605
            );

Line: 3034


                 pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'INSERTED IN PPR', x_Log_Level=> 3);

Line: 3041


                 pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'UPDATING PPR', x_Log_Level=> 3);

Line: 3044


            PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(
                       X_PROGRESS_ROLLUP_ID              => l_PROGRESS_ROLLUP_ID
                      ,X_PROJECT_ID                      => p_project_id
                      --,X_OBJECT_ID                       => l_assignment_id  --bug# 3764224 Changes for RLM
                      ,X_OBJECT_ID                       => l_resource_list_member_id
                      ,X_OBJECT_TYPE                     => l_object_type
                      ,X_AS_OF_DATE                      => p_as_of_date
                ,X_OBJECT_VERSION_ID          => l_object_version_id
                      ,X_LAST_UPDATE_DATE                => SYSDATE
                      ,X_LAST_UPDATED_BY                 => l_user_id
                ,X_PROGRESS_STATUS_CODE            => l_rollup_progress_status
                      ,X_LAST_UPDATE_LOGIN               => l_login_id
                      ,X_INCREMENTAL_WORK_QTY            => l_INCREMENTAL_WORK_QTY
                      ,X_CUMULATIVE_WORK_QTY             => l_CUMULATIVE_WORK_QTY
                      ,X_BASE_PERCENT_COMPLETE           => l_BASE_PERCENT_COMPLETE
                      ,X_EFF_ROLLUP_PERCENT_COMP         => l_EFF_ROLLUP_PERCENT_COMP
                      ,X_COMPLETED_PERCENTAGE            => l_rollup_completed_percentage
                ,X_ESTIMATED_START_DATE            => l_estimated_start_date
                      ,X_ESTIMATED_FINISH_DATE           => l_estimated_finish_date
                      ,X_ACTUAL_START_DATE               => l_actual_start_date
                      ,X_ACTUAL_FINISH_DATE              => l_actual_finish_date
                      ,X_EST_REMAINING_EFFORT            => l_ppl_etc_effort  -- need to populate the buckets
                      ,X_BASE_PERCENT_COMP_DERIV_CODE    => l_BASE_PERCENT_COMP_DERIV_CODE
                      ,X_BASE_PROGRESS_STATUS_CODE       => l_date_override_flag -- 4533112 l_BASE_PROGRESS_STATUS_CODE
                      ,X_EFF_ROLLUP_PROG_STAT_CODE       => l_EFF_ROLLUP_PROG_STAT_CODE
                ,X_RECORD_VERSION_NUMBER           => l_rollup_rec_ver_number
                      ,x_percent_complete_id             => l_percent_complete_id
                      ,X_STRUCTURE_TYPE                  => p_structure_type
                      ,X_PROJ_ELEMENT_ID                 => p_task_id
                      ,X_STRUCTURE_VERSION_ID            => l_structure_version_id
                      ,X_PPL_ACT_EFFORT_TO_DATE         => l_ppl_act_effort_to_date
                      ,X_EQPMT_ACT_EFFORT_TO_DATE  => l_eqpmt_act_effort_to_date
                      ,X_EQPMT_ETC_EFFORT                => l_eqpmt_etc_effort
                      ,X_OTH_ACT_COST_TO_DATE_TC   => l_oth_act_bur_cost_to_date_tc
                      ,X_OTH_ACT_COST_TO_DATE_FC   => l_oth_act_bur_cost_to_date_fc
                      ,X_OTH_ACT_COST_TO_DATE_PC   => l_oth_act_bur_cost_to_date_pc
                      ,X_OTH_ETC_COST_TC                 => l_oth_etc_bur_cost_tc
                      ,X_OTH_ETC_COST_FC                 => l_oth_etc_bur_cost_fc
                      ,X_OTH_ETC_COST_PC                 => l_oth_etc_bur_cost_pc
                      ,X_PPL_ACT_COST_TO_DATE_TC   => l_ppl_act_bur_cost_to_date_tc
                      ,X_PPL_ACT_COST_TO_DATE_FC   => l_ppl_act_bur_cost_to_date_fc
                      ,X_PPL_ACT_COST_TO_DATE_PC   => l_ppl_act_bur_cost_to_date_pc
                      ,X_PPL_ETC_COST_TC                 => l_ppl_etc_bur_cost_tc
                      ,X_PPL_ETC_COST_FC                 => l_ppl_etc_bur_cost_fc
                      ,X_PPL_ETC_COST_PC                 => l_ppl_etc_bur_cost_pc
                      ,X_EQPMT_ACT_COST_TO_DATE_TC      => l_eqp_act_bur_cost_to_date_tc
                      ,X_EQPMT_ACT_COST_TO_DATE_FC      => l_eqp_act_bur_cost_to_date_fc
                      ,X_EQPMT_ACT_COST_TO_DATE_PC      => l_eqp_act_bur_cost_to_date_pc
                      ,X_EQPMT_ETC_COST_TC               => l_eqpmt_etc_bur_cost_tc
                      ,X_EQPMT_ETC_COST_FC               => l_eqpmt_etc_bur_cost_fc
                      ,X_EQPMT_ETC_COST_PC               => l_eqpmt_etc_bur_cost_pc
                      ,X_EARNED_VALUE                    => null
                      ,X_TASK_WT_BASIS_CODE              => null
                      ,X_SUBPRJ_PPL_ACT_EFFORT           => null
                      ,X_SUBPRJ_EQPMT_ACT_EFFORT         => null
                      ,X_SUBPRJ_PPL_ETC_EFFORT           => null
                      ,X_SUBPRJ_EQPMT_ETC_EFFORT         => null
                      ,X_SBPJ_OTH_ACT_COST_TO_DATE_TC    => null
                      ,X_SBPJ_OTH_ACT_COST_TO_DATE_FC    => null
                      ,X_SBPJ_OTH_ACT_COST_TO_DATE_PC    => null
                      ,X_SUBPRJ_PPL_ACT_COST_TC          => null
                      ,X_SUBPRJ_PPL_ACT_COST_FC          => null
                      ,X_SUBPRJ_PPL_ACT_COST_PC          => null
                      ,X_SUBPRJ_EQPMT_ACT_COST_TC        => null
                      ,X_SUBPRJ_EQPMT_ACT_COST_FC        => null
                      ,X_SUBPRJ_EQPMT_ACT_COST_PC        => null
                      ,X_SUBPRJ_OTH_ETC_COST_TC          => null
                      ,X_SUBPRJ_OTH_ETC_COST_FC          => null
                      ,X_SUBPRJ_OTH_ETC_COST_PC          => null
                      ,X_SUBPRJ_PPL_ETC_COST_TC          => null
                      ,X_SUBPRJ_PPL_ETC_COST_FC          => null
                      ,X_SUBPRJ_PPL_ETC_COST_PC          => null
                      ,X_SUBPRJ_EQPMT_ETC_COST_TC        => null
                      ,X_SUBPRJ_EQPMT_ETC_COST_FC        => null
                      ,X_SUBPRJ_EQPMT_ETC_COST_PC        => null
                      ,X_SUBPRJ_EARNED_VALUE             => null
                ,X_CURRENT_FLAG               => l_rollup_current_flag -- Bug 3879461 l_current_flag
                ,X_PROJFUNC_COST_RATE_TYPE         => l_projfunc_cost_rate_type
                ,X_PROJFUNC_COST_EXCHANGE_RATE     => l_projfunc_cost_exch_rate
                ,X_PROJFUNC_COST_RATE_DATE         => l_projfunc_cost_rate_date
                ,X_PROJ_COST_RATE_TYPE             => l_project_rate_type
                ,X_PROJ_COST_EXCHANGE_RATE         => l_project_exch_rate
                ,X_PROJ_COST_RATE_DATE             => l_project_rate_date
                ,X_TXN_CURRENCY_CODE             =>  l_txn_currency_code -- Fix for Bug # 3988457.
						     -- p_txn_currency_code    --maansari4/30
                ,X_PROG_PA_PERIOD_NAME             => l_prog_pa_period_name
                ,X_PROG_GL_PERIOD_NAME        => l_prog_gl_period_name
                --bug 3608801
                      ,X_OTH_QUANTITY_TO_DATE            => l_oth_quantity_to_date -- bug no.3608801
                      ,X_OTH_ETC_QUANTITY                => l_oth_etc_quantity
                --bug 3608801
                      ,X_OTH_ACT_RAWCOST_TO_DATE_TC     => l_oth_act_raw_cost_to_date_tc
                      ,X_OTH_ACT_RAWCOST_TO_DATE_FC     => l_oth_act_raw_cost_to_date_fc
                      ,X_OTH_ACT_RAWCOST_TO_DATE_PC     => l_oth_act_raw_cost_to_date_pc
                      ,X_OTH_ETC_RAWCOST_TC        => l_oth_etc_raw_cost_tc
                      ,X_OTH_ETC_RAWCOST_FC        => l_oth_etc_raw_cost_fc
                      ,X_OTH_ETC_RAWCOST_PC        => l_oth_etc_raw_cost_pc
                      ,X_PPL_ACT_RAWCOST_TO_DATE_TC     => l_ppl_act_raw_cost_to_date_tc
                      ,X_PPL_ACT_RAWCOST_TO_DATE_FC     => l_ppl_act_raw_cost_to_date_fc
                      ,X_PPL_ACT_RAWCOST_TO_DATE_PC     => l_ppl_act_raw_cost_to_date_pc
                      ,X_PPL_ETC_RAWCOST_TC        => l_ppl_etc_raw_cost_tc
                      ,X_PPL_ETC_RAWCOST_FC        => l_ppl_etc_raw_cost_fc
                      ,X_PPL_ETC_RAWCOST_PC        => l_ppl_etc_raw_cost_pc
                      ,X_EQPMT_ACT_RAWCOST_TO_DATE_TC   => l_eqp_act_raw_cost_to_date_tc
                      ,X_EQPMT_ACT_RAWCOST_TO_DATE_FC   => l_eqp_act_raw_cost_to_date_fc
                      ,X_EQPMT_ACT_RAWCOST_TO_DATE_PC   => l_eqp_act_raw_cost_to_date_pc
                      ,X_EQPMT_ETC_RAWCOST_TC           => l_eqpmt_etc_raw_cost_tc
                      ,X_EQPMT_ETC_RAWCOST_FC           => l_eqpmt_etc_raw_cost_fc
                      ,X_EQPMT_ETC_RAWCOST_PC           => l_eqpmt_etc_raw_cost_pc
                      ,X_SP_OTH_ACT_RAWCOST_TODATE_TC   => null
                      ,X_SP_OTH_ACT_RAWCOST_TODATE_FC   => null
                      ,X_SP_OTH_ACT_RAWCOST_TODATE_PC   => null
                      ,X_SUBPRJ_PPL_ACT_RAWCOST_TC      => null
                      ,X_SUBPRJ_PPL_ACT_RAWCOST_FC      => null
                      ,X_SUBPRJ_PPL_ACT_RAWCOST_PC      => null
                      ,X_SUBPRJ_EQPMT_ACT_RAWCOST_TC    => null
                      ,X_SUBPRJ_EQPMT_ACT_RAWCOST_FC    => null
                      ,X_SUBPRJ_EQPMT_ACT_RAWCOST_PC    => null
                      ,X_SUBPRJ_OTH_ETC_RAWCOST_TC      => null
                      ,X_SUBPRJ_OTH_ETC_RAWCOST_FC      => null
                      ,X_SUBPRJ_OTH_ETC_RAWCOST_PC      => null
                      ,X_SUBPRJ_PPL_ETC_RAWCOST_TC      => null
                      ,X_SUBPRJ_PPL_ETC_RAWCOST_FC      => null
                      ,X_SUBPRJ_PPL_ETC_RAWCOST_PC      => null
                      ,X_SUBPRJ_EQPMT_ETC_RAWCOST_TC    => null
                      ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC    => null
                      ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC    => null
					  ,X_CBS_ELEMENT_ID					=> l_cbs_element_id --Added for 16200605
            );

Line: 3180


    ELSIF l_db_action = 'UPDATE'
    THEN
        IF  l_working_aod IS NOT NULL
        THEN
            l_aod := l_working_aod;

Line: 3211


          SELECT record_version_number into l_record_version_number
          FROM pa_percent_completes
          where percent_complete_id = l_percent_complete_id;

Line: 3215


		--DEBUG_DJ('After SELECT INTO 3313');

Line: 3223


           pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_percent_complete_id: '||l_percent_complete_id, x_Log_Level=> 3);

Line: 3227


        PA_PERCENT_COMPLETES_PKG.UPDATE_ROW(
                       p_TASK_ID                 => l_task_id
                      ,p_DATE_COMPUTED           => p_as_of_date
                      ,p_LAST_UPDATE_DATE        => SYSDATE
                      ,p_LAST_UPDATED_BY         => l_user_id
                      ,p_LAST_UPDATE_LOGIN       => l_login_id
                ,p_COMPLETED_PERCENTAGE    => l_percent_complete
                      ,p_DESCRIPTION             => l_brief_overview
                ,p_PM_PRODUCT_CODE         => l_pm_product_code
                ,p_CURRENT_FLAG            => l_current_flag
                ,p_PERCENT_COMPLETE_ID     => l_percent_complete_id
                      ,p_project_id              => p_project_id
                      ,p_OBJECT_TYPE             => l_object_type
                      --,p_OBJECT_ID               => l_assignment_id  --bug# 3764224 Changes for RLM
                      ,p_OBJECT_ID               => l_resource_list_member_id
                ,p_OBJECT_VERSION_ID       => l_object_version_id
                ,p_PROGRESS_STATUS_CODE    => l_progress_status_code
                      ,p_ACTUAL_START_DATE       => l_actual_start_date
                      ,p_ACTUAL_FINISH_DATE      => l_actual_finish_date
                      ,p_ESTIMATED_START_DATE    => l_estimated_start_date
                      ,p_ESTIMATED_FINISH_DATE   => l_estimated_finish_date
                      ,p_PUBLISHED_FLAG          => l_published_flag
                      ,p_PUBLISHED_BY_PARTY_ID   => l_published_by_party_id
                      ,p_PROGRESS_COMMENT        => l_progress_comment
                      ,p_HISTORY_FLAG            => 'N'
                ,p_status_code             => l_task_status
                      ,p_RECORD_VERSION_NUMBER   => l_record_version_number
                      ,p_ATTRIBUTE_CATEGORY      => null
                      ,p_ATTRIBUTE1              => null
                      ,p_ATTRIBUTE2              => null
                      ,p_ATTRIBUTE3              => null
                      ,p_ATTRIBUTE4              => null
                      ,p_ATTRIBUTE5              => null
                      ,p_ATTRIBUTE6              => null
                      ,p_ATTRIBUTE7              => null
                      ,p_ATTRIBUTE8              => null
                      ,p_ATTRIBUTE9              => null
                      ,p_ATTRIBUTE10             => null
                      ,p_ATTRIBUTE11             => null
                      ,p_ATTRIBUTE12             => null
                      ,p_ATTRIBUTE13             => null
                      ,p_ATTRIBUTE14             => null
                      ,p_ATTRIBUTE15             => null
                ,p_structure_type        => p_structure_type
				,X_CBS_ELEMENT_ID					=> l_cbs_element_id --Added for 16200605

        );

Line: 3297


             pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_PROGRESS_ROLLUP_ID: '||l_PROGRESS_ROLLUP_ID, x_Log_Level=> 3);

Line: 3303


            PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(
                       X_PROGRESS_ROLLUP_ID              => l_PROGRESS_ROLLUP_ID
                      ,X_PROJECT_ID                      => p_project_id
                      --,X_OBJECT_ID                       => l_assignment_id   --bug# 3764224 Changes for RLM
                      ,X_OBJECT_ID                       => l_resource_list_member_id
                      ,X_OBJECT_TYPE                     => l_object_type
                      ,X_AS_OF_DATE                      => p_as_of_date
                ,X_OBJECT_VERSION_ID          => l_object_version_id
                      ,X_LAST_UPDATE_DATE                => SYSDATE
                      ,X_LAST_UPDATED_BY                 => l_user_id
                ,X_PROGRESS_STATUS_CODE            => l_rollup_progress_status
                      ,X_LAST_UPDATE_LOGIN               => l_login_id
                      ,X_INCREMENTAL_WORK_QTY            => l_INCREMENTAL_WORK_QTY
                      ,X_CUMULATIVE_WORK_QTY             => l_CUMULATIVE_WORK_QTY
                      ,X_BASE_PERCENT_COMPLETE           => l_BASE_PERCENT_COMPLETE
                      ,X_EFF_ROLLUP_PERCENT_COMP         => l_EFF_ROLLUP_PERCENT_COMP
                      ,X_COMPLETED_PERCENTAGE            => l_rollup_completed_percentage
                ,X_ESTIMATED_START_DATE            => l_estimated_start_date
                      ,X_ESTIMATED_FINISH_DATE           => l_estimated_finish_date
                      ,X_ACTUAL_START_DATE               => l_actual_start_date
                      ,X_ACTUAL_FINISH_DATE              => l_actual_finish_date
                      ,X_EST_REMAINING_EFFORT            => l_ppl_etc_effort  -- need to populate the buckets
                      ,X_BASE_PERCENT_COMP_DERIV_CODE    => l_BASE_PERCENT_COMP_DERIV_CODE
                      ,X_BASE_PROGRESS_STATUS_CODE       => l_date_override_flag -- 4533112 l_BASE_PROGRESS_STATUS_CODE
                      ,X_EFF_ROLLUP_PROG_STAT_CODE       => l_EFF_ROLLUP_PROG_STAT_CODE
                ,X_RECORD_VERSION_NUMBER           => l_rollup_rec_ver_number
                      ,x_percent_complete_id             => l_percent_complete_id
                      ,X_STRUCTURE_TYPE                  => p_structure_type
                      ,X_PROJ_ELEMENT_ID                 => p_task_id
                      ,X_STRUCTURE_VERSION_ID            => l_structure_version_id
                      ,X_PPL_ACT_EFFORT_TO_DATE         => l_ppl_act_effort_to_date
                      ,X_EQPMT_ACT_EFFORT_TO_DATE  => l_eqpmt_act_effort_to_date
                      ,X_EQPMT_ETC_EFFORT                => l_eqpmt_etc_effort
                      ,X_OTH_ACT_COST_TO_DATE_TC   => l_oth_act_bur_cost_to_date_tc
                      ,X_OTH_ACT_COST_TO_DATE_FC   => l_oth_act_bur_cost_to_date_fc
                      ,X_OTH_ACT_COST_TO_DATE_PC   => l_oth_act_bur_cost_to_date_pc
                      ,X_OTH_ETC_COST_TC                 => l_oth_etc_bur_cost_tc
                      ,X_OTH_ETC_COST_FC                 => l_oth_etc_bur_cost_fc
                      ,X_OTH_ETC_COST_PC                 => l_oth_etc_bur_cost_pc
                      ,X_PPL_ACT_COST_TO_DATE_TC   => l_ppl_act_bur_cost_to_date_tc
                      ,X_PPL_ACT_COST_TO_DATE_FC   => l_ppl_act_bur_cost_to_date_fc
                      ,X_PPL_ACT_COST_TO_DATE_PC   => l_ppl_act_bur_cost_to_date_pc
                      ,X_PPL_ETC_COST_TC                 => l_ppl_etc_bur_cost_tc
                      ,X_PPL_ETC_COST_FC                 => l_ppl_etc_bur_cost_fc
                      ,X_PPL_ETC_COST_PC                 => l_ppl_etc_bur_cost_pc
                      ,X_EQPMT_ACT_COST_TO_DATE_TC      => l_eqp_act_bur_cost_to_date_tc
                      ,X_EQPMT_ACT_COST_TO_DATE_FC      => l_eqp_act_bur_cost_to_date_fc
                      ,X_EQPMT_ACT_COST_TO_DATE_PC      => l_eqp_act_bur_cost_to_date_pc
                      ,X_EQPMT_ETC_COST_TC               => l_eqpmt_etc_bur_cost_tc
                      ,X_EQPMT_ETC_COST_FC               => l_eqpmt_etc_bur_cost_fc
                      ,X_EQPMT_ETC_COST_PC               => l_eqpmt_etc_bur_cost_pc
                      ,X_EARNED_VALUE                    => null
                      ,X_TASK_WT_BASIS_CODE              => null
                      ,X_SUBPRJ_PPL_ACT_EFFORT           => null
                      ,X_SUBPRJ_EQPMT_ACT_EFFORT         => null
                      ,X_SUBPRJ_PPL_ETC_EFFORT           => null
                      ,X_SUBPRJ_EQPMT_ETC_EFFORT         => null
                      ,X_SBPJ_OTH_ACT_COST_TO_DATE_TC    => null
                      ,X_SBPJ_OTH_ACT_COST_TO_DATE_FC    => null
                      ,X_SBPJ_OTH_ACT_COST_TO_DATE_PC    => null
                      ,X_SUBPRJ_PPL_ACT_COST_TC          => null
                      ,X_SUBPRJ_PPL_ACT_COST_FC          => null
                      ,X_SUBPRJ_PPL_ACT_COST_PC          => null
                      ,X_SUBPRJ_EQPMT_ACT_COST_TC        => null
                      ,X_SUBPRJ_EQPMT_ACT_COST_FC        => null
                      ,X_SUBPRJ_EQPMT_ACT_COST_PC        => null
                      ,X_SUBPRJ_OTH_ETC_COST_TC          => null
                      ,X_SUBPRJ_OTH_ETC_COST_FC          => null
                      ,X_SUBPRJ_OTH_ETC_COST_PC          => null
                      ,X_SUBPRJ_PPL_ETC_COST_TC          => null
                      ,X_SUBPRJ_PPL_ETC_COST_FC          => null
                      ,X_SUBPRJ_PPL_ETC_COST_PC          => null
                      ,X_SUBPRJ_EQPMT_ETC_COST_TC        => null
                      ,X_SUBPRJ_EQPMT_ETC_COST_FC        => null
                      ,X_SUBPRJ_EQPMT_ETC_COST_PC        => null
                      ,X_SUBPRJ_EARNED_VALUE             => null
                ,X_CURRENT_FLAG               => l_rollup_current_flag -- Bug 3879461 l_current_flag
                ,X_PROJFUNC_COST_RATE_TYPE         => l_projfunc_cost_rate_type
                ,X_PROJFUNC_COST_EXCHANGE_RATE     => l_projfunc_cost_exch_rate
                ,X_PROJFUNC_COST_RATE_DATE         => l_projfunc_cost_rate_date
                ,X_PROJ_COST_RATE_TYPE             => l_project_rate_type
                ,X_PROJ_COST_EXCHANGE_RATE         => l_project_exch_rate
                ,X_PROJ_COST_RATE_DATE             => l_project_rate_date
                ,X_TXN_CURRENCY_CODE             =>  l_txn_currency_code -- Fix for Bug # 3988457.
						     -- p_txn_currency_code    --maansari4/30
                ,X_PROG_PA_PERIOD_NAME             => l_prog_pa_period_name
                ,X_PROG_GL_PERIOD_NAME        => l_prog_gl_period_name
                --bug 3608801
                      ,X_OTH_QUANTITY_TO_DATE            => l_oth_quantity_to_date  -- bug no.3608801
                      ,X_OTH_ETC_QUANTITY                => l_oth_etc_quantity
                --bug 3608801
                      ,X_OTH_ACT_RAWCOST_TO_DATE_TC     => l_oth_act_raw_cost_to_date_tc
                      ,X_OTH_ACT_RAWCOST_TO_DATE_FC     => l_oth_act_raw_cost_to_date_fc
                      ,X_OTH_ACT_RAWCOST_TO_DATE_PC     => l_oth_act_raw_cost_to_date_pc
                      ,X_OTH_ETC_RAWCOST_TC        => l_oth_etc_raw_cost_tc
                      ,X_OTH_ETC_RAWCOST_FC        => l_oth_etc_raw_cost_fc
                      ,X_OTH_ETC_RAWCOST_PC        => l_oth_etc_raw_cost_pc
                      ,X_PPL_ACT_RAWCOST_TO_DATE_TC     => l_ppl_act_raw_cost_to_date_tc
                      ,X_PPL_ACT_RAWCOST_TO_DATE_FC     => l_ppl_act_raw_cost_to_date_fc
                      ,X_PPL_ACT_RAWCOST_TO_DATE_PC     => l_ppl_act_raw_cost_to_date_pc
                      ,X_PPL_ETC_RAWCOST_TC        => l_ppl_etc_raw_cost_tc
                      ,X_PPL_ETC_RAWCOST_FC        => l_ppl_etc_raw_cost_fc
                      ,X_PPL_ETC_RAWCOST_PC        => l_ppl_etc_raw_cost_pc
                      ,X_EQPMT_ACT_RAWCOST_TO_DATE_TC   => l_eqp_act_raw_cost_to_date_tc
                      ,X_EQPMT_ACT_RAWCOST_TO_DATE_FC   => l_eqp_act_raw_cost_to_date_fc
                      ,X_EQPMT_ACT_RAWCOST_TO_DATE_PC   => l_eqp_act_raw_cost_to_date_pc
                      ,X_EQPMT_ETC_RAWCOST_TC           => l_eqpmt_etc_raw_cost_tc
                      ,X_EQPMT_ETC_RAWCOST_FC           => l_eqpmt_etc_raw_cost_fc
                      ,X_EQPMT_ETC_RAWCOST_PC           => l_eqpmt_etc_raw_cost_pc
                ,X_SP_OTH_ACT_RAWCOST_TODATE_TC    => null
                      ,X_SP_OTH_ACT_RAWCOST_TODATE_FC   => null
                      ,X_SP_OTH_ACT_RAWCOST_TODATE_PC   => null
                      ,X_SUBPRJ_PPL_ACT_RAWCOST_TC      => null
                      ,X_SUBPRJ_PPL_ACT_RAWCOST_FC      => null
                      ,X_SUBPRJ_PPL_ACT_RAWCOST_PC      => null
                      ,X_SUBPRJ_EQPMT_ACT_RAWCOST_TC    => null
                      ,X_SUBPRJ_EQPMT_ACT_RAWCOST_FC    => null
                      ,X_SUBPRJ_EQPMT_ACT_RAWCOST_PC    => null
                      ,X_SUBPRJ_OTH_ETC_RAWCOST_TC      => null
                      ,X_SUBPRJ_OTH_ETC_RAWCOST_FC      => null
                      ,X_SUBPRJ_OTH_ETC_RAWCOST_PC      => null
                      ,X_SUBPRJ_PPL_ETC_RAWCOST_TC      => null
                      ,X_SUBPRJ_PPL_ETC_RAWCOST_FC      => null
                      ,X_SUBPRJ_PPL_ETC_RAWCOST_PC      => null
                      ,X_SUBPRJ_EQPMT_ETC_RAWCOST_TC    => null
                      ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC    => null
                      ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC    => null
					  ,X_CBS_ELEMENT_ID					=> l_cbs_element_id --Added for 16200605

            );

Line: 3438


            PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
                       X_PROGRESS_ROLLUP_ID              => l_PROGRESS_ROLLUP_ID
                      ,X_PROJECT_ID                      => p_project_id
                      --,X_OBJECT_ID                       => l_assignment_id  --bug# 3764224 Changes for RLM
                      ,X_OBJECT_ID                       => l_resource_list_member_id
                      ,X_OBJECT_TYPE                     => l_object_type
                      ,X_AS_OF_DATE                      => p_as_of_date
                ,X_OBJECT_VERSION_ID          => l_object_version_id
                      ,X_LAST_UPDATE_DATE                => SYSDATE
                      ,X_LAST_UPDATED_BY                 => l_user_id
                      ,X_CREATION_DATE                   => SYSDATE
                      ,X_CREATED_BY                      => l_user_id
                ,X_PROGRESS_STATUS_CODE            => l_rollup_progress_status
                      ,X_LAST_UPDATE_LOGIN               => l_login_id
                      ,X_INCREMENTAL_WORK_QTY            => l_INCREMENTAL_WORK_QTY
                      ,X_CUMULATIVE_WORK_QTY             => l_CUMULATIVE_WORK_QTY
                      ,X_BASE_PERCENT_COMPLETE           => l_BASE_PERCENT_COMPLETE
                      ,X_EFF_ROLLUP_PERCENT_COMP         => l_EFF_ROLLUP_PERCENT_COMP
                      ,X_COMPLETED_PERCENTAGE            => l_rollup_completed_percentage
                      ,X_ESTIMATED_START_DATE            => l_estimated_start_date
                      ,X_ESTIMATED_FINISH_DATE           => l_estimated_finish_date
                      ,X_ACTUAL_START_DATE               => l_actual_start_date
                      ,X_ACTUAL_FINISH_DATE              => l_actual_finish_date
                      ,X_EST_REMAINING_EFFORT            => l_ppl_etc_effort
                      ,X_BASE_PERCENT_COMP_DERIV_CODE    => l_BASE_PERCENT_COMP_DERIV_CODE
                      ,X_BASE_PROGRESS_STATUS_CODE       => l_date_override_flag -- 4533112 l_BASE_PROGRESS_STATUS_CODE
                      ,X_EFF_ROLLUP_PROG_STAT_CODE       => l_EFF_ROLLUP_PROG_STAT_CODE
                ,x_percent_complete_id             => l_percent_complete_id
                ,X_STRUCTURE_TYPE                  => p_structure_type
                ,X_PROJ_ELEMENT_ID                 => p_task_id
                      ,X_STRUCTURE_VERSION_ID            => l_structure_version_id
                      ,X_PPL_ACT_EFFORT_TO_DATE          => l_ppl_act_effort_to_date
                      ,X_EQPMT_ACT_EFFORT_TO_DATE        => l_eqpmt_act_effort_to_date
                      ,X_EQPMT_ETC_EFFORT                => l_eqpmt_etc_effort
                      ,X_OTH_ACT_COST_TO_DATE_TC   => l_oth_act_bur_cost_to_date_tc
                      ,X_OTH_ACT_COST_TO_DATE_FC   => l_oth_act_bur_cost_to_date_fc
                      ,X_OTH_ACT_COST_TO_DATE_PC   => l_oth_act_bur_cost_to_date_pc
                      ,X_OTH_ETC_COST_TC                 => l_oth_etc_bur_cost_tc
                      ,X_OTH_ETC_COST_FC                 => l_oth_etc_bur_cost_fc
                      ,X_OTH_ETC_COST_PC                 => l_oth_etc_bur_cost_pc
                      ,X_PPL_ACT_COST_TO_DATE_TC   => l_ppl_act_bur_cost_to_date_tc
                      ,X_PPL_ACT_COST_TO_DATE_FC   => l_ppl_act_bur_cost_to_date_fc
                      ,X_PPL_ACT_COST_TO_DATE_PC   => l_ppl_act_bur_cost_to_date_pc
                      ,X_PPL_ETC_COST_TC                 => l_ppl_etc_bur_cost_tc
                      ,X_PPL_ETC_COST_FC                 => l_ppl_etc_bur_cost_fc
                      ,X_PPL_ETC_COST_PC                 => l_ppl_etc_bur_cost_pc
                      ,X_EQPMT_ACT_COST_TO_DATE_TC      => l_eqp_act_bur_cost_to_date_tc
                      ,X_EQPMT_ACT_COST_TO_DATE_FC      => l_eqp_act_bur_cost_to_date_fc
                      ,X_EQPMT_ACT_COST_TO_DATE_PC      => l_eqp_act_bur_cost_to_date_pc
                      ,X_EQPMT_ETC_COST_TC               => l_eqpmt_etc_bur_cost_tc
                      ,X_EQPMT_ETC_COST_FC               => l_eqpmt_etc_bur_cost_fc
                      ,X_EQPMT_ETC_COST_PC               => l_eqpmt_etc_bur_cost_pc
                      ,X_EARNED_VALUE                    => null
                      ,X_TASK_WT_BASIS_CODE              => null
                      ,X_SUBPRJ_PPL_ACT_EFFORT           => null
                      ,X_SUBPRJ_EQPMT_ACT_EFFORT         => null
                      ,X_SUBPRJ_PPL_ETC_EFFORT           => null
                      ,X_SUBPRJ_EQPMT_ETC_EFFORT         => null
                      ,X_SBPJ_OTH_ACT_COST_TO_DATE_TC    => null
                      ,X_SBPJ_OTH_ACT_COST_TO_DATE_FC    => null
                      ,X_SBPJ_OTH_ACT_COST_TO_DATE_PC    => null
                      ,X_SUBPRJ_PPL_ACT_COST_TC          => null
                      ,X_SUBPRJ_PPL_ACT_COST_FC          => null
                      ,X_SUBPRJ_PPL_ACT_COST_PC          => null
                      ,X_SUBPRJ_EQPMT_ACT_COST_TC        => null
                      ,X_SUBPRJ_EQPMT_ACT_COST_FC        => null
                      ,X_SUBPRJ_EQPMT_ACT_COST_PC        => null
                      ,X_SUBPRJ_OTH_ETC_COST_TC          => null
                      ,X_SUBPRJ_OTH_ETC_COST_FC          => null
                      ,X_SUBPRJ_OTH_ETC_COST_PC          => null
                      ,X_SUBPRJ_PPL_ETC_COST_TC          => null
                      ,X_SUBPRJ_PPL_ETC_COST_FC          => null
                      ,X_SUBPRJ_PPL_ETC_COST_PC          => null
                      ,X_SUBPRJ_EQPMT_ETC_COST_TC        => null
                      ,X_SUBPRJ_EQPMT_ETC_COST_FC        => null
                      ,X_SUBPRJ_EQPMT_ETC_COST_PC        => null
                ,X_SUBPRJ_EARNED_VALUE             => null
                ,X_CURRENT_FLAG               => l_rollup_current_flag -- Bug 3879461 l_current_flag
                ,X_PROJFUNC_COST_RATE_TYPE         => l_projfunc_cost_rate_type
                ,X_PROJFUNC_COST_EXCHANGE_RATE     => l_projfunc_cost_exch_rate
                ,X_PROJFUNC_COST_RATE_DATE         => l_projfunc_cost_rate_date
                ,X_PROJ_COST_RATE_TYPE             => l_project_rate_type
                ,X_PROJ_COST_EXCHANGE_RATE         => l_project_exch_rate
                ,X_PROJ_COST_RATE_DATE             => l_project_rate_date
                ,X_TXN_CURRENCY_CODE          =>  l_txn_currency_code -- Fix for Bug # 3988457.
						  -- p_txn_currency_code    --maansari4/30
                ,X_PROG_PA_PERIOD_NAME        => l_prog_pa_period_name
                ,X_PROG_GL_PERIOD_NAME        => l_prog_gl_period_name
                --bug 3608801
                      ,X_OTH_QUANTITY_TO_DATE            => l_oth_quantity_to_date   -- bug no.3608801
                      ,X_OTH_ETC_QUANTITY                => l_oth_etc_quantity
                --bug 3608801
                      ,X_OTH_ACT_RAWCOST_TO_DATE_TC     => l_oth_act_raw_cost_to_date_tc
                      ,X_OTH_ACT_RAWCOST_TO_DATE_FC     => l_oth_act_raw_cost_to_date_fc
                      ,X_OTH_ACT_RAWCOST_TO_DATE_PC     => l_oth_act_raw_cost_to_date_pc
                      ,X_OTH_ETC_RAWCOST_TC        => l_oth_etc_raw_cost_tc
                      ,X_OTH_ETC_RAWCOST_FC        => l_oth_etc_raw_cost_fc
                      ,X_OTH_ETC_RAWCOST_PC        => l_oth_etc_raw_cost_pc
                      ,X_PPL_ACT_RAWCOST_TO_DATE_TC     => l_ppl_act_raw_cost_to_date_tc
                      ,X_PPL_ACT_RAWCOST_TO_DATE_FC     => l_ppl_act_raw_cost_to_date_fc
                      ,X_PPL_ACT_RAWCOST_TO_DATE_PC     => l_ppl_act_raw_cost_to_date_pc
                      ,X_PPL_ETC_RAWCOST_TC        => l_ppl_etc_raw_cost_tc
                      ,X_PPL_ETC_RAWCOST_FC        => l_ppl_etc_raw_cost_fc
                      ,X_PPL_ETC_RAWCOST_PC        => l_ppl_etc_raw_cost_pc
                      ,X_EQPMT_ACT_RAWCOST_TO_DATE_TC   => l_eqp_act_raw_cost_to_date_tc
                      ,X_EQPMT_ACT_RAWCOST_TO_DATE_FC   => l_eqp_act_raw_cost_to_date_fc
                      ,X_EQPMT_ACT_RAWCOST_TO_DATE_PC   => l_eqp_act_raw_cost_to_date_pc
                      ,X_EQPMT_ETC_RAWCOST_TC           => l_eqpmt_etc_raw_cost_tc
                      ,X_EQPMT_ETC_RAWCOST_FC           => l_eqpmt_etc_raw_cost_fc
                      ,X_EQPMT_ETC_RAWCOST_PC           => l_eqpmt_etc_raw_cost_pc
                ,X_SP_OTH_ACT_RAWCOST_TODATE_TC    => null
                      ,X_SP_OTH_ACT_RAWCOST_TODATE_FC   => null
                      ,X_SP_OTH_ACT_RAWCOST_TODATE_PC   => null
                      ,X_SUBPRJ_PPL_ACT_RAWCOST_TC      => null
                      ,X_SUBPRJ_PPL_ACT_RAWCOST_FC      => null
                      ,X_SUBPRJ_PPL_ACT_RAWCOST_PC      => null
                      ,X_SUBPRJ_EQPMT_ACT_RAWCOST_TC    => null
                      ,X_SUBPRJ_EQPMT_ACT_RAWCOST_FC    => null
                      ,X_SUBPRJ_EQPMT_ACT_RAWCOST_PC    => null
                      ,X_SUBPRJ_OTH_ETC_RAWCOST_TC      => null
                      ,X_SUBPRJ_OTH_ETC_RAWCOST_FC      => null
                      ,X_SUBPRJ_OTH_ETC_RAWCOST_PC      => null
                      ,X_SUBPRJ_PPL_ETC_RAWCOST_TC      => null
                      ,X_SUBPRJ_PPL_ETC_RAWCOST_FC      => null
                      ,X_SUBPRJ_PPL_ETC_RAWCOST_PC      => null
                      ,X_SUBPRJ_EQPMT_ETC_RAWCOST_TC    => null
                      ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC    => null
                      ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC    => null
					  ,X_CBS_ELEMENT_ID					=> l_cbs_element_id --Added for 16200605

            );

Line: 3576


             pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'COMPLETED ', x_Log_Level=> 3);

Line: 3617


             pa_fp_planning_transaction_pub.update_planning_transactions
             (
               p_context                      => 'WORKPLAN'
              ,p_struct_elem_version_id       => p_structure_version_id
              ,p_task_elem_version_id_tbl     => l_task_elem_version_id_tbl
              ,p_planned_people_effort_tbl    => l_planned_people_effort_tbl
              ,p_planned_equip_effort_tbl     => l_planned_equip_effort_tbl
              ,p_resource_assignment_id_tbl   => l_resource_assignment_id_tbl
              ,p_resource_list_member_id_tbl  => l_resource_list_member_id_tbl
              ,p_resource_class_code_tbl      => l_resource_class_code_tbl
     --            ,p_start_date_tbl               => l_start_date_tbl
     --            ,p_end_date_tbl                 => l_end_date_tbl
              ,x_return_status                => l_return_status
              ,x_msg_count                    => l_msg_count
              ,x_msg_data                     => l_msg_data
             );

Line: 3636


                              p_procedure_name => 'UPDATE_ASSIGNMENT_PROGRESS',
                              p_error_text     => SUBSTRB('pa_fp_planning_transaction_pub.update_planning_transactions:'||SQLERRM,1,240));

Line: 3646


           pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'EXITING ', x_Log_Level=> 3);

Line: 3655


         rollback to UPDATE_ASSIGNMENT_PROGRESS;

Line: 3679


         rollback to UPDATE_ASSIGNMENT_PROGRESS;

Line: 3683


                              p_procedure_name => 'UPDATE_ASSIGNMENT_PROGRESS',
                              p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 3690


         rollback to UPDATE_DELIVERABLE_PROGRESS;

Line: 3694


                              p_procedure_name => 'UPDATE_ASSIGNMENT_PROGRESS',
                              p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 3699


END UPDATE_ASSIGNMENT_PROGRESS;