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_ROLES

Line 347: FROM wf_roles

343:
344: cursor c_get_pref(c_user VARCHAR2) is
345: SELECT name,
346: notification_preference
347: FROM wf_roles
348: WHERE name = c_user;
349: rec_get_pref c_get_pref%rowtype;
350: l_mail_pref VARCHAR2(100);
351:

Line 1886: l_adhoc_role WF_ROLES.NAME%TYPE;

1882: l_permission_to_view_price BOOLEAN;
1883: l_view_net_price_flag VARCHAR2(1);
1884: l_paynow_flag VARCHAR2(1);
1885: l_reccharge_flag VARCHAR2(1);
1886: l_adhoc_role WF_ROLES.NAME%TYPE;
1887: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
1888: l_admin_email_addr WF_USERS.email_address%TYPE;
1889: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
1890: l_admin_adhoc_user WF_USERS.NAME%TYPE;

Line 1887: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;

1883: l_view_net_price_flag VARCHAR2(1);
1884: l_paynow_flag VARCHAR2(1);
1885: l_reccharge_flag VARCHAR2(1);
1886: l_adhoc_role WF_ROLES.NAME%TYPE;
1887: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
1888: l_admin_email_addr WF_USERS.email_address%TYPE;
1889: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
1890: l_admin_adhoc_user WF_USERS.NAME%TYPE;
1891: l_admin_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

Line 3520: l_sales_adhoc_role WF_ROLES.NAME%TYPE;

3516: l_quote_org_id NUMBER;
3517: l_org_contract_rep WF_USERS.NAME%TYPE;
3518:
3519: l_role_users Varchar2(200);
3520: l_sales_adhoc_role WF_ROLES.NAME%TYPE;
3521: l_sales_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
3522:
3523: l_quote_name Varchar2(50);
3524: l_quote_number Number;

Line 3521: l_sales_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;

3517: l_org_contract_rep WF_USERS.NAME%TYPE;
3518:
3519: l_role_users Varchar2(200);
3520: l_sales_adhoc_role WF_ROLES.NAME%TYPE;
3521: l_sales_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
3522:
3523: l_quote_name Varchar2(50);
3524: l_quote_number Number;
3525:

Line 3933: l_sales_adhoc_role WF_ROLES.NAME%TYPE;

3929: l_sales_email_addr WF_USERS.email_address%TYPE;
3930: l_sales_event_type VARCHAR(20);
3931:
3932: l_role_users Varchar2(200);
3933: l_sales_adhoc_role WF_ROLES.NAME%TYPE;
3934: l_sales_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
3935:
3936: l_sales_adhoc_user WF_USERS.NAME%TYPE;
3937: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

Line 3934: l_sales_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;

3930: l_sales_event_type VARCHAR(20);
3931:
3932: l_role_users Varchar2(200);
3933: l_sales_adhoc_role WF_ROLES.NAME%TYPE;
3934: l_sales_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
3935:
3936: l_sales_adhoc_user WF_USERS.NAME%TYPE;
3937: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3938:

Line 4957: l_adhoc_role WF_ROLES.NAME%TYPE;

4953:
4954: l_stop_working_msg_context FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
4955:
4956: l_role_users Varchar2(200);
4957: l_adhoc_role WF_ROLES.NAME%TYPE;
4958: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
4959: l_adhoc_user WF_USERS.NAME%TYPE;
4960: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
4961: l_create_adhoc_flag VARCHAR2(1);

Line 4958: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;

4954: l_stop_working_msg_context FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
4955:
4956: l_role_users Varchar2(200);
4957: l_adhoc_role WF_ROLES.NAME%TYPE;
4958: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
4959: l_adhoc_user WF_USERS.NAME%TYPE;
4960: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
4961: l_create_adhoc_flag VARCHAR2(1);
4962: l_context_code VARCHAR2(2000);

Line 5191: l_adhoc_role WF_ROLES.NAME%TYPE;

5187: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
5188: l_accesslevel VARCHAR2(60);
5189:
5190: l_role_users Varchar2(400);
5191: l_adhoc_role WF_ROLES.NAME%TYPE;
5192: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
5193: l_adhoc_user WF_USERS.NAME%TYPE;
5194: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
5195: l_create_adhoc_flag VARCHAR2(1);

Line 5192: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;

5188: l_accesslevel VARCHAR2(60);
5189:
5190: l_role_users Varchar2(400);
5191: l_adhoc_role WF_ROLES.NAME%TYPE;
5192: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
5193: l_adhoc_user WF_USERS.NAME%TYPE;
5194: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
5195: l_create_adhoc_flag VARCHAR2(1);
5196:

Line 5447: l_adhoc_role WF_ROLES.NAME%TYPE;

5443: l_new_access_level VARCHAR2(60);
5444: l_old_access_level VARCHAR2(60);
5445:
5446: l_role_users Varchar2(400);
5447: l_adhoc_role WF_ROLES.NAME%TYPE;
5448: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
5449: l_adhoc_user WF_USERS.NAME%TYPE;
5450: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
5451: l_create_adhoc_flag VARCHAR2(1);

Line 5448: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;

5444: l_old_access_level VARCHAR2(60);
5445:
5446: l_role_users Varchar2(400);
5447: l_adhoc_role WF_ROLES.NAME%TYPE;
5448: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
5449: l_adhoc_user WF_USERS.NAME%TYPE;
5450: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
5451: l_create_adhoc_flag VARCHAR2(1);
5452: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_REC_TYPE;

Line 6004: l_adhoc_role WF_ROLES.NAME%TYPE;

6000: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
6001: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
6002: l_user_name WF_USERS.NAME%TYPE;
6003: l_role_users Varchar2(200);
6004: l_adhoc_role WF_ROLES.NAME%TYPE;
6005: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
6006: l_adhoc_user WF_USERS.NAME%TYPE;
6007: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
6008: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

Line 6005: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;

6001: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
6002: l_user_name WF_USERS.NAME%TYPE;
6003: l_role_users Varchar2(200);
6004: l_adhoc_role WF_ROLES.NAME%TYPE;
6005: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;
6006: l_adhoc_user WF_USERS.NAME%TYPE;
6007: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
6008: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
6009: l_quote_name Varchar2(50);