eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_PRINTER_PKG dependencies on FND_PRINTER

Line 1: package body FND_PRINTER_PKG as

1: package body FND_PRINTER_PKG as
2: /* $Header: AFPRMPRB.pls 120.2 2005/08/19 20:17:07 ckclark ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 15: cursor C is select ROWID from FND_PRINTER

11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: cursor C is select ROWID from FND_PRINTER
16: where PRINTER_NAME = X_PRINTER_NAME
17: ;
18: begin
19: insert into FND_PRINTER (

Line 19: insert into FND_PRINTER (

15: cursor C is select ROWID from FND_PRINTER
16: where PRINTER_NAME = X_PRINTER_NAME
17: ;
18: begin
19: insert into FND_PRINTER (
20: PRINTER_NAME,
21: PRINTER_TYPE,
22: CREATION_DATE,
23: CREATED_BY,

Line 37: insert into FND_PRINTER_TL (

33: X_LAST_UPDATED_BY,
34: X_LAST_UPDATE_LOGIN
35: );
36:
37: insert into FND_PRINTER_TL (
38: PRINTER_NAME,
39: CREATION_DATE,
40: CREATED_BY,
41: LAST_UPDATE_DATE,

Line 61: from FND_PRINTER_TL T

57: from FND_LANGUAGES L
58: where L.INSTALLED_FLAG in ('I', 'B')
59: and not exists
60: (select NULL
61: from FND_PRINTER_TL T
62: where T.PRINTER_NAME = X_PRINTER_NAME
63: and T.LANGUAGE = L.LANGUAGE_CODE);
64:
65: open c;

Line 82: from FND_PRINTER

78: X_DESCRIPTION in VARCHAR2
79: ) is
80: cursor c is select
81: PRINTER_TYPE
82: from FND_PRINTER
83: where PRINTER_NAME = X_PRINTER_NAME
84: for update of PRINTER_NAME nowait;
85: recinfo c%rowtype;
86:

Line 89: from FND_PRINTER_TL

85: recinfo c%rowtype;
86:
87: cursor c1 is select
88: DESCRIPTION
89: from FND_PRINTER_TL
90: where PRINTER_NAME = X_PRINTER_NAME
91: and LANGUAGE = userenv('LANG')
92: for update of PRINTER_NAME nowait;
93: tlinfo c1%rowtype;

Line 140: update FND_PRINTER set

136: X_LAST_UPDATED_BY in NUMBER,
137: X_LAST_UPDATE_LOGIN in NUMBER
138: ) is
139: begin
140: update FND_PRINTER set
141: PRINTER_TYPE = X_PRINTER_TYPE,
142: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
143: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
144: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 151: update FND_PRINTER_TL set

147: if (sql%notfound) then
148: raise no_data_found;
149: end if;
150:
151: update FND_PRINTER_TL set
152: DESCRIPTION = X_DESCRIPTION,
153: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
154: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
155: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 169: delete from FND_PRINTER

165: procedure DELETE_ROW (
166: X_PRINTER_NAME in VARCHAR2
167: ) is
168: begin
169: delete from FND_PRINTER
170: where PRINTER_NAME = X_PRINTER_NAME;
171:
172: if (sql%notfound) then
173: raise no_data_found;

Line 176: delete from FND_PRINTER_TL

172: if (sql%notfound) then
173: raise no_data_found;
174: end if;
175:
176: delete from FND_PRINTER_TL
177: where PRINTER_NAME = X_PRINTER_NAME;
178:
179: if (sql%notfound) then
180: raise no_data_found;

Line 193: delete from FND_PRINTER_TL T

189: /* as a quick workaround to fix the time-consuming table handler issue */
190: /* Eventually we'll need to turn them into a separate fix_language procedure */
191: /*
192:
193: delete from FND_PRINTER_TL T
194: where not exists
195: (select NULL
196: from FND_PRINTER B
197: where B.PRINTER_NAME = T.PRINTER_NAME

Line 196: from FND_PRINTER B

192:
193: delete from FND_PRINTER_TL T
194: where not exists
195: (select NULL
196: from FND_PRINTER B
197: where B.PRINTER_NAME = T.PRINTER_NAME
198: );
199:
200: update FND_PRINTER_TL T set (

Line 200: update FND_PRINTER_TL T set (

196: from FND_PRINTER B
197: where B.PRINTER_NAME = T.PRINTER_NAME
198: );
199:
200: update FND_PRINTER_TL T set (
201: DESCRIPTION
202: ) = (select
203: B.DESCRIPTION
204: from FND_PRINTER_TL B

Line 204: from FND_PRINTER_TL B

200: update FND_PRINTER_TL T set (
201: DESCRIPTION
202: ) = (select
203: B.DESCRIPTION
204: from FND_PRINTER_TL B
205: where B.PRINTER_NAME = T.PRINTER_NAME
206: and B.LANGUAGE = T.SOURCE_LANG)
207: where (
208: T.PRINTER_NAME,

Line 213: from FND_PRINTER_TL SUBB, FND_PRINTER_TL SUBT

209: T.LANGUAGE
210: ) in (select
211: SUBT.PRINTER_NAME,
212: SUBT.LANGUAGE
213: from FND_PRINTER_TL SUBB, FND_PRINTER_TL SUBT
214: where SUBB.PRINTER_NAME = SUBT.PRINTER_NAME
215: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
216: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
217: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 222: insert into FND_PRINTER_TL (

218: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
219: ));
220: */
221:
222: insert into FND_PRINTER_TL (
223: PRINTER_NAME,
224: CREATION_DATE,
225: CREATED_BY,
226: LAST_UPDATE_DATE,

Line 242: from FND_PRINTER_TL B, FND_LANGUAGES L

238: B.LAST_UPDATE_LOGIN,
239: B.DESCRIPTION,
240: L.LANGUAGE_CODE,
241: B.SOURCE_LANG
242: from FND_PRINTER_TL B, FND_LANGUAGES L
243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL

Line 247: from FND_PRINTER_TL T

243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL
247: from FND_PRINTER_TL T
248: where T.PRINTER_NAME = B.PRINTER_NAME
249: and T.LANGUAGE = L.LANGUAGE_CODE);
250: end ADD_LANGUAGE;
251:

Line 252: end FND_PRINTER_PKG;

248: where T.PRINTER_NAME = B.PRINTER_NAME
249: and T.LANGUAGE = L.LANGUAGE_CODE);
250: end ADD_LANGUAGE;
251:
252: end FND_PRINTER_PKG;