APPS.CR_RSRC_MST_PKG dependencies on CR_RSRC_MST_B

Line 26: cursor C is select ROWID from CR_RSRC_MST_B

22: X_CAPACITY_TOLERANCE in NUMBER,
23: X_UTILIZATION in NUMBER,
24: X_EFFICIENCY in NUMBER
25: ) is
26: cursor C is select ROWID from CR_RSRC_MST_B
27: where RESOURCES = X_RESOURCES
28: ;
29: begin
30: insert into CR_RSRC_MST_B (

Line 30: insert into CR_RSRC_MST_B (

26: cursor C is select ROWID from CR_RSRC_MST_B
27: where RESOURCES = X_RESOURCES
28: ;
29: begin
30: insert into CR_RSRC_MST_B (
31: RESOURCE_CLASS,
32: TRANS_CNT,
33: DELETE_MARK,
34: TEXT_CODE,

Line 141: from CR_RSRC_MST_B

137: COST_CMPNTCLS_ID,
138: CAPACITY_TOLERANCE,
139: UTILIZATION,
140: EFFICIENCY
141: from CR_RSRC_MST_B
142: where RESOURCES = X_RESOURCES
143: for update of RESOURCES nowait;
144: recinfo c%rowtype;
145:

Line 227: update CR_RSRC_MST_B set

223: X_UTILIZATION in NUMBER,
224: X_EFFICIENCY in NUMBER
225: ) is
226: begin
227: update CR_RSRC_MST_B set
228: RESOURCE_CLASS = X_RESOURCE_CLASS,
229: TRANS_CNT = X_TRANS_CNT,
230: DELETE_MARK = X_DELETE_MARK,
231: TEXT_CODE = X_TEXT_CODE,

Line 278: update CR_RSRC_MST_B set delete_mark = 1

274: raise no_data_found;
275: end if;
276:
277: ******************/
278: update CR_RSRC_MST_B set delete_mark = 1
279: where RESOURCES = X_RESOURCES;
280:
281: if (sql%notfound) then
282: raise no_data_found;

Line 292: from CR_RSRC_MST_B B

288: begin
289: delete from CR_RSRC_MST_TL T
290: where not exists
291: (select NULL
292: from CR_RSRC_MST_B B
293: where B.RESOURCES = T.RESOURCES
294: );
295:
296: update CR_RSRC_MST_TL T set (