[Home] [Help]
3096: l_msg_index_out NUMBER;
3097: l_module_name VARCHAR2(200);
3098: l_any_err_occured_flg VARCHAR2(1);
3099: l_action_number pa_ci_actions.ci_action_number%type;
3100: l_ci_comment_id pa_ci_comments.ci_comment_id%type;
3101: l_type_code pa_ci_comments.type_code%type;
3102: l_ci_action_id pa_ci_actions.ci_action_id%type;
3103: l_ci_record_version_number pa_control_items.record_version_number%type;
3104: l_process_name varchar(100);
3097: l_module_name VARCHAR2(200);
3098: l_any_err_occured_flg VARCHAR2(1);
3099: l_action_number pa_ci_actions.ci_action_number%type;
3100: l_ci_comment_id pa_ci_comments.ci_comment_id%type;
3101: l_type_code pa_ci_comments.type_code%type;
3102: l_ci_action_id pa_ci_actions.ci_action_id%type;
3103: l_ci_record_version_number pa_control_items.record_version_number%type;
3104: l_process_name varchar(100);
3105: l_item_key pa_wf_processes.item_key%TYPE;
3169: /* now prepare the output table to store the output values*/
3170: x_action_tbl(i).action_id := l_ci_action_id;
3171: x_action_tbl(i).action_number := l_action_number;
3172:
3173: /*set the type_code for the pa_ci_comments table before inserting comment in it*/
3174: if(p_action_tbl(i).action_status = 'CI_ACTION_CLOSED' or p_action_tbl(i).action_status = 'CI_ACTION_CANCELED') then
3175: l_type_code := 'CLOSURE';
3176: elsif(p_action_tbl(i).action_status = 'CI_ACTION_OPEN') then
3177: l_type_code := 'REQUESTOR';
3182: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3183: end if;
3184:
3185: /*now call the add comment api*/
3186: pa_ci_comments_pkg.insert_row(
3187: p_ci_comment_id => l_ci_comment_id,
3188: p_ci_id => p_ci_id,
3189: p_type_code => l_type_code,
3190: p_comment_text => p_action_tbl(i).request_text,