APPS.FRM_DELIVERY_FTP_SERVERS_PKG dependencies on FRM_DELIVERY_FTP_SERVERS_TL

Line 54: insert into FRM_DELIVERY_FTP_SERVERS_TL (

50: X_LAST_UPDATED_BY,
51: X_LAST_UPDATE_LOGIN
52: );
53:
54: insert into FRM_DELIVERY_FTP_SERVERS_TL (
55: SERVER_ID,
56: SERVER_NAME,
57: CREATION_DATE,
58: CREATED_BY,

Line 78: from FRM_DELIVERY_FTP_SERVERS_TL T

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

Line 119: from FRM_DELIVERY_FTP_SERVERS_TL

115:
116: cursor c1 is select
117: SERVER_NAME,
118: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
119: from FRM_DELIVERY_FTP_SERVERS_TL
120: where SERVER_ID = X_SERVER_ID
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
122: for update of SERVER_ID nowait;
123: begin

Line 195: update FRM_DELIVERY_FTP_SERVERS_TL set

191: if (sql%notfound) then
192: raise no_data_found;
193: end if;
194:
195: update FRM_DELIVERY_FTP_SERVERS_TL set
196: SERVER_NAME = X_SERVER_NAME,
197: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
198: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
199: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 213: delete from FRM_DELIVERY_FTP_SERVERS_TL

209: procedure DELETE_ROW (
210: X_SERVER_ID in NUMBER
211: ) is
212: begin
213: delete from FRM_DELIVERY_FTP_SERVERS_TL
214: where SERVER_ID = X_SERVER_ID;
215:
216: if (sql%notfound) then
217: raise no_data_found;

Line 231: delete from FRM_DELIVERY_FTP_SERVERS_TL T

227:
228: procedure ADD_LANGUAGE
229: is
230: begin
231: delete from FRM_DELIVERY_FTP_SERVERS_TL T
232: where not exists
233: (select NULL
234: from FRM_DELIVERY_FTP_SERVERS_B B
235: where B.SERVER_ID = T.SERVER_ID

Line 238: update FRM_DELIVERY_FTP_SERVERS_TL T set (

234: from FRM_DELIVERY_FTP_SERVERS_B B
235: where B.SERVER_ID = T.SERVER_ID
236: );
237:
238: update FRM_DELIVERY_FTP_SERVERS_TL T set (
239: SERVER_NAME
240: ) = (select
241: B.SERVER_NAME
242: from FRM_DELIVERY_FTP_SERVERS_TL B

Line 242: from FRM_DELIVERY_FTP_SERVERS_TL B

238: update FRM_DELIVERY_FTP_SERVERS_TL T set (
239: SERVER_NAME
240: ) = (select
241: B.SERVER_NAME
242: from FRM_DELIVERY_FTP_SERVERS_TL B
243: where B.SERVER_ID = T.SERVER_ID
244: and B.LANGUAGE = T.SOURCE_LANG)
245: where (
246: T.SERVER_ID,

Line 251: from FRM_DELIVERY_FTP_SERVERS_TL SUBB, FRM_DELIVERY_FTP_SERVERS_TL SUBT

247: T.LANGUAGE
248: ) in (select
249: SUBT.SERVER_ID,
250: SUBT.LANGUAGE
251: from FRM_DELIVERY_FTP_SERVERS_TL SUBB, FRM_DELIVERY_FTP_SERVERS_TL SUBT
252: where SUBB.SERVER_ID = SUBT.SERVER_ID
253: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
254: and (SUBB.SERVER_NAME <> SUBT.SERVER_NAME
255: ));

Line 257: insert into FRM_DELIVERY_FTP_SERVERS_TL (

253: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
254: and (SUBB.SERVER_NAME <> SUBT.SERVER_NAME
255: ));
256:
257: insert into FRM_DELIVERY_FTP_SERVERS_TL (
258: SERVER_ID,
259: SERVER_NAME,
260: CREATION_DATE,
261: CREATED_BY,

Line 277: from FRM_DELIVERY_FTP_SERVERS_TL B, FND_LANGUAGES L

273: B.LAST_UPDATE_LOGIN,
274: B.LAST_UPDATE_DATE,
275: L.LANGUAGE_CODE,
276: B.SOURCE_LANG
277: from FRM_DELIVERY_FTP_SERVERS_TL B, FND_LANGUAGES L
278: where L.INSTALLED_FLAG in ('I', 'B')
279: and B.LANGUAGE = userenv('LANG')
280: and not exists
281: (select NULL

Line 282: from FRM_DELIVERY_FTP_SERVERS_TL T

278: where L.INSTALLED_FLAG in ('I', 'B')
279: and B.LANGUAGE = userenv('LANG')
280: and not exists
281: (select NULL
282: from FRM_DELIVERY_FTP_SERVERS_TL T
283: where T.SERVER_ID = B.SERVER_ID
284: and T.LANGUAGE = L.LANGUAGE_CODE);
285: end ADD_LANGUAGE;
286: