DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on FND_GLOBAL

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

309:
310: g_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
311: g_amt_format VARCHAR2(20);
312:
313: NEWLINE VARCHAR2(1) := fnd_global.newline;
314: TAB VARCHAR2(1) := fnd_global.tab;
315:
316:
317: /*Procedure getUserType(pPartyId IN Varchar2,

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

310: g_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
311: g_amt_format VARCHAR2(20);
312:
313: NEWLINE VARCHAR2(1) := fnd_global.newline;
314: TAB VARCHAR2(1) := fnd_global.tab;
315:
316:
317: /*Procedure getUserType(pPartyId IN Varchar2,
318: pUserType OUT NOCOPY Varchar2) IS

Line 4000: where user_id = FND_GLOBAL.USER_ID;

3996:
3997: cursor c_userenv_partyid is
3998: select customer_id
3999: from FND_USER
4000: where user_id = FND_GLOBAL.USER_ID;
4001: rec_userenv_partyid c_userenv_partyid%rowtype;
4002:
4003: BEGIN
4004: x_return_status := FND_API.g_ret_sts_success;

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

9965: WHERE parameter = 'NLS_TERRITORY';
9966:
9967: IF (l_sess_lang <> l_lang_pref) THEN
9968: --need to create an adhoc user
9969: l_adhoc_user := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
9970: l_adhoc_user_display := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
9971:
9972: wf_directory.CreateAdHocUser(
9973: name => l_adhoc_user ,

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

9966:
9967: IF (l_sess_lang <> l_lang_pref) THEN
9968: --need to create an adhoc user
9969: l_adhoc_user := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
9970: l_adhoc_user_display := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
9971:
9972: wf_directory.CreateAdHocUser(
9973: name => l_adhoc_user ,
9974: display_name => l_adhoc_user_display ,

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

9995:
9996: ELSE
9997: --only e-mail address passed in
9998: --create an adhoc user with session lang and territory as preference
9999: l_adhoc_user := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
10000: l_adhoc_user_display := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
10001:
10002: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
10003:

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

9996: ELSE
9997: --only e-mail address passed in
9998: --create an adhoc user with session lang and territory as preference
9999: l_adhoc_user := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
10000: l_adhoc_user_display := substrb(('IBEUE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_quote_header_id),1,320);
10001:
10002: l_notification_preference := NVL( FND_PROFILE.VALUE_SPECIFIC('IBE_DEFAULT_USER_EMAIL_FORMAT',null,null,671), 'MAILTEXT');
10003:
10004: wf_directory.CreateAdHocUser(

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

10050: IF (p_wf_users_tbl IS NULL OR p_wf_users_tbl.COUNT <= 0) THEN
10051: return;
10052: END IF;
10053:
10054: l_adhoc_role := substrb(('IBER'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_wf_users_tbl(1)||p_quote_header_id),1,320);
10055: 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);
10056:
10057: SELECT DISTINCT value
10058: INTO l_sess_lang

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

10051: return;
10052: END IF;
10053:
10054: l_adhoc_role := substrb(('IBER'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_wf_users_tbl(1)||p_quote_header_id),1,320);
10055: 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);
10056:
10057: SELECT DISTINCT value
10058: INTO l_sess_lang
10059: FROM nls_session_parameters