APPS.FRM_DELIVERY_MAILERS_PKG dependencies on FRM_DELIVERY_MAILERS_TL

Line 51: insert into FRM_DELIVERY_MAILERS_TL (

47: X_LAST_UPDATED_BY,
48: X_LAST_UPDATE_LOGIN
49: );
50:
51: insert into FRM_DELIVERY_MAILERS_TL (
52: MAILER_ID,
53: MAILER_NAME,
54: CREATION_DATE,
55: CREATED_BY,

Line 75: from FRM_DELIVERY_MAILERS_TL T

71: from FND_LANGUAGES L
72: where L.INSTALLED_FLAG in ('I', 'B')
73: and not exists
74: (select NULL
75: from FRM_DELIVERY_MAILERS_TL T
76: where T.MAILER_ID = X_MAILER_ID
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;

Line 114: from FRM_DELIVERY_MAILERS_TL

110:
111: cursor c1 is select
112: MAILER_NAME,
113: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
114: from FRM_DELIVERY_MAILERS_TL
115: where MAILER_ID = X_MAILER_ID
116: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
117: for update of MAILER_ID nowait;
118: begin

Line 186: update FRM_DELIVERY_MAILERS_TL set

182: if (sql%notfound) then
183: raise no_data_found;
184: end if;
185:
186: update FRM_DELIVERY_MAILERS_TL set
187: MAILER_NAME = X_MAILER_NAME,
188: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
189: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
190: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 204: delete from FRM_DELIVERY_MAILERS_TL

200: procedure DELETE_ROW (
201: X_MAILER_ID in NUMBER
202: ) is
203: begin
204: delete from FRM_DELIVERY_MAILERS_TL
205: where MAILER_ID = X_MAILER_ID;
206:
207: if (sql%notfound) then
208: raise no_data_found;

Line 222: delete from FRM_DELIVERY_MAILERS_TL T

218:
219: procedure ADD_LANGUAGE
220: is
221: begin
222: delete from FRM_DELIVERY_MAILERS_TL T
223: where not exists
224: (select NULL
225: from FRM_DELIVERY_MAILERS_B B
226: where B.MAILER_ID = T.MAILER_ID

Line 229: update FRM_DELIVERY_MAILERS_TL T set (

225: from FRM_DELIVERY_MAILERS_B B
226: where B.MAILER_ID = T.MAILER_ID
227: );
228:
229: update FRM_DELIVERY_MAILERS_TL T set (
230: MAILER_NAME
231: ) = (select
232: B.MAILER_NAME
233: from FRM_DELIVERY_MAILERS_TL B

Line 233: from FRM_DELIVERY_MAILERS_TL B

229: update FRM_DELIVERY_MAILERS_TL T set (
230: MAILER_NAME
231: ) = (select
232: B.MAILER_NAME
233: from FRM_DELIVERY_MAILERS_TL B
234: where B.MAILER_ID = T.MAILER_ID
235: and B.LANGUAGE = T.SOURCE_LANG)
236: where (
237: T.MAILER_ID,

Line 242: from FRM_DELIVERY_MAILERS_TL SUBB, FRM_DELIVERY_MAILERS_TL SUBT

238: T.LANGUAGE
239: ) in (select
240: SUBT.MAILER_ID,
241: SUBT.LANGUAGE
242: from FRM_DELIVERY_MAILERS_TL SUBB, FRM_DELIVERY_MAILERS_TL SUBT
243: where SUBB.MAILER_ID = SUBT.MAILER_ID
244: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
245: and (SUBB.MAILER_NAME <> SUBT.MAILER_NAME
246: ));

Line 248: insert into FRM_DELIVERY_MAILERS_TL (

244: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
245: and (SUBB.MAILER_NAME <> SUBT.MAILER_NAME
246: ));
247:
248: insert into FRM_DELIVERY_MAILERS_TL (
249: MAILER_ID,
250: MAILER_NAME,
251: CREATION_DATE,
252: CREATED_BY,

Line 268: from FRM_DELIVERY_MAILERS_TL B, FND_LANGUAGES L

264: B.LAST_UPDATE_LOGIN,
265: B.LAST_UPDATE_DATE,
266: L.LANGUAGE_CODE,
267: B.SOURCE_LANG
268: from FRM_DELIVERY_MAILERS_TL B, FND_LANGUAGES L
269: where L.INSTALLED_FLAG in ('I', 'B')
270: and B.LANGUAGE = userenv('LANG')
271: and not exists
272: (select NULL

Line 273: from FRM_DELIVERY_MAILERS_TL T

269: where L.INSTALLED_FLAG in ('I', 'B')
270: and B.LANGUAGE = userenv('LANG')
271: and not exists
272: (select NULL
273: from FRM_DELIVERY_MAILERS_TL T
274: where T.MAILER_ID = B.MAILER_ID
275: and T.LANGUAGE = L.LANGUAGE_CODE);
276: end ADD_LANGUAGE;
277: