APPS.PA_RESOURCE_CLASSES_PVT dependencies on PA_RESOURCE_CLASSES_B

Line 17: l_resource_class_id pa_resource_classes_b.resource_class_id%type;

13: P_LAST_UPDATED_BY in NUMBER ,
14: P_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16:
17: l_resource_class_id pa_resource_classes_b.resource_class_id%type;
18:
19:
20: cursor C is select ROWID from pa_resource_classes_b
21: where resource_class_id = l_resource_class_id;

Line 20: cursor C is select ROWID from pa_resource_classes_b

16:
17: l_resource_class_id pa_resource_classes_b.resource_class_id%type;
18:
19:
20: cursor C is select ROWID from pa_resource_classes_b
21: where resource_class_id = l_resource_class_id;
22: begin
23:
24: select nvl(P_RESOURCE_CLASS_ID,PA_RESOURCE_CLASSES_S.nextval)

Line 28: insert into pa_resource_classes_b (

24: select nvl(P_RESOURCE_CLASS_ID,PA_RESOURCE_CLASSES_S.nextval)
25: into l_resource_class_id
26: from dual;
27:
28: insert into pa_resource_classes_b (
29: RESOURCE_CLASS_ID ,
30: RESOURCE_CLASS_CODE ,
31: RESOURCE_CLASS_SEQ ,
32: CREATION_DATE ,

Line 93: from pa_resource_classes_b

89: P_RESOURCE_CLASS_ID in NUMBER
90: ) is
91: cursor c is select
92: RESOURCE_CLASS_CODE
93: from pa_resource_classes_b
94: where RESOURCE_CLASS_ID = P_RESOURCE_CLASS_ID
95: for update of RESOURCE_CLASS_ID nowait;
96: recinfo c%rowtype;
97:

Line 132: update pa_resource_classes_b set

128: P_LAST_UPDATED_BY in NUMBER ,
129: P_LAST_UPDATE_LOGIN in NUMBER
130: ) is
131: begin
132: update pa_resource_classes_b set
133: RESOURCE_CLASS_CODE = P_RESOURCE_CLASS_CODE,
134: RESOURCE_CLASS_SEQ = P_RESOURCE_CLASS_SEQ,
135: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE ,
136: LAST_UPDATED_BY = P_LAST_UPDATED_BY ,

Line 170: delete from pa_resource_classes_b

166: if (sql%notfound) then
167: raise no_data_found;
168: end if;
169:
170: delete from pa_resource_classes_b
171: where RESOURCE_CLASS_ID = P_RESOURCE_CLASS_ID;
172:
173: if (sql%notfound) then
174: raise no_data_found;

Line 184: from pa_resource_classes_b B

180: begin
181: delete from pa_resource_classes_tl T
182: where not exists
183: (select NULL
184: from pa_resource_classes_b B
185: where B.RESOURCE_CLASS_ID = T.RESOURCE_CLASS_ID
186: );
187:
188: update pa_resource_classes_tl T set (