APPS.CN_IMP_REV_CL_PVT dependencies on CN_REVENUE_CLASSES

Line 11: -- cn_revenue_classes_all

7: -- Start of comments
8: -- API name : RevCl_Import
9: -- Type : Private.
10: -- Function : programtransfer data from staging table into
11: -- cn_revenue_classes_all
12: -- Pre-reqs : None.
13: -- Parameters :
14: -- IN p_imp_header_id IN NUMBER,
15: -- OUT : errbuf OUT VARCHAR2 Required

Line 45: FROM CN_REVENUE_CLASSES_IMP_V

41: error_code,
42: name,
43: description
44:
45: FROM CN_REVENUE_CLASSES_IMP_V
46: WHERE imp_header_id = p_imp_header_id
47: AND status_code = l_status_code
48: ;
49:

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

46: WHERE imp_header_id = p_imp_header_id
47: AND status_code = l_status_code
48: ;
49:
50: Cursor get_rev_cls( p_revenue_class_name cn_revenue_classes.name%TYPE ) IS
51: select count(1)
52: from cn_revenue_classes
53: where name = p_revenue_class_name and org_id=p_org_id;
54:

Line 52: from cn_revenue_classes

48: ;
49:
50: Cursor get_rev_cls( p_revenue_class_name cn_revenue_classes.name%TYPE ) IS
51: select count(1)
52: from cn_revenue_classes
53: where name = p_revenue_class_name and org_id=p_org_id;
54:
55: l_api_name CONSTANT VARCHAR2(30) := 'RevCl_Import';
56: l_api_version CONSTANT NUMBER := 1.0;

Line 59: l_rev_class_name cn_revenue_classes.name%TYPE;

55: l_api_name CONSTANT VARCHAR2(30) := 'RevCl_Import';
56: l_api_version CONSTANT NUMBER := 1.0;
57:
58: l_rev_cl_imp c_rev_cl_imp_csr%ROWTYPE;
59: l_rev_class_name cn_revenue_classes.name%TYPE;
60:
61: l_return_status VARCHAR2(1);
62: -- l_msg_count NUMBER;
63: l_msg_data VARCHAR2(2000);