APPS.PA_FP_CI_INCLUDE_PKG dependencies on PA_CONTROL_ITEMS

Line 61: l_source_project_id pa_control_items.project_id%TYPE;

57: l_count_versions NUMBER := 0;
58: l_count_projects NUMBER := 0;
59: l_target_plan_types_cnt NUMBER := 0;
60: l_merged_count NUMBER := 0;
61: l_source_project_id pa_control_items.project_id%TYPE;
62:
63: BEGIN
64: savepoint before_copy_control_items;
65: pa_debug.init_err_stack('PAFPINCB.FP_CI_COPY_CONTROL_ITEMS');

Line 119: FROM pa_control_items bv

115: --to the same project or not as the target control item id
116:
117: SELECT bv.project_id
118: INTO l_source_project_id
119: FROM pa_control_items bv
120: WHERE
121: bv.ci_id = l_s_fp_ci_id;
122:
123: --DBMS_OUTPUT.PUT_LINE('l_source_project_id : ' || l_source_project_id);

Line 224: FROM pa_control_items bv

220: --Check if the source control item id belongs
221: --to the same project or not as the target control item id
222: SELECT bv.project_id
223: INTO l_source_project_id
224: FROM pa_control_items bv
225: WHERE
226: bv.ci_id = l_s_fp_ci_id;
227:
228: --DBMS_OUTPUT.PUT_LINE('l_source_project_id : ' || l_source_project_id);

Line 375: FROM pa_control_items targetCi,

371: WHERE a.ci_id = p_source_ci_id
372: AND a.impact_type_code IN ('FINPLAN_COST','FINPLAN_REVENUE','FINPLAN')
373: AND (a.impact_type_code = 'FINPLAN' OR
374: EXISTS (SELECT 1
375: FROM pa_control_items targetCi,
376: pa_ci_impact_type_usage targetUsage
377: WHERE targetCi.ci_id = p_target_ci_id
378: AND targetCi.ci_type_id = targetUsage.ci_type_id
379: AND targetUsage.impact_type_code = a.impact_type_code));

Line 463: FROM pa_control_items pci,

459:
460: -- Check if change order type allows either of cost, revenue impacts
461: SELECT count(*)
462: INTO l_allowed_impacts_count
463: FROM pa_control_items pci,
464: pa_ci_impact_type_usage pcit
465: WHERE pci.ci_type_id = pcit.ci_type_id
466: AND pci.ci_id = p_target_ci_id
467: AND impact_type_code IN ('FINPLAN_COST','FINPLAN_REVENUE');