DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on WF_ROLES

Line 337: FROM wf_roles

333:
334: cursor c_get_pref(c_user VARCHAR2) is
335: SELECT name,
336: notification_preference
337: FROM wf_roles
338: WHERE name = c_user;
339: rec_get_pref c_get_pref%rowtype;
340: l_mail_pref VARCHAR2(100);
341:

Line 1876: l_adhoc_role WF_ROLES.NAME%TYPE;

1872: l_permission_to_view_price BOOLEAN;
1873: l_view_net_price_flag VARCHAR2(1);
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;

Line 1877: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;

1873: l_view_net_price_flag VARCHAR2(1);
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;

Line 3425: l_sales_adhoc_role WF_ROLES.NAME%TYPE;

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;
3427:
3428: l_quote_name Varchar2(50);
3429: l_quote_number Number;

Line 3426: l_sales_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;

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;
3427:
3428: l_quote_name Varchar2(50);
3429: l_quote_number Number;
3430:

Line 3838: l_sales_adhoc_role WF_ROLES.NAME%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;
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;

Line 3839: l_sales_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;

3835: l_sales_event_type VARCHAR(20);
3836:
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:

Line 4862: l_adhoc_role WF_ROLES.NAME%TYPE;

4858:
4859: l_stop_working_msg_context FND_NEW_MESSAGES.MESSAGE_TEXT%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);

Line 4863: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;

4859: l_stop_working_msg_context FND_NEW_MESSAGES.MESSAGE_TEXT%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);

Line 5096: l_adhoc_role WF_ROLES.NAME%TYPE;

5092: x_recepient_party_id HZ_PARTIES.PARTY_ID%TYPE;
5093: l_accesslevel VARCHAR2(60);
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);

Line 5097: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;

5093: l_accesslevel VARCHAR2(60);
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:

Line 5352: l_adhoc_role WF_ROLES.NAME%TYPE;

5348: l_new_access_level VARCHAR2(60);
5349: l_old_access_level VARCHAR2(60);
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);

Line 5353: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%TYPE;

5349: l_old_access_level VARCHAR2(60);
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;

Line 5909: l_adhoc_role WF_ROLES.NAME%TYPE;

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;
5912: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
5913: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

Line 5910: l_adhoc_role_display WF_ROLES.DISPLAY_NAME%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;
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);