APPS.CS_BILLING_TYPE_CATEGORIES_PKG dependencies on CS_BILLING_TYPE_CATEGORIES

Line 1: package body CS_BILLING_TYPE_CATEGORIES_PKG as

1: package body CS_BILLING_TYPE_CATEGORIES_PKG as
2: /* $Header: csxchbcb.pls 115.4 2003/02/11 19:21:38 cnemalik noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 18: cursor C is select ROWID from CS_BILLING_TYPE_CATEGORIES

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from CS_BILLING_TYPE_CATEGORIES
19: where BILLING_TYPE = X_BILLING_TYPE
20: ;
21: begin
22: insert into CS_BILLING_TYPE_CATEGORIES (

Line 22: insert into CS_BILLING_TYPE_CATEGORIES (

18: cursor C is select ROWID from CS_BILLING_TYPE_CATEGORIES
19: where BILLING_TYPE = X_BILLING_TYPE
20: ;
21: begin
22: insert into CS_BILLING_TYPE_CATEGORIES (
23: BILLING_TYPE,
24: BILLING_CATEGORY,
25: ROLLUP_ITEM_ID,
26: START_DATE_ACTIVE,

Line 71: from CS_BILLING_TYPE_CATEGORIES

67: BILLING_CATEGORY,
68: ROLLUP_ITEM_ID,
69: START_DATE_ACTIVE,
70: END_DATE_ACTIVE
71: from CS_BILLING_TYPE_CATEGORIES
72: where BILLING_TYPE = X_BILLING_TYPE
73: for update of BILLING_TYPE nowait;
74: recinfo c%rowtype;
75:

Line 114: update CS_BILLING_TYPE_CATEGORIES set

110: X_LAST_UPDATED_BY in NUMBER,
111: X_LAST_UPDATE_LOGIN in NUMBER
112: ) is
113: begin
114: update CS_BILLING_TYPE_CATEGORIES set
115: BILLING_CATEGORY = X_BILLING_CATEGORY,
116: ROLLUP_ITEM_ID = X_ROLLUP_ITEM_ID,
117: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
118: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 135: delete from CS_BILLING_TYPE_CATEGORIES

131: procedure DELETE_ROW (
132: X_BILLING_TYPE in VARCHAR2
133: ) is
134: begin
135: delete from CS_BILLING_TYPE_CATEGORIES
136: where BILLING_TYPE = X_BILLING_TYPE;
137:
138: if (sql%notfound) then
139: raise no_data_found;

Line 185: from cs_billing_type_categories

181: f_enddate := to_date(X_END_DATE_ACTIVE, 'YYYY/MM/DD');
182:
183: select billing_type, last_updated_by, last_update_date
184: into db_billing_type, db_luby, db_ludate
185: from cs_billing_type_categories
186: where billing_type = X_BILLING_TYPE;
187:
188: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
189: db_ludate, X_CUSTOM_MODE)) then

Line 192: CS_BILLING_TYPE_CATEGORIES_PKG.UPDATE_ROW (

188: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
189: db_ludate, X_CUSTOM_MODE)) then
190:
191:
192: CS_BILLING_TYPE_CATEGORIES_PKG.UPDATE_ROW (
193: X_BILLING_TYPE => x_billing_type,
194: X_BILLING_CATEGORY => x_billing_category,
195: X_ROLLUP_ITEM_ID => x_rollup_item_id,
196: X_START_DATE_ACTIVE => f_stdate,

Line 207: CS_BILLING_TYPE_CATEGORIES_PKG.INSERT_ROW (

203:
204: exception
205: when no_data_found then
206:
207: CS_BILLING_TYPE_CATEGORIES_PKG.INSERT_ROW (
208: X_ROWID => l_rowid,
209: X_BILLING_TYPE => x_billing_type,
210: X_BILLING_CATEGORY => x_billing_category,
211: X_ROLLUP_ITEM_ID => x_rollup_item_id,

Line 223: end CS_BILLING_TYPE_CATEGORIES_PKG;

219: X_LAST_UPDATE_LOGIN => 0);
220:
221: end LOAD_ROW;
222:
223: end CS_BILLING_TYPE_CATEGORIES_PKG;