APPS.CR_RSRC_CLS_PKG dependencies on CR_RSRC_CLS_B

Line 16: cursor C is select ROWID from CR_RSRC_CLS_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from CR_RSRC_CLS_B
17: where RESOURCE_CLASS = X_RESOURCE_CLASS
18: ;
19: begin
20: insert into CR_RSRC_CLS_B (

Line 20: insert into CR_RSRC_CLS_B (

16: cursor C is select ROWID from CR_RSRC_CLS_B
17: where RESOURCE_CLASS = X_RESOURCE_CLASS
18: ;
19: begin
20: insert into CR_RSRC_CLS_B (
21: RESOURCE_CLASS,
22: TRANS_CNT,
23: DELETE_MARK,
24: TEXT_CODE,

Line 91: from CR_RSRC_CLS_B

87: cursor c is select
88: TRANS_CNT,
89: DELETE_MARK,
90: TEXT_CODE
91: from CR_RSRC_CLS_B
92: where RESOURCE_CLASS = X_RESOURCE_CLASS
93: for update of RESOURCE_CLASS nowait;
94: recinfo c%rowtype;
95:

Line 149: update CR_RSRC_CLS_B set

145: X_LAST_UPDATED_BY in NUMBER,
146: X_LAST_UPDATE_LOGIN in NUMBER
147: ) is
148: begin
149: update CR_RSRC_CLS_B set
150: TRANS_CNT = X_TRANS_CNT,
151: DELETE_MARK = X_DELETE_MARK,
152: TEXT_CODE = X_TEXT_CODE,
153: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 189: update CR_RSRC_CLS_B set delete_mark = 1

185: raise no_data_found;
186: end if;
187:
188: *****************/
189: update CR_RSRC_CLS_B set delete_mark = 1
190: where RESOURCE_CLASS = X_RESOURCE_CLASS;
191:
192: if (sql%notfound) then
193: raise no_data_found;

Line 203: from CR_RSRC_CLS_B B

199: begin
200: delete from CR_RSRC_CLS_TL T
201: where not exists
202: (select NULL
203: from CR_RSRC_CLS_B B
204: where B.RESOURCE_CLASS = T.RESOURCE_CLASS
205: );
206:
207: update CR_RSRC_CLS_TL T set (