APPS.CN_REVENUE_CLASS_PVT dependencies on CN_REVENUE_CLASSES

Line 66: Cursor get_rev_cls( p_revenue_class_name cn_revenue_classes.name%TYPE ) IS

62: l_sequence_number NUMBER;
63: l_count NUMBER;
64: l_revenue_class_id NUMBER;
65:
66: Cursor get_rev_cls( p_revenue_class_name cn_revenue_classes.name%TYPE ) IS
67: select count(1)
68: from cn_revenue_classes
69: where name = p_revenue_class_name and org_id = p_org_id;
70:

Line 68: from cn_revenue_classes

64: l_revenue_class_id NUMBER;
65:
66: Cursor get_rev_cls( p_revenue_class_name cn_revenue_classes.name%TYPE ) IS
67: select count(1)
68: from cn_revenue_classes
69: where name = p_revenue_class_name and org_id = p_org_id;
70:
71: BEGIN
72:

Line 232: FROM cn_revenue_classes

228: ) IS
229:
230: CURSOR l_ovn_csr IS
231: SELECT nvl(object_version_number,1)
232: FROM cn_revenue_classes
233: WHERE revenue_class_id = p_revenue_class_rec.revenue_class_id;
234:
235: l_api_name CONSTANT VARCHAR2(30) := 'Update_Revenue_Class';
236: l_api_version CONSTANT NUMBER := 1.0;

Line 243: Cursor get_rev_cls( p_revenue_class_name cn_revenue_classes.name%TYPE,

239:
240: l_object_version_number NUMBER;
241:
242:
243: Cursor get_rev_cls( p_revenue_class_name cn_revenue_classes.name%TYPE,
244: p_revenue_class_id NUMBER ) IS
245: select count(1)
246: from cn_revenue_classes
247: where name = p_revenue_class_name

Line 246: from cn_revenue_classes

242:
243: Cursor get_rev_cls( p_revenue_class_name cn_revenue_classes.name%TYPE,
244: p_revenue_class_id NUMBER ) IS
245: select count(1)
246: from cn_revenue_classes
247: where name = p_revenue_class_name
248: and revenue_class_id <> p_revenue_class_id;
249:
250: BEGIN

Line 465: from cn_revenue_classes

461: -- cursor to get the revenue classes
462: --
463: cursor get_rev is
464: select name
465: from cn_revenue_classes
466: where revenue_class_id = p_revenue_class_id;
467:
468: l_revenue_class_name cn_revenue_classes.name%TYPE;
469: l_env_org_id NUMBER;

Line 468: l_revenue_class_name cn_revenue_classes.name%TYPE;

464: select name
465: from cn_revenue_classes
466: where revenue_class_id = p_revenue_class_id;
467:
468: l_revenue_class_name cn_revenue_classes.name%TYPE;
469: l_env_org_id NUMBER;
470:
471: BEGIN
472: