APPS.PA_CONTROL_API_PVT dependencies on PA_CI_ACTIONS

Line 2747: from pa_ci_actions

2743: and meaning = p_action_type_code;
2744:
2745: cursor check_valid_src_ci_action_id(p_action_id number) is
2746: select ci_action_id, status_code
2747: from pa_ci_actions
2748: where source_ci_action_id = p_action_id;
2749:
2750:
2751: cursor chk_action_status_code(p_action_status VARCHAR2)

Line 2782: --l_src_ci_action_id pa_ci_actions.ci_action_id%type;

2778: l_return_status VARCHAR2(1);
2779:
2780: l_action_status_code pa_project_statuses.project_status_code%type;
2781: l_ci_status_code pa_control_items.status_code%type;
2782: --l_src_ci_action_id pa_ci_actions.ci_action_id%type;
2783: l_action_tbl pa_control_api_pub.ci_actions_in_tbl_type;
2784: chk_valid_src_ci_action_id_rec check_valid_src_ci_action_id%rowtype;
2785:
2786: BEGIN

Line 3099: l_action_number pa_ci_actions.ci_action_number%type;

3095: l_msg_data VARCHAR2(2000);
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;

Line 3102: l_ci_action_id pa_ci_actions.ci_action_id%type;

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;
3106: l_num_of_actions number;

Line 3141: l_action_number := PA_CI_ACTIONS_UTIL.get_next_ci_action_number(p_ci_id);

3137: For i in 1..p_action_tbl.count
3138: loop
3139: /*get the action number*/
3140: if (p_ci_id IS NOT NULL) then
3141: l_action_number := PA_CI_ACTIONS_UTIL.get_next_ci_action_number(p_ci_id);
3142: end if;
3143:
3144: if l_debug_mode = 'Y' then
3145: pa_debug.g_err_stage := 'calling insert row to create the action';

Line 3149: /*insert row in pa_ci_actions*/

3145: pa_debug.g_err_stage := 'calling insert row to create the action';
3146: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3147: end if;
3148:
3149: /*insert row in pa_ci_actions*/
3150: pa_ci_actions_pkg.insert_row(
3151: p_ci_action_id => l_ci_action_id, -- this is out paramter
3152: p_ci_id => p_ci_id,
3153: p_ci_action_number => l_action_number,

Line 3150: pa_ci_actions_pkg.insert_row(

3146: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3147: end if;
3148:
3149: /*insert row in pa_ci_actions*/
3150: pa_ci_actions_pkg.insert_row(
3151: p_ci_action_id => l_ci_action_id, -- this is out paramter
3152: p_ci_id => p_ci_id,
3153: p_ci_action_number => l_action_number,
3154: p_status_code => p_action_tbl(i).action_status,

Line 3342: from pa_ci_actions pca,

3338:
3339: cursor get_ci_action_id(p_ci_id number, p_action_number number)
3340: is
3341: select pca.ci_action_id, pca.assigned_to, pci.project_id
3342: from pa_ci_actions pca,
3343: pa_control_items pci
3344: where pca.ci_id = p_ci_id
3345: and pca.ci_action_number = p_action_number
3346: and pci.ci_id = p_ci_id;

Line 3351: from pa_ci_actions pca,

3347:
3348: cursor validate_ci_action_id(p_action_id number)
3349: is
3350: select pca.ci_action_id, pca.assigned_to, pci.project_id
3351: from pa_ci_actions pca,
3352: pa_control_items pci
3353: where pca.ci_action_id = p_action_id
3354: and pci.ci_id = pca.ci_id;
3355: