203:
204: BEGIN
205: update pa_percent_completes
206: set
207: OBJECT_VERSION_ID = decode(P_OBJECT_VERSION_ID,FND_API.G_MISS_NUM,OBJECT_VERSION_ID,P_OBJECT_VERSION_ID),
208: OBJECT_TYPE = decode(p_OBJECT_TYPE,FND_API.G_MISS_CHAR,OBJECT_TYPE,p_OBJECT_TYPE),
209: OBJECT_ID = decode(p_OBJECT_ID,FND_API.G_MISS_NUM,OBJECT_ID,p_OBJECT_ID),
210: task_ID = decode(p_task_ID,FND_API.G_MISS_NUM,task_ID,p_task_ID),
211: project_ID = decode(p_project_ID,FND_API.G_MISS_NUM,project_ID,p_project_ID),
204: BEGIN
205: update pa_percent_completes
206: set
207: OBJECT_VERSION_ID = decode(P_OBJECT_VERSION_ID,FND_API.G_MISS_NUM,OBJECT_VERSION_ID,P_OBJECT_VERSION_ID),
208: OBJECT_TYPE = decode(p_OBJECT_TYPE,FND_API.G_MISS_CHAR,OBJECT_TYPE,p_OBJECT_TYPE),
209: OBJECT_ID = decode(p_OBJECT_ID,FND_API.G_MISS_NUM,OBJECT_ID,p_OBJECT_ID),
210: task_ID = decode(p_task_ID,FND_API.G_MISS_NUM,task_ID,p_task_ID),
211: project_ID = decode(p_project_ID,FND_API.G_MISS_NUM,project_ID,p_project_ID),
212: DATE_COMPUTED = decode(p_DATE_COMPUTED,FND_API.G_MISS_DATE,DATE_COMPUTED,p_DATE_COMPUTED),
205: update pa_percent_completes
206: set
207: OBJECT_VERSION_ID = decode(P_OBJECT_VERSION_ID,FND_API.G_MISS_NUM,OBJECT_VERSION_ID,P_OBJECT_VERSION_ID),
208: OBJECT_TYPE = decode(p_OBJECT_TYPE,FND_API.G_MISS_CHAR,OBJECT_TYPE,p_OBJECT_TYPE),
209: OBJECT_ID = decode(p_OBJECT_ID,FND_API.G_MISS_NUM,OBJECT_ID,p_OBJECT_ID),
210: task_ID = decode(p_task_ID,FND_API.G_MISS_NUM,task_ID,p_task_ID),
211: project_ID = decode(p_project_ID,FND_API.G_MISS_NUM,project_ID,p_project_ID),
212: DATE_COMPUTED = decode(p_DATE_COMPUTED,FND_API.G_MISS_DATE,DATE_COMPUTED,p_DATE_COMPUTED),
213: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
206: set
207: OBJECT_VERSION_ID = decode(P_OBJECT_VERSION_ID,FND_API.G_MISS_NUM,OBJECT_VERSION_ID,P_OBJECT_VERSION_ID),
208: OBJECT_TYPE = decode(p_OBJECT_TYPE,FND_API.G_MISS_CHAR,OBJECT_TYPE,p_OBJECT_TYPE),
209: OBJECT_ID = decode(p_OBJECT_ID,FND_API.G_MISS_NUM,OBJECT_ID,p_OBJECT_ID),
210: task_ID = decode(p_task_ID,FND_API.G_MISS_NUM,task_ID,p_task_ID),
211: project_ID = decode(p_project_ID,FND_API.G_MISS_NUM,project_ID,p_project_ID),
212: DATE_COMPUTED = decode(p_DATE_COMPUTED,FND_API.G_MISS_DATE,DATE_COMPUTED,p_DATE_COMPUTED),
213: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
214: LAST_UPDATED_BY = p_LAST_UPDATED_BY,
207: OBJECT_VERSION_ID = decode(P_OBJECT_VERSION_ID,FND_API.G_MISS_NUM,OBJECT_VERSION_ID,P_OBJECT_VERSION_ID),
208: OBJECT_TYPE = decode(p_OBJECT_TYPE,FND_API.G_MISS_CHAR,OBJECT_TYPE,p_OBJECT_TYPE),
209: OBJECT_ID = decode(p_OBJECT_ID,FND_API.G_MISS_NUM,OBJECT_ID,p_OBJECT_ID),
210: task_ID = decode(p_task_ID,FND_API.G_MISS_NUM,task_ID,p_task_ID),
211: project_ID = decode(p_project_ID,FND_API.G_MISS_NUM,project_ID,p_project_ID),
212: DATE_COMPUTED = decode(p_DATE_COMPUTED,FND_API.G_MISS_DATE,DATE_COMPUTED,p_DATE_COMPUTED),
213: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
214: LAST_UPDATED_BY = p_LAST_UPDATED_BY,
215: LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,
208: OBJECT_TYPE = decode(p_OBJECT_TYPE,FND_API.G_MISS_CHAR,OBJECT_TYPE,p_OBJECT_TYPE),
209: OBJECT_ID = decode(p_OBJECT_ID,FND_API.G_MISS_NUM,OBJECT_ID,p_OBJECT_ID),
210: task_ID = decode(p_task_ID,FND_API.G_MISS_NUM,task_ID,p_task_ID),
211: project_ID = decode(p_project_ID,FND_API.G_MISS_NUM,project_ID,p_project_ID),
212: DATE_COMPUTED = decode(p_DATE_COMPUTED,FND_API.G_MISS_DATE,DATE_COMPUTED,p_DATE_COMPUTED),
213: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
214: LAST_UPDATED_BY = p_LAST_UPDATED_BY,
215: LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,
216: COMPLETED_PERCENTAGE = decode(p_COMPLETED_PERCENTAGE,FND_API.G_MISS_NUM,COMPLETED_PERCENTAGE,p_COMPLETED_PERCENTAGE),
212: DATE_COMPUTED = decode(p_DATE_COMPUTED,FND_API.G_MISS_DATE,DATE_COMPUTED,p_DATE_COMPUTED),
213: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
214: LAST_UPDATED_BY = p_LAST_UPDATED_BY,
215: LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,
216: COMPLETED_PERCENTAGE = decode(p_COMPLETED_PERCENTAGE,FND_API.G_MISS_NUM,COMPLETED_PERCENTAGE,p_COMPLETED_PERCENTAGE),
217: DESCRIPTION = decode(p_DESCRIPTION,FND_API.G_MISS_CHAR,DESCRIPTION,p_DESCRIPTION),
218: CURRENT_FLAG = decode(p_CURRENT_FLAG,FND_API.G_MISS_CHAR,CURRENT_FLAG,p_CURRENT_FLAG),
219: PROGRESS_STATUS_CODE = decode(p_PROGRESS_STATUS_CODE,FND_API.G_MISS_CHAR,PROGRESS_STATUS_CODE,p_PROGRESS_STATUS_CODE),
220: ACTUAL_START_DATE = decode(p_ACTUAL_START_DATE,FND_API.G_MISS_DATE,ACTUAL_START_DATE,p_ACTUAL_START_DATE),
213: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
214: LAST_UPDATED_BY = p_LAST_UPDATED_BY,
215: LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,
216: COMPLETED_PERCENTAGE = decode(p_COMPLETED_PERCENTAGE,FND_API.G_MISS_NUM,COMPLETED_PERCENTAGE,p_COMPLETED_PERCENTAGE),
217: DESCRIPTION = decode(p_DESCRIPTION,FND_API.G_MISS_CHAR,DESCRIPTION,p_DESCRIPTION),
218: CURRENT_FLAG = decode(p_CURRENT_FLAG,FND_API.G_MISS_CHAR,CURRENT_FLAG,p_CURRENT_FLAG),
219: PROGRESS_STATUS_CODE = decode(p_PROGRESS_STATUS_CODE,FND_API.G_MISS_CHAR,PROGRESS_STATUS_CODE,p_PROGRESS_STATUS_CODE),
220: ACTUAL_START_DATE = decode(p_ACTUAL_START_DATE,FND_API.G_MISS_DATE,ACTUAL_START_DATE,p_ACTUAL_START_DATE),
221: ACTUAL_FINISH_DATE = decode(p_ACTUAL_FINISH_DATE,FND_API.G_MISS_DATE,ACTUAL_FINISH_DATE,p_ACTUAL_FINISH_DATE),
214: LAST_UPDATED_BY = p_LAST_UPDATED_BY,
215: LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,
216: COMPLETED_PERCENTAGE = decode(p_COMPLETED_PERCENTAGE,FND_API.G_MISS_NUM,COMPLETED_PERCENTAGE,p_COMPLETED_PERCENTAGE),
217: DESCRIPTION = decode(p_DESCRIPTION,FND_API.G_MISS_CHAR,DESCRIPTION,p_DESCRIPTION),
218: CURRENT_FLAG = decode(p_CURRENT_FLAG,FND_API.G_MISS_CHAR,CURRENT_FLAG,p_CURRENT_FLAG),
219: PROGRESS_STATUS_CODE = decode(p_PROGRESS_STATUS_CODE,FND_API.G_MISS_CHAR,PROGRESS_STATUS_CODE,p_PROGRESS_STATUS_CODE),
220: ACTUAL_START_DATE = decode(p_ACTUAL_START_DATE,FND_API.G_MISS_DATE,ACTUAL_START_DATE,p_ACTUAL_START_DATE),
221: ACTUAL_FINISH_DATE = decode(p_ACTUAL_FINISH_DATE,FND_API.G_MISS_DATE,ACTUAL_FINISH_DATE,p_ACTUAL_FINISH_DATE),
222: ESTIMATED_START_DATE = decode(p_ESTIMATED_START_DATE,FND_API.G_MISS_DATE,ESTIMATED_START_DATE,p_ESTIMATED_START_DATE),
215: LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,
216: COMPLETED_PERCENTAGE = decode(p_COMPLETED_PERCENTAGE,FND_API.G_MISS_NUM,COMPLETED_PERCENTAGE,p_COMPLETED_PERCENTAGE),
217: DESCRIPTION = decode(p_DESCRIPTION,FND_API.G_MISS_CHAR,DESCRIPTION,p_DESCRIPTION),
218: CURRENT_FLAG = decode(p_CURRENT_FLAG,FND_API.G_MISS_CHAR,CURRENT_FLAG,p_CURRENT_FLAG),
219: PROGRESS_STATUS_CODE = decode(p_PROGRESS_STATUS_CODE,FND_API.G_MISS_CHAR,PROGRESS_STATUS_CODE,p_PROGRESS_STATUS_CODE),
220: ACTUAL_START_DATE = decode(p_ACTUAL_START_DATE,FND_API.G_MISS_DATE,ACTUAL_START_DATE,p_ACTUAL_START_DATE),
221: ACTUAL_FINISH_DATE = decode(p_ACTUAL_FINISH_DATE,FND_API.G_MISS_DATE,ACTUAL_FINISH_DATE,p_ACTUAL_FINISH_DATE),
222: ESTIMATED_START_DATE = decode(p_ESTIMATED_START_DATE,FND_API.G_MISS_DATE,ESTIMATED_START_DATE,p_ESTIMATED_START_DATE),
223: ESTIMATED_FINISH_DATE = decode(p_ESTIMATED_FINISH_DATE,FND_API.G_MISS_DATE,ESTIMATED_FINISH_DATE,p_ESTIMATED_FINISH_DATE),
216: COMPLETED_PERCENTAGE = decode(p_COMPLETED_PERCENTAGE,FND_API.G_MISS_NUM,COMPLETED_PERCENTAGE,p_COMPLETED_PERCENTAGE),
217: DESCRIPTION = decode(p_DESCRIPTION,FND_API.G_MISS_CHAR,DESCRIPTION,p_DESCRIPTION),
218: CURRENT_FLAG = decode(p_CURRENT_FLAG,FND_API.G_MISS_CHAR,CURRENT_FLAG,p_CURRENT_FLAG),
219: PROGRESS_STATUS_CODE = decode(p_PROGRESS_STATUS_CODE,FND_API.G_MISS_CHAR,PROGRESS_STATUS_CODE,p_PROGRESS_STATUS_CODE),
220: ACTUAL_START_DATE = decode(p_ACTUAL_START_DATE,FND_API.G_MISS_DATE,ACTUAL_START_DATE,p_ACTUAL_START_DATE),
221: ACTUAL_FINISH_DATE = decode(p_ACTUAL_FINISH_DATE,FND_API.G_MISS_DATE,ACTUAL_FINISH_DATE,p_ACTUAL_FINISH_DATE),
222: ESTIMATED_START_DATE = decode(p_ESTIMATED_START_DATE,FND_API.G_MISS_DATE,ESTIMATED_START_DATE,p_ESTIMATED_START_DATE),
223: ESTIMATED_FINISH_DATE = decode(p_ESTIMATED_FINISH_DATE,FND_API.G_MISS_DATE,ESTIMATED_FINISH_DATE,p_ESTIMATED_FINISH_DATE),
224: published_FLAG = decode(p_published_FLAG,FND_API.G_MISS_CHAR,published_FLAG,p_published_FLAG),
217: DESCRIPTION = decode(p_DESCRIPTION,FND_API.G_MISS_CHAR,DESCRIPTION,p_DESCRIPTION),
218: CURRENT_FLAG = decode(p_CURRENT_FLAG,FND_API.G_MISS_CHAR,CURRENT_FLAG,p_CURRENT_FLAG),
219: PROGRESS_STATUS_CODE = decode(p_PROGRESS_STATUS_CODE,FND_API.G_MISS_CHAR,PROGRESS_STATUS_CODE,p_PROGRESS_STATUS_CODE),
220: ACTUAL_START_DATE = decode(p_ACTUAL_START_DATE,FND_API.G_MISS_DATE,ACTUAL_START_DATE,p_ACTUAL_START_DATE),
221: ACTUAL_FINISH_DATE = decode(p_ACTUAL_FINISH_DATE,FND_API.G_MISS_DATE,ACTUAL_FINISH_DATE,p_ACTUAL_FINISH_DATE),
222: ESTIMATED_START_DATE = decode(p_ESTIMATED_START_DATE,FND_API.G_MISS_DATE,ESTIMATED_START_DATE,p_ESTIMATED_START_DATE),
223: ESTIMATED_FINISH_DATE = decode(p_ESTIMATED_FINISH_DATE,FND_API.G_MISS_DATE,ESTIMATED_FINISH_DATE,p_ESTIMATED_FINISH_DATE),
224: published_FLAG = decode(p_published_FLAG,FND_API.G_MISS_CHAR,published_FLAG,p_published_FLAG),
225: PUBLISHED_BY_PARTY_ID = decode(PUBLISHED_BY_PARTY_ID,FND_API.G_MISS_NUM,PUBLISHED_BY_PARTY_ID,p_PUBLISHED_BY_PARTY_ID),
218: CURRENT_FLAG = decode(p_CURRENT_FLAG,FND_API.G_MISS_CHAR,CURRENT_FLAG,p_CURRENT_FLAG),
219: PROGRESS_STATUS_CODE = decode(p_PROGRESS_STATUS_CODE,FND_API.G_MISS_CHAR,PROGRESS_STATUS_CODE,p_PROGRESS_STATUS_CODE),
220: ACTUAL_START_DATE = decode(p_ACTUAL_START_DATE,FND_API.G_MISS_DATE,ACTUAL_START_DATE,p_ACTUAL_START_DATE),
221: ACTUAL_FINISH_DATE = decode(p_ACTUAL_FINISH_DATE,FND_API.G_MISS_DATE,ACTUAL_FINISH_DATE,p_ACTUAL_FINISH_DATE),
222: ESTIMATED_START_DATE = decode(p_ESTIMATED_START_DATE,FND_API.G_MISS_DATE,ESTIMATED_START_DATE,p_ESTIMATED_START_DATE),
223: ESTIMATED_FINISH_DATE = decode(p_ESTIMATED_FINISH_DATE,FND_API.G_MISS_DATE,ESTIMATED_FINISH_DATE,p_ESTIMATED_FINISH_DATE),
224: published_FLAG = decode(p_published_FLAG,FND_API.G_MISS_CHAR,published_FLAG,p_published_FLAG),
225: PUBLISHED_BY_PARTY_ID = decode(PUBLISHED_BY_PARTY_ID,FND_API.G_MISS_NUM,PUBLISHED_BY_PARTY_ID,p_PUBLISHED_BY_PARTY_ID),
226: PROGRESS_COMMENT = decode(p_PROGRESS_COMMENT,FND_API.G_MISS_CHAR,PROGRESS_COMMENT,p_PROGRESS_COMMENT),
219: PROGRESS_STATUS_CODE = decode(p_PROGRESS_STATUS_CODE,FND_API.G_MISS_CHAR,PROGRESS_STATUS_CODE,p_PROGRESS_STATUS_CODE),
220: ACTUAL_START_DATE = decode(p_ACTUAL_START_DATE,FND_API.G_MISS_DATE,ACTUAL_START_DATE,p_ACTUAL_START_DATE),
221: ACTUAL_FINISH_DATE = decode(p_ACTUAL_FINISH_DATE,FND_API.G_MISS_DATE,ACTUAL_FINISH_DATE,p_ACTUAL_FINISH_DATE),
222: ESTIMATED_START_DATE = decode(p_ESTIMATED_START_DATE,FND_API.G_MISS_DATE,ESTIMATED_START_DATE,p_ESTIMATED_START_DATE),
223: ESTIMATED_FINISH_DATE = decode(p_ESTIMATED_FINISH_DATE,FND_API.G_MISS_DATE,ESTIMATED_FINISH_DATE,p_ESTIMATED_FINISH_DATE),
224: published_FLAG = decode(p_published_FLAG,FND_API.G_MISS_CHAR,published_FLAG,p_published_FLAG),
225: PUBLISHED_BY_PARTY_ID = decode(PUBLISHED_BY_PARTY_ID,FND_API.G_MISS_NUM,PUBLISHED_BY_PARTY_ID,p_PUBLISHED_BY_PARTY_ID),
226: PROGRESS_COMMENT = decode(p_PROGRESS_COMMENT,FND_API.G_MISS_CHAR,PROGRESS_COMMENT,p_PROGRESS_COMMENT),
227: HISTORY_FLAG = decode(p_HISTORY_FLAG,FND_API.G_MISS_CHAR,HISTORY_FLAG,p_HISTORY_FLAG),
220: ACTUAL_START_DATE = decode(p_ACTUAL_START_DATE,FND_API.G_MISS_DATE,ACTUAL_START_DATE,p_ACTUAL_START_DATE),
221: ACTUAL_FINISH_DATE = decode(p_ACTUAL_FINISH_DATE,FND_API.G_MISS_DATE,ACTUAL_FINISH_DATE,p_ACTUAL_FINISH_DATE),
222: ESTIMATED_START_DATE = decode(p_ESTIMATED_START_DATE,FND_API.G_MISS_DATE,ESTIMATED_START_DATE,p_ESTIMATED_START_DATE),
223: ESTIMATED_FINISH_DATE = decode(p_ESTIMATED_FINISH_DATE,FND_API.G_MISS_DATE,ESTIMATED_FINISH_DATE,p_ESTIMATED_FINISH_DATE),
224: published_FLAG = decode(p_published_FLAG,FND_API.G_MISS_CHAR,published_FLAG,p_published_FLAG),
225: PUBLISHED_BY_PARTY_ID = decode(PUBLISHED_BY_PARTY_ID,FND_API.G_MISS_NUM,PUBLISHED_BY_PARTY_ID,p_PUBLISHED_BY_PARTY_ID),
226: PROGRESS_COMMENT = decode(p_PROGRESS_COMMENT,FND_API.G_MISS_CHAR,PROGRESS_COMMENT,p_PROGRESS_COMMENT),
227: HISTORY_FLAG = decode(p_HISTORY_FLAG,FND_API.G_MISS_CHAR,HISTORY_FLAG,p_HISTORY_FLAG),
228: status_code = decode(p_status_code,FND_API.G_MISS_CHAR,status_code,p_status_code),
221: ACTUAL_FINISH_DATE = decode(p_ACTUAL_FINISH_DATE,FND_API.G_MISS_DATE,ACTUAL_FINISH_DATE,p_ACTUAL_FINISH_DATE),
222: ESTIMATED_START_DATE = decode(p_ESTIMATED_START_DATE,FND_API.G_MISS_DATE,ESTIMATED_START_DATE,p_ESTIMATED_START_DATE),
223: ESTIMATED_FINISH_DATE = decode(p_ESTIMATED_FINISH_DATE,FND_API.G_MISS_DATE,ESTIMATED_FINISH_DATE,p_ESTIMATED_FINISH_DATE),
224: published_FLAG = decode(p_published_FLAG,FND_API.G_MISS_CHAR,published_FLAG,p_published_FLAG),
225: PUBLISHED_BY_PARTY_ID = decode(PUBLISHED_BY_PARTY_ID,FND_API.G_MISS_NUM,PUBLISHED_BY_PARTY_ID,p_PUBLISHED_BY_PARTY_ID),
226: PROGRESS_COMMENT = decode(p_PROGRESS_COMMENT,FND_API.G_MISS_CHAR,PROGRESS_COMMENT,p_PROGRESS_COMMENT),
227: HISTORY_FLAG = decode(p_HISTORY_FLAG,FND_API.G_MISS_CHAR,HISTORY_FLAG,p_HISTORY_FLAG),
228: status_code = decode(p_status_code,FND_API.G_MISS_CHAR,status_code,p_status_code),
229: RECORD_VERSION_NUMBER = RECORD_VERSION_NUMBER + 1
222: ESTIMATED_START_DATE = decode(p_ESTIMATED_START_DATE,FND_API.G_MISS_DATE,ESTIMATED_START_DATE,p_ESTIMATED_START_DATE),
223: ESTIMATED_FINISH_DATE = decode(p_ESTIMATED_FINISH_DATE,FND_API.G_MISS_DATE,ESTIMATED_FINISH_DATE,p_ESTIMATED_FINISH_DATE),
224: published_FLAG = decode(p_published_FLAG,FND_API.G_MISS_CHAR,published_FLAG,p_published_FLAG),
225: PUBLISHED_BY_PARTY_ID = decode(PUBLISHED_BY_PARTY_ID,FND_API.G_MISS_NUM,PUBLISHED_BY_PARTY_ID,p_PUBLISHED_BY_PARTY_ID),
226: PROGRESS_COMMENT = decode(p_PROGRESS_COMMENT,FND_API.G_MISS_CHAR,PROGRESS_COMMENT,p_PROGRESS_COMMENT),
227: HISTORY_FLAG = decode(p_HISTORY_FLAG,FND_API.G_MISS_CHAR,HISTORY_FLAG,p_HISTORY_FLAG),
228: status_code = decode(p_status_code,FND_API.G_MISS_CHAR,status_code,p_status_code),
229: RECORD_VERSION_NUMBER = RECORD_VERSION_NUMBER + 1
230: ,ATTRIBUTE_CATEGORY = DECODE( P_ATTRIBUTE_CATEGORY, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
223: ESTIMATED_FINISH_DATE = decode(p_ESTIMATED_FINISH_DATE,FND_API.G_MISS_DATE,ESTIMATED_FINISH_DATE,p_ESTIMATED_FINISH_DATE),
224: published_FLAG = decode(p_published_FLAG,FND_API.G_MISS_CHAR,published_FLAG,p_published_FLAG),
225: PUBLISHED_BY_PARTY_ID = decode(PUBLISHED_BY_PARTY_ID,FND_API.G_MISS_NUM,PUBLISHED_BY_PARTY_ID,p_PUBLISHED_BY_PARTY_ID),
226: PROGRESS_COMMENT = decode(p_PROGRESS_COMMENT,FND_API.G_MISS_CHAR,PROGRESS_COMMENT,p_PROGRESS_COMMENT),
227: HISTORY_FLAG = decode(p_HISTORY_FLAG,FND_API.G_MISS_CHAR,HISTORY_FLAG,p_HISTORY_FLAG),
228: status_code = decode(p_status_code,FND_API.G_MISS_CHAR,status_code,p_status_code),
229: RECORD_VERSION_NUMBER = RECORD_VERSION_NUMBER + 1
230: ,ATTRIBUTE_CATEGORY = DECODE( P_ATTRIBUTE_CATEGORY, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
231: ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY )
224: published_FLAG = decode(p_published_FLAG,FND_API.G_MISS_CHAR,published_FLAG,p_published_FLAG),
225: PUBLISHED_BY_PARTY_ID = decode(PUBLISHED_BY_PARTY_ID,FND_API.G_MISS_NUM,PUBLISHED_BY_PARTY_ID,p_PUBLISHED_BY_PARTY_ID),
226: PROGRESS_COMMENT = decode(p_PROGRESS_COMMENT,FND_API.G_MISS_CHAR,PROGRESS_COMMENT,p_PROGRESS_COMMENT),
227: HISTORY_FLAG = decode(p_HISTORY_FLAG,FND_API.G_MISS_CHAR,HISTORY_FLAG,p_HISTORY_FLAG),
228: status_code = decode(p_status_code,FND_API.G_MISS_CHAR,status_code,p_status_code),
229: RECORD_VERSION_NUMBER = RECORD_VERSION_NUMBER + 1
230: ,ATTRIBUTE_CATEGORY = DECODE( P_ATTRIBUTE_CATEGORY, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
231: ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY )
232: ,ATTRIBUTE1 = DECODE( P_ATTRIBUTE1, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,