APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_CI_IMPACTS

Line 1534: pa_ci_impacts pci,

1530: select DECODE(bv.version_type,'REVENUE',revenue_fin_plan_level_code,
1531: 'ALL',all_fin_plan_level_code,null)
1532: from pa_budget_versions bv,
1533: pa_proj_fp_options po,
1534: pa_ci_impacts pci,
1535: pa_projects_all ppa
1536: where bv.project_id = p_project_id
1537: and bv.approved_rev_plan_type_flag = 'Y'
1538: and po.project_id = bv.project_id

Line 7465: /* FP.M -This function checks if any record exists in pa_ci_impacts and if yes then

7461:
7462: END get_not_included;
7463:
7464:
7465: /* FP.M -This function checks if any record exists in pa_ci_impacts and if yes then
7466: * returns the impact type code
7467: */
7468: FUNCTION is_impact_exists(p_ci_id IN pa_ci_impacts.ci_id%TYPE)
7469: RETURN VARCHAR2

Line 7468: FUNCTION is_impact_exists(p_ci_id IN pa_ci_impacts.ci_id%TYPE)

7464:
7465: /* FP.M -This function checks if any record exists in pa_ci_impacts and if yes then
7466: * returns the impact type code
7467: */
7468: FUNCTION is_impact_exists(p_ci_id IN pa_ci_impacts.ci_id%TYPE)
7469: RETURN VARCHAR2
7470: IS
7471: l_record_count NUMBER;
7472: l_impact_type_code VARCHAR2(30);

Line 7485: FROM pa_ci_impacts

7481: -- Bug 3787977: Introduced the following cursor to get the impact_type_code
7482: CURSOR get_impact_type_csr
7483: IS
7484: SELECT impact_type_code
7485: FROM pa_ci_impacts
7486: WHERE ci_id = p_ci_id
7487: AND impact_type_code IN ('FINPLAN',
7488: 'FINPLAN_COST',
7489: 'FINPLAN_REVENUE')

Line 9834: FUNCTION has_co_been_merged(p_ci_id IN pa_ci_impacts.ci_id%TYPE)

9830: RAISE;
9831: END get_impl_agr_revenue;
9832:
9833: /* Function returns 'Y' if the change order has been implemented/included into ANY budget version. */
9834: FUNCTION has_co_been_merged(p_ci_id IN pa_ci_impacts.ci_id%TYPE)
9835: RETURN VARCHAR2
9836: IS
9837: l_is_merged varchar2(1) := 'N';
9838: BEGIN