[Home] [Help]
3113: l_msg_index_out NUMBER;
3114: l_module_name VARCHAR2(200);
3115: l_any_err_occured_flg VARCHAR2(1);
3116: l_action_number pa_ci_actions.ci_action_number%type;
3117: l_ci_comment_id pa_ci_comments.ci_comment_id%type;
3118: l_type_code pa_ci_comments.type_code%type;
3119: l_ci_action_id pa_ci_actions.ci_action_id%type;
3120: l_ci_record_version_number pa_control_items.record_version_number%type;
3121: l_process_name varchar(100);
3114: l_module_name VARCHAR2(200);
3115: l_any_err_occured_flg VARCHAR2(1);
3116: l_action_number pa_ci_actions.ci_action_number%type;
3117: l_ci_comment_id pa_ci_comments.ci_comment_id%type;
3118: l_type_code pa_ci_comments.type_code%type;
3119: l_ci_action_id pa_ci_actions.ci_action_id%type;
3120: l_ci_record_version_number pa_control_items.record_version_number%type;
3121: l_process_name varchar(100);
3122: l_item_key pa_wf_processes.item_key%TYPE;
3186: /* now prepare the output table to store the output values*/
3187: x_action_tbl(i).action_id := l_ci_action_id;
3188: x_action_tbl(i).action_number := l_action_number;
3189:
3190: /*set the type_code for the pa_ci_comments table before inserting comment in it*/
3191: if(p_action_tbl(i).action_status = 'CI_ACTION_CLOSED' or p_action_tbl(i).action_status = 'CI_ACTION_CANCELED') then
3192: l_type_code := 'CLOSURE';
3193: elsif(p_action_tbl(i).action_status = 'CI_ACTION_OPEN') then
3194: l_type_code := 'REQUESTOR';
3199: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3200: end if;
3201:
3202: /*now call the add comment api*/
3203: pa_ci_comments_pkg.insert_row(
3204: p_ci_comment_id => l_ci_comment_id,
3205: p_ci_id => p_ci_id,
3206: p_type_code => l_type_code,
3207: p_comment_text => p_action_tbl(i).request_text,