APPS.CN_API dependencies on CN_COMP_PLANS

Line 769: RETURN cn_comp_plans.name%TYPE IS

765: --| Function Name : get_cp_name
766: --| Desc : Pass in comp plan id then return comp plan name
767: --| ---------------------------------------------------------------------+
768: FUNCTION get_cp_name( p_comp_plan_id NUMBER)
769: RETURN cn_comp_plans.name%TYPE IS
770:
771: l_comp_plan_name cn_comp_plans.name%TYPE;
772:
773: BEGIN

Line 771: l_comp_plan_name cn_comp_plans.name%TYPE;

767: --| ---------------------------------------------------------------------+
768: FUNCTION get_cp_name( p_comp_plan_id NUMBER)
769: RETURN cn_comp_plans.name%TYPE IS
770:
771: l_comp_plan_name cn_comp_plans.name%TYPE;
772:
773: BEGIN
774: SELECT name
775: INTO l_comp_plan_name

Line 776: FROM cn_comp_plans_all

772:
773: BEGIN
774: SELECT name
775: INTO l_comp_plan_name
776: FROM cn_comp_plans_all
777: WHERE comp_plan_id = p_comp_plan_id;
778:
779: RETURN l_comp_plan_name;
780:

Line 791: RETURN cn_comp_plans.comp_plan_id%TYPE IS

787: --| Function Name : get_cp_id
788: --| Desc : Pass in comp plan name then return comp plan id
789: --| ---------------------------------------------------------------------+
790: FUNCTION get_cp_id( p_comp_plan_name VARCHAR2, p_org_id NUMBER)
791: RETURN cn_comp_plans.comp_plan_id%TYPE IS
792:
793: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
794:
795: BEGIN

Line 793: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;

789: --| ---------------------------------------------------------------------+
790: FUNCTION get_cp_id( p_comp_plan_name VARCHAR2, p_org_id NUMBER)
791: RETURN cn_comp_plans.comp_plan_id%TYPE IS
792:
793: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
794:
795: BEGIN
796: SELECT comp_plan_id
797: INTO l_comp_plan_id

Line 798: FROM cn_comp_plans_all

794:
795: BEGIN
796: SELECT comp_plan_id
797: INTO l_comp_plan_id
798: FROM cn_comp_plans_all
799: WHERE name = p_comp_plan_name
800: AND org_id = p_org_id;
801:
802: RETURN l_comp_plan_id;

Line 1893: l_comp_plan_name cn_comp_plans.name%TYPE;

1889: x_return_status OUT NOCOPY VARCHAR2 ) IS
1890:
1891: l_rev_class_total NUMBER := 0;
1892: l_rev_class_total_unique NUMBER := 0;
1893: l_comp_plan_name cn_comp_plans.name%TYPE;
1894: l_rc_overlap VARCHAR2(03);
1895: l_sum_trx_flag VARCHAR2(03); -- commented for bug 7655423 / uncommented for f port of 7330382
1896:
1897: BEGIN

Line 1904: FROM cn_comp_plans_all

1900:
1901: BEGIN
1902: SELECT name, Nvl(p_rc_overlap,allow_rev_class_overlap),sum_trx_flag -- commented for bug 7655423
1903: INTO l_comp_plan_name,l_rc_overlap,l_sum_trx_flag
1904: FROM cn_comp_plans_all
1905: WHERE comp_plan_id = p_comp_plan_id;
1906: EXCEPTION
1907: WHEN NO_DATA_FOUND THEN
1908: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1918: IF CN_COMP_PLANS_PKG.check_unique_rev_class

1914: END ;
1915:
1916: IF l_rc_overlap = 'N' THEN
1917: -- The function below adds the message
1918: IF CN_COMP_PLANS_PKG.check_unique_rev_class
1919: (p_comp_plan_id,l_comp_plan_name,l_rc_overlap,l_sum_trx_flag) = FALSE THEN
1920: x_loading_status := 'PLN_PLAN_DUP_REV_CLASS';
1921: x_return_status := FND_API.G_RET_STS_ERROR;
1922: END IF ;