APPS.AR_BPA_PAGE_SETUPS_PKG dependencies on AR_BPA_PAGE_SETUPS_B

Line 26: cursor C is select ROWID from AR_BPA_PAGE_SETUPS_B

22: X_LAST_UPDATE_DATE in DATE,
23: X_LAST_UPDATED_BY in NUMBER,
24: X_LAST_UPDATE_LOGIN in NUMBER
25: ) is
26: cursor C is select ROWID from AR_BPA_PAGE_SETUPS_B
27: where PAGE_SETUP_ID = X_PAGE_SETUP_ID
28: ;
29: begin
30: insert into AR_BPA_PAGE_SETUPS_B (

Line 30: insert into AR_BPA_PAGE_SETUPS_B (

26: cursor C is select ROWID from AR_BPA_PAGE_SETUPS_B
27: where PAGE_SETUP_ID = X_PAGE_SETUP_ID
28: ;
29: begin
30: insert into AR_BPA_PAGE_SETUPS_B (
31: PAGE_WIDTH,
32: PAGE_HEIGHT,
33: TOP_MARGIN,
34: BOTTOM_MARGIN,

Line 136: from AR_BPA_PAGE_SETUPS_B

132: SEEDED_FLAG,
133: PAGE_UNIT_OF_MEASURE,
134: PRINT_FONT_FAMILY,
135: PRINT_FONT_SIZE
136: from AR_BPA_PAGE_SETUPS_B
137: where PAGE_SETUP_ID = X_PAGE_SETUP_ID
138: for update of PAGE_SETUP_ID nowait;
139: recinfo c%rowtype;
140:

Line 213: update AR_BPA_PAGE_SETUPS_B set

209: X_LAST_UPDATED_BY in NUMBER,
210: X_LAST_UPDATE_LOGIN in NUMBER
211: ) is
212: begin
213: update AR_BPA_PAGE_SETUPS_B set
214: PAGE_WIDTH = X_PAGE_WIDTH,
215: PAGE_HEIGHT = X_PAGE_HEIGHT,
216: TOP_MARGIN = X_TOP_MARGIN,
217: BOTTOM_MARGIN = X_BOTTOM_MARGIN,

Line 260: delete from AR_BPA_PAGE_SETUPS_B

256: if (sql%notfound) then
257: raise no_data_found;
258: end if;
259:
260: delete from AR_BPA_PAGE_SETUPS_B
261: where PAGE_SETUP_ID = X_PAGE_SETUP_ID;
262:
263: if (sql%notfound) then
264: raise no_data_found;

Line 274: from AR_BPA_PAGE_SETUPS_B B

270: begin
271: delete from AR_BPA_PAGE_SETUPS_TL T
272: where not exists
273: (select NULL
274: from AR_BPA_PAGE_SETUPS_B B
275: where B.PAGE_SETUP_ID = T.PAGE_SETUP_ID
276: );
277:
278: update AR_BPA_PAGE_SETUPS_TL T set (