APPS.PA_RES_FORMATS_PVT dependencies on PA_RES_FORMATS_B

Line 31: l_res_format_id pa_res_formats_b.res_format_id%type;

27: P_LAST_UPDATED_BY in NUMBER ,
28: P_LAST_UPDATE_LOGIN in NUMBER
29: ) is
30:
31: l_res_format_id pa_res_formats_b.res_format_id%type;
32:
33:
34: cursor C is select ROWID from pa_res_formats_b
35: where res_format_id = l_res_format_id;

Line 34: cursor C is select ROWID from pa_res_formats_b

30:
31: l_res_format_id pa_res_formats_b.res_format_id%type;
32:
33:
34: cursor C is select ROWID from pa_res_formats_b
35: where res_format_id = l_res_format_id;
36: begin
37:
38: select nvl(P_RES_FORMAT_ID,PA_RES_FORMATS_S.nextval)

Line 42: insert into pa_res_formats_b (

38: select nvl(P_RES_FORMAT_ID,PA_RES_FORMATS_S.nextval)
39: into l_res_format_id
40: from dual;
41:
42: insert into pa_res_formats_b (
43: RES_FORMAT_ID ,
44: RESOURCE_FORMAT_SEQ ,
45: RESOURCE_CLASS_ID ,
46: RES_TYPE_ID ,

Line 150: from pa_res_formats_b

146: SUPPLIER_DISP_CHARS ,
147: ROLE_ENABLED_FLAG ,
148: ROLE_DISP_CHARS ,
149: RESOURCE_CLASS_FLAG
150: from pa_res_formats_b
151: where RES_FORMAT_ID = P_RES_FORMAT_ID
152: for update of RES_FORMAT_ID nowait;
153: recinfo c%rowtype;
154:

Line 203: update pa_res_formats_b set

199: P_LAST_UPDATED_BY in NUMBER ,
200: P_LAST_UPDATE_LOGIN in NUMBER
201: ) is
202: begin
203: update pa_res_formats_b set
204: RESOURCE_FORMAT_SEQ = P_RESOURCE_FORMAT_SEQ,
205: RESOURCE_CLASS_ID = P_RESOURCE_CLASS_ID,
206: RES_TYPE_ID = P_RES_TYPE_ID,
207: RES_TYPE_ENABLED_FLAG = P_RES_TYPE_ENABLED_FLAG,

Line 255: delete from pa_res_formats_b

251: if (sql%notfound) then
252: raise no_data_found;
253: end if;
254:
255: delete from pa_res_formats_b
256: where RES_FORMAT_ID = P_RES_FORMAT_ID;
257:
258: if (sql%notfound) then
259: raise no_data_found;

Line 269: from PA_RES_FORMATS_B B

265: begin
266: delete from pa_res_formats_tl T
267: where not exists
268: (select NULL
269: from PA_RES_FORMATS_B B
270: where B.RES_FORMAT_ID = T.res_format_id
271: );
272:
273: update pa_res_formats_tl T set (