APPS.PA_CONTROL_ITEMS_UTILS dependencies on PA_CI_IMPACTS

Line 108: from pa_ci_impacts

104: where ci_type_id = p_ci_type_id;
105:
106: cursor ci_impact is
107: select impact_type_code
108: from pa_ci_impacts
109: where ci_id = p_ci_id;
110:
111: cursor budget_type_code is
112: SELECT impact_budget_type_code

Line 210: from pa_ci_impacts

206: elsif (ci_impact%found and impact_1 = 'Y') then
207: begin
208: select 'Y'
209: into temp
210: from pa_ci_impacts
211: where ci_id = p_ci_id_2
212: and impact_type_code <> 'FINPLAN' /* Bug# 3724520 */
213: and impact_Type_code not in (select impact_Type_code
214: from pa_ci_impact_type_usage

Line 894: SELECT * FROM pa_ci_impacts

890: is
891: SELECT 'Y' FROM dual
892: WHERE exists
893: (
894: SELECT * FROM pa_ci_impacts
895: WHERE ci_id = p_ci_id
896: AND impact_type_code = 'FINPLAN'
897: );
898:

Line 2234: SELECT * FROM pa_ci_impacts

2230: is
2231: SELECT 'Y' FROM dual
2232: WHERE exists
2233: (
2234: SELECT * FROM pa_ci_impacts
2235: WHERE ci_id = p_ci_id
2236: AND impact_type_code like 'FINPLAN%'
2237: );
2238:

Line 2519: l_ret := pa_ci_impacts_util.is_any_impact_implemented(p_ci_id);

2515: l_type := getcitypeclasscode(p_ci_id);
2516:
2517: IF l_type = 'CHANGE_ORDER' OR l_type = 'CHANGE_REQUEST' THEN
2518: -- check if any impact is implemented
2519: l_ret := pa_ci_impacts_util.is_any_impact_implemented(p_ci_id);
2520:
2521:
2522: IF (l_ret ) THEN
2523: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 2569: l_ret := pa_ci_impacts_util.is_all_impact_implemented(p_ci_id);

2565:
2566: IF l_type = 'CHANGE_ORDER' THEN
2567: -- check if any impact is implemented
2568:
2569: l_ret := pa_ci_impacts_util.is_all_impact_implemented(p_ci_id);
2570:
2571: IF (NOT l_ret ) THEN
2572: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2573: ,p_msg_name => 'PA_CI_CLOSE_INV_IMP');

Line 2627: l_ret := pa_ci_impacts_util.is_any_impact_implemented(p_ci_id);

2623: END IF;
2624:
2625: IF l_next_sys_status = 'CI_WORKING' THEN
2626: -- check no impact is implemented
2627: l_ret := pa_ci_impacts_util.is_any_impact_implemented(p_ci_id);
2628:
2629: IF (l_ret ) THEN
2630: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2631: ,p_msg_name => 'PA_CI_WORKING_INV_IMP');

Line 2646: l_ret := pa_ci_impacts_util.is_all_impact_implemented(p_ci_id);

2642: l_type := getcitypeclasscode(p_ci_id);
2643:
2644: -- check all impact are implemented
2645: IF l_type = 'CHANGE_ORDER' then
2646: l_ret := pa_ci_impacts_util.is_all_impact_implemented(p_ci_id);
2647:
2648: IF (NOT l_ret ) THEN
2649: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2650: ,p_msg_name => 'PA_CI_CLOSE_INV_IMP');

Line 2661: l_ret := pa_ci_impacts_util.is_any_impact_implemented

2657:
2658: ELSIF l_next_sys_status = 'CI_CANCELED' THEN
2659: -- check no impact is implemented
2660:
2661: l_ret := pa_ci_impacts_util.is_any_impact_implemented
2662: (p_ci_id);
2663:
2664: IF (l_ret ) THEN
2665: PA_UTILS.Add_Message( p_app_short_name => 'PA'