52: x_AGING_BUCKET_ID,
53: x_SCORE_ID,
54: x_DUNNING_LEVEL,
55: 1.0,
56: fnd_global.user_id,
57: sysdate,
58: sysdate,
59: fnd_global.user_id,
60: fnd_global.user_id,
55: 1.0,
56: fnd_global.user_id,
57: sysdate,
58: sysdate,
59: fnd_global.user_id,
60: fnd_global.user_id,
61: to_number(null),
62: to_number(null),
63: to_date(null)
56: fnd_global.user_id,
57: sysdate,
58: sysdate,
59: fnd_global.user_id,
60: fnd_global.user_id,
61: to_number(null),
62: to_number(null),
63: to_date(null)
64: );
80: x_NAME,
81: x_DESCRIPTION,
82: L.LANGUAGE_CODE,
83: userenv('LANG'),
84: fnd_global.user_id,
85: sysdate,
86: sysdate,
87: fnd_global.user_id,
88: fnd_global.user_id
83: userenv('LANG'),
84: fnd_global.user_id,
85: sysdate,
86: sysdate,
87: fnd_global.user_id,
88: fnd_global.user_id
89: from FND_LANGUAGES L
90: where L.INSTALLED_FLAG in ('I', 'B')
91: and not exists
84: fnd_global.user_id,
85: sysdate,
86: sysdate,
87: fnd_global.user_id,
88: fnd_global.user_id
89: from FND_LANGUAGES L
90: where L.INSTALLED_FLAG in ('I', 'B')
91: and not exists
92: (select NULL
221: SCORE_ID = x_score_id,
222: DUNNING_LEVEL = x_dunning_level,
223: OBJECT_VERSION_NUMBER = object_version_number + 1.0,
224: LAST_UPDATE_DATE = sysdate,
225: LAST_UPDATED_BY = fnd_global.user_id,
226: LAST_UPDATE_LOGIN = fnd_global.user_id
227: where dunning_plan_id = x_dunning_plan_id;
228:
229: if (sql%notfound) then
222: DUNNING_LEVEL = x_dunning_level,
223: OBJECT_VERSION_NUMBER = object_version_number + 1.0,
224: LAST_UPDATE_DATE = sysdate,
225: LAST_UPDATED_BY = fnd_global.user_id,
226: LAST_UPDATE_LOGIN = fnd_global.user_id
227: where dunning_plan_id = x_dunning_plan_id;
228:
229: if (sql%notfound) then
230: raise no_data_found;
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,
238: LAST_UPDATE_LOGIN = fnd_global.user_id,
239: SOURCE_LANG = userenv('LANG')
240: where dunning_plan_id = x_dunning_plan_id
241: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
234: name = x_name,
235: description = x_description,
236: LAST_UPDATE_DATE = sysdate,
237: LAST_UPDATED_BY = fnd_global.user_id,
238: LAST_UPDATE_LOGIN = fnd_global.user_id,
239: SOURCE_LANG = userenv('LANG')
240: where dunning_plan_id = x_dunning_plan_id
241: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
242:
349: set name = x_name,
350: description = x_description,
351: source_lang = userenv('LANG'),
352: last_update_date = sysdate,
353: last_updated_by = fnd_global.user_id,
354: last_update_login = 0
355: where dunning_plan_id = x_dunning_plan_id
356: and userenv('LANG') in (language, source_lang);
357: