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_ITEMS

Line 997: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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;
1001:

Line 1231: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

1227: document_type IN OUT NOCOPY VARCHAR2
1228: ) is
1229: L_api_name CONSTANT VARCHAR2(30) := 'Generate_Credential_Msg';
1230: L_api_version CONSTANT NUMBER := 1.0;
1231: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
1232: -- l_uname VARCHAR2(30);
1233: l_passwd VARCHAR2(30);
1234: l_credential_line VARCHAR2(255);
1235: BEGIN

Line 1335: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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';
1339: l_notifName Varchar2(30) := 'ACCTREGNOTIFICATION';

Line 1640: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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;
1644:

Line 1856: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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;
1860: l_temp_str VARCHAR2(2000);

Line 2512: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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';
2516: l_order_header_id NUMBER;

Line 2913: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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);
2917: l_party_id NUMBER;

Line 3137: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

3133: x_msg_data OUT NOCOPY VARCHAR2
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:

Line 3507: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;

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;
3511: l_sales_adhoc_user_display WF_USERS.DISPLAY_NAME%TYPE;

Line 3512: l_sales_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:
3516: l_quote_org_id NUMBER;

Line 3928: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;

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

Line 3939: l_sales_item_key WF_ITEMS.ITEM_KEY%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:
3942: l_Notification WF_USERS.Notification_Preference%TYPE;
3943: l_Lang WF_USERS.Language%TYPE;

Line 4736: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

4732: l_messageName WF_MESSAGES.NAME%TYPE;
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;

Line 4937: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

4933: l_Orgid Number := null;
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;

Line 5172: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

5168: l_Orgid Number := null;
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;

Line 5426: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

5422: l_Orgid Number := null;
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;

Line 5669: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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);
5673: l_sent_by_last_name VARCHAR2(1000);

Line 6000: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

5996: l_UserType jtf_um_usertypes_b.usertype_key%type := 'ALL';
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;

Line 6356: l_item_type wf_items.item_type%TYPE;

6352: document IN OUT NOCOPY VARCHAR2,
6353: document_type IN OUT NOCOPY VARCHAR2
6354: )IS
6355:
6356: l_item_type wf_items.item_type%TYPE;
6357: l_item_key wf_items.item_key%TYPE;
6358: l_quote_id NUMBER;
6359: l_event_type VARCHAR2(20);
6360: l_document VARCHAR2(32000) := '';

Line 6357: l_item_key wf_items.item_key%TYPE;

6353: document_type IN OUT NOCOPY VARCHAR2
6354: )IS
6355:
6356: l_item_type wf_items.item_type%TYPE;
6357: l_item_key wf_items.item_key%TYPE;
6358: l_quote_id NUMBER;
6359: l_event_type VARCHAR2(20);
6360: l_document VARCHAR2(32000) := '';
6361: l_party_first_name hz_parties.person_first_name%TYPE;

Line 6595: l_item_type wf_items.item_type%TYPE;

6591: document IN OUT NOCOPY VARCHAR2,
6592: document_type IN OUT NOCOPY VARCHAR2
6593: )
6594: IS
6595: l_item_type wf_items.item_type%TYPE;
6596: l_item_key wf_items.item_key%TYPE;
6597: l_quote_id NUMBER;
6598: l_event_type VARCHAR2(20);
6599: l_comments VARCHAR2(2000);

Line 6596: l_item_key wf_items.item_key%TYPE;

6592: document_type IN OUT NOCOPY VARCHAR2
6593: )
6594: IS
6595: l_item_type wf_items.item_type%TYPE;
6596: l_item_key wf_items.item_key%TYPE;
6597: l_quote_id NUMBER;
6598: l_event_type VARCHAR2(20);
6599: l_comments VARCHAR2(2000);
6600: l_party_first_name hz_parties.person_first_name%TYPE;

Line 6997: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

6993: document_type IN OUT NOCOPY VARCHAR2
6994: ) IS
6995: l_document VARCHAR2(32000) := ' '||NEWLINE;
6996: l_view_net_price_flag VARCHAR2(1);
6997: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
6998: l_order_id NUMBER;
6999: l_temp_str VARCHAR2(2000):='';
7000: l_event_type VARCHAR2(20);
7001: l_quote_id NUMBER;

Line 7148: l_item_type wf_items.item_type%TYPE;

7144: p_quote_flag IN VARCHAR2,
7145: p_tax_flag IN VARCHAR2,
7146: x_document OUT NOCOPY VARCHAR2
7147: ) is
7148: l_item_type wf_items.item_type%TYPE;
7149: l_item_key wf_items.item_key%TYPE;
7150: l_quote_id NUMBER;
7151: l_event_type VARCHAR2(20);
7152: l_document VARCHAR2(32000) := '';

Line 7149: l_item_key wf_items.item_key%TYPE;

7145: p_tax_flag IN VARCHAR2,
7146: x_document OUT NOCOPY VARCHAR2
7147: ) is
7148: l_item_type wf_items.item_type%TYPE;
7149: l_item_key wf_items.item_key%TYPE;
7150: l_quote_id NUMBER;
7151: l_event_type VARCHAR2(20);
7152: l_document VARCHAR2(32000) := '';
7153: l_ship_flag VARCHAR2(1);

Line 7592: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

7588: p_tax_flag IN VARCHAR2,
7589: x_document IN OUT NOCOPY VARCHAR2
7590: )IS
7591:
7592: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
7593: l_event_type VARCHAR2(20);
7594: l_document VARCHAR2(32000) := '';
7595: l_string_in VARCHAR2(250);
7596: l_string_out VARCHAR2(250);

Line 8177: l_item_type wf_items.item_type%TYPE;

8173: document IN OUT NOCOPY VARCHAR2,
8174: document_type IN OUT NOCOPY VARCHAR2
8175: )IS
8176:
8177: l_item_type wf_items.item_type%TYPE;
8178: l_item_key wf_items.item_key%TYPE;
8179: l_quote_id NUMBER;
8180: l_event_type VARCHAR2(20);
8181: l_document VARCHAR2(32000) := '';

Line 8178: l_item_key wf_items.item_key%TYPE;

8174: document_type IN OUT NOCOPY VARCHAR2
8175: )IS
8176:
8177: l_item_type wf_items.item_type%TYPE;
8178: l_item_key wf_items.item_key%TYPE;
8179: l_quote_id NUMBER;
8180: l_event_type VARCHAR2(20);
8181: l_document VARCHAR2(32000) := '';
8182: l_ship_flag VARCHAR2(1);

Line 8336: l_item_type wf_items.item_type%TYPE;

8332: document IN OUT NOCOPY VARCHAR2,
8333: document_type IN OUT NOCOPY VARCHAR2
8334: )IS
8335:
8336: l_item_type wf_items.item_type%TYPE;
8337: l_item_key wf_items.item_key%TYPE;
8338: l_quote_id NUMBER;
8339: l_event_type VARCHAR2(20);
8340: l_document VARCHAR2(32000) := '';

Line 8337: l_item_key wf_items.item_key%TYPE;

8333: document_type IN OUT NOCOPY VARCHAR2
8334: )IS
8335:
8336: l_item_type wf_items.item_type%TYPE;
8337: l_item_key wf_items.item_key%TYPE;
8338: l_quote_id NUMBER;
8339: l_event_type VARCHAR2(20);
8340: l_document VARCHAR2(32000) := '';
8341: l_temp_str VARCHAR2(2000):='';

Line 8617: l_item_type wf_items.item_type%TYPE := 'IBEALERT';

8613: document IN OUT NOCOPY VARCHAR2,
8614: document_type IN OUT NOCOPY VARCHAR2
8615: ) IS
8616:
8617: l_item_type wf_items.item_type%TYPE := 'IBEALERT';
8618: l_item_key wf_items.item_key%TYPE;
8619: l_quote_id NUMBER;
8620: l_event_type VARCHAR2(20);
8621: l_contract_id NUMBER;

Line 8618: l_item_key wf_items.item_key%TYPE;

8614: document_type IN OUT NOCOPY VARCHAR2
8615: ) IS
8616:
8617: l_item_type wf_items.item_type%TYPE := 'IBEALERT';
8618: l_item_key wf_items.item_key%TYPE;
8619: l_quote_id NUMBER;
8620: l_event_type VARCHAR2(20);
8621: l_contract_id NUMBER;
8622: l_contract_Number VARCHAR2(120);

Line 9136: l_item_type wf_items.item_type%TYPE := 'IBEALERT';

9132: document IN OUT NOCOPY VARCHAR2,
9133: document_type IN OUT NOCOPY VARCHAR2
9134: ) IS
9135:
9136: l_item_type wf_items.item_type%TYPE := 'IBEALERT';
9137: l_item_key wf_items.item_key%TYPE;
9138: l_quote_id NUMBER;
9139: l_event_type VARCHAR2(20);
9140: l_document VARCHAR2(32000) := '';

Line 9137: l_item_key wf_items.item_key%TYPE;

9133: document_type IN OUT NOCOPY VARCHAR2
9134: ) IS
9135:
9136: l_item_type wf_items.item_type%TYPE := 'IBEALERT';
9137: l_item_key wf_items.item_key%TYPE;
9138: l_quote_id NUMBER;
9139: l_event_type VARCHAR2(20);
9140: l_document VARCHAR2(32000) := '';
9141: l_description mtl_system_items_kfv.description%TYPE;

Line 9279: l_item_type wf_items.item_type%TYPE := 'IBEALERT';

9275: document IN OUT NOCOPY VARCHAR2,
9276: document_type IN OUT NOCOPY VARCHAR2
9277: )IS
9278:
9279: l_item_type wf_items.item_type%TYPE := 'IBEALERT';
9280: l_item_key wf_items.item_key%TYPE;
9281: l_quote_id NUMBER;
9282: l_event_type VARCHAR2(20);
9283: l_document VARCHAR2(32000) := '';

Line 9280: l_item_key wf_items.item_key%TYPE;

9276: document_type IN OUT NOCOPY VARCHAR2
9277: )IS
9278:
9279: l_item_type wf_items.item_type%TYPE := 'IBEALERT';
9280: l_item_key wf_items.item_key%TYPE;
9281: l_quote_id NUMBER;
9282: l_event_type VARCHAR2(20);
9283: l_document VARCHAR2(32000) := '';
9284: l_temp_str VARCHAR2(2000):='';