APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_CI_IMPACTS

Line 1568: pa_ci_impacts pci,

1564: select DECODE(bv.version_type,'REVENUE',revenue_fin_plan_level_code,
1565: 'ALL',all_fin_plan_level_code,null)
1566: from pa_budget_versions bv,
1567: pa_proj_fp_options po,
1568: pa_ci_impacts pci,
1569: pa_projects_all ppa
1570: where bv.project_id = p_project_id
1571: and bv.approved_rev_plan_type_flag = 'Y'
1572: and po.project_id = bv.project_id

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

7533:
7534: END get_not_included;
7535:
7536:
7537: /* FP.M -This function checks if any record exists in pa_ci_impacts and if yes then
7538: * returns the impact type code
7539: */
7540: FUNCTION is_impact_exists(p_ci_id IN pa_ci_impacts.ci_id%TYPE)
7541: RETURN VARCHAR2

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

7536:
7537: /* FP.M -This function checks if any record exists in pa_ci_impacts and if yes then
7538: * returns the impact type code
7539: */
7540: FUNCTION is_impact_exists(p_ci_id IN pa_ci_impacts.ci_id%TYPE)
7541: RETURN VARCHAR2
7542: IS
7543: l_record_count NUMBER;
7544: l_impact_type_code VARCHAR2(30);

Line 7557: FROM pa_ci_impacts

7553: -- Bug 3787977: Introduced the following cursor to get the impact_type_code
7554: CURSOR get_impact_type_csr
7555: IS
7556: SELECT impact_type_code
7557: FROM pa_ci_impacts
7558: WHERE ci_id = p_ci_id
7559: AND impact_type_code IN ('FINPLAN',
7560: 'FINPLAN_COST',
7561: 'FINPLAN_REVENUE')

Line 9993: FUNCTION is_edit_plan_enabled(p_ci_id IN pa_ci_impacts.ci_id%TYPE)

9989: END get_impl_agr_revenue;
9990:
9991: /*Function added for EnC */
9992:
9993: FUNCTION is_edit_plan_enabled(p_ci_id IN pa_ci_impacts.ci_id%TYPE)
9994: RETURN VARCHAR2
9995: IS
9996: l_is_editplanned_enabled varchar2(1) := 'N';
9997: BEGIN

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

10014:
10015: END is_edit_plan_enabled;
10016:
10017: /* Function returns 'Y' if the change order has been implemented/included into ANY budget version. */
10018: FUNCTION has_co_been_merged(p_ci_id IN pa_ci_impacts.ci_id%TYPE)
10019: RETURN VARCHAR2
10020: IS
10021: l_is_merged varchar2(1) := 'N';
10022: BEGIN