APPS.CN_API dependencies on CN_REVENUE_CLASSES

Line 141: RETURN cn_revenue_classes.revenue_class_id%TYPE IS

137: --| Function Name : get_rev_class_id
138: --| Desc : Pass in revenue class name then return revenue class id
139: --| ---------------------------------------------------------------------+
140: FUNCTION get_rev_class_id( p_rev_class_name VARCHAR2, p_org_id NUMBER)
141: RETURN cn_revenue_classes.revenue_class_id%TYPE IS
142:
143: l_rev_class_id cn_revenue_classes.revenue_class_id%TYPE;
144:
145: BEGIN

Line 143: l_rev_class_id cn_revenue_classes.revenue_class_id%TYPE;

139: --| ---------------------------------------------------------------------+
140: FUNCTION get_rev_class_id( p_rev_class_name VARCHAR2, p_org_id NUMBER)
141: RETURN cn_revenue_classes.revenue_class_id%TYPE IS
142:
143: l_rev_class_id cn_revenue_classes.revenue_class_id%TYPE;
144:
145: BEGIN
146: SELECT revenue_class_id
147: INTO l_rev_class_id

Line 148: FROM cn_revenue_classes_all

144:
145: BEGIN
146: SELECT revenue_class_id
147: INTO l_rev_class_id
148: FROM cn_revenue_classes_all
149: WHERE name = p_rev_class_name
150: AND org_id = p_org_id
151: ;
152: RETURN l_rev_class_id;

Line 163: RETURN cn_revenue_classes.name%TYPE IS

159: --| Function Name : get_rev_class_name
160: --| Desc : Pass in revenue class name then return revenue class id
161: --| ---------------------------------------------------------------------+
162: FUNCTION get_rev_class_name( p_rev_class_id NUMBER)
163: RETURN cn_revenue_classes.name%TYPE IS
164:
165: l_rev_class_name cn_revenue_classes.name%TYPE;
166:
167: BEGIN

Line 165: l_rev_class_name cn_revenue_classes.name%TYPE;

161: --| ---------------------------------------------------------------------+
162: FUNCTION get_rev_class_name( p_rev_class_id NUMBER)
163: RETURN cn_revenue_classes.name%TYPE IS
164:
165: l_rev_class_name cn_revenue_classes.name%TYPE;
166:
167: BEGIN
168: SELECT name
169: INTO l_rev_class_name

Line 170: FROM cn_revenue_classes_all

166:
167: BEGIN
168: SELECT name
169: INTO l_rev_class_name
170: FROM cn_revenue_classes_all
171: WHERE revenue_class_id = p_rev_class_id
172: ;
173: RETURN l_rev_class_name;
174: EXCEPTION