APPS.CN_REVENUE_CLASS_PKG dependencies on CN_REVENUE_CLASSES

Line 37: SELECT cn_revenue_classes_s.nextval

33: PROCEDURE Get_UID( x_revenue_class_id IN OUT NOCOPY NUMBER) IS
34:
35: BEGIN
36:
37: SELECT cn_revenue_classes_s.nextval
38: INTO X_revenue_class_id
39: FROM dual;
40:
41: END Get_UID;

Line 68: INSERT INTO cn_revenue_Classes

64: BEGIN
65:
66: Get_UID( x_revenue_class_id );
67:
68: INSERT INTO cn_revenue_Classes
69: ( ORG_ID
70: ,revenue_class_id
71: ,name
72: ,DESCRIPTION

Line 116: l_revenue_class_id cn_revenue_classes.revenue_class_id%TYPE;

112: ,p_Last_Update_Date DATE
113: ,p_Last_Update_Login NUMBER ) IS
114:
115:
116: l_revenue_class_id cn_revenue_classes.revenue_class_id%TYPE;
117: l_name cn_revenue_classes.name%TYPE;
118: l_description cn_revenue_classes.description%TYPE;
119: l_liability_account_Id cn_revenue_classes.liability_account_id%TYPE;
120: l_expense_account_Id cn_revenue_classes.expense_account_id%TYPE;

Line 117: l_name cn_revenue_classes.name%TYPE;

113: ,p_Last_Update_Login NUMBER ) IS
114:
115:
116: l_revenue_class_id cn_revenue_classes.revenue_class_id%TYPE;
117: l_name cn_revenue_classes.name%TYPE;
118: l_description cn_revenue_classes.description%TYPE;
119: l_liability_account_Id cn_revenue_classes.liability_account_id%TYPE;
120: l_expense_account_Id cn_revenue_classes.expense_account_id%TYPE;
121:

Line 118: l_description cn_revenue_classes.description%TYPE;

114:
115:
116: l_revenue_class_id cn_revenue_classes.revenue_class_id%TYPE;
117: l_name cn_revenue_classes.name%TYPE;
118: l_description cn_revenue_classes.description%TYPE;
119: l_liability_account_Id cn_revenue_classes.liability_account_id%TYPE;
120: l_expense_account_Id cn_revenue_classes.expense_account_id%TYPE;
121:
122: CURSOR C IS

Line 119: l_liability_account_Id cn_revenue_classes.liability_account_id%TYPE;

115:
116: l_revenue_class_id cn_revenue_classes.revenue_class_id%TYPE;
117: l_name cn_revenue_classes.name%TYPE;
118: l_description cn_revenue_classes.description%TYPE;
119: l_liability_account_Id cn_revenue_classes.liability_account_id%TYPE;
120: l_expense_account_Id cn_revenue_classes.expense_account_id%TYPE;
121:
122: CURSOR C IS
123: SELECT *

Line 120: l_expense_account_Id cn_revenue_classes.expense_account_id%TYPE;

116: l_revenue_class_id cn_revenue_classes.revenue_class_id%TYPE;
117: l_name cn_revenue_classes.name%TYPE;
118: l_description cn_revenue_classes.description%TYPE;
119: l_liability_account_Id cn_revenue_classes.liability_account_id%TYPE;
120: l_expense_account_Id cn_revenue_classes.expense_account_id%TYPE;
121:
122: CURSOR C IS
123: SELECT *
124: FROM cn_revenue_classes

Line 124: FROM cn_revenue_classes

120: l_expense_account_Id cn_revenue_classes.expense_account_id%TYPE;
121:
122: CURSOR C IS
123: SELECT *
124: FROM cn_revenue_classes
125: WHERE revenue_class_id = p_revenue_class_id
126: FOR UPDATE of revenue_class_id NOWAIT;
127: oldrow C%ROWTYPE;
128:

Line 169: UPDATE cn_revenue_classes

165: RAISE NO_DATA_FOUND;
166: END IF;
167:
168:
169: UPDATE cn_revenue_classes
170: SET
171: revenue_class_id = l_revenue_class_id,
172: object_version_number = nvl(p_object_version_number,0) + 1,
173: name = l_name,

Line 196: and t.name = 'CN_REVENUE_CLASSES');

192: cn_dim_hierarchies dh
193: where d.source_table_id = t.table_id
194: and d.dimension_id = h.dimension_id
195: and h.head_hierarchy_id = dh.header_dim_hierarchy_id
196: and t.name = 'CN_REVENUE_CLASSES');
197:
198: END IF;
199:
200: END Update_row;

Line 211: DELETE FROM cn_revenue_classes

207:
208: PROCEDURE Delete_row( p_revenue_class_id NUMBER ) IS
209: BEGIN
210:
211: DELETE FROM cn_revenue_classes
212: WHERE revenue_class_id = p_revenue_class_id ;
213: IF (SQL%NOTFOUND) THEN
214: RAISE NO_DATA_FOUND;
215: END IF;