DBA Data[Home] [Help]

APPS.ITG_SYNCCOAINBOUND_PVT dependencies on FND_GLOBAL

Line 211: l_comp_attrs := 'Y'||fnd_global.local_chr(10)||'Y'||

207: * Allow Posting = Y,
208: * Account Type = value,
209: * Reconciliation = N
210: */
211: l_comp_attrs := 'Y'||fnd_global.local_chr(10)||'Y'||
212: fnd_global.local_chr(10)||p_acct_type||
213: fnd_global.local_chr(10)||'N';
214: ELSE
215: /* Key:

Line 212: fnd_global.local_chr(10)||p_acct_type||

208: * Account Type = value,
209: * Reconciliation = N
210: */
211: l_comp_attrs := 'Y'||fnd_global.local_chr(10)||'Y'||
212: fnd_global.local_chr(10)||p_acct_type||
213: fnd_global.local_chr(10)||'N';
214: ELSE
215: /* Key:
216: * Allow Budgeting = Y,

Line 213: fnd_global.local_chr(10)||'N';

209: * Reconciliation = N
210: */
211: l_comp_attrs := 'Y'||fnd_global.local_chr(10)||'Y'||
212: fnd_global.local_chr(10)||p_acct_type||
213: fnd_global.local_chr(10)||'N';
214: ELSE
215: /* Key:
216: * Allow Budgeting = Y,
217: * Allow Posting = Y,

Line 219: l_comp_attrs := 'Y'||fnd_global.local_chr(10)||'Y';

215: /* Key:
216: * Allow Budgeting = Y,
217: * Allow Posting = Y,
218: */
219: l_comp_attrs := 'Y'||fnd_global.local_chr(10)||'Y';
220: END IF;
221:
222: /* next flex value id. */
223: SELECT fnd_flex_values_s.nextval

Line 253: x_created_by => FND_GLOBAL.user_id,

249: x_value_category => NULL,
250: x_flex_value_meaning => p_flex_value,
251: x_description => p_flex_desc,
252: x_creation_date => l_creation_date,
253: x_created_by => FND_GLOBAL.user_id,
254: x_last_update_date => l_creation_date,
255: x_last_updated_by => FND_GLOBAL.user_id,
256: x_last_update_login => FND_GLOBAL.login_id,
257: x_attribute_sort_order => NULL,

Line 255: x_last_updated_by => FND_GLOBAL.user_id,

251: x_description => p_flex_desc,
252: x_creation_date => l_creation_date,
253: x_created_by => FND_GLOBAL.user_id,
254: x_last_update_date => l_creation_date,
255: x_last_updated_by => FND_GLOBAL.user_id,
256: x_last_update_login => FND_GLOBAL.login_id,
257: x_attribute_sort_order => NULL,
258: /* Why didn't the flex people default these to NULL??? */
259: x_attribute1 => NULL, x_attribute2 => NULL, x_attribute3 => NULL,

Line 256: x_last_update_login => FND_GLOBAL.login_id,

252: x_creation_date => l_creation_date,
253: x_created_by => FND_GLOBAL.user_id,
254: x_last_update_date => l_creation_date,
255: x_last_updated_by => FND_GLOBAL.user_id,
256: x_last_update_login => FND_GLOBAL.login_id,
257: x_attribute_sort_order => NULL,
258: /* Why didn't the flex people default these to NULL??? */
259: x_attribute1 => NULL, x_attribute2 => NULL, x_attribute3 => NULL,
260: x_attribute4 => NULL, x_attribute5 => NULL, x_attribute6 => NULL,

Line 386: last_updated_by = FND_GLOBAL.user_id

382: SET start_date_active = nvl(p_effective_date, start_date_active),
383: end_date_active = nvl(p_expiration_date, end_date_active),
384: enabled_flag = p_enabled_flag,
385: last_update_date = l_update_date,
386: last_updated_by = FND_GLOBAL.user_id
387: WHERE flex_value_id = l_value_id;
388:
389: IF SQL%ROWCOUNT = 0 THEN
390: ITG_MSG.flex_update_fail_novalue(p_flex_value);

Line 398: last_updated_by = FND_GLOBAL.user_id

394: /* ...and the translated description */
395: UPDATE fnd_flex_values_tl
396: SET description = p_flex_desc,
397: last_update_date = l_update_date,
398: last_updated_by = FND_GLOBAL.user_id
399: WHERE flex_value_id = l_value_id
400: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
401:
402: IF SQL%ROWCOUNT = 0 THEN