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: citypeimpact ci_type_impact%rowtype;
112: ciimpact ci_impact%rowtype;

Line 166: from pa_ci_impacts

162: elsif (ci_impact%found and impact_1 = 'Y') then
163: begin
164: select 'Y'
165: into temp
166: from pa_ci_impacts
167: where ci_id = p_ci_id_2
168: and impact_type_code <> 'FINPLAN' /* Bug# 3724520 */
169: and impact_Type_code not in (select impact_Type_code
170: from pa_ci_impact_type_usage

Line 850: SELECT * FROM pa_ci_impacts

846: is
847: SELECT 'Y' FROM dual
848: WHERE exists
849: (
850: SELECT * FROM pa_ci_impacts
851: WHERE ci_id = p_ci_id
852: AND impact_type_code = 'FINPLAN'
853: );
854:

Line 2138: SELECT * FROM pa_ci_impacts

2134: is
2135: SELECT 'Y' FROM dual
2136: WHERE exists
2137: (
2138: SELECT * FROM pa_ci_impacts
2139: WHERE ci_id = p_ci_id
2140: AND impact_type_code like 'FINPLAN%'
2141: );
2142:

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

2404: l_type := getcitypeclasscode(p_ci_id);
2405:
2406: IF l_type = 'CHANGE_ORDER' OR l_type = 'CHANGE_REQUEST' THEN
2407: -- check if any impact is implemented
2408: l_ret := pa_ci_impacts_util.is_any_impact_implemented(p_ci_id);
2409:
2410:
2411: IF (l_ret ) THEN
2412: PA_UTILS.Add_Message( p_app_short_name => 'PA'

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

2454:
2455: IF l_type = 'CHANGE_ORDER' THEN
2456: -- check if any impact is implemented
2457:
2458: l_ret := pa_ci_impacts_util.is_all_impact_implemented(p_ci_id);
2459:
2460: IF (NOT l_ret ) THEN
2461: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2462: ,p_msg_name => 'PA_CI_CLOSE_INV_IMP');

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

2512: END IF;
2513:
2514: IF l_next_sys_status = 'CI_WORKING' THEN
2515: -- check no impact is implemented
2516: l_ret := pa_ci_impacts_util.is_any_impact_implemented(p_ci_id);
2517:
2518: IF (l_ret ) THEN
2519: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2520: ,p_msg_name => 'PA_CI_WORKING_INV_IMP');

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

2531: l_type := getcitypeclasscode(p_ci_id);
2532:
2533: -- check all impact are implemented
2534: IF l_type = 'CHANGE_ORDER' then
2535: l_ret := pa_ci_impacts_util.is_all_impact_implemented(p_ci_id);
2536:
2537: IF (NOT l_ret ) THEN
2538: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2539: ,p_msg_name => 'PA_CI_CLOSE_INV_IMP');

Line 2550: l_ret := pa_ci_impacts_util.is_any_impact_implemented

2546:
2547: ELSIF l_next_sys_status = 'CI_CANCELED' THEN
2548: -- check no impact is implemented
2549:
2550: l_ret := pa_ci_impacts_util.is_any_impact_implemented
2551: (p_ci_id);
2552:
2553: IF (l_ret ) THEN
2554: PA_UTILS.Add_Message( p_app_short_name => 'PA'