APPS.IEX_DUNNING_PLANS_PKG dependencies on IEX_DUNNING_PLANS_TL

Line 67: insert into iex_dunning_plans_tl (

63: to_date(null)
64: );
65:
66:
67: insert into iex_dunning_plans_tl (
68: DUNNING_PLAN_ID,
69: NAME,
70: DESCRIPTION,
71: LANGUAGE,

Line 93: from iex_dunning_plans_tl T

89: from FND_LANGUAGES L
90: where L.INSTALLED_FLAG in ('I', 'B')
91: and not exists
92: (select NULL
93: from iex_dunning_plans_tl T
94: where T.dunning_plan_id = x_dunning_plan_id
95: and T.LANGUAGE = L.LANGUAGE_CODE);
96:
97: open l_insert;

Line 145: from iex_dunning_plans_tl

141: cursor c1 is select
142: NAME,
143: DESCRIPTION,
144: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
145: from iex_dunning_plans_tl
146: where dunning_plan_id = x_dunning_plan_id
147: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
148: for update of dunning_plan_id nowait;
149: begin

Line 233: update iex_dunning_plans_tl set

229: if (sql%notfound) then
230: raise no_data_found;
231: end if;
232:
233: update iex_dunning_plans_tl set
234: name = x_name,
235: description = x_description,
236: LAST_UPDATE_DATE = sysdate,
237: LAST_UPDATED_BY = fnd_global.user_id,

Line 252: delete from iex_dunning_plans_tl

248: procedure DELETE_ROW (
249: x_dunning_plan_id in NUMBER
250: ) is
251: begin
252: delete from iex_dunning_plans_tl
253: where dunning_plan_id = x_dunning_plan_id;
254:
255: if (sql%notfound) then
256: raise no_data_found;

Line 277: delete from iex_dunning_plans_tl T

273:
274: procedure ADD_LANGUAGE
275: is
276: begin
277: delete from iex_dunning_plans_tl T
278: where not exists
279: (select NULL
280: from iex_dunning_plans_b B
281: where B.dunning_plan_id = T.dunning_plan_id

Line 284: update iex_dunning_plans_tl T set (

280: from iex_dunning_plans_b B
281: where B.dunning_plan_id = T.dunning_plan_id
282: );
283:
284: update iex_dunning_plans_tl T set (
285: name,
286: description
287: ) = (select
288: B.name,

Line 290: from iex_dunning_plans_tl B

286: description
287: ) = (select
288: B.name,
289: B.description
290: from iex_dunning_plans_tl B
291: where B.dunning_plan_id = T.dunning_plan_id
292: and B.LANGUAGE = T.SOURCE_LANG)
293: where (
294: T.dunning_plan_id,

Line 299: from iex_dunning_plans_tl SUBB, iex_dunning_plans_tl SUBT

295: T.LANGUAGE
296: ) in (select
297: SUBT.dunning_plan_id,
298: SUBT.LANGUAGE
299: from iex_dunning_plans_tl SUBB, iex_dunning_plans_tl SUBT
300: where SUBB.dunning_plan_id = SUBT.dunning_plan_id
301: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
302: and (SUBB.name <> SUBT.name
303: or (SUBB.name is null and SUBT.name is not null)

Line 310: insert into iex_dunning_plans_tl (

306: or (SUBB.description is null and SUBT.description is not null)
307: or (SUBB.description is not null and SUBT.description is null)
308: ));
309:
310: insert into iex_dunning_plans_tl (
311: dunning_plan_id,
312: name,
313: description,
314: LAST_UPDATE_DATE,

Line 332: from iex_dunning_plans_tl B, FND_LANGUAGES L

328: B.CREATED_BY,
329: B.LAST_UPDATE_LOGIN,
330: L.LANGUAGE_CODE,
331: B.SOURCE_LANG
332: from iex_dunning_plans_tl B, FND_LANGUAGES L
333: where L.INSTALLED_FLAG in ('I', 'B')
334: and B.LANGUAGE = userenv('LANG')
335: and not exists
336: (select NULL

Line 337: from iex_dunning_plans_tl T

333: where L.INSTALLED_FLAG in ('I', 'B')
334: and B.LANGUAGE = userenv('LANG')
335: and not exists
336: (select NULL
337: from iex_dunning_plans_tl T
338: where T.dunning_plan_id = B.dunning_plan_id
339: and T.LANGUAGE = L.LANGUAGE_CODE);
340: end ADD_LANGUAGE;
341:

Line 348: update iex_dunning_plans_tl

344: x_name in VARCHAR2,
345: x_description in VARCHAR2
346: ) is
347: begin
348: update iex_dunning_plans_tl
349: set name = x_name,
350: description = x_description,
351: source_lang = userenv('LANG'),
352: last_update_date = sysdate,