APPS.FND_PRINTER_PKG dependencies on FND_PRINTER_TL

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 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 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 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 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: