DBA Data[Home] [Help]

APPS.AMS_CUST_SETUP_PVT dependencies on FND_GLOBAL

Line 143: FND_GLOBAL.user_id,

139: VALUES
140: (
141: l_cust_setup_rec.custom_setup_id,
142: SYSDATE,
143: FND_GLOBAL.user_id,
144: SYSDATE,
145: FND_GLOBAL.user_id,
146: 1,
147: FND_GLOBAL.conc_login_id,

Line 145: FND_GLOBAL.user_id,

141: l_cust_setup_rec.custom_setup_id,
142: SYSDATE,
143: FND_GLOBAL.user_id,
144: SYSDATE,
145: FND_GLOBAL.user_id,
146: 1,
147: FND_GLOBAL.conc_login_id,
148: l_cust_setup_rec.activity_type_code,
149: l_cust_setup_rec.media_id,

Line 147: FND_GLOBAL.conc_login_id,

143: FND_GLOBAL.user_id,
144: SYSDATE,
145: FND_GLOBAL.user_id,
146: 1,
147: FND_GLOBAL.conc_login_id,
148: l_cust_setup_rec.activity_type_code,
149: l_cust_setup_rec.media_id,
150: NVL(l_cust_setup_rec.enabled_flag,'Y'),
151: NVL(l_cust_setup_rec.allow_essential_grouping,'N'),

Line 175: FND_GLOBAL.user_id,

171: SELECT
172: l_cust_setup_rec.custom_setup_id,
173: l.language_code,
174: SYSDATE,
175: FND_GLOBAL.user_id,
176: SYSDATE,
177: FND_GLOBAL.user_id,
178: FND_GLOBAL.conc_login_id,
179: USERENV('LANG'),

Line 177: FND_GLOBAL.user_id,

173: l.language_code,
174: SYSDATE,
175: FND_GLOBAL.user_id,
176: SYSDATE,
177: FND_GLOBAL.user_id,
178: FND_GLOBAL.conc_login_id,
179: USERENV('LANG'),
180: l_cust_setup_rec.setup_name,
181: l_cust_setup_rec.description

Line 178: FND_GLOBAL.conc_login_id,

174: SYSDATE,
175: FND_GLOBAL.user_id,
176: SYSDATE,
177: FND_GLOBAL.user_id,
178: FND_GLOBAL.conc_login_id,
179: USERENV('LANG'),
180: l_cust_setup_rec.setup_name,
181: l_cust_setup_rec.description
182: FROM fnd_languages l

Line 223: FND_GLOBAL.user_id,

219: )
220: select ams_custom_setup_attr_s.nextval,
221: x_cust_setup_id,
222: SYSDATE,
223: FND_GLOBAL.user_id,
224: SYSDATE,
225: FND_GLOBAL.user_id,
226: 1,
227: FND_GLOBAL.conc_login_id,

Line 225: FND_GLOBAL.user_id,

221: x_cust_setup_id,
222: SYSDATE,
223: FND_GLOBAL.user_id,
224: SYSDATE,
225: FND_GLOBAL.user_id,
226: 1,
227: FND_GLOBAL.conc_login_id,
228: stp.display_sequence_no,
229: stp.setup_attribute,

Line 227: FND_GLOBAL.conc_login_id,

223: FND_GLOBAL.user_id,
224: SYSDATE,
225: FND_GLOBAL.user_id,
226: 1,
227: FND_GLOBAL.conc_login_id,
228: stp.display_sequence_no,
229: stp.setup_attribute,
230: stp.mandatory_flag,
231: 'Y',

Line 275: FND_GLOBAL.user_id,

271: )
272: select ams_custom_setup_attr_s.nextval,
273: x_cust_setup_id,
274: SYSDATE,
275: FND_GLOBAL.user_id,
276: SYSDATE,
277: FND_GLOBAL.user_id,
278: 1,
279: FND_GLOBAL.conc_login_id,

Line 277: FND_GLOBAL.user_id,

273: x_cust_setup_id,
274: SYSDATE,
275: FND_GLOBAL.user_id,
276: SYSDATE,
277: FND_GLOBAL.user_id,
278: 1,
279: FND_GLOBAL.conc_login_id,
280: stp.display_sequence_no,
281: stp.setup_attribute,

Line 279: FND_GLOBAL.conc_login_id,

275: FND_GLOBAL.user_id,
276: SYSDATE,
277: FND_GLOBAL.user_id,
278: 1,
279: FND_GLOBAL.conc_login_id,
280: stp.display_sequence_no,
281: stp.setup_attribute,
282: stp.mandatory_flag,
283: 'Y',

Line 330: FND_GLOBAL.user_id,

326: )
327: select ams_custom_setup_attr_s.nextval,
328: x_cust_setup_id,
329: SYSDATE,
330: FND_GLOBAL.user_id,
331: SYSDATE,
332: FND_GLOBAL.user_id,
333: 1,
334: FND_GLOBAL.conc_login_id,

Line 332: FND_GLOBAL.user_id,

328: x_cust_setup_id,
329: SYSDATE,
330: FND_GLOBAL.user_id,
331: SYSDATE,
332: FND_GLOBAL.user_id,
333: 1,
334: FND_GLOBAL.conc_login_id,
335: stp.display_sequence_no,
336: stp.setup_attribute,

Line 334: FND_GLOBAL.conc_login_id,

330: FND_GLOBAL.user_id,
331: SYSDATE,
332: FND_GLOBAL.user_id,
333: 1,
334: FND_GLOBAL.conc_login_id,
335: stp.display_sequence_no,
336: stp.setup_attribute,
337: stp.mandatory_flag,
338: --decode(stp.setup_attribute,'PTNR','N','Y'), --'Y',--anchaudh modified: to bring up partner attribute unchecked while any user activity template creation

Line 386: FND_GLOBAL.user_id,

382: )
383: select ams_custom_setup_attr_s.nextval,
384: x_cust_setup_id,
385: SYSDATE,
386: FND_GLOBAL.user_id,
387: SYSDATE,
388: FND_GLOBAL.user_id,
389: 1,
390: FND_GLOBAL.conc_login_id,

Line 388: FND_GLOBAL.user_id,

384: x_cust_setup_id,
385: SYSDATE,
386: FND_GLOBAL.user_id,
387: SYSDATE,
388: FND_GLOBAL.user_id,
389: 1,
390: FND_GLOBAL.conc_login_id,
391: stp.display_sequence_no,
392: stp.setup_attribute,

Line 390: FND_GLOBAL.conc_login_id,

386: FND_GLOBAL.user_id,
387: SYSDATE,
388: FND_GLOBAL.user_id,
389: 1,
390: FND_GLOBAL.conc_login_id,
391: stp.display_sequence_no,
392: stp.setup_attribute,
393: stp.mandatory_flag,
394: --decode(stp.setup_attribute,'PTNR','N','Y'), --'Y',--anchaudh modified: to bring up partner attribute unchecked while any user activity template creation

Line 443: FND_GLOBAL.user_id,

439: )
440: select ams_custom_setup_attr_s.nextval,
441: x_cust_setup_id,
442: SYSDATE,
443: FND_GLOBAL.user_id,
444: SYSDATE,
445: FND_GLOBAL.user_id,
446: 1,
447: FND_GLOBAL.conc_login_id,

Line 445: FND_GLOBAL.user_id,

441: x_cust_setup_id,
442: SYSDATE,
443: FND_GLOBAL.user_id,
444: SYSDATE,
445: FND_GLOBAL.user_id,
446: 1,
447: FND_GLOBAL.conc_login_id,
448: stp.display_sequence_no,
449: stp.setup_attribute,

Line 447: FND_GLOBAL.conc_login_id,

443: FND_GLOBAL.user_id,
444: SYSDATE,
445: FND_GLOBAL.user_id,
446: 1,
447: FND_GLOBAL.conc_login_id,
448: stp.display_sequence_no,
449: stp.setup_attribute,
450: stp.mandatory_flag,
451: --decode(stp.setup_attribute,'PTNR','N','Y'), --'Y',--anchaudh modified: to bring up partner attribute unchecked while any user activity template creation

Line 498: FND_GLOBAL.user_id,

494: )
495: select ams_custom_setup_attr_s.nextval,
496: x_cust_setup_id,
497: SYSDATE,
498: FND_GLOBAL.user_id,
499: SYSDATE,
500: FND_GLOBAL.user_id,
501: 1,
502: FND_GLOBAL.conc_login_id,

Line 500: FND_GLOBAL.user_id,

496: x_cust_setup_id,
497: SYSDATE,
498: FND_GLOBAL.user_id,
499: SYSDATE,
500: FND_GLOBAL.user_id,
501: 1,
502: FND_GLOBAL.conc_login_id,
503: stp.display_sequence_no,
504: stp.setup_attribute,

Line 502: FND_GLOBAL.conc_login_id,

498: FND_GLOBAL.user_id,
499: SYSDATE,
500: FND_GLOBAL.user_id,
501: 1,
502: FND_GLOBAL.conc_login_id,
503: stp.display_sequence_no,
504: stp.setup_attribute,
505: stp.mandatory_flag,
506: --decode(stp.setup_attribute,'PTNR','N','Y'), --'Y',--anchaudh modified: to bring up partner attribute unchecked while any user activity template creation

Line 695: last_updated_by = FND_GLOBAL.user_id,

691: END IF;
692:
693: UPDATE AMS_CUSTOM_SETUPS_B SET
694: last_update_date = SYSDATE,
695: last_updated_by = FND_GLOBAL.user_id,
696: object_version_number = l_cust_setup_rec.object_version_number + 1,
697: last_update_login = FND_GLOBAL.conc_login_id,
698: activity_type_code = l_cust_setup_rec.activity_type_code,
699: media_id = l_cust_setup_rec.media_id,

Line 697: last_update_login = FND_GLOBAL.conc_login_id,

693: UPDATE AMS_CUSTOM_SETUPS_B SET
694: last_update_date = SYSDATE,
695: last_updated_by = FND_GLOBAL.user_id,
696: object_version_number = l_cust_setup_rec.object_version_number + 1,
697: last_update_login = FND_GLOBAL.conc_login_id,
698: activity_type_code = l_cust_setup_rec.activity_type_code,
699: media_id = l_cust_setup_rec.media_id,
700: enabled_flag = l_cust_setup_rec.enabled_flag,
701: object_type = l_cust_setup_rec.object_type,

Line 718: last_updated_by = FND_GLOBAL.user_id,

714: END IF;
715:
716: UPDATE AMS_CUSTOM_SETUPS_TL SET
717: last_update_date = SYSDATE,
718: last_updated_by = FND_GLOBAL.user_id,
719: last_update_login = FND_GLOBAL.conc_login_id,
720: source_lang = USERENV('LANG'),
721: setup_name = l_cust_setup_rec.setup_name,
722: description = l_cust_setup_rec.description

Line 719: last_update_login = FND_GLOBAL.conc_login_id,

715:
716: UPDATE AMS_CUSTOM_SETUPS_TL SET
717: last_update_date = SYSDATE,
718: last_updated_by = FND_GLOBAL.user_id,
719: last_update_login = FND_GLOBAL.conc_login_id,
720: source_lang = USERENV('LANG'),
721: setup_name = l_cust_setup_rec.setup_name,
722: description = l_cust_setup_rec.description
723: WHERE custom_setup_id = l_cust_setup_rec.custom_setup_id