APPS.CN_API dependencies on CN_REVENUE_CLASSES

Line 163: RETURN cn_revenue_classes.revenue_class_id%TYPE IS

159: --| Function Name : get_rev_class_id
160: --| Desc : Pass in revenue class name then return revenue class id
161: --| ---------------------------------------------------------------------+
162: FUNCTION get_rev_class_id( p_rev_class_name VARCHAR2, p_org_id NUMBER)
163: RETURN cn_revenue_classes.revenue_class_id%TYPE IS
164:
165: l_rev_class_id cn_revenue_classes.revenue_class_id%TYPE;
166:
167: BEGIN

Line 165: l_rev_class_id cn_revenue_classes.revenue_class_id%TYPE;

161: --| ---------------------------------------------------------------------+
162: FUNCTION get_rev_class_id( p_rev_class_name VARCHAR2, p_org_id NUMBER)
163: RETURN cn_revenue_classes.revenue_class_id%TYPE IS
164:
165: l_rev_class_id cn_revenue_classes.revenue_class_id%TYPE;
166:
167: BEGIN
168: SELECT revenue_class_id
169: INTO l_rev_class_id

Line 170: FROM cn_revenue_classes_all

166:
167: BEGIN
168: SELECT revenue_class_id
169: INTO l_rev_class_id
170: FROM cn_revenue_classes_all
171: WHERE name = p_rev_class_name
172: AND org_id = p_org_id
173: ;
174: RETURN l_rev_class_id;

Line 185: RETURN cn_revenue_classes.name%TYPE IS

181: --| Function Name : get_rev_class_name
182: --| Desc : Pass in revenue class name then return revenue class id
183: --| ---------------------------------------------------------------------+
184: FUNCTION get_rev_class_name( p_rev_class_id NUMBER)
185: RETURN cn_revenue_classes.name%TYPE IS
186:
187: l_rev_class_name cn_revenue_classes.name%TYPE;
188:
189: BEGIN

Line 187: l_rev_class_name cn_revenue_classes.name%TYPE;

183: --| ---------------------------------------------------------------------+
184: FUNCTION get_rev_class_name( p_rev_class_id NUMBER)
185: RETURN cn_revenue_classes.name%TYPE IS
186:
187: l_rev_class_name cn_revenue_classes.name%TYPE;
188:
189: BEGIN
190: SELECT name
191: INTO l_rev_class_name

Line 192: FROM cn_revenue_classes_all

188:
189: BEGIN
190: SELECT name
191: INTO l_rev_class_name
192: FROM cn_revenue_classes_all
193: WHERE revenue_class_id = p_rev_class_id
194: ;
195: RETURN l_rev_class_name;
196: EXCEPTION