[Home] [Help]
2235: ,x_return_status => x_return_status
2236: ,x_msg_count => x_msg_count
2237: ,x_msg_data => x_msg_data);
2238:
2239: exit when pa_control_items_pvt.ci_number_exists(p_project_id, l_ci_number_char
2240: ,p_ci_type_id) = FALSE;
2241: end loop;
2242: else --p_auto_number_flag = 'Y' and l_system_status_code <> 'CI_DRAFT'
2243: /*For manual numbering check if passed ci_number already exist.*/
2241: end loop;
2242: else --p_auto_number_flag = 'Y' and l_system_status_code <> 'CI_DRAFT'
2243: /*For manual numbering check if passed ci_number already exist.*/
2244: l_ci_number_char := p_ci_number;
2245: if pa_control_items_pvt.ci_number_exists(p_project_id, l_ci_number_char ,p_ci_type_id) = TRUE then
2246: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2247: ,p_msg_name => 'PA_CI_DUPLICATE_CI_NUMBER');--msg already there
2248: if l_debug_mode = 'Y' then
2249: pa_debug.g_err_stage:= 'Duplicate ci_number passed.';
3204: if(p_action_tbl(i).action_status = 'CI_ACTION_OPEN') then
3205: l_num_open_action := l_num_open_action + 1;
3206: end if;
3207:
3208: /* pa_control_items_pvt.update_number_of_actions (
3209: p_ci_id => p_ci_id,
3210: p_num_of_actions => 1,
3211: p_record_version_number => l_ci_record_version_number,
3212: x_num_of_actions => l_num_of_actions,
3268:
3269: --if there were any open actions update the no of open action in pa_control_items
3270: --this has to be done outside the loop only once for all the open actions in table.
3271: if(l_num_open_action is not null and l_num_open_action > 0 ) then
3272: pa_control_items_pvt.update_number_of_actions (
3273: p_ci_id => p_ci_id,
3274: p_num_of_actions => l_num_open_action,
3275: p_record_version_number => l_ci_record_version_number,
3276: x_num_of_actions => l_num_of_actions,