[Home] [Help]
2760: and meaning = p_action_type_code;
2761:
2762: cursor check_valid_src_ci_action_id(p_action_id number) is
2763: select ci_action_id, status_code
2764: from pa_ci_actions
2765: where source_ci_action_id = p_action_id;
2766:
2767:
2768: cursor chk_action_status_code(p_action_status VARCHAR2)
2795: l_return_status VARCHAR2(1);
2796:
2797: l_action_status_code pa_project_statuses.project_status_code%type;
2798: l_ci_status_code pa_control_items.status_code%type;
2799: --l_src_ci_action_id pa_ci_actions.ci_action_id%type;
2800: l_action_tbl pa_control_api_pub.ci_actions_in_tbl_type;
2801: chk_valid_src_ci_action_id_rec check_valid_src_ci_action_id%rowtype;
2802:
2803: BEGIN
3112: l_msg_data VARCHAR2(2000);
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;
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;
3123: l_num_of_actions number;
3154: For i in 1..p_action_tbl.count
3155: loop
3156: /*get the action number*/
3157: if (p_ci_id IS NOT NULL) then
3158: l_action_number := PA_CI_ACTIONS_UTIL.get_next_ci_action_number(p_ci_id);
3159: end if;
3160:
3161: if l_debug_mode = 'Y' then
3162: pa_debug.g_err_stage := 'calling insert row to create the action';
3162: pa_debug.g_err_stage := 'calling insert row to create the action';
3163: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3164: end if;
3165:
3166: /*insert row in pa_ci_actions*/
3167: pa_ci_actions_pkg.insert_row(
3168: p_ci_action_id => l_ci_action_id, -- this is out paramter
3169: p_ci_id => p_ci_id,
3170: p_ci_action_number => l_action_number,
3163: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3164: end if;
3165:
3166: /*insert row in pa_ci_actions*/
3167: pa_ci_actions_pkg.insert_row(
3168: p_ci_action_id => l_ci_action_id, -- this is out paramter
3169: p_ci_id => p_ci_id,
3170: p_ci_action_number => l_action_number,
3171: p_status_code => p_action_tbl(i).action_status,
3355:
3356: cursor get_ci_action_id(p_ci_id number, p_action_number number)
3357: is
3358: select pca.ci_action_id, pca.assigned_to, pci.project_id
3359: from pa_ci_actions pca,
3360: pa_control_items pci
3361: where pca.ci_id = p_ci_id
3362: and pca.ci_action_number = p_action_number
3363: and pci.ci_id = p_ci_id;
3364:
3365: cursor validate_ci_action_id(p_action_id number)
3366: is
3367: select pca.ci_action_id, pca.assigned_to, pci.project_id
3368: from pa_ci_actions pca,
3369: pa_control_items pci
3370: where pca.ci_action_id = p_action_id
3371: and pci.ci_id = pca.ci_id;
3372: