APPS.CN_API dependencies on CN_COMP_PLANS

Line 747: RETURN cn_comp_plans.name%TYPE IS

743: --| Function Name : get_cp_name
744: --| Desc : Pass in comp plan id then return comp plan name
745: --| ---------------------------------------------------------------------+
746: FUNCTION get_cp_name( p_comp_plan_id NUMBER)
747: RETURN cn_comp_plans.name%TYPE IS
748:
749: l_comp_plan_name cn_comp_plans.name%TYPE;
750:
751: BEGIN

Line 749: l_comp_plan_name cn_comp_plans.name%TYPE;

745: --| ---------------------------------------------------------------------+
746: FUNCTION get_cp_name( p_comp_plan_id NUMBER)
747: RETURN cn_comp_plans.name%TYPE IS
748:
749: l_comp_plan_name cn_comp_plans.name%TYPE;
750:
751: BEGIN
752: SELECT name
753: INTO l_comp_plan_name

Line 754: FROM cn_comp_plans_all

750:
751: BEGIN
752: SELECT name
753: INTO l_comp_plan_name
754: FROM cn_comp_plans_all
755: WHERE comp_plan_id = p_comp_plan_id;
756:
757: RETURN l_comp_plan_name;
758:

Line 769: RETURN cn_comp_plans.comp_plan_id%TYPE IS

765: --| Function Name : get_cp_id
766: --| Desc : Pass in comp plan name then return comp plan id
767: --| ---------------------------------------------------------------------+
768: FUNCTION get_cp_id( p_comp_plan_name VARCHAR2, p_org_id NUMBER)
769: RETURN cn_comp_plans.comp_plan_id%TYPE IS
770:
771: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
772:
773: BEGIN

Line 771: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;

767: --| ---------------------------------------------------------------------+
768: FUNCTION get_cp_id( p_comp_plan_name VARCHAR2, p_org_id NUMBER)
769: RETURN cn_comp_plans.comp_plan_id%TYPE IS
770:
771: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
772:
773: BEGIN
774: SELECT comp_plan_id
775: INTO l_comp_plan_id

Line 776: FROM cn_comp_plans_all

772:
773: BEGIN
774: SELECT comp_plan_id
775: INTO l_comp_plan_id
776: FROM cn_comp_plans_all
777: WHERE name = p_comp_plan_name
778: AND org_id = p_org_id;
779:
780: RETURN l_comp_plan_id;

Line 1871: l_comp_plan_name cn_comp_plans.name%TYPE;

1867: x_return_status OUT NOCOPY VARCHAR2 ) IS
1868:
1869: l_rev_class_total NUMBER := 0;
1870: l_rev_class_total_unique NUMBER := 0;
1871: l_comp_plan_name cn_comp_plans.name%TYPE;
1872: l_rc_overlap VARCHAR2(03);
1873: -- l_sum_trx_flag VARCHAR2(03); -- commented for bug 7655423
1874:
1875: BEGIN

Line 1882: FROM cn_comp_plans_all

1878:
1879: BEGIN
1880: SELECT name, Nvl(p_rc_overlap,allow_rev_class_overlap)--,sum_trx_flag -- commented for bug 7655423
1881: INTO l_comp_plan_name,l_rc_overlap--,l_sum_trx_flag
1882: FROM cn_comp_plans_all
1883: WHERE comp_plan_id = p_comp_plan_id;
1884: EXCEPTION
1885: WHEN NO_DATA_FOUND THEN
1886: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1896: IF CN_COMP_PLANS_PKG.check_unique_rev_class

1892: END ;
1893:
1894: IF l_rc_overlap = 'N' THEN
1895: -- The function below adds the message
1896: IF CN_COMP_PLANS_PKG.check_unique_rev_class
1897: (p_comp_plan_id,l_comp_plan_name,l_rc_overlap) = FALSE THEN
1898: x_loading_status := 'PLN_PLAN_DUP_REV_CLASS';
1899: x_return_status := FND_API.G_RET_STS_ERROR;
1900: END IF ;