The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure INSERT_ROW(
X_PROGRESS_ROLLUP_ID IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
,X_PROJECT_ID IN NUMBER
,X_OBJECT_ID IN NUMBER
,X_OBJECT_TYPE IN VARCHAR2
,X_AS_OF_DATE IN DATE
,X_OBJECT_VERSION_ID IN NUMBER
,X_LAST_UPDATE_DATE IN DATE
,X_LAST_UPDATED_BY IN NUMBER
,X_CREATION_DATE IN DATE
,X_CREATED_BY IN NUMBER
,X_PROGRESS_STATUS_CODE IN VARCHAR2
,X_LAST_UPDATE_LOGIN IN NUMBER
,X_INCREMENTAL_WORK_QTY IN NUMBER
,X_CUMULATIVE_WORK_QTY IN NUMBER
,X_BASE_PERCENT_COMPLETE IN NUMBER
,X_EFF_ROLLUP_PERCENT_COMP IN NUMBER
,X_COMPLETED_PERCENTAGE IN NUMBER
,X_ESTIMATED_START_DATE IN DATE
,X_ESTIMATED_FINISH_DATE IN DATE
,X_ACTUAL_START_DATE IN DATE
,X_ACTUAL_FINISH_DATE IN DATE
,X_EST_REMAINING_EFFORT IN NUMBER
,X_BASE_PERCENT_COMP_DERIV_CODE IN VARCHAR2
,X_BASE_PROGRESS_STATUS_CODE IN VARCHAR2
,X_EFF_ROLLUP_PROG_STAT_CODE IN VARCHAR2
,x_percent_complete_id in number
,X_STRUCTURE_TYPE IN VARCHAR2
,X_PROJ_ELEMENT_ID IN NUMBER
,X_STRUCTURE_VERSION_ID IN NUMBER
,X_PPL_ACT_EFFORT_TO_DATE IN NUMBER
,X_EQPMT_ACT_EFFORT_TO_DATE IN NUMBER
,X_EQPMT_ETC_EFFORT IN NUMBER
,X_OTH_ACT_COST_TO_DATE_TC IN NUMBER
,X_OTH_ACT_COST_TO_DATE_FC IN NUMBER
,X_OTH_ACT_COST_TO_DATE_PC IN NUMBER
,X_OTH_ETC_COST_TC IN NUMBER
,X_OTH_ETC_COST_FC IN NUMBER
,X_OTH_ETC_COST_PC IN NUMBER
,X_PPL_ACT_COST_TO_DATE_TC IN NUMBER
,X_PPL_ACT_COST_TO_DATE_FC IN NUMBER
,X_PPL_ACT_COST_TO_DATE_PC IN NUMBER
,X_PPL_ETC_COST_TC IN NUMBER
,X_PPL_ETC_COST_FC IN NUMBER
,X_PPL_ETC_COST_PC IN NUMBER
,X_EQPMT_ACT_COST_TO_DATE_TC IN NUMBER
,X_EQPMT_ACT_COST_TO_DATE_FC IN NUMBER
,X_EQPMT_ACT_COST_TO_DATE_PC IN NUMBER
,X_EQPMT_ETC_COST_TC IN NUMBER
,X_EQPMT_ETC_COST_FC IN NUMBER
,X_EQPMT_ETC_COST_PC IN NUMBER
,X_EARNED_VALUE IN NUMBER
,X_TASK_WT_BASIS_CODE IN VARCHAR2
,X_SUBPRJ_PPL_ACT_EFFORT IN NUMBER
,X_SUBPRJ_EQPMT_ACT_EFFORT IN NUMBER
,X_SUBPRJ_PPL_ETC_EFFORT IN NUMBER
,X_SUBPRJ_EQPMT_ETC_EFFORT IN NUMBER
,X_SBPJ_OTH_ACT_COST_TO_DATE_TC IN NUMBER
,X_SBPJ_OTH_ACT_COST_TO_DATE_FC IN NUMBER
,X_SBPJ_OTH_ACT_COST_TO_DATE_PC IN NUMBER
,X_SUBPRJ_PPL_ACT_COST_TC IN NUMBER
,X_SUBPRJ_PPL_ACT_COST_FC IN NUMBER
,X_SUBPRJ_PPL_ACT_COST_PC IN NUMBER
,X_SUBPRJ_EQPMT_ACT_COST_TC IN NUMBER
,X_SUBPRJ_EQPMT_ACT_COST_FC IN NUMBER
,X_SUBPRJ_EQPMT_ACT_COST_PC IN NUMBER
,X_SUBPRJ_OTH_ETC_COST_TC IN NUMBER
,X_SUBPRJ_OTH_ETC_COST_FC IN NUMBER
,X_SUBPRJ_OTH_ETC_COST_PC IN NUMBER
,X_SUBPRJ_PPL_ETC_COST_TC IN NUMBER
,X_SUBPRJ_PPL_ETC_COST_FC IN NUMBER
,X_SUBPRJ_PPL_ETC_COST_PC IN NUMBER
,X_SUBPRJ_EQPMT_ETC_COST_TC IN NUMBER
,X_SUBPRJ_EQPMT_ETC_COST_FC IN NUMBER
,X_SUBPRJ_EQPMT_ETC_COST_PC IN NUMBER
,X_SUBPRJ_EARNED_VALUE IN NUMBER
,X_CURRENT_FLAG IN VARCHAR2
,X_PROJFUNC_COST_RATE_TYPE VARCHAR2
,X_PROJFUNC_COST_EXCHANGE_RATE NUMBER
,X_PROJFUNC_COST_RATE_DATE DATE
,X_PROJ_COST_RATE_TYPE VARCHAR2
,X_PROJ_COST_EXCHANGE_RATE NUMBER
,X_PROJ_COST_RATE_DATE DATE
,X_TXN_CURRENCY_CODE VARCHAR2
,X_PROG_PA_PERIOD_NAME VARCHAR2
,X_PROG_GL_PERIOD_NAME VARCHAR2
,X_OTH_QUANTITY_TO_DATE NUMBER
,X_OTH_ETC_QUANTITY NUMBER
,X_OTH_ACT_RAWCOST_TO_DATE_TC IN NUMBER
,X_OTH_ACT_RAWCOST_TO_DATE_FC IN NUMBER
,X_OTH_ACT_RAWCOST_TO_DATE_PC IN NUMBER
,X_OTH_ETC_RAWCOST_TC IN NUMBER
,X_OTH_ETC_RAWCOST_FC IN NUMBER
,X_OTH_ETC_RAWCOST_PC IN NUMBER
,X_PPL_ACT_RAWCOST_TO_DATE_TC IN NUMBER
,X_PPL_ACT_RAWCOST_TO_DATE_FC IN NUMBER
,X_PPL_ACT_RAWCOST_TO_DATE_PC IN NUMBER
,X_PPL_ETC_RAWCOST_TC IN NUMBER
,X_PPL_ETC_RAWCOST_FC IN NUMBER
,X_PPL_ETC_RAWCOST_PC IN NUMBER
,X_EQPMT_ACT_RAWCOST_TO_DATE_TC IN NUMBER
,X_EQPMT_ACT_RAWCOST_TO_DATE_FC IN NUMBER
,X_EQPMT_ACT_RAWCOST_TO_DATE_PC IN NUMBER
,X_EQPMT_ETC_RAWCOST_TC IN NUMBER
,X_EQPMT_ETC_RAWCOST_FC IN NUMBER
,X_EQPMT_ETC_RAWCOST_PC IN NUMBER
,X_SP_OTH_ACT_RAWCOST_TODATE_TC IN NUMBER
,X_SP_OTH_ACT_RAWCOST_TODATE_FC IN NUMBER
,X_SP_OTH_ACT_RAWCOST_TODATE_PC IN NUMBER
,X_SUBPRJ_PPL_ACT_RAWCOST_TC IN NUMBER
,X_SUBPRJ_PPL_ACT_RAWCOST_FC IN NUMBER
,X_SUBPRJ_PPL_ACT_RAWCOST_PC IN NUMBER
,X_SUBPRJ_EQPMT_ACT_RAWCOST_TC IN NUMBER
,X_SUBPRJ_EQPMT_ACT_RAWCOST_FC IN NUMBER
,X_SUBPRJ_EQPMT_ACT_RAWCOST_PC IN NUMBER
,X_SUBPRJ_OTH_ETC_RAWCOST_TC IN NUMBER
,X_SUBPRJ_OTH_ETC_RAWCOST_FC IN NUMBER
,X_SUBPRJ_OTH_ETC_RAWCOST_PC IN NUMBER
,X_SUBPRJ_PPL_ETC_RAWCOST_TC IN NUMBER
,X_SUBPRJ_PPL_ETC_RAWCOST_FC IN NUMBER
,X_SUBPRJ_PPL_ETC_RAWCOST_PC IN NUMBER
,X_SUBPRJ_EQPMT_ETC_RAWCOST_TC IN NUMBER
,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC IN NUMBER
,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC IN NUMBER
, X_CBS_ELEMENT_ID IN NUMBER DEFAULT NULL --Added for CBS 16200605
) IS
BEGIN
IF X_PROGRESS_ROLLUP_ID IS NULL
THEN
select PA_PROGRESS_ROLLUP_S.nextval
into X_PROGRESS_ROLLUP_ID
from dual;
insert into pa_progress_rollup(
PROGRESS_ROLLUP_ID
,PROJECT_ID
,OBJECT_ID
,OBJECT_TYPE
,AS_OF_DATE
,OBJECT_VERSION_ID
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,CREATION_DATE
,CREATED_BY
,PROGRESS_STATUS_CODE
,LAST_UPDATE_LOGIN
,INCREMENTAL_WORK_QUANTITY
,CUMULATIVE_WORK_QUANTITY
,BASE_PERCENT_COMPLETE
,EFF_ROLLUP_PERCENT_COMP
,COMPLETED_PERCENTAGE
,ESTIMATED_START_DATE
,ESTIMATED_FINISH_DATE
,ACTUAL_START_DATE
,ACTUAL_FINISH_DATE
,ESTIMATED_REMAINING_EFFORT
,RECORD_VERSION_NUMBER
,BASE_PERCENT_COMP_DERIV_CODE
,BASE_PROGRESS_STATUS_CODE
,EFF_ROLLUP_PROG_STAT_CODE
,PERCENT_COMPLETE_ID
,STRUCTURE_TYPE
,PROJ_ELEMENT_ID
,STRUCTURE_VERSION_ID
,PPL_ACT_EFFORT_TO_DATE
,EQPMT_ACT_EFFORT_TO_DATE
,EQPMT_ETC_EFFORT
,OTH_ACT_COST_TO_DATE_TC
,OTH_ACT_COST_TO_DATE_FC
,OTH_ACT_COST_TO_DATE_PC
,OTH_ETC_COST_TC
,OTH_ETC_COST_FC
,OTH_ETC_COST_PC
,PPL_ACT_COST_TO_DATE_TC
,PPL_ACT_COST_TO_DATE_FC
,PPL_ACT_COST_TO_DATE_PC
,PPL_ETC_COST_TC
,PPL_ETC_COST_FC
,PPL_ETC_COST_PC
,EQPMT_ACT_COST_TO_DATE_TC
,EQPMT_ACT_COST_TO_DATE_FC
,EQPMT_ACT_COST_TO_DATE_PC
,EQPMT_ETC_COST_TC
,EQPMT_ETC_COST_FC
,EQPMT_ETC_COST_PC
,EARNED_VALUE
,TASK_WT_BASIS_CODE
,SUBPRJ_PPL_ACT_EFFORT
,SUBPRJ_EQPMT_ACT_EFFORT
,SUBPRJ_PPL_ETC_EFFORT
,SUBPRJ_EQPMT_ETC_EFFORT
,SUBPRJ_OTH_ACT_COST_TO_DT_TC
,SUBPRJ_OTH_ACT_COST_TO_DT_FC
,SUBPRJ_OTH_ACT_COST_TO_DT_PC
,SUBPRJ_PPL_ACT_COST_TC
,SUBPRJ_PPL_ACT_COST_FC
,SUBPRJ_PPL_ACT_COST_PC
,SUBPRJ_EQPMT_ACT_COST_TC
,SUBPRJ_EQPMT_ACT_COST_FC
,SUBPRJ_EQPMT_ACT_COST_PC
,SUBPRJ_OTH_ETC_COST_TC
,SUBPRJ_OTH_ETC_COST_FC
,SUBPRJ_OTH_ETC_COST_PC
,SUBPRJ_PPL_ETC_COST_TC
,SUBPRJ_PPL_ETC_COST_FC
,SUBPRJ_PPL_ETC_COST_PC
,SUBPRJ_EQPMT_ETC_COST_TC
,SUBPRJ_EQPMT_ETC_COST_FC
,SUBPRJ_EQPMT_ETC_COST_PC
,SUBPRJ_EARNED_VALUE
,CURRENT_FLAG
,PROJFUNC_COST_RATE_TYPE
,PROJFUNC_COST_EXCHANGE_RATE
,PROJFUNC_COST_RATE_DATE
,PROJ_COST_RATE_TYPE
,PROJ_COST_EXCHANGE_RATE
,PROJ_COST_RATE_DATE
,TXN_CURRENCY_CODE
,PROG_PA_PERIOD_NAME
,PROG_GL_PERIOD_NAME
,OTH_QUANTITY_TO_DATE
,OTH_ETC_QUANTITY
,OTH_ACT_RAWCOST_TO_DATE_TC
,OTH_ACT_RAWCOST_TO_DATE_FC
,OTH_ACT_RAWCOST_TO_DATE_PC
,OTH_ETC_RAWCOST_TC
,OTH_ETC_RAWCOST_FC
,OTH_ETC_RAWCOST_PC
,PPL_ACT_RAWCOST_TO_DATE_TC
,PPL_ACT_RAWCOST_TO_DATE_FC
,PPL_ACT_RAWCOST_TO_DATE_PC
,PPL_ETC_RAWCOST_TC
,PPL_ETC_RAWCOST_FC
,PPL_ETC_RAWCOST_PC
,EQPMT_ACT_RAWCOST_TO_DATE_TC
,EQPMT_ACT_RAWCOST_TO_DATE_FC
,EQPMT_ACT_RAWCOST_TO_DATE_PC
,EQPMT_ETC_RAWCOST_TC
,EQPMT_ETC_RAWCOST_FC
,EQPMT_ETC_RAWCOST_PC
,SPJ_OTH_ACT_RAWCOST_TO_DT_TC
,SPJ_OTH_ACT_RAWCOST_TO_DT_FC
,SPJ_OTH_ACT_RAWCOST_TO_DT_PC
,SUBPRJ_PPL_ACT_RAWCOST_TC
,SUBPRJ_PPL_ACT_RAWCOST_FC
,SUBPRJ_PPL_ACT_RAWCOST_PC
,SUBPRJ_EQPMT_ACT_RAWCOST_TC
,SUBPRJ_EQPMT_ACT_RAWCOST_FC
,SUBPRJ_EQPMT_ACT_RAWCOST_PC
,SUBPRJ_OTH_ETC_RAWCOST_TC
,SUBPRJ_OTH_ETC_RAWCOST_FC
,SUBPRJ_OTH_ETC_RAWCOST_PC
,SUBPRJ_PPL_ETC_RAWCOST_TC
,SUBPRJ_PPL_ETC_RAWCOST_FC
,SUBPRJ_PPL_ETC_RAWCOST_PC
,SUBPRJ_EQPMT_ETC_RAWCOST_TC
,SUBPRJ_EQPMT_ETC_RAWCOST_FC
,SUBPRJ_EQPMT_ETC_RAWCOST_PC
, cbs_element_id --added for CBS 16200605
) VALUES (
X_PROGRESS_ROLLUP_ID
,X_PROJECT_ID
,X_OBJECT_ID
,X_OBJECT_TYPE
,X_AS_OF_DATE
,X_OBJECT_VERSION_ID
,X_LAST_UPDATE_DATE
,X_LAST_UPDATED_BY
,X_CREATION_DATE
,X_CREATED_BY
,X_PROGRESS_STATUS_CODE
,X_LAST_UPDATE_LOGIN
,X_INCREMENTAL_WORK_QTY
,X_CUMULATIVE_WORK_QTY
,X_BASE_PERCENT_COMPLETE
,X_EFF_ROLLUP_PERCENT_COMP
,X_COMPLETED_PERCENTAGE
,X_ESTIMATED_START_DATE
,X_ESTIMATED_FINISH_DATE
,X_ACTUAL_START_DATE
,X_ACTUAL_FINISH_DATE
,X_EST_REMAINING_EFFORT
,1 ----record version number
,X_BASE_PERCENT_COMP_DERIV_CODE
,X_BASE_PROGRESS_STATUS_CODE
,X_EFF_ROLLUP_PROG_STAT_CODE
,x_PERCENT_COMPLETE_ID
,X_STRUCTURE_TYPE
,X_PROJ_ELEMENT_ID
,X_STRUCTURE_VERSION_ID
,X_PPL_ACT_EFFORT_TO_DATE
,X_EQPMT_ACT_EFFORT_TO_DATE
,X_EQPMT_ETC_EFFORT
,X_OTH_ACT_COST_TO_DATE_TC
,X_OTH_ACT_COST_TO_DATE_FC
,X_OTH_ACT_COST_TO_DATE_PC
,X_OTH_ETC_COST_TC
,X_OTH_ETC_COST_FC
,X_OTH_ETC_COST_PC
,X_PPL_ACT_COST_TO_DATE_TC
,X_PPL_ACT_COST_TO_DATE_FC
,X_PPL_ACT_COST_TO_DATE_PC
,X_PPL_ETC_COST_TC
,X_PPL_ETC_COST_FC
,X_PPL_ETC_COST_PC
,X_EQPMT_ACT_COST_TO_DATE_TC
,X_EQPMT_ACT_COST_TO_DATE_FC
,X_EQPMT_ACT_COST_TO_DATE_PC
,X_EQPMT_ETC_COST_TC
,X_EQPMT_ETC_COST_FC
,X_EQPMT_ETC_COST_PC
,X_EARNED_VALUE
,X_TASK_WT_BASIS_CODE
,X_SUBPRJ_PPL_ACT_EFFORT
,X_SUBPRJ_EQPMT_ACT_EFFORT
,X_SUBPRJ_PPL_ETC_EFFORT
,X_SUBPRJ_EQPMT_ETC_EFFORT
,X_SBPJ_OTH_ACT_COST_TO_DATE_TC
,X_SBPJ_OTH_ACT_COST_TO_DATE_FC
,X_SBPJ_OTH_ACT_COST_TO_DATE_PC
,X_SUBPRJ_PPL_ACT_COST_TC
,X_SUBPRJ_PPL_ACT_COST_FC
,X_SUBPRJ_PPL_ACT_COST_PC
,X_SUBPRJ_EQPMT_ACT_COST_TC
,X_SUBPRJ_EQPMT_ACT_COST_FC
,X_SUBPRJ_EQPMT_ACT_COST_PC
,X_SUBPRJ_OTH_ETC_COST_TC
,X_SUBPRJ_OTH_ETC_COST_FC
,X_SUBPRJ_OTH_ETC_COST_PC
,X_SUBPRJ_PPL_ETC_COST_TC
,X_SUBPRJ_PPL_ETC_COST_FC
,X_SUBPRJ_PPL_ETC_COST_PC
,X_SUBPRJ_EQPMT_ETC_COST_TC
,X_SUBPRJ_EQPMT_ETC_COST_FC
,X_SUBPRJ_EQPMT_ETC_COST_PC
,X_SUBPRJ_EARNED_VALUE
,X_CURRENT_FLAG
,X_PROJFUNC_COST_RATE_TYPE
,X_PROJFUNC_COST_EXCHANGE_RATE
,X_PROJFUNC_COST_RATE_DATE
,X_PROJ_COST_RATE_TYPE
,X_PROJ_COST_EXCHANGE_RATE
,X_PROJ_COST_RATE_DATE
,X_TXN_CURRENCY_CODE
,X_PROG_PA_PERIOD_NAME
,X_PROG_GL_PERIOD_NAME
,X_OTH_QUANTITY_TO_DATE
,X_OTH_ETC_QUANTITY
,X_OTH_ACT_RAWCOST_TO_DATE_TC
,X_OTH_ACT_RAWCOST_TO_DATE_FC
,X_OTH_ACT_RAWCOST_TO_DATE_PC
,X_OTH_ETC_RAWCOST_TC
,X_OTH_ETC_RAWCOST_FC
,X_OTH_ETC_RAWCOST_PC
,X_PPL_ACT_RAWCOST_TO_DATE_TC
,X_PPL_ACT_RAWCOST_TO_DATE_FC
,X_PPL_ACT_RAWCOST_TO_DATE_PC
,X_PPL_ETC_RAWCOST_TC
,X_PPL_ETC_RAWCOST_FC
,X_PPL_ETC_RAWCOST_PC
,X_EQPMT_ACT_RAWCOST_TO_DATE_TC
,X_EQPMT_ACT_RAWCOST_TO_DATE_FC
,X_EQPMT_ACT_RAWCOST_TO_DATE_PC
,X_EQPMT_ETC_RAWCOST_TC
,X_EQPMT_ETC_RAWCOST_FC
,X_EQPMT_ETC_RAWCOST_PC
,X_SP_OTH_ACT_RAWCOST_TODATE_TC
,X_SP_OTH_ACT_RAWCOST_TODATE_FC
,X_SP_OTH_ACT_RAWCOST_TODATE_PC
,X_SUBPRJ_PPL_ACT_RAWCOST_TC
,X_SUBPRJ_PPL_ACT_RAWCOST_FC
,X_SUBPRJ_PPL_ACT_RAWCOST_PC
,X_SUBPRJ_EQPMT_ACT_RAWCOST_TC
,X_SUBPRJ_EQPMT_ACT_RAWCOST_FC
,X_SUBPRJ_EQPMT_ACT_RAWCOST_PC
,X_SUBPRJ_OTH_ETC_RAWCOST_TC
,X_SUBPRJ_OTH_ETC_RAWCOST_FC
,X_SUBPRJ_OTH_ETC_RAWCOST_PC
,X_SUBPRJ_PPL_ETC_RAWCOST_TC
,X_SUBPRJ_PPL_ETC_RAWCOST_FC
,X_SUBPRJ_PPL_ETC_RAWCOST_PC
,X_SUBPRJ_EQPMT_ETC_RAWCOST_TC
,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC
,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC
,X_CBS_ELEMENT_ID --added for CBS 16200605
);
p_procedure_name => 'INSERT_ROW',
p_error_text => SUBSTRB(SQLERRM,1,240));
End insert_row;
procedure UPDATE_ROW(
X_PROGRESS_ROLLUP_ID IN NUMBER
,X_PROJECT_ID IN NUMBER
,X_OBJECT_ID IN NUMBER
,X_OBJECT_TYPE IN VARCHAR2
,X_AS_OF_DATE IN DATE
,X_OBJECT_VERSION_ID IN NUMBER
,X_LAST_UPDATE_DATE IN DATE
,X_LAST_UPDATED_BY IN NUMBER
,X_PROGRESS_STATUS_CODE IN VARCHAR2
,X_LAST_UPDATE_LOGIN IN NUMBER
,X_INCREMENTAL_WORK_QTY IN NUMBER
,X_CUMULATIVE_WORK_QTY IN NUMBER
,X_BASE_PERCENT_COMPLETE IN NUMBER
,X_EFF_ROLLUP_PERCENT_COMP IN NUMBER
,X_COMPLETED_PERCENTAGE IN NUMBER
,X_ESTIMATED_START_DATE IN DATE
,X_ESTIMATED_FINISH_DATE IN DATE
,X_ACTUAL_START_DATE IN DATE
,X_ACTUAL_FINISH_DATE IN DATE
,X_EST_REMAINING_EFFORT IN NUMBER
,X_BASE_PERCENT_COMP_DERIV_CODE IN VARCHAR2
,X_BASE_PROGRESS_STATUS_CODE IN VARCHAR2
,X_EFF_ROLLUP_PROG_STAT_CODE IN VARCHAR2
,X_RECORD_VERSION_NUMBER IN NUMBER
,x_percent_complete_id in number
,X_STRUCTURE_TYPE IN VARCHAR2
,X_PROJ_ELEMENT_ID IN NUMBER
,X_STRUCTURE_VERSION_ID IN NUMBER
,X_PPL_ACT_EFFORT_TO_DATE IN NUMBER
,X_EQPMT_ACT_EFFORT_TO_DATE IN NUMBER
,X_EQPMT_ETC_EFFORT IN NUMBER
,X_OTH_ACT_COST_TO_DATE_TC IN NUMBER
,X_OTH_ACT_COST_TO_DATE_FC IN NUMBER
,X_OTH_ACT_COST_TO_DATE_PC IN NUMBER
,X_OTH_ETC_COST_TC IN NUMBER
,X_OTH_ETC_COST_FC IN NUMBER
,X_OTH_ETC_COST_PC IN NUMBER
,X_PPL_ACT_COST_TO_DATE_TC IN NUMBER
,X_PPL_ACT_COST_TO_DATE_FC IN NUMBER
,X_PPL_ACT_COST_TO_DATE_PC IN NUMBER
,X_PPL_ETC_COST_TC IN NUMBER
,X_PPL_ETC_COST_FC IN NUMBER
,X_PPL_ETC_COST_PC IN NUMBER
,X_EQPMT_ACT_COST_TO_DATE_TC IN NUMBER
,X_EQPMT_ACT_COST_TO_DATE_FC IN NUMBER
,X_EQPMT_ACT_COST_TO_DATE_PC IN NUMBER
,X_EQPMT_ETC_COST_TC IN NUMBER
,X_EQPMT_ETC_COST_FC IN NUMBER
,X_EQPMT_ETC_COST_PC IN NUMBER
,X_EARNED_VALUE IN NUMBER
,X_TASK_WT_BASIS_CODE IN VARCHAR2
,X_SUBPRJ_PPL_ACT_EFFORT IN NUMBER
,X_SUBPRJ_EQPMT_ACT_EFFORT IN NUMBER
,X_SUBPRJ_PPL_ETC_EFFORT IN NUMBER
,X_SUBPRJ_EQPMT_ETC_EFFORT IN NUMBER
,X_SBPJ_OTH_ACT_COST_TO_DATE_TC IN NUMBER
,X_SBPJ_OTH_ACT_COST_TO_DATE_FC IN NUMBER
,X_SBPJ_OTH_ACT_COST_TO_DATE_PC IN NUMBER
,X_SUBPRJ_PPL_ACT_COST_TC IN NUMBER
,X_SUBPRJ_PPL_ACT_COST_FC IN NUMBER
,X_SUBPRJ_PPL_ACT_COST_PC IN NUMBER
,X_SUBPRJ_EQPMT_ACT_COST_TC IN NUMBER
,X_SUBPRJ_EQPMT_ACT_COST_FC IN NUMBER
,X_SUBPRJ_EQPMT_ACT_COST_PC IN NUMBER
,X_SUBPRJ_OTH_ETC_COST_TC IN NUMBER
,X_SUBPRJ_OTH_ETC_COST_FC IN NUMBER
,X_SUBPRJ_OTH_ETC_COST_PC IN NUMBER
,X_SUBPRJ_PPL_ETC_COST_TC IN NUMBER
,X_SUBPRJ_PPL_ETC_COST_FC IN NUMBER
,X_SUBPRJ_PPL_ETC_COST_PC IN NUMBER
,X_SUBPRJ_EQPMT_ETC_COST_TC IN NUMBER
,X_SUBPRJ_EQPMT_ETC_COST_FC IN NUMBER
,X_SUBPRJ_EQPMT_ETC_COST_PC IN NUMBER
,X_SUBPRJ_EARNED_VALUE IN NUMBER
,X_CURRENT_FLAG IN VARCHAR2
,X_PROJFUNC_COST_RATE_TYPE VARCHAR2
,X_PROJFUNC_COST_EXCHANGE_RATE NUMBER
,X_PROJFUNC_COST_RATE_DATE DATE
,X_PROJ_COST_RATE_TYPE VARCHAR2
,X_PROJ_COST_EXCHANGE_RATE NUMBER
,X_PROJ_COST_RATE_DATE DATE
,X_TXN_CURRENCY_CODE VARCHAR2
,X_PROG_PA_PERIOD_NAME VARCHAR2
,X_PROG_GL_PERIOD_NAME VARCHAR2
,X_OTH_QUANTITY_TO_DATE NUMBER
,X_OTH_ETC_QUANTITY NUMBER
,X_OTH_ACT_RAWCOST_TO_DATE_TC IN NUMBER
,X_OTH_ACT_RAWCOST_TO_DATE_FC IN NUMBER
,X_OTH_ACT_RAWCOST_TO_DATE_PC IN NUMBER
,X_OTH_ETC_RAWCOST_TC IN NUMBER
,X_OTH_ETC_RAWCOST_FC IN NUMBER
,X_OTH_ETC_RAWCOST_PC IN NUMBER
,X_PPL_ACT_RAWCOST_TO_DATE_TC IN NUMBER
,X_PPL_ACT_RAWCOST_TO_DATE_FC IN NUMBER
,X_PPL_ACT_RAWCOST_TO_DATE_PC IN NUMBER
,X_PPL_ETC_RAWCOST_TC IN NUMBER
,X_PPL_ETC_RAWCOST_FC IN NUMBER
,X_PPL_ETC_RAWCOST_PC IN NUMBER
,X_EQPMT_ACT_RAWCOST_TO_DATE_TC IN NUMBER
,X_EQPMT_ACT_RAWCOST_TO_DATE_FC IN NUMBER
,X_EQPMT_ACT_RAWCOST_TO_DATE_PC IN NUMBER
,X_EQPMT_ETC_RAWCOST_TC IN NUMBER
,X_EQPMT_ETC_RAWCOST_FC IN NUMBER
,X_EQPMT_ETC_RAWCOST_PC IN NUMBER
,X_SP_OTH_ACT_RAWCOST_TODATE_TC IN NUMBER
,X_SP_OTH_ACT_RAWCOST_TODATE_FC IN NUMBER
,X_SP_OTH_ACT_RAWCOST_TODATE_PC IN NUMBER
,X_SUBPRJ_PPL_ACT_RAWCOST_TC IN NUMBER
,X_SUBPRJ_PPL_ACT_RAWCOST_FC IN NUMBER
,X_SUBPRJ_PPL_ACT_RAWCOST_PC IN NUMBER
,X_SUBPRJ_EQPMT_ACT_RAWCOST_TC IN NUMBER
,X_SUBPRJ_EQPMT_ACT_RAWCOST_FC IN NUMBER
,X_SUBPRJ_EQPMT_ACT_RAWCOST_PC IN NUMBER
,X_SUBPRJ_OTH_ETC_RAWCOST_TC IN NUMBER
,X_SUBPRJ_OTH_ETC_RAWCOST_FC IN NUMBER
,X_SUBPRJ_OTH_ETC_RAWCOST_PC IN NUMBER
,X_SUBPRJ_PPL_ETC_RAWCOST_TC IN NUMBER
,X_SUBPRJ_PPL_ETC_RAWCOST_FC IN NUMBER
,X_SUBPRJ_PPL_ETC_RAWCOST_PC IN NUMBER
,X_SUBPRJ_EQPMT_ETC_RAWCOST_TC IN NUMBER
,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC IN NUMBER
,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC IN NUMBER
, X_CBS_ELEMENT_ID IN NUMBER DEFAULT NULL --Added for CBS 16200605
) IS
BEGIN
UPDATE pa_progress_rollup
SET
PROJECT_ID = DECODE(X_PROJECT_ID, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
PROJECT_ID, X_PROJECT_ID )
,OBJECT_ID = DECODE(X_OBJECT_ID, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
OBJECT_ID, X_OBJECT_ID )
,OBJECT_TYPE = DECODE(X_OBJECT_TYPE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
OBJECT_TYPE, X_OBJECT_TYPE )
,AS_OF_DATE = DECODE(X_AS_OF_DATE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
AS_OF_DATE, X_AS_OF_DATE )
,OBJECT_VERSION_ID = DECODE(X_OBJECT_VERSION_ID, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
OBJECT_VERSION_ID, X_OBJECT_VERSION_ID )
,LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
,LAST_UPDATED_BY = X_LAST_UPDATED_BY
,PROGRESS_STATUS_CODE = DECODE(X_PROGRESS_STATUS_CODE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
PROGRESS_STATUS_CODE, X_PROGRESS_STATUS_CODE )
,LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
,INCREMENTAL_WORK_QUANTITY = DECODE( X_INCREMENTAL_WORK_QTY, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
INCREMENTAL_WORK_QUANTITY, X_INCREMENTAL_WORK_QTY )
,CUMULATIVE_WORK_QUANTITY = DECODE( X_CUMULATIVE_WORK_QTY, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
CUMULATIVE_WORK_QUANTITY, X_CUMULATIVE_WORK_QTY )
,BASE_PERCENT_COMPLETE = DECODE( X_BASE_PERCENT_COMPLETE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
BASE_PERCENT_COMPLETE, X_BASE_PERCENT_COMPLETE )
,EFF_ROLLUP_PERCENT_COMP = DECODE( X_EFF_ROLLUP_PERCENT_COMP, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
EFF_ROLLUP_PERCENT_COMP, X_EFF_ROLLUP_PERCENT_COMP )
,COMPLETED_PERCENTAGE = DECODE( X_COMPLETED_PERCENTAGE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
COMPLETED_PERCENTAGE, X_COMPLETED_PERCENTAGE )
,ESTIMATED_START_DATE = DECODE( X_ESTIMATED_START_DATE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
ESTIMATED_START_DATE, X_ESTIMATED_START_DATE )
,ESTIMATED_FINISH_DATE = DECODE( X_ESTIMATED_FINISH_DATE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
ESTIMATED_FINISH_DATE, X_ESTIMATED_FINISH_DATE )
,ACTUAL_START_DATE = DECODE( X_ACTUAL_START_DATE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
ACTUAL_START_DATE, X_ACTUAL_START_DATE )
,ACTUAL_FINISH_DATE = DECODE( X_ACTUAL_FINISH_DATE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
ACTUAL_FINISH_DATE, X_ACTUAL_FINISH_DATE )
,ESTIMATED_REMAINING_EFFORT = DECODE( X_EST_REMAINING_EFFORT, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
ESTIMATED_REMAINING_EFFORT, X_EST_REMAINING_EFFORT )
,RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 1 ) + 1
,BASE_PERCENT_COMP_DERIV_CODE = DECODE( X_BASE_PERCENT_COMP_DERIV_CODE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
BASE_PERCENT_COMP_DERIV_CODE, X_BASE_PERCENT_COMP_DERIV_CODE )
,BASE_PROGRESS_STATUS_CODE = DECODE( X_BASE_PROGRESS_STATUS_CODE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
BASE_PROGRESS_STATUS_CODE, X_BASE_PROGRESS_STATUS_CODE )
,EFF_ROLLUP_PROG_STAT_CODE = DECODE( X_EFF_ROLLUP_PROG_STAT_CODE, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
EFF_ROLLUP_PROG_STAT_CODE, X_EFF_ROLLUP_PROG_STAT_CODE )
,percent_complete_id = nvl(x_percent_complete_id,percent_complete_id)
,STRUCTURE_TYPE=DECODE(X_STRUCTURE_TYPE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,STRUCTURE_TYPE,X_STRUCTURE_TYPE)
,PROJ_ELEMENT_ID=DECODE(X_PROJ_ELEMENT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,PROJ_ELEMENT_ID,X_PROJ_ELEMENT_ID)
,STRUCTURE_VERSION_ID=DECODE(X_STRUCTURE_VERSION_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,STRUCTURE_VERSION_ID,X_STRUCTURE_VERSION_ID)
,PPL_ACT_EFFORT_TO_DATE=DECODE(X_PPL_ACT_EFFORT_TO_DATE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,PPL_ACT_EFFORT_TO_DATE,X_PPL_ACT_EFFORT_TO_DATE)
,EQPMT_ACT_EFFORT_TO_DATE=DECODE(X_EQPMT_ACT_EFFORT_TO_DATE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,EQPMT_ACT_EFFORT_TO_DATE,X_EQPMT_ACT_EFFORT_TO_DATE)
,EQPMT_ETC_EFFORT=DECODE(X_EQPMT_ETC_EFFORT,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,EQPMT_ETC_EFFORT,X_EQPMT_ETC_EFFORT)
,OTH_ACT_COST_TO_DATE_TC=DECODE(X_OTH_ACT_COST_TO_DATE_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,OTH_ACT_COST_TO_DATE_TC,X_OTH_ACT_COST_TO_DATE_TC)
,OTH_ACT_COST_TO_DATE_FC=DECODE(X_OTH_ACT_COST_TO_DATE_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,OTH_ACT_COST_TO_DATE_FC,X_OTH_ACT_COST_TO_DATE_FC)
,OTH_ACT_COST_TO_DATE_PC=DECODE(X_OTH_ACT_COST_TO_DATE_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,OTH_ACT_COST_TO_DATE_PC,X_OTH_ACT_COST_TO_DATE_PC)
,OTH_ETC_COST_TC=DECODE(X_OTH_ETC_COST_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,OTH_ETC_COST_TC,X_OTH_ETC_COST_TC)
,OTH_ETC_COST_FC=DECODE(X_OTH_ETC_COST_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,OTH_ETC_COST_FC,X_OTH_ETC_COST_FC)
,OTH_ETC_COST_PC=DECODE(X_OTH_ETC_COST_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,OTH_ETC_COST_PC,X_OTH_ETC_COST_PC)
,PPL_ACT_COST_TO_DATE_TC=DECODE(X_PPL_ACT_COST_TO_DATE_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,PPL_ACT_COST_TO_DATE_TC,X_PPL_ACT_COST_TO_DATE_TC)
,PPL_ACT_COST_TO_DATE_FC=DECODE(X_PPL_ACT_COST_TO_DATE_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,PPL_ACT_COST_TO_DATE_FC,X_PPL_ACT_COST_TO_DATE_FC)
,PPL_ACT_COST_TO_DATE_PC=DECODE(X_PPL_ACT_COST_TO_DATE_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,PPL_ACT_COST_TO_DATE_PC,X_PPL_ACT_COST_TO_DATE_PC)
,PPL_ETC_COST_TC=DECODE(X_PPL_ETC_COST_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,PPL_ETC_COST_TC,X_PPL_ETC_COST_TC)
,PPL_ETC_COST_FC=DECODE(X_PPL_ETC_COST_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,PPL_ETC_COST_FC,X_PPL_ETC_COST_FC)
,PPL_ETC_COST_PC=DECODE(X_PPL_ETC_COST_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,PPL_ETC_COST_PC,X_PPL_ETC_COST_PC)
,EQPMT_ACT_COST_TO_DATE_TC=DECODE(X_EQPMT_ACT_COST_TO_DATE_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,EQPMT_ACT_COST_TO_DATE_TC,X_EQPMT_ACT_COST_TO_DATE_TC)
,EQPMT_ACT_COST_TO_DATE_FC=DECODE(X_EQPMT_ACT_COST_TO_DATE_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,EQPMT_ACT_COST_TO_DATE_FC,X_EQPMT_ACT_COST_TO_DATE_FC)
,EQPMT_ACT_COST_TO_DATE_PC=DECODE(X_EQPMT_ACT_COST_TO_DATE_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,EQPMT_ACT_COST_TO_DATE_PC,X_EQPMT_ACT_COST_TO_DATE_PC)
,EQPMT_ETC_COST_TC=DECODE(X_EQPMT_ETC_COST_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,EQPMT_ETC_COST_TC,X_EQPMT_ETC_COST_TC)
,EQPMT_ETC_COST_FC=DECODE(X_EQPMT_ETC_COST_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,EQPMT_ETC_COST_FC,X_EQPMT_ETC_COST_FC)
,EQPMT_ETC_COST_PC=DECODE(X_EQPMT_ETC_COST_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,EQPMT_ETC_COST_PC,X_EQPMT_ETC_COST_PC)
,EARNED_VALUE=DECODE(X_EARNED_VALUE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,EARNED_VALUE,X_EARNED_VALUE)
,TASK_WT_BASIS_CODE=DECODE(X_TASK_WT_BASIS_CODE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,TASK_WT_BASIS_CODE,X_TASK_WT_BASIS_CODE)
,SUBPRJ_PPL_ACT_EFFORT=DECODE(X_SUBPRJ_PPL_ACT_EFFORT,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_PPL_ACT_EFFORT,X_SUBPRJ_PPL_ACT_EFFORT)
,SUBPRJ_EQPMT_ACT_EFFORT=DECODE(X_SUBPRJ_EQPMT_ACT_EFFORT,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_EQPMT_ACT_EFFORT,X_SUBPRJ_EQPMT_ACT_EFFORT)
,SUBPRJ_PPL_ETC_EFFORT=DECODE(X_SUBPRJ_PPL_ETC_EFFORT,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_PPL_ETC_EFFORT,X_SUBPRJ_PPL_ETC_EFFORT)
,SUBPRJ_EQPMT_ETC_EFFORT=DECODE(X_SUBPRJ_EQPMT_ETC_EFFORT,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_EQPMT_ETC_EFFORT,X_SUBPRJ_EQPMT_ETC_EFFORT)
,SUBPRJ_OTH_ACT_COST_TO_DT_TC=DECODE(X_SBPJ_OTH_ACT_COST_TO_DATE_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_OTH_ACT_COST_TO_DT_TC,X_SBPJ_OTH_ACT_COST_TO_DATE_TC)
,SUBPRJ_OTH_ACT_COST_TO_DT_FC =DECODE(X_SBPJ_OTH_ACT_COST_TO_DATE_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_OTH_ACT_COST_TO_DT_FC ,X_SBPJ_OTH_ACT_COST_TO_DATE_FC)
,SUBPRJ_OTH_ACT_COST_TO_DT_PC=DECODE(X_SBPJ_OTH_ACT_COST_TO_DATE_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_OTH_ACT_COST_TO_DT_PC,X_SBPJ_OTH_ACT_COST_TO_DATE_PC)
,SUBPRJ_PPL_ACT_COST_TC=DECODE(X_SUBPRJ_PPL_ACT_COST_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_PPL_ACT_COST_TC,X_SUBPRJ_PPL_ACT_COST_TC)
,SUBPRJ_PPL_ACT_COST_FC=DECODE(X_SUBPRJ_PPL_ACT_COST_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_PPL_ACT_COST_FC,X_SUBPRJ_PPL_ACT_COST_FC)
,SUBPRJ_PPL_ACT_COST_PC=DECODE(X_SUBPRJ_PPL_ACT_COST_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_PPL_ACT_COST_PC,X_SUBPRJ_PPL_ACT_COST_PC)
,SUBPRJ_EQPMT_ACT_COST_TC=DECODE(X_SUBPRJ_EQPMT_ACT_COST_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_EQPMT_ACT_COST_TC,X_SUBPRJ_EQPMT_ACT_COST_TC)
,SUBPRJ_EQPMT_ACT_COST_FC=DECODE(X_SUBPRJ_EQPMT_ACT_COST_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_EQPMT_ACT_COST_FC,X_SUBPRJ_EQPMT_ACT_COST_FC)
,SUBPRJ_EQPMT_ACT_COST_PC=DECODE(X_SUBPRJ_EQPMT_ACT_COST_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_EQPMT_ACT_COST_PC,X_SUBPRJ_EQPMT_ACT_COST_PC)
,SUBPRJ_OTH_ETC_COST_TC=DECODE(X_SUBPRJ_OTH_ETC_COST_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_OTH_ETC_COST_TC,X_SUBPRJ_OTH_ETC_COST_TC)
,SUBPRJ_OTH_ETC_COST_FC=DECODE(X_SUBPRJ_OTH_ETC_COST_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_OTH_ETC_COST_FC,X_SUBPRJ_OTH_ETC_COST_FC)
,SUBPRJ_OTH_ETC_COST_PC=DECODE(X_SUBPRJ_OTH_ETC_COST_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_OTH_ETC_COST_PC,X_SUBPRJ_OTH_ETC_COST_PC)
,SUBPRJ_PPL_ETC_COST_TC=DECODE(X_SUBPRJ_PPL_ETC_COST_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_PPL_ETC_COST_TC,X_SUBPRJ_PPL_ETC_COST_TC)
,SUBPRJ_PPL_ETC_COST_FC=DECODE(X_SUBPRJ_PPL_ETC_COST_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_PPL_ETC_COST_FC,X_SUBPRJ_PPL_ETC_COST_FC)
,SUBPRJ_PPL_ETC_COST_PC=DECODE(X_SUBPRJ_PPL_ETC_COST_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_PPL_ETC_COST_PC,X_SUBPRJ_PPL_ETC_COST_PC)
,SUBPRJ_EQPMT_ETC_COST_TC=DECODE(X_SUBPRJ_EQPMT_ETC_COST_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_EQPMT_ETC_COST_TC,X_SUBPRJ_EQPMT_ETC_COST_TC)
,SUBPRJ_EQPMT_ETC_COST_FC=DECODE(X_SUBPRJ_EQPMT_ETC_COST_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_EQPMT_ETC_COST_FC,X_SUBPRJ_EQPMT_ETC_COST_FC)
,SUBPRJ_EQPMT_ETC_COST_PC=DECODE(X_SUBPRJ_EQPMT_ETC_COST_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_EQPMT_ETC_COST_PC,X_SUBPRJ_EQPMT_ETC_COST_PC)
,SUBPRJ_EARNED_VALUE=DECODE(X_SUBPRJ_EARNED_VALUE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_EARNED_VALUE,X_SUBPRJ_EARNED_VALUE)
,CURRENT_FLAG=DECODE(X_CURRENT_FLAG,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,CURRENT_FLAG,X_CURRENT_FLAG)
,PROJFUNC_COST_RATE_TYPE = DECODE(X_PROJFUNC_COST_RATE_TYPE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,PROJFUNC_COST_RATE_TYPE,X_PROJFUNC_COST_RATE_TYPE)
,PROJFUNC_COST_EXCHANGE_RATE = DECODE(X_PROJFUNC_COST_EXCHANGE_RATE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,PROJFUNC_COST_EXCHANGE_RATE,X_PROJFUNC_COST_EXCHANGE_RATE)
,PROJFUNC_COST_RATE_DATE = DECODE(X_PROJFUNC_COST_RATE_DATE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,PROJFUNC_COST_RATE_DATE,X_PROJFUNC_COST_RATE_DATE)
,PROJ_COST_RATE_TYPE = DECODE(X_PROJ_COST_RATE_TYPE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,PROJ_COST_RATE_TYPE,X_PROJ_COST_RATE_TYPE)
,PROJ_COST_EXCHANGE_RATE = DECODE(X_PROJ_COST_EXCHANGE_RATE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,PROJ_COST_EXCHANGE_RATE,X_PROJ_COST_EXCHANGE_RATE)
,PROJ_COST_RATE_DATE = DECODE(X_PROJ_COST_RATE_DATE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,PROJ_COST_RATE_DATE,X_PROJ_COST_RATE_DATE)
,TXN_CURRENCY_CODE = DECODE(X_TXN_CURRENCY_CODE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,TXN_CURRENCY_CODE,X_TXN_CURRENCY_CODE)
,PROG_PA_PERIOD_NAME = DECODE(X_PROG_PA_PERIOD_NAME,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,PROG_PA_PERIOD_NAME,X_PROG_PA_PERIOD_NAME)
,PROG_GL_PERIOD_NAME = DECODE(X_PROG_GL_PERIOD_NAME,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,PROG_GL_PERIOD_NAME,X_PROG_GL_PERIOD_NAME)
,OTH_QUANTITY_TO_DATE = DECODE(X_OTH_QUANTITY_TO_DATE,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,OTH_QUANTITY_TO_DATE,X_OTH_QUANTITY_TO_DATE)
,OTH_ETC_QUANTITY = DECODE(X_OTH_ETC_QUANTITY,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,OTH_ETC_QUANTITY,X_OTH_ETC_QUANTITY)
,OTH_ACT_RAWCOST_TO_DATE_TC=DECODE(X_OTH_ACT_RAWCOST_TO_DATE_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,OTH_ACT_RAWCOST_TO_DATE_TC,X_OTH_ACT_RAWCOST_TO_DATE_TC)
,OTH_ACT_RAWCOST_TO_DATE_FC=DECODE(X_OTH_ACT_RAWCOST_TO_DATE_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,OTH_ACT_RAWCOST_TO_DATE_FC,X_OTH_ACT_RAWCOST_TO_DATE_FC)
,OTH_ACT_RAWCOST_TO_DATE_PC=DECODE(X_OTH_ACT_RAWCOST_TO_DATE_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,OTH_ACT_RAWCOST_TO_DATE_PC,X_OTH_ACT_RAWCOST_TO_DATE_PC)
,OTH_ETC_RAWCOST_TC=DECODE(X_OTH_ETC_RAWCOST_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,OTH_ETC_RAWCOST_TC,X_OTH_ETC_RAWCOST_TC)
,OTH_ETC_RAWCOST_FC=DECODE(X_OTH_ETC_RAWCOST_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,OTH_ETC_RAWCOST_FC,X_OTH_ETC_RAWCOST_FC)
,OTH_ETC_RAWCOST_PC=DECODE(X_OTH_ETC_RAWCOST_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,OTH_ETC_RAWCOST_PC,X_OTH_ETC_RAWCOST_PC)
,PPL_ACT_RAWCOST_TO_DATE_TC=DECODE(X_PPL_ACT_RAWCOST_TO_DATE_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,PPL_ACT_RAWCOST_TO_DATE_TC,X_PPL_ACT_RAWCOST_TO_DATE_TC)
,PPL_ACT_RAWCOST_TO_DATE_FC=DECODE(X_PPL_ACT_RAWCOST_TO_DATE_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,PPL_ACT_RAWCOST_TO_DATE_FC,X_PPL_ACT_RAWCOST_TO_DATE_FC)
,PPL_ACT_RAWCOST_TO_DATE_PC=DECODE(X_PPL_ACT_RAWCOST_TO_DATE_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,PPL_ACT_RAWCOST_TO_DATE_PC,X_PPL_ACT_RAWCOST_TO_DATE_PC)
,PPL_ETC_RAWCOST_TC=DECODE(X_PPL_ETC_RAWCOST_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,PPL_ETC_RAWCOST_TC,X_PPL_ETC_RAWCOST_TC)
,PPL_ETC_RAWCOST_FC=DECODE(X_PPL_ETC_RAWCOST_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,PPL_ETC_RAWCOST_FC,X_PPL_ETC_RAWCOST_FC)
,PPL_ETC_RAWCOST_PC=DECODE(X_PPL_ETC_RAWCOST_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,PPL_ETC_RAWCOST_PC,X_PPL_ETC_RAWCOST_PC)
,EQPMT_ACT_RAWCOST_TO_DATE_TC=DECODE(X_EQPMT_ACT_RAWCOST_TO_DATE_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,EQPMT_ACT_RAWCOST_TO_DATE_TC,X_EQPMT_ACT_RAWCOST_TO_DATE_TC)
,EQPMT_ACT_RAWCOST_TO_DATE_FC=DECODE(X_EQPMT_ACT_RAWCOST_TO_DATE_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,EQPMT_ACT_RAWCOST_TO_DATE_FC,X_EQPMT_ACT_RAWCOST_TO_DATE_FC)
,EQPMT_ACT_RAWCOST_TO_DATE_PC=DECODE(X_EQPMT_ACT_RAWCOST_TO_DATE_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,EQPMT_ACT_RAWCOST_TO_DATE_PC,X_EQPMT_ACT_RAWCOST_TO_DATE_PC)
,EQPMT_ETC_RAWCOST_TC=DECODE(X_EQPMT_ETC_RAWCOST_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,EQPMT_ETC_RAWCOST_TC,X_EQPMT_ETC_RAWCOST_TC)
,EQPMT_ETC_RAWCOST_FC=DECODE(X_EQPMT_ETC_RAWCOST_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,EQPMT_ETC_RAWCOST_FC,X_EQPMT_ETC_RAWCOST_FC)
,EQPMT_ETC_RAWCOST_PC=DECODE(X_EQPMT_ETC_RAWCOST_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,EQPMT_ETC_RAWCOST_PC,X_EQPMT_ETC_RAWCOST_PC)
,SPJ_OTH_ACT_RAWCOST_TO_DT_TC=DECODE(X_SP_OTH_ACT_RAWCOST_TODATE_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SPJ_OTH_ACT_RAWCOST_TO_DT_TC,X_SP_OTH_ACT_RAWCOST_TODATE_TC)
,SPJ_OTH_ACT_RAWCOST_TO_DT_FC=DECODE(X_SP_OTH_ACT_RAWCOST_TODATE_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,X_SUBPRJ_EQPMT_ACT_RAWCOST_PC,X_SP_OTH_ACT_RAWCOST_TODATE_FC)
,SPJ_OTH_ACT_RAWCOST_TO_DT_PC=DECODE(X_SP_OTH_ACT_RAWCOST_TODATE_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SPJ_OTH_ACT_RAWCOST_TO_DT_PC,X_SP_OTH_ACT_RAWCOST_TODATE_PC)
,SUBPRJ_PPL_ACT_RAWCOST_TC=DECODE(X_SUBPRJ_PPL_ACT_RAWCOST_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_PPL_ACT_RAWCOST_TC,X_SUBPRJ_PPL_ACT_RAWCOST_TC)
,SUBPRJ_PPL_ACT_RAWCOST_FC=DECODE(X_SUBPRJ_PPL_ACT_RAWCOST_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_PPL_ACT_RAWCOST_FC,X_SUBPRJ_PPL_ACT_RAWCOST_FC)
,SUBPRJ_PPL_ACT_RAWCOST_PC=DECODE(X_SUBPRJ_PPL_ACT_RAWCOST_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_PPL_ACT_RAWCOST_PC,X_SUBPRJ_PPL_ACT_RAWCOST_PC)
,SUBPRJ_EQPMT_ACT_RAWCOST_TC=DECODE(X_SUBPRJ_EQPMT_ACT_RAWCOST_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_EQPMT_ACT_RAWCOST_TC,X_SUBPRJ_EQPMT_ACT_RAWCOST_TC)
,SUBPRJ_EQPMT_ACT_RAWCOST_FC=DECODE(X_SUBPRJ_EQPMT_ACT_RAWCOST_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_EQPMT_ACT_RAWCOST_FC,X_SUBPRJ_EQPMT_ACT_RAWCOST_FC)
,SUBPRJ_EQPMT_ACT_RAWCOST_PC=DECODE(X_SUBPRJ_EQPMT_ACT_RAWCOST_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_EQPMT_ACT_RAWCOST_PC,X_SUBPRJ_EQPMT_ACT_RAWCOST_PC)
,SUBPRJ_OTH_ETC_RAWCOST_TC=DECODE(X_SUBPRJ_OTH_ETC_RAWCOST_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_OTH_ETC_RAWCOST_TC,X_SUBPRJ_OTH_ETC_RAWCOST_TC)
,SUBPRJ_OTH_ETC_RAWCOST_FC=DECODE(X_SUBPRJ_OTH_ETC_RAWCOST_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_OTH_ETC_RAWCOST_FC,X_SUBPRJ_OTH_ETC_RAWCOST_FC)
,SUBPRJ_OTH_ETC_RAWCOST_PC=DECODE(X_SUBPRJ_OTH_ETC_RAWCOST_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_OTH_ETC_RAWCOST_PC,X_SUBPRJ_OTH_ETC_RAWCOST_PC)
,SUBPRJ_PPL_ETC_RAWCOST_TC=DECODE(X_SUBPRJ_PPL_ETC_RAWCOST_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_PPL_ETC_RAWCOST_TC,X_SUBPRJ_PPL_ETC_RAWCOST_TC)
,SUBPRJ_PPL_ETC_RAWCOST_FC=DECODE(X_SUBPRJ_PPL_ETC_RAWCOST_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_PPL_ETC_RAWCOST_FC,X_SUBPRJ_PPL_ETC_RAWCOST_FC)
,SUBPRJ_PPL_ETC_RAWCOST_PC=DECODE(X_SUBPRJ_PPL_ETC_RAWCOST_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_PPL_ETC_RAWCOST_PC,X_SUBPRJ_PPL_ETC_RAWCOST_PC)
,SUBPRJ_EQPMT_ETC_RAWCOST_TC=DECODE(X_SUBPRJ_EQPMT_ETC_RAWCOST_TC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_EQPMT_ETC_RAWCOST_TC,X_SUBPRJ_EQPMT_ETC_RAWCOST_TC)
,SUBPRJ_EQPMT_ETC_RAWCOST_FC=DECODE(X_SUBPRJ_EQPMT_ETC_RAWCOST_FC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_EQPMT_ETC_RAWCOST_FC,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC)
,SUBPRJ_EQPMT_ETC_RAWCOST_PC=DECODE(X_SUBPRJ_EQPMT_ETC_RAWCOST_PC,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,SUBPRJ_EQPMT_ETC_RAWCOST_PC,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC)
,CBS_ELEMENT_ID = X_CBS_ELEMENT_ID --Added for 16200605
WHERE PROGRESS_ROLLUP_ID = X_PROGRESS_ROLLUP_ID
AND record_version_number = x_record_version_number;
p_procedure_name => 'UPDATE_ROW',
p_error_text => SUBSTRB(SQLERRM,1,240));
End update_row;
Procedure DELETE_ROW(
p_row_id VARCHAR2 ) IS
BEGIN
DELETE FROM pa_progress_rollup
WHERE rowid = p_row_id;
END DELETE_ROW;