DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on FND_GLOBAL

Line 303: NEWLINE VARCHAR2(1) := fnd_global.newline;

299:
300: g_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
301: g_amt_format VARCHAR2(20);
302:
303: NEWLINE VARCHAR2(1) := fnd_global.newline;
304: TAB VARCHAR2(1) := fnd_global.tab;
305:
306:
307: /*Procedure getUserType(pPartyId IN Varchar2,

Line 304: TAB VARCHAR2(1) := fnd_global.tab;

300: g_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
301: g_amt_format VARCHAR2(20);
302:
303: NEWLINE VARCHAR2(1) := fnd_global.newline;
304: TAB VARCHAR2(1) := fnd_global.tab;
305:
306:
307: /*Procedure getUserType(pPartyId IN Varchar2,
308: pUserType OUT NOCOPY Varchar2) IS

Line 3905: where user_id = FND_GLOBAL.USER_ID;

3901:
3902: cursor c_userenv_partyid is
3903: select customer_id
3904: from FND_USER
3905: where user_id = FND_GLOBAL.USER_ID;
3906: rec_userenv_partyid c_userenv_partyid%rowtype;
3907:
3908: BEGIN
3909: x_return_status := FND_API.g_ret_sts_success;

Line 9874: l_adhoc_user := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);

9870: WHERE parameter = 'NLS_TERRITORY';
9871:
9872: IF (l_sess_lang <> l_lang_pref) THEN
9873: --need to create an adhoc user
9874: l_adhoc_user := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
9875: l_adhoc_user_display := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
9876:
9877: wf_directory.CreateAdHocUser(
9878: name => l_adhoc_user ,

Line 9875: l_adhoc_user_display := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);

9871:
9872: IF (l_sess_lang <> l_lang_pref) THEN
9873: --need to create an adhoc user
9874: l_adhoc_user := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
9875: l_adhoc_user_display := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
9876:
9877: wf_directory.CreateAdHocUser(
9878: name => l_adhoc_user ,
9879: display_name => l_adhoc_user_display ,

Line 9904: l_adhoc_user := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);

9900:
9901: ELSE
9902: --only e-mail address passed in
9903: --create an adhoc user with session lang and territory as preference
9904: l_adhoc_user := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
9905: l_adhoc_user_display := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
9906:
9907: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
9908:

Line 9905: l_adhoc_user_display := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);

9901: ELSE
9902: --only e-mail address passed in
9903: --create an adhoc user with session lang and territory as preference
9904: l_adhoc_user := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
9905: l_adhoc_user_display := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
9906:
9907: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
9908:
9909: wf_directory.CreateAdHocUser(

Line 9959: l_adhoc_role := substrb(('IBER'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_wf_users_tbl(1)||p_quote_header_id),1,320);

9955: IF (p_wf_users_tbl IS NULL OR p_wf_users_tbl.COUNT <= 0) THEN
9956: return;
9957: END IF;
9958:
9959: l_adhoc_role := substrb(('IBER'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_wf_users_tbl(1)||p_quote_header_id),1,320);
9960: l_adhoc_role_display := substrb(('IBE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_wf_users_tbl(1)||p_quote_header_id),1,320);
9961:
9962: SELECT DISTINCT value
9963: INTO l_sess_lang

Line 9960: l_adhoc_role_display := substrb(('IBE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_wf_users_tbl(1)||p_quote_header_id),1,320);

9956: return;
9957: END IF;
9958:
9959: l_adhoc_role := substrb(('IBER'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_wf_users_tbl(1)||p_quote_header_id),1,320);
9960: l_adhoc_role_display := substrb(('IBE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_wf_users_tbl(1)||p_quote_header_id),1,320);
9961:
9962: SELECT DISTINCT value
9963: INTO l_sess_lang
9964: FROM nls_session_parameters