APPS.FND_PRINTER_STYLES_PKG dependencies on FND_PRINTER_STYLES

Line 1: package body FND_PRINTER_STYLES_PKG as

1: package body FND_PRINTER_STYLES_PKG as
2: /* $Header: AFPRRPSB.pls 120.2 2005/08/19 20:18:05 ckclark ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 21: cursor C is select ROWID from FND_PRINTER_STYLES

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from FND_PRINTER_STYLES
22: where PRINTER_STYLE_NAME = X_PRINTER_STYLE_NAME
23: ;
24: begin
25: insert into FND_PRINTER_STYLES (

Line 25: insert into FND_PRINTER_STYLES (

21: cursor C is select ROWID from FND_PRINTER_STYLES
22: where PRINTER_STYLE_NAME = X_PRINTER_STYLE_NAME
23: ;
24: begin
25: insert into FND_PRINTER_STYLES (
26: PRINTER_STYLE_NAME,
27: SEQUENCE,
28: WIDTH,
29: LENGTH,

Line 55: insert into FND_PRINTER_STYLES_TL (

51: X_LAST_UPDATED_BY,
52: X_LAST_UPDATE_LOGIN
53: );
54:
55: insert into FND_PRINTER_STYLES_TL (
56: PRINTER_STYLE_NAME,
57: USER_PRINTER_STYLE_NAME,
58: LAST_UPDATE_DATE,
59: LAST_UPDATED_BY,

Line 79: from FND_PRINTER_STYLES_TL T

75: from FND_LANGUAGES L
76: where L.INSTALLED_FLAG in ('I', 'B')
77: and not exists
78: (select NULL
79: from FND_PRINTER_STYLES_TL T
80: where T.PRINTER_STYLE_NAME = X_PRINTER_STYLE_NAME
81: and T.LANGUAGE = L.LANGUAGE_CODE);
82:
83: open c;

Line 112: from FND_PRINTER_STYLES

108: DESCRIPTION,
109: ORIENTATION,
110: SRW_DRIVER,
111: HEADER_FLAG
112: from FND_PRINTER_STYLES
113: where PRINTER_STYLE_NAME = X_PRINTER_STYLE_NAME
114: for update of PRINTER_STYLE_NAME nowait;
115: recinfo c%rowtype;
116:

Line 119: from FND_PRINTER_STYLES_TL

115: recinfo c%rowtype;
116:
117: cursor c1 is select
118: USER_PRINTER_STYLE_NAME
119: from FND_PRINTER_STYLES_TL
120: where PRINTER_STYLE_NAME = X_PRINTER_STYLE_NAME
121: and LANGUAGE = userenv('LANG')
122: for update of PRINTER_STYLE_NAME nowait;
123: tlinfo c1%rowtype;

Line 185: update FND_PRINTER_STYLES set

181: X_LAST_UPDATED_BY in NUMBER,
182: X_LAST_UPDATE_LOGIN in NUMBER
183: ) is
184: begin
185: update FND_PRINTER_STYLES set
186: SEQUENCE = X_SEQUENCE,
187: WIDTH = X_WIDTH,
188: LENGTH = X_LENGTH,
189: DESCRIPTION = X_DESCRIPTION,

Line 202: update FND_PRINTER_STYLES_TL set

198: if (sql%notfound) then
199: raise no_data_found;
200: end if;
201:
202: update FND_PRINTER_STYLES_TL set
203: USER_PRINTER_STYLE_NAME = X_USER_PRINTER_STYLE_NAME,
204: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
205: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
206: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 220: delete from FND_PRINTER_STYLES

216: procedure DELETE_ROW (
217: X_PRINTER_STYLE_NAME in VARCHAR2
218: ) is
219: begin
220: delete from FND_PRINTER_STYLES
221: where PRINTER_STYLE_NAME = X_PRINTER_STYLE_NAME;
222:
223: if (sql%notfound) then
224: raise no_data_found;

Line 227: delete from FND_PRINTER_STYLES_TL

223: if (sql%notfound) then
224: raise no_data_found;
225: end if;
226:
227: delete from FND_PRINTER_STYLES_TL
228: where PRINTER_STYLE_NAME = X_PRINTER_STYLE_NAME;
229:
230: if (sql%notfound) then
231: raise no_data_found;

Line 244: delete from FND_PRINTER_STYLES_TL T

240: /* as a quick workaround to fix the time-consuming table handler issue */
241: /* Eventually we'll need to turn them into a separate fix_language procedure */
242: /*
243:
244: delete from FND_PRINTER_STYLES_TL T
245: where not exists
246: (select NULL
247: from FND_PRINTER_STYLES B
248: where B.PRINTER_STYLE_NAME = T.PRINTER_STYLE_NAME

Line 247: from FND_PRINTER_STYLES B

243:
244: delete from FND_PRINTER_STYLES_TL T
245: where not exists
246: (select NULL
247: from FND_PRINTER_STYLES B
248: where B.PRINTER_STYLE_NAME = T.PRINTER_STYLE_NAME
249: );
250:
251: update FND_PRINTER_STYLES_TL T set (

Line 251: update FND_PRINTER_STYLES_TL T set (

247: from FND_PRINTER_STYLES B
248: where B.PRINTER_STYLE_NAME = T.PRINTER_STYLE_NAME
249: );
250:
251: update FND_PRINTER_STYLES_TL T set (
252: USER_PRINTER_STYLE_NAME
253: ) = (select
254: B.USER_PRINTER_STYLE_NAME
255: from FND_PRINTER_STYLES_TL B

Line 255: from FND_PRINTER_STYLES_TL B

251: update FND_PRINTER_STYLES_TL T set (
252: USER_PRINTER_STYLE_NAME
253: ) = (select
254: B.USER_PRINTER_STYLE_NAME
255: from FND_PRINTER_STYLES_TL B
256: where B.PRINTER_STYLE_NAME = T.PRINTER_STYLE_NAME
257: and B.LANGUAGE = T.SOURCE_LANG)
258: where (
259: T.PRINTER_STYLE_NAME,

Line 264: from FND_PRINTER_STYLES_TL SUBB, FND_PRINTER_STYLES_TL SUBT

260: T.LANGUAGE
261: ) in (select
262: SUBT.PRINTER_STYLE_NAME,
263: SUBT.LANGUAGE
264: from FND_PRINTER_STYLES_TL SUBB, FND_PRINTER_STYLES_TL SUBT
265: where SUBB.PRINTER_STYLE_NAME = SUBT.PRINTER_STYLE_NAME
266: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
267: and (SUBB.USER_PRINTER_STYLE_NAME <> SUBT.USER_PRINTER_STYLE_NAME
268: ));

Line 271: insert into FND_PRINTER_STYLES_TL (

267: and (SUBB.USER_PRINTER_STYLE_NAME <> SUBT.USER_PRINTER_STYLE_NAME
268: ));
269: */
270:
271: insert into FND_PRINTER_STYLES_TL (
272: PRINTER_STYLE_NAME,
273: USER_PRINTER_STYLE_NAME,
274: LAST_UPDATE_DATE,
275: LAST_UPDATED_BY,

Line 291: from FND_PRINTER_STYLES_TL B, FND_LANGUAGES L

287: B.CREATED_BY,
288: B.LAST_UPDATE_LOGIN,
289: L.LANGUAGE_CODE,
290: B.SOURCE_LANG
291: from FND_PRINTER_STYLES_TL B, FND_LANGUAGES L
292: where L.INSTALLED_FLAG in ('I', 'B')
293: and B.LANGUAGE = userenv('LANG')
294: and not exists
295: (select NULL

Line 296: from FND_PRINTER_STYLES_TL T

292: where L.INSTALLED_FLAG in ('I', 'B')
293: and B.LANGUAGE = userenv('LANG')
294: and not exists
295: (select NULL
296: from FND_PRINTER_STYLES_TL T
297: where T.PRINTER_STYLE_NAME = B.PRINTER_STYLE_NAME
298: and T.LANGUAGE = L.LANGUAGE_CODE);
299: end ADD_LANGUAGE;
300:

Line 301: end FND_PRINTER_STYLES_PKG;

297: where T.PRINTER_STYLE_NAME = B.PRINTER_STYLE_NAME
298: and T.LANGUAGE = L.LANGUAGE_CODE);
299: end ADD_LANGUAGE;
300:
301: end FND_PRINTER_STYLES_PKG;