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 594: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

590: ,p_context_msg IN VARCHAR2 :=FND_API.G_MISS_CHAR
591: ,p_notes IN VARCHAR2 :=FND_API.G_MISS_CHAR
592: ,p_notif_context IN VARCHAR2 ) is
593:
594: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
595: l_temp_retrieve_str Varchar2(2000);
596: L_temp_update_str Varchar2(2000);
597:
598:

Line 996: l_adhoc_user WF_USERS.NAME%TYPE;

992: g_ItemType Varchar2(10) := 'IBEALERT';
993: g_processName Varchar2(30) := 'PROCESSMAP';
994:
995:
996: l_adhoc_user WF_USERS.NAME%TYPE;
997: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
998: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
999:
1000: l_partyId Number;

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

994:
995:
996: l_adhoc_user WF_USERS.NAME%TYPE;
997: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
998: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
999:
1000: l_partyId Number;
1001:
1002: l_notifEnabled Varchar2(3) := 'Y';

Line 1334: l_adhoc_user WF_USERS.NAME%TYPE;

1330: x_return_status OUT NOCOPY VARCHAR2,
1331: x_msg_count OUT NOCOPY NUMBER,
1332: x_msg_data OUT NOCOPY VARCHAR2
1333: ) IS
1334: l_adhoc_user WF_USERS.NAME%TYPE;
1335: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
1336: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
1337: l_partyId Number;
1338: l_notifEnabled Varchar2(3) := 'Y';

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

1332: x_msg_data OUT NOCOPY VARCHAR2
1333: ) IS
1334: l_adhoc_user WF_USERS.NAME%TYPE;
1335: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
1336: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
1337: l_partyId Number;
1338: l_notifEnabled Varchar2(3) := 'Y';
1339: l_notifName Varchar2(30) := 'ACCTREGNOTIFICATION';
1340: l_OrgId Number := null;

Line 1639: l_adhoc_user WF_USERS.NAME%TYPE;

1635: x_msg_count OUT NOCOPY NUMBER,
1636: x_msg_data OUT NOCOPY VARCHAR2
1637: ) IS
1638:
1639: l_adhoc_user WF_USERS.NAME%TYPE;
1640: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
1641: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
1642:
1643: l_partyId Number;

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

1637: ) IS
1638:
1639: l_adhoc_user WF_USERS.NAME%TYPE;
1640: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
1641: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
1642:
1643: l_partyId Number;
1644:
1645: l_event_type Varchar2(30) := 'FORGETLOGIN';

Line 1855: l_adhoc_user WF_USERS.NAME%TYPE;

1851: x_msg_count OUT NOCOPY NUMBER,
1852: x_msg_data OUT NOCOPY VARCHAR2
1853: ) IS
1854:
1855: l_adhoc_user WF_USERS.NAME%TYPE;
1856: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
1857: l_event_type VARCHAR2(20);
1858: l_email_addr WF_USERS.Email_Address%TYPE;
1859: l_this NUMBER;

Line 1858: l_email_addr WF_USERS.Email_Address%TYPE;

1854:
1855: l_adhoc_user WF_USERS.NAME%TYPE;
1856: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
1857: l_event_type VARCHAR2(20);
1858: l_email_addr WF_USERS.Email_Address%TYPE;
1859: l_this NUMBER;
1860: l_temp_str VARCHAR2(2000);
1861: l_next NUMBER;
1862: l_errmsg_count NUMBER;

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

1862: l_errmsg_count NUMBER;
1863: l_errmsg_data VARCHAR2(32000);
1864: l_party_id NUMBER;
1865: lx_party_id NUMBER;
1866: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
1867: l_order_id NUMBER;
1868: l_partyId Number;
1869: l_first_name VARCHAR2(2000);
1870: l_last_name VARCHAR2(2000);

Line 1888: l_admin_email_addr WF_USERS.email_address%TYPE;

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;
1892: l_role_users Varchar2(200);

Line 1889: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

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;
1892: l_role_users Varchar2(200);
1893: l_card_number Varchar2(50);--bug 6877589 ukalaiah

Line 1890: l_admin_adhoc_user WF_USERS.NAME%TYPE;

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;
1892: l_role_users Varchar2(200);
1893: l_card_number Varchar2(50);--bug 6877589 ukalaiah
1894:

Line 1891: l_admin_adhoc_user_display WF_USERS.DISPLAY_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;
1892: l_role_users Varchar2(200);
1893: l_card_number Varchar2(50);--bug 6877589 ukalaiah
1894:
1895:

Line 2511: l_user_name WF_USERS.NAME%TYPE;

2507: x_msg_data OUT NOCOPY VARCHAR2
2508: ) IS
2509:
2510:
2511: l_user_name WF_USERS.NAME%TYPE;
2512: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
2513: l_event_type VARCHAR2(20);
2514: l_party_id NUMBER;
2515: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

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

2511: l_user_name WF_USERS.NAME%TYPE;
2512: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
2513: l_event_type VARCHAR2(20);
2514: l_party_id NUMBER;
2515: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
2516: l_order_header_id NUMBER;
2517: l_permission_to_view_price BOOLEAN;
2518: l_view_net_price_flag VARCHAR2(1);
2519: x_recepient_party_id NUMBER;

Line 2912: l_cust_adhoc_user WF_USERS.NAME%TYPE;

2908: x_msg_count OUT NOCOPY NUMBER,
2909: x_msg_data OUT NOCOPY VARCHAR2
2910: ) is
2911:
2912: l_cust_adhoc_user WF_USERS.NAME%TYPE;
2913: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
2914: l_event_type VARCHAR2(20) := 'CNCLORDR';
2915: l_errmsg_count NUMBER;
2916: l_errmsg_data VARCHAR2(32000);

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

2916: l_errmsg_data VARCHAR2(32000);
2917: l_party_id NUMBER;
2918: l_contact_party_id NUMBER;
2919: l_msite_name VARCHAR2(2000);
2920: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
2921: l_order_id NUMBER;
2922: l_quote_id NUMBER;
2923: l_order_num NUMBER;
2924: l_contact_first_name VARCHAR2(2000);

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

3134: ) IS
3135:
3136: l_event_type VARCHAR(20);
3137: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
3138: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3139:
3140: l_quote_org_id NUMBER;
3141:
3142: l_org_contract_rep WF_USERS.NAME%TYPE;

Line 3142: l_org_contract_rep WF_USERS.NAME%TYPE;

3138: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3139:
3140: l_quote_org_id NUMBER;
3141:
3142: l_org_contract_rep WF_USERS.NAME%TYPE;
3143: l_customer_user WF_USERS.NAME%TYPE;
3144:
3145: l_quote_number Number;
3146:

Line 3143: l_customer_user WF_USERS.NAME%TYPE;

3139:
3140: l_quote_org_id NUMBER;
3141:
3142: l_org_contract_rep WF_USERS.NAME%TYPE;
3143: l_customer_user WF_USERS.NAME%TYPE;
3144:
3145: l_quote_number Number;
3146:
3147: l_msite_id Number := null;

Line 3503: l_cust_email_addr WF_USERS.Email_Address%TYPE;

3499: x_msg_count OUT NOCOPY NUMBER,
3500: x_msg_data OUT NOCOPY VARCHAR2
3501: ) IS
3502:
3503: l_cust_email_addr WF_USERS.Email_Address%TYPE;
3504: l_cust_event_type VARCHAR(20);
3505: l_cust_adhoc_user WF_USERS.NAME%TYPE;
3506: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3507: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;

Line 3505: l_cust_adhoc_user WF_USERS.NAME%TYPE;

3501: ) IS
3502:
3503: l_cust_email_addr WF_USERS.Email_Address%TYPE;
3504: l_cust_event_type VARCHAR(20);
3505: l_cust_adhoc_user WF_USERS.NAME%TYPE;
3506: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3507: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;
3508: l_sales_email_addr WF_USERS.email_address%TYPE;
3509: l_sales_event_type VARCHAR(20);

Line 3506: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

3502:
3503: l_cust_email_addr WF_USERS.Email_Address%TYPE;
3504: l_cust_event_type VARCHAR(20);
3505: l_cust_adhoc_user WF_USERS.NAME%TYPE;
3506: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3507: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;
3508: l_sales_email_addr WF_USERS.email_address%TYPE;
3509: l_sales_event_type VARCHAR(20);
3510: l_sales_adhoc_user WF_USERS.NAME%TYPE;

Line 3508: l_sales_email_addr WF_USERS.email_address%TYPE;

3504: l_cust_event_type VARCHAR(20);
3505: l_cust_adhoc_user WF_USERS.NAME%TYPE;
3506: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3507: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;
3508: l_sales_email_addr WF_USERS.email_address%TYPE;
3509: l_sales_event_type VARCHAR(20);
3510: l_sales_adhoc_user WF_USERS.NAME%TYPE;
3511: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3512: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;

Line 3510: l_sales_adhoc_user WF_USERS.NAME%TYPE;

3506: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3507: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;
3508: l_sales_email_addr WF_USERS.email_address%TYPE;
3509: l_sales_event_type VARCHAR(20);
3510: l_sales_adhoc_user WF_USERS.NAME%TYPE;
3511: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3512: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;
3513: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3514: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

Line 3511: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

3507: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;
3508: l_sales_email_addr WF_USERS.email_address%TYPE;
3509: l_sales_event_type VARCHAR(20);
3510: l_sales_adhoc_user WF_USERS.NAME%TYPE;
3511: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3512: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;
3513: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3514: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
3515:

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

3509: l_sales_event_type VARCHAR(20);
3510: l_sales_adhoc_user WF_USERS.NAME%TYPE;
3511: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3512: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;
3513: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3514: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
3515:
3516: l_quote_org_id NUMBER;
3517: l_org_contract_rep WF_USERS.NAME%TYPE;

Line 3514: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

3510: l_sales_adhoc_user WF_USERS.NAME%TYPE;
3511: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3512: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;
3513: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3514: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
3515:
3516: l_quote_org_id NUMBER;
3517: l_org_contract_rep WF_USERS.NAME%TYPE;
3518:

Line 3517: l_org_contract_rep WF_USERS.NAME%TYPE;

3513: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3514: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
3515:
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;

Line 3926: l_cust_adhoc_user WF_USERS.NAME%TYPE;

3922: ) IS
3923:
3924: l_cust_email_addr hz_contact_points.email_address%TYPE;
3925: l_cust_event_type VARCHAR(20);
3926: l_cust_adhoc_user WF_USERS.NAME%TYPE;
3927: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3928: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;
3929: l_sales_email_addr WF_USERS.email_address%TYPE;
3930: l_sales_event_type VARCHAR(20);

Line 3927: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

3923:
3924: l_cust_email_addr hz_contact_points.email_address%TYPE;
3925: l_cust_event_type VARCHAR(20);
3926: l_cust_adhoc_user WF_USERS.NAME%TYPE;
3927: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3928: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;
3929: l_sales_email_addr WF_USERS.email_address%TYPE;
3930: l_sales_event_type VARCHAR(20);
3931:

Line 3929: l_sales_email_addr WF_USERS.email_address%TYPE;

3925: l_cust_event_type VARCHAR(20);
3926: l_cust_adhoc_user WF_USERS.NAME%TYPE;
3927: l_cust_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3928: l_cust_item_key WF_ITEMS.ITEM_KEY%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;

Line 3936: l_sales_adhoc_user WF_USERS.NAME%TYPE;

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:
3939: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;
3940: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

Line 3937: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

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:
3939: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;
3940: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3941:

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

3936: l_sales_adhoc_user WF_USERS.NAME%TYPE;
3937: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;
3938:
3939: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;
3940: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3941:
3942: l_Notification WF_USERS.Notification_Preference%TYPE;
3943: l_Lang WF_USERS.Language%TYPE;
3944: l_Territory WF_USERS.Territory%TYPE;

Line 3942: l_Notification WF_USERS.Notification_Preference%TYPE;

3938:
3939: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;
3940: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3941:
3942: l_Notification WF_USERS.Notification_Preference%TYPE;
3943: l_Lang WF_USERS.Language%TYPE;
3944: l_Territory WF_USERS.Territory%TYPE;
3945: l_email_addr WF_USERS.email_address%TYPE;
3946: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

Line 3943: l_Lang WF_USERS.Language%TYPE;

3939: l_sales_item_key WF_ITEMS.ITEM_KEY%TYPE;
3940: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3941:
3942: l_Notification WF_USERS.Notification_Preference%TYPE;
3943: l_Lang WF_USERS.Language%TYPE;
3944: l_Territory WF_USERS.Territory%TYPE;
3945: l_email_addr WF_USERS.email_address%TYPE;
3946: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
3947:

Line 3944: l_Territory WF_USERS.Territory%TYPE;

3940: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
3941:
3942: l_Notification WF_USERS.Notification_Preference%TYPE;
3943: l_Lang WF_USERS.Language%TYPE;
3944: l_Territory WF_USERS.Territory%TYPE;
3945: l_email_addr WF_USERS.email_address%TYPE;
3946: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
3947:
3948: l_order_id NUMBER;

Line 3945: l_email_addr WF_USERS.email_address%TYPE;

3941:
3942: l_Notification WF_USERS.Notification_Preference%TYPE;
3943: l_Lang WF_USERS.Language%TYPE;
3944: l_Territory WF_USERS.Territory%TYPE;
3945: l_email_addr WF_USERS.email_address%TYPE;
3946: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
3947:
3948: l_order_id NUMBER;
3949: l_sales_rep WF_USERS.NAME%TYPE;

Line 3946: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

3942: l_Notification WF_USERS.Notification_Preference%TYPE;
3943: l_Lang WF_USERS.Language%TYPE;
3944: l_Territory WF_USERS.Territory%TYPE;
3945: l_email_addr WF_USERS.email_address%TYPE;
3946: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
3947:
3948: l_order_id NUMBER;
3949: l_sales_rep WF_USERS.NAME%TYPE;
3950:

Line 3949: l_sales_rep WF_USERS.NAME%TYPE;

3945: l_email_addr WF_USERS.email_address%TYPE;
3946: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
3947:
3948: l_order_id NUMBER;
3949: l_sales_rep WF_USERS.NAME%TYPE;
3950:
3951: l_partyId Number;
3952: l_orgid Number := null;
3953: l_notifEnabled Varchar2(3) := 'Y';

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

4733: l_msgEnabled VARCHAR2(3);
4734: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
4735: x_partyid HZ_PARTIES.PARTY_ID%TYPE;
4736: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4737: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4738: l_user_name WF_USERS.NAME%TYPE;
4739: l_usertype jtf_um_usertypes_b.usertype_key%type := FND_API.G_MISS_CHAR;
4740: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
4741: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

Line 4738: l_user_name WF_USERS.NAME%TYPE;

4734: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
4735: x_partyid HZ_PARTIES.PARTY_ID%TYPE;
4736: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4737: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4738: l_user_name WF_USERS.NAME%TYPE;
4739: l_usertype jtf_um_usertypes_b.usertype_key%type := FND_API.G_MISS_CHAR;
4740: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
4741: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4742: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;

Line 4740: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

4736: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4737: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4738: l_user_name WF_USERS.NAME%TYPE;
4739: l_usertype jtf_um_usertypes_b.usertype_key%type := FND_API.G_MISS_CHAR;
4740: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
4741: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4742: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;
4743: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;
4744: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;

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

4934: l_messageName WF_MESSAGES.NAME%TYPE;
4935: l_msgEnabled VARCHAR2(3);
4936: l_usertype jtf_um_usertypes_b.usertype_key%type := 'ALL' ;
4937: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4938: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4939: l_user_name WF_USERS.NAME%TYPE;
4940: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
4941: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4942: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

Line 4939: l_user_name WF_USERS.NAME%TYPE;

4935: l_msgEnabled VARCHAR2(3);
4936: l_usertype jtf_um_usertypes_b.usertype_key%type := 'ALL' ;
4937: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4938: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4939: l_user_name WF_USERS.NAME%TYPE;
4940: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
4941: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4942: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4943: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;

Line 4940: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;

4936: l_usertype jtf_um_usertypes_b.usertype_key%type := 'ALL' ;
4937: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4938: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4939: l_user_name WF_USERS.NAME%TYPE;
4940: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
4941: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4942: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4943: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4944:

Line 4959: l_adhoc_user WF_USERS.NAME%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);
4963:

Line 4960: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

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);
4963:
4964:

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

5169: l_messageName WF_MESSAGES.NAME%TYPE;
5170: l_msgEnabled VARCHAR2(3);
5171: l_usertype jtf_um_usertypes_b.usertype_key%type := 'ALL' ;
5172: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
5173: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5174: l_user_name WF_USERS.NAME%TYPE;
5175: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5176: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5177: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

Line 5174: l_user_name WF_USERS.NAME%TYPE;

5170: l_msgEnabled VARCHAR2(3);
5171: l_usertype jtf_um_usertypes_b.usertype_key%type := 'ALL' ;
5172: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
5173: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5174: l_user_name WF_USERS.NAME%TYPE;
5175: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5176: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5177: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5178: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;

Line 5175: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;

5171: l_usertype jtf_um_usertypes_b.usertype_key%type := 'ALL' ;
5172: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
5173: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5174: l_user_name WF_USERS.NAME%TYPE;
5175: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5176: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5177: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5178: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
5179:

Line 5193: l_adhoc_user WF_USERS.NAME%TYPE;

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:
5197: l_temp_retrieve_str VARCHAR2(1000);

Line 5194: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

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:
5197: l_temp_retrieve_str VARCHAR2(1000);
5198: l_temp_update_str VARCHAR2(1000);

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

5423: l_messageName WF_MESSAGES.NAME%TYPE;
5424: l_msgEnabled VARCHAR2(3);
5425: l_usertype jtf_um_usertypes_b.usertype_key%type := 'ALL' ;
5426: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
5427: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5428: l_user_name WF_USERS.NAME%TYPE;
5429: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5430: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5431: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

Line 5428: l_user_name WF_USERS.NAME%TYPE;

5424: l_msgEnabled VARCHAR2(3);
5425: l_usertype jtf_um_usertypes_b.usertype_key%type := 'ALL' ;
5426: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
5427: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5428: l_user_name WF_USERS.NAME%TYPE;
5429: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5430: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5431: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5432: l_is_it_quote varchar2(1) := FND_API.G_FALSE;

Line 5429: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;

5425: l_usertype jtf_um_usertypes_b.usertype_key%type := 'ALL' ;
5426: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
5427: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5428: l_user_name WF_USERS.NAME%TYPE;
5429: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5430: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5431: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5432: l_is_it_quote varchar2(1) := FND_API.G_FALSE;
5433:

Line 5449: l_adhoc_user WF_USERS.NAME%TYPE;

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;
5453: l_temp_update_str VARCHAR2(1000);

Line 5450: l_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

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;
5453: l_temp_update_str VARCHAR2(1000);
5454: l_url VARCHAR2(2000);

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

5664:
5665: rec_get_email c_get_email%rowtype;
5666: rec_quote_name c_quote_name%rowtype;
5667:
5668: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5669: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
5670: l_event_type VARCHAR2(100) := 'VIEWSHAREDCART';
5671:
5672: l_sent_by_first_name VARCHAR2(1000);

Line 5691: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

5687: l_email_address VARCHAR2(2000);
5688: l_notif_Enabled VARCHAR2(1);
5689:
5690: l_notif_name VARCHAR2(1000) := 'IBE_VIEWSHAREDCART';
5691: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
5692: BEGIN
5693: x_return_status := FND_API.g_ret_sts_success ;
5694: IBE_UTIL.DEBUG('Notify_view_shared_cart: START');
5695:

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

5997: l_messageName WF_MESSAGES.NAME%TYPE;
5998: l_msgEnabled VARCHAR2(3) :='Y';
5999: l_partyid Number;
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;

Line 6002: l_user_name WF_USERS.NAME%TYPE;

5998: l_msgEnabled VARCHAR2(3) :='Y';
5999: l_partyid Number;
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;

Line 6006: l_adhoc_user WF_USERS.NAME%TYPE;

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);
6010: l_quote_Num Number;

Line 6007: l_adhoc_user_display WF_USERS.DISPLAY_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);
6010: l_quote_Num Number;
6011: l_quote_ver Number;

Line 6008: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

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);
6010: l_quote_Num Number;
6011: l_quote_ver Number;
6012: l_quote_password Varchar2(240);

Line 9916: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

9912: l_sess_lang VARCHAR2(40);
9913: l_sess_terr VARCHAR2(40);
9914: l_adhoc_user VARCHAR2(4000);
9915: l_adhoc_user_display VARCHAR2(4000);
9916: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
9917: l_notif_pref WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
9918: l_email_addr VARCHAR2(2000);
9919:
9920: BEGIN

Line 9917: l_notif_pref WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

9913: l_sess_terr VARCHAR2(40);
9914: l_adhoc_user VARCHAR2(4000);
9915: l_adhoc_user_display VARCHAR2(4000);
9916: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
9917: l_notif_pref WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
9918: l_email_addr VARCHAR2(2000);
9919:
9920: BEGIN
9921: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 9941: FROM wf_users

9937: --first get the preferred language for this workflow user
9938: BEGIN
9939: SELECT DISTINCT language, territory, notification_preference, email_address
9940: INTO l_lang_pref, l_terr_pref, l_notif_pref, l_email_addr
9941: FROM wf_users
9942: WHERE name = l_wf_user;
9943: EXCEPTION
9944: WHEN OTHERS THEN
9945: --exception while retrieving the language/territory prefs

Line 10032: p_wf_users_tbl IN JTF_VARCHAR2_TABLE_100,

10028: END get_wf_user;
10029:
10030:
10031: PROCEDURE get_wf_role (
10032: p_wf_users_tbl IN JTF_VARCHAR2_TABLE_100,
10033: p_quote_header_id IN NUMBER,
10034: x_wf_role OUT NOCOPY VARCHAR2
10035: ) IS
10036: --any local variables go here

Line 10043: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;

10039: l_adhoc_role VARCHAR2(4000);
10040: l_adhoc_role_display VARCHAR2(4000);
10041: l_sess_lang varchar2(40);
10042: l_sess_terr varchar2(40);
10043: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
10044:
10045: BEGIN
10046:
10047: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

10046:
10047: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
10048: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:Start');
10049: END IF;
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);

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

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

10063: INTO l_sess_terr
10064: FROM nls_session_parameters
10065: WHERE parameter = 'NLS_TERRITORY';
10066:
10067: FOR i IN 1..p_wf_users_tbl.COUNT LOOP
10068: l_wf_role_usrs := l_wf_role_usrs ||','|| p_wf_users_tbl(i);
10069: END LOOP;
10070: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
10071: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:l_wf_role_usrs='||l_wf_role_usrs);

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

10064: FROM nls_session_parameters
10065: WHERE parameter = 'NLS_TERRITORY';
10066:
10067: FOR i IN 1..p_wf_users_tbl.COUNT LOOP
10068: l_wf_role_usrs := l_wf_role_usrs ||','|| p_wf_users_tbl(i);
10069: END LOOP;
10070: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
10071: IBE_UTIL.DEBUG('ibe_workflow_pvt.get_wf_role:l_wf_role_usrs='||l_wf_role_usrs);
10072: END IF;