eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_WORKFLOW_PVT dependencies on WF_USERS

Line 584: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

580: ,p_context_msg IN VARCHAR2 :=FND_API.G_MISS_CHAR
581: ,p_notes IN VARCHAR2 :=FND_API.G_MISS_CHAR
582: ,p_notif_context IN VARCHAR2 ) is
583:
584: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
585: l_temp_retrieve_str Varchar2(2000);
586: L_temp_update_str Varchar2(2000);
587:
588:

Line 986: l_adhoc_user WF_USERS.NAME%TYPE;

982: g_ItemType Varchar2(10) := 'IBEALERT';
983: g_processName Varchar2(30) := 'PROCESSMAP';
984:
985:
986: l_adhoc_user WF_USERS.NAME%TYPE;
987: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
988: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
989:
990: l_partyId Number;

Line 988: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

984:
985:
986: l_adhoc_user WF_USERS.NAME%TYPE;
987: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
988: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
989:
990: l_partyId Number;
991:
992: l_notifEnabled Varchar2(3) := 'Y';

Line 1324: l_adhoc_user WF_USERS.NAME%TYPE;

1320: x_return_status OUT NOCOPY VARCHAR2,
1321: x_msg_count OUT NOCOPY NUMBER,
1322: x_msg_data OUT NOCOPY VARCHAR2
1323: ) IS
1324: l_adhoc_user WF_USERS.NAME%TYPE;
1325: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
1326: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
1327: l_partyId Number;
1328: l_notifEnabled Varchar2(3) := 'Y';

Line 1326: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

1322: x_msg_data OUT NOCOPY VARCHAR2
1323: ) IS
1324: l_adhoc_user WF_USERS.NAME%TYPE;
1325: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
1326: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
1327: l_partyId Number;
1328: l_notifEnabled Varchar2(3) := 'Y';
1329: l_notifName Varchar2(30) := 'ACCTREGNOTIFICATION';
1330: l_OrgId Number := null;

Line 1629: l_adhoc_user WF_USERS.NAME%TYPE;

1625: x_msg_count OUT NOCOPY NUMBER,
1626: x_msg_data OUT NOCOPY VARCHAR2
1627: ) IS
1628:
1629: l_adhoc_user WF_USERS.NAME%TYPE;
1630: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
1631: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
1632:
1633: l_partyId Number;

Line 1631: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

1627: ) IS
1628:
1629: l_adhoc_user WF_USERS.NAME%TYPE;
1630: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
1631: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
1632:
1633: l_partyId Number;
1634:
1635: l_event_type Varchar2(30) := 'FORGETLOGIN';

Line 1845: l_adhoc_user WF_USERS.NAME%TYPE;

1841: x_msg_count OUT NOCOPY NUMBER,
1842: x_msg_data OUT NOCOPY VARCHAR2
1843: ) IS
1844:
1845: l_adhoc_user WF_USERS.NAME%TYPE;
1846: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
1847: l_event_type VARCHAR2(20);
1848: l_email_addr WF_USERS.Email_Address%TYPE;
1849: l_this NUMBER;

Line 1848: l_email_addr WF_USERS.Email_Address%TYPE;

1844:
1845: l_adhoc_user WF_USERS.NAME%TYPE;
1846: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
1847: l_event_type VARCHAR2(20);
1848: l_email_addr WF_USERS.Email_Address%TYPE;
1849: l_this NUMBER;
1850: l_temp_str VARCHAR2(2000);
1851: l_next NUMBER;
1852: l_errmsg_count NUMBER;

Line 1856: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

1852: l_errmsg_count NUMBER;
1853: l_errmsg_data VARCHAR2(32000);
1854: l_party_id NUMBER;
1855: lx_party_id NUMBER;
1856: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
1857: l_order_id NUMBER;
1858: l_partyId Number;
1859: l_first_name VARCHAR2(2000);
1860: l_last_name VARCHAR2(2000);

Line 1878: l_admin_email_addr WF_USERS.email_address%TYPE;

1874: l_paynow_flag VARCHAR2(1);
1875: l_reccharge_flag VARCHAR2(1);
1876: l_adhoc_role WF_ROLES.NAME%TYPE;
1877: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
1878: l_admin_email_addr WF_USERS.email_address%TYPE;
1879: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
1880: l_admin_adhoc_user WF_USERS.NAME%TYPE;
1881: l_admin_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
1882: l_role_users Varchar2(200);

Line 1879: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

1875: l_reccharge_flag VARCHAR2(1);
1876: l_adhoc_role WF_ROLES.NAME%TYPE;
1877: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
1878: l_admin_email_addr WF_USERS.email_address%TYPE;
1879: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
1880: l_admin_adhoc_user WF_USERS.NAME%TYPE;
1881: l_admin_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
1882: l_role_users Varchar2(200);
1883:

Line 1880: l_admin_adhoc_user WF_USERS.NAME%TYPE;

1876: l_adhoc_role WF_ROLES.NAME%TYPE;
1877: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
1878: l_admin_email_addr WF_USERS.email_address%TYPE;
1879: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
1880: l_admin_adhoc_user WF_USERS.NAME%TYPE;
1881: l_admin_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
1882: l_role_users Varchar2(200);
1883:
1884:

Line 1881: l_admin_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

1877: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
1878: l_admin_email_addr WF_USERS.email_address%TYPE;
1879: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
1880: l_admin_adhoc_user WF_USERS.NAME%TYPE;
1881: l_admin_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
1882: l_role_users Varchar2(200);
1883:
1884:
1885:

Line 2438: l_user_name WF_USERS.NAME%TYPE;

2434: x_msg_data OUT NOCOPY VARCHAR2
2435: ) IS
2436:
2437:
2438: l_user_name WF_USERS.NAME%TYPE;
2439: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
2440: l_event_type VARCHAR2(20);
2441: l_party_id NUMBER;
2442: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

Line 2442: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

2438: l_user_name WF_USERS.NAME%TYPE;
2439: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
2440: l_event_type VARCHAR2(20);
2441: l_party_id NUMBER;
2442: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
2443: l_order_header_id NUMBER;
2444: l_permission_to_view_price BOOLEAN;
2445: l_view_net_price_flag VARCHAR2(1);
2446: x_recepient_party_id NUMBER;

Line 2822: l_cust_adhoc_user WF_USERS.NAME%TYPE;

2818: x_msg_count OUT NOCOPY NUMBER,
2819: x_msg_data OUT NOCOPY VARCHAR2
2820: ) is
2821:
2822: l_cust_adhoc_user WF_USERS.NAME%TYPE;
2823: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
2824: l_event_type VARCHAR2(20) := 'CNCLORDR';
2825: l_errmsg_count NUMBER;
2826: l_errmsg_data VARCHAR2(32000);

Line 2830: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

2826: l_errmsg_data VARCHAR2(32000);
2827: l_party_id NUMBER;
2828: l_contact_party_id NUMBER;
2829: l_msite_name VARCHAR2(2000);
2830: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
2831: l_order_id NUMBER;
2832: l_quote_id NUMBER;
2833: l_order_num NUMBER;
2834: l_contact_first_name VARCHAR2(2000);

Line 3043: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

3039: ) IS
3040:
3041: l_event_type VARCHAR(20);
3042: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
3043: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3044:
3045: l_quote_org_id NUMBER;
3046:
3047: l_org_contract_rep WF_USERS.NAME%TYPE;

Line 3047: l_org_contract_rep WF_USERS.NAME%TYPE;

3043: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3044:
3045: l_quote_org_id NUMBER;
3046:
3047: l_org_contract_rep WF_USERS.NAME%TYPE;
3048: l_customer_user WF_USERS.NAME%TYPE;
3049:
3050: l_quote_number Number;
3051:

Line 3048: l_customer_user WF_USERS.NAME%TYPE;

3044:
3045: l_quote_org_id NUMBER;
3046:
3047: l_org_contract_rep WF_USERS.NAME%TYPE;
3048: l_customer_user WF_USERS.NAME%TYPE;
3049:
3050: l_quote_number Number;
3051:
3052: l_msite_id Number := null;

Line 3408: l_cust_email_addr WF_USERS.Email_Address%TYPE;

3404: x_msg_count OUT NOCOPY NUMBER,
3405: x_msg_data OUT NOCOPY VARCHAR2
3406: ) IS
3407:
3408: l_cust_email_addr WF_USERS.Email_Address%TYPE;
3409: l_cust_event_type VARCHAR(20);
3410: l_cust_adhoc_user WF_USERS.NAME%TYPE;
3411: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3412: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;

Line 3410: l_cust_adhoc_user WF_USERS.NAME%TYPE;

3406: ) IS
3407:
3408: l_cust_email_addr WF_USERS.Email_Address%TYPE;
3409: l_cust_event_type VARCHAR(20);
3410: l_cust_adhoc_user WF_USERS.NAME%TYPE;
3411: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3412: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;
3413: l_sales_email_addr WF_USERS.email_address%TYPE;
3414: l_sales_event_type VARCHAR(20);

Line 3411: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

3407:
3408: l_cust_email_addr WF_USERS.Email_Address%TYPE;
3409: l_cust_event_type VARCHAR(20);
3410: l_cust_adhoc_user WF_USERS.NAME%TYPE;
3411: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3412: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;
3413: l_sales_email_addr WF_USERS.email_address%TYPE;
3414: l_sales_event_type VARCHAR(20);
3415: l_sales_adhoc_user WF_USERS.NAME%TYPE;

Line 3413: l_sales_email_addr WF_USERS.email_address%TYPE;

3409: l_cust_event_type VARCHAR(20);
3410: l_cust_adhoc_user WF_USERS.NAME%TYPE;
3411: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3412: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;
3413: l_sales_email_addr WF_USERS.email_address%TYPE;
3414: l_sales_event_type VARCHAR(20);
3415: l_sales_adhoc_user WF_USERS.NAME%TYPE;
3416: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3417: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;

Line 3415: l_sales_adhoc_user WF_USERS.NAME%TYPE;

3411: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3412: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;
3413: l_sales_email_addr WF_USERS.email_address%TYPE;
3414: l_sales_event_type VARCHAR(20);
3415: l_sales_adhoc_user WF_USERS.NAME%TYPE;
3416: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3417: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;
3418: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3419: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

Line 3416: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

3412: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;
3413: l_sales_email_addr WF_USERS.email_address%TYPE;
3414: l_sales_event_type VARCHAR(20);
3415: l_sales_adhoc_user WF_USERS.NAME%TYPE;
3416: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3417: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;
3418: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3419: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
3420:

Line 3418: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

3414: l_sales_event_type VARCHAR(20);
3415: l_sales_adhoc_user WF_USERS.NAME%TYPE;
3416: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3417: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;
3418: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3419: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
3420:
3421: l_quote_org_id NUMBER;
3422: l_org_contract_rep WF_USERS.NAME%TYPE;

Line 3419: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

3415: l_sales_adhoc_user WF_USERS.NAME%TYPE;
3416: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3417: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;
3418: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3419: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
3420:
3421: l_quote_org_id NUMBER;
3422: l_org_contract_rep WF_USERS.NAME%TYPE;
3423:

Line 3422: l_org_contract_rep WF_USERS.NAME%TYPE;

3418: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3419: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
3420:
3421: l_quote_org_id NUMBER;
3422: l_org_contract_rep WF_USERS.NAME%TYPE;
3423:
3424: l_role_users Varchar2(200);
3425: l_sales_adhoc_role WF_ROLES.NAME%TYPE;
3426: l_sales_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;

Line 3831: l_cust_adhoc_user WF_USERS.NAME%TYPE;

3827: ) IS
3828:
3829: l_cust_email_addr hz_contact_points.email_address%TYPE;
3830: l_cust_event_type VARCHAR(20);
3831: l_cust_adhoc_user WF_USERS.NAME%TYPE;
3832: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3833: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;
3834: l_sales_email_addr WF_USERS.email_address%TYPE;
3835: l_sales_event_type VARCHAR(20);

Line 3832: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

3828:
3829: l_cust_email_addr hz_contact_points.email_address%TYPE;
3830: l_cust_event_type VARCHAR(20);
3831: l_cust_adhoc_user WF_USERS.NAME%TYPE;
3832: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3833: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;
3834: l_sales_email_addr WF_USERS.email_address%TYPE;
3835: l_sales_event_type VARCHAR(20);
3836:

Line 3834: l_sales_email_addr WF_USERS.email_address%TYPE;

3830: l_cust_event_type VARCHAR(20);
3831: l_cust_adhoc_user WF_USERS.NAME%TYPE;
3832: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3833: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;
3834: l_sales_email_addr WF_USERS.email_address%TYPE;
3835: l_sales_event_type VARCHAR(20);
3836:
3837: l_role_users Varchar2(200);
3838: l_sales_adhoc_role WF_ROLES.NAME%TYPE;

Line 3841: l_sales_adhoc_user WF_USERS.NAME%TYPE;

3837: l_role_users Varchar2(200);
3838: l_sales_adhoc_role WF_ROLES.NAME%TYPE;
3839: l_sales_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
3840:
3841: l_sales_adhoc_user WF_USERS.NAME%TYPE;
3842: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3843:
3844: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;
3845: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

Line 3842: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

3838: l_sales_adhoc_role WF_ROLES.NAME%TYPE;
3839: l_sales_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
3840:
3841: l_sales_adhoc_user WF_USERS.NAME%TYPE;
3842: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3843:
3844: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;
3845: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3846:

Line 3845: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

3841: l_sales_adhoc_user WF_USERS.NAME%TYPE;
3842: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3843:
3844: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;
3845: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3846:
3847: l_Notification WF_USERS.Notification_Preference%TYPE;
3848: l_Lang WF_USERS.Language%TYPE;
3849: l_Territory WF_USERS.Territory%TYPE;

Line 3847: l_Notification WF_USERS.Notification_Preference%TYPE;

3843:
3844: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;
3845: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3846:
3847: l_Notification WF_USERS.Notification_Preference%TYPE;
3848: l_Lang WF_USERS.Language%TYPE;
3849: l_Territory WF_USERS.Territory%TYPE;
3850: l_email_addr WF_USERS.email_address%TYPE;
3851: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

Line 3848: l_Lang WF_USERS.Language%TYPE;

3844: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;
3845: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3846:
3847: l_Notification WF_USERS.Notification_Preference%TYPE;
3848: l_Lang WF_USERS.Language%TYPE;
3849: l_Territory WF_USERS.Territory%TYPE;
3850: l_email_addr WF_USERS.email_address%TYPE;
3851: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
3852:

Line 3849: l_Territory WF_USERS.Territory%TYPE;

3845: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3846:
3847: l_Notification WF_USERS.Notification_Preference%TYPE;
3848: l_Lang WF_USERS.Language%TYPE;
3849: l_Territory WF_USERS.Territory%TYPE;
3850: l_email_addr WF_USERS.email_address%TYPE;
3851: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
3852:
3853: l_order_id NUMBER;

Line 3850: l_email_addr WF_USERS.email_address%TYPE;

3846:
3847: l_Notification WF_USERS.Notification_Preference%TYPE;
3848: l_Lang WF_USERS.Language%TYPE;
3849: l_Territory WF_USERS.Territory%TYPE;
3850: l_email_addr WF_USERS.email_address%TYPE;
3851: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
3852:
3853: l_order_id NUMBER;
3854: l_sales_rep WF_USERS.NAME%TYPE;

Line 3851: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

3847: l_Notification WF_USERS.Notification_Preference%TYPE;
3848: l_Lang WF_USERS.Language%TYPE;
3849: l_Territory WF_USERS.Territory%TYPE;
3850: l_email_addr WF_USERS.email_address%TYPE;
3851: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
3852:
3853: l_order_id NUMBER;
3854: l_sales_rep WF_USERS.NAME%TYPE;
3855:

Line 3854: l_sales_rep WF_USERS.NAME%TYPE;

3850: l_email_addr WF_USERS.email_address%TYPE;
3851: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
3852:
3853: l_order_id NUMBER;
3854: l_sales_rep WF_USERS.NAME%TYPE;
3855:
3856: l_partyId Number;
3857: l_orgid Number := null;
3858: l_notifEnabled Varchar2(3) := 'Y';

Line 4642: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

4638: l_msgEnabled VARCHAR2(3);
4639: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
4640: x_partyid HZ_PARTIES.PARTY_ID%TYPE;
4641: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4642: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4643: l_user_name WF_USERS.NAME%TYPE;
4644: l_usertype Varchar2(30) := FND_API.G_MISS_CHAR;
4645: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
4646: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

Line 4643: l_user_name WF_USERS.NAME%TYPE;

4639: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
4640: x_partyid HZ_PARTIES.PARTY_ID%TYPE;
4641: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4642: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4643: l_user_name WF_USERS.NAME%TYPE;
4644: l_usertype Varchar2(30) := FND_API.G_MISS_CHAR;
4645: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
4646: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4647: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;

Line 4645: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

4641: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4642: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4643: l_user_name WF_USERS.NAME%TYPE;
4644: l_usertype Varchar2(30) := FND_API.G_MISS_CHAR;
4645: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
4646: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4647: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;
4648: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;
4649: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;

Line 4843: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

4839: l_messageName WF_MESSAGES.NAME%TYPE;
4840: l_msgEnabled VARCHAR2(3);
4841: l_usertype Varchar2(30) := 'ALL' ;
4842: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4843: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4844: l_user_name WF_USERS.NAME%TYPE;
4845: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
4846: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4847: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

Line 4844: l_user_name WF_USERS.NAME%TYPE;

4840: l_msgEnabled VARCHAR2(3);
4841: l_usertype Varchar2(30) := 'ALL' ;
4842: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4843: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4844: l_user_name WF_USERS.NAME%TYPE;
4845: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
4846: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4847: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4848: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;

Line 4845: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;

4841: l_usertype Varchar2(30) := 'ALL' ;
4842: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4843: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4844: l_user_name WF_USERS.NAME%TYPE;
4845: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
4846: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4847: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4848: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4849:

Line 4864: l_adhoc_user WF_USERS.NAME%TYPE;

4860:
4861: l_role_users Varchar2(200);
4862: l_adhoc_role WF_ROLES.NAME%TYPE;
4863: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
4864: l_adhoc_user WF_USERS.NAME%TYPE;
4865: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
4866: l_create_adhoc_flag VARCHAR2(1);
4867: l_context_code VARCHAR2(2000);
4868:

Line 4865: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

4861: l_role_users Varchar2(200);
4862: l_adhoc_role WF_ROLES.NAME%TYPE;
4863: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
4864: l_adhoc_user WF_USERS.NAME%TYPE;
4865: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
4866: l_create_adhoc_flag VARCHAR2(1);
4867: l_context_code VARCHAR2(2000);
4868:
4869:

Line 5078: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

5074: l_messageName WF_MESSAGES.NAME%TYPE;
5075: l_msgEnabled VARCHAR2(3);
5076: l_usertype Varchar2(30) := 'ALL' ;
5077: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
5078: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5079: l_user_name WF_USERS.NAME%TYPE;
5080: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5081: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5082: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

Line 5079: l_user_name WF_USERS.NAME%TYPE;

5075: l_msgEnabled VARCHAR2(3);
5076: l_usertype Varchar2(30) := 'ALL' ;
5077: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
5078: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5079: l_user_name WF_USERS.NAME%TYPE;
5080: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5081: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5082: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5083: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;

Line 5080: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;

5076: l_usertype Varchar2(30) := 'ALL' ;
5077: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
5078: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5079: l_user_name WF_USERS.NAME%TYPE;
5080: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5081: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5082: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5083: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
5084:

Line 5098: l_adhoc_user WF_USERS.NAME%TYPE;

5094:
5095: l_role_users Varchar2(400);
5096: l_adhoc_role WF_ROLES.NAME%TYPE;
5097: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
5098: l_adhoc_user WF_USERS.NAME%TYPE;
5099: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
5100: l_create_adhoc_flag VARCHAR2(1);
5101:
5102: l_temp_retrieve_str VARCHAR2(1000);

Line 5099: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

5095: l_role_users Varchar2(400);
5096: l_adhoc_role WF_ROLES.NAME%TYPE;
5097: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
5098: l_adhoc_user WF_USERS.NAME%TYPE;
5099: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
5100: l_create_adhoc_flag VARCHAR2(1);
5101:
5102: l_temp_retrieve_str VARCHAR2(1000);
5103: l_temp_update_str VARCHAR2(1000);

Line 5332: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

5328: l_messageName WF_MESSAGES.NAME%TYPE;
5329: l_msgEnabled VARCHAR2(3);
5330: l_usertype Varchar2(30) := 'ALL' ;
5331: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
5332: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5333: l_user_name WF_USERS.NAME%TYPE;
5334: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5335: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5336: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

Line 5333: l_user_name WF_USERS.NAME%TYPE;

5329: l_msgEnabled VARCHAR2(3);
5330: l_usertype Varchar2(30) := 'ALL' ;
5331: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
5332: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5333: l_user_name WF_USERS.NAME%TYPE;
5334: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5335: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5336: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5337: l_is_it_quote varchar2(1) := FND_API.G_FALSE;

Line 5334: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;

5330: l_usertype Varchar2(30) := 'ALL' ;
5331: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
5332: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5333: l_user_name WF_USERS.NAME%TYPE;
5334: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5335: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5336: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5337: l_is_it_quote varchar2(1) := FND_API.G_FALSE;
5338:

Line 5354: l_adhoc_user WF_USERS.NAME%TYPE;

5350:
5351: l_role_users Varchar2(400);
5352: l_adhoc_role WF_ROLES.NAME%TYPE;
5353: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
5354: l_adhoc_user WF_USERS.NAME%TYPE;
5355: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
5356: l_create_adhoc_flag VARCHAR2(1);
5357: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE;
5358: l_temp_update_str VARCHAR2(1000);

Line 5355: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

5351: l_role_users Varchar2(400);
5352: l_adhoc_role WF_ROLES.NAME%TYPE;
5353: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
5354: l_adhoc_user WF_USERS.NAME%TYPE;
5355: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
5356: l_create_adhoc_flag VARCHAR2(1);
5357: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE;
5358: l_temp_update_str VARCHAR2(1000);
5359: l_url VARCHAR2(2000);

Line 5573: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

5569:
5570: rec_get_email c_get_email%rowtype;
5571: rec_quote_name c_quote_name%rowtype;
5572:
5573: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5574: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
5575: l_event_type VARCHAR2(100) := 'VIEWSHAREDCART';
5576:
5577: l_sent_by_first_name VARCHAR2(1000);

Line 5596: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

5592: l_email_address VARCHAR2(2000);
5593: l_notif_Enabled VARCHAR2(1);
5594:
5595: l_notif_name VARCHAR2(1000) := 'IBE_VIEWSHAREDCART';
5596: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
5597: BEGIN
5598: x_return_status := FND_API.g_ret_sts_success ;
5599: IBE_UTIL.DEBUG('Notify_view_shared_cart: START');
5600:

Line 5906: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

5902: l_messageName WF_MESSAGES.NAME%TYPE;
5903: l_msgEnabled VARCHAR2(3) :='Y';
5904: l_partyid Number;
5905: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
5906: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5907: l_user_name WF_USERS.NAME%TYPE;
5908: l_role_users Varchar2(200);
5909: l_adhoc_role WF_ROLES.NAME%TYPE;
5910: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;

Line 5907: l_user_name WF_USERS.NAME%TYPE;

5903: l_msgEnabled VARCHAR2(3) :='Y';
5904: l_partyid Number;
5905: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
5906: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5907: l_user_name WF_USERS.NAME%TYPE;
5908: l_role_users Varchar2(200);
5909: l_adhoc_role WF_ROLES.NAME%TYPE;
5910: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
5911: l_adhoc_user WF_USERS.NAME%TYPE;

Line 5911: l_adhoc_user WF_USERS.NAME%TYPE;

5907: l_user_name WF_USERS.NAME%TYPE;
5908: l_role_users Varchar2(200);
5909: l_adhoc_role WF_ROLES.NAME%TYPE;
5910: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
5911: l_adhoc_user WF_USERS.NAME%TYPE;
5912: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
5913: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
5914: l_quote_name Varchar2(50);
5915: l_quote_Num Number;

Line 5912: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

5908: l_role_users Varchar2(200);
5909: l_adhoc_role WF_ROLES.NAME%TYPE;
5910: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
5911: l_adhoc_user WF_USERS.NAME%TYPE;
5912: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
5913: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
5914: l_quote_name Varchar2(50);
5915: l_quote_Num Number;
5916: l_quote_ver Number;

Line 5913: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

5909: l_adhoc_role WF_ROLES.NAME%TYPE;
5910: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
5911: l_adhoc_user WF_USERS.NAME%TYPE;
5912: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
5913: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
5914: l_quote_name Varchar2(50);
5915: l_quote_Num Number;
5916: l_quote_ver Number;
5917: l_quote_password Varchar2(240);

Line 9821: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

9817: l_sess_lang VARCHAR2(40);
9818: l_sess_terr VARCHAR2(40);
9819: l_adhoc_user VARCHAR2(4000);
9820: l_adhoc_user_display VARCHAR2(4000);
9821: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
9822: l_notif_pref WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
9823: l_email_addr VARCHAR2(2000);
9824:
9825: BEGIN

Line 9822: l_notif_pref WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

9818: l_sess_terr VARCHAR2(40);
9819: l_adhoc_user VARCHAR2(4000);
9820: l_adhoc_user_display VARCHAR2(4000);
9821: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
9822: l_notif_pref WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
9823: l_email_addr VARCHAR2(2000);
9824:
9825: BEGIN
9826: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 9846: FROM wf_users

9842: --first get the preferred language for this workflow user
9843: BEGIN
9844: SELECT DISTINCT language, territory, notification_preference, email_address
9845: INTO l_lang_pref, l_terr_pref, l_notif_pref, l_email_addr
9846: FROM wf_users
9847: WHERE name = l_wf_user;
9848: EXCEPTION
9849: WHEN OTHERS THEN
9850: --exception while retrieving the language/territory prefs

Line 9937: p_wf_users_tbl IN JTF_VARCHAR2_TABLE_100,

9933: END get_wf_user;
9934:
9935:
9936: PROCEDURE get_wf_role (
9937: p_wf_users_tbl IN JTF_VARCHAR2_TABLE_100,
9938: p_quote_header_id IN NUMBER,
9939: x_wf_role OUT NOCOPY VARCHAR2
9940: ) IS
9941: --any local variables go here

Line 9948: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

9944: l_adhoc_role VARCHAR2(4000);
9945: l_adhoc_role_display VARCHAR2(4000);
9946: l_sess_lang varchar2(40);
9947: l_sess_terr varchar2(40);
9948: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
9949:
9950: BEGIN
9951:
9952: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 9955: IF (p_wf_users_tbl IS NULL OR p_wf_users_tbl.COUNT <= 0) THEN

9951:
9952: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9953: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:Start');
9954: END IF;
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);

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

Line 9972: FOR i IN 1..p_wf_users_tbl.COUNT LOOP

9968: INTO l_sess_terr
9969: FROM nls_session_parameters
9970: WHERE parameter = 'NLS_TERRITORY';
9971:
9972: FOR i IN 1..p_wf_users_tbl.COUNT LOOP
9973: l_wf_role_usrs := l_wf_role_usrs ||','|| p_wf_users_tbl(i);
9974: END LOOP;
9975: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9976: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:l_wf_role_usrs='||l_wf_role_usrs);

Line 9973: l_wf_role_usrs := l_wf_role_usrs ||','|| p_wf_users_tbl(i);

9969: FROM nls_session_parameters
9970: WHERE parameter = 'NLS_TERRITORY';
9971:
9972: FOR i IN 1..p_wf_users_tbl.COUNT LOOP
9973: l_wf_role_usrs := l_wf_role_usrs ||','|| p_wf_users_tbl(i);
9974: END LOOP;
9975: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
9976: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:l_wf_role_usrs='||l_wf_role_usrs);
9977: END IF;