DBA Data[Home] [Help]

APPS.IEX_DUNNING_PLANS_PKG dependencies on FND_GLOBAL

Line 56: fnd_global.user_id,

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,

Line 59: 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)

Line 60: fnd_global.user_id,

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

Line 84: fnd_global.user_id,

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

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

Line 88: fnd_global.user_id

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

Line 225: LAST_UPDATED_BY = fnd_global.user_id,

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

Line 226: LAST_UPDATE_LOGIN = fnd_global.user_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
230: raise no_data_found;

Line 237: LAST_UPDATED_BY = fnd_global.user_id,

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);

Line 238: LAST_UPDATE_LOGIN = fnd_global.user_id,

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:

Line 353: last_updated_by = fnd_global.user_id,

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: