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 987: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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

Line 1221: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

1217: document_type IN OUT NOCOPY VARCHAR2
1218: ) is
1219: L_api_name CONSTANT VARCHAR2(30) := 'Generate_Credential_Msg';
1220: L_api_version CONSTANT NUMBER := 1.0;
1221: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
1222: -- l_uname VARCHAR2(30);
1223: l_passwd VARCHAR2(30);
1224: l_credential_line VARCHAR2(255);
1225: BEGIN

Line 1325: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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

Line 1630: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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

Line 1846: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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

Line 2439: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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

Line 2823: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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

Line 3042: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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

Line 3412: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;

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

Line 3417: l_sales_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:
3421: l_quote_org_id NUMBER;

Line 3833: l_cust_item_key WF_ITEMS.ITEM_KEY%TYPE;

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

Line 3844: l_sales_item_key WF_ITEMS.ITEM_KEY%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:
3847: l_Notification WF_USERS.Notification_Preference%TYPE;
3848: l_Lang WF_USERS.Language%TYPE;

Line 4641: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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

Line 4842: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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

Line 5077: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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

Line 5331: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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

Line 5574: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

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

Line 5905: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

5901: l_UserType Varchar2(30) := 'ALL';
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;

Line 6261: l_item_type wf_items.item_type%TYPE;

6257: document IN OUT NOCOPY VARCHAR2,
6258: document_type IN OUT NOCOPY VARCHAR2
6259: )IS
6260:
6261: l_item_type wf_items.item_type%TYPE;
6262: l_item_key wf_items.item_key%TYPE;
6263: l_quote_id NUMBER;
6264: l_event_type VARCHAR2(20);
6265: l_document VARCHAR2(32000) := '';

Line 6262: l_item_key wf_items.item_key%TYPE;

6258: document_type IN OUT NOCOPY VARCHAR2
6259: )IS
6260:
6261: l_item_type wf_items.item_type%TYPE;
6262: l_item_key wf_items.item_key%TYPE;
6263: l_quote_id NUMBER;
6264: l_event_type VARCHAR2(20);
6265: l_document VARCHAR2(32000) := '';
6266: l_party_first_name hz_parties.person_first_name%TYPE;

Line 6500: l_item_type wf_items.item_type%TYPE;

6496: document IN OUT NOCOPY VARCHAR2,
6497: document_type IN OUT NOCOPY VARCHAR2
6498: )
6499: IS
6500: l_item_type wf_items.item_type%TYPE;
6501: l_item_key wf_items.item_key%TYPE;
6502: l_quote_id NUMBER;
6503: l_event_type VARCHAR2(20);
6504: l_comments VARCHAR2(2000);

Line 6501: l_item_key wf_items.item_key%TYPE;

6497: document_type IN OUT NOCOPY VARCHAR2
6498: )
6499: IS
6500: l_item_type wf_items.item_type%TYPE;
6501: l_item_key wf_items.item_key%TYPE;
6502: l_quote_id NUMBER;
6503: l_event_type VARCHAR2(20);
6504: l_comments VARCHAR2(2000);
6505: l_party_first_name hz_parties.person_first_name%TYPE;

Line 6902: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

6898: document_type IN OUT NOCOPY VARCHAR2
6899: ) IS
6900: l_document VARCHAR2(32000) := ' '||NEWLINE;
6901: l_view_net_price_flag VARCHAR2(1);
6902: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
6903: l_order_id NUMBER;
6904: l_temp_str VARCHAR2(2000):='';
6905: l_event_type VARCHAR2(20);
6906: l_quote_id NUMBER;

Line 7053: l_item_type wf_items.item_type%TYPE;

7049: p_quote_flag IN VARCHAR2,
7050: p_tax_flag IN VARCHAR2,
7051: x_document OUT NOCOPY VARCHAR2
7052: ) is
7053: l_item_type wf_items.item_type%TYPE;
7054: l_item_key wf_items.item_key%TYPE;
7055: l_quote_id NUMBER;
7056: l_event_type VARCHAR2(20);
7057: l_document VARCHAR2(32000) := '';

Line 7054: l_item_key wf_items.item_key%TYPE;

7050: p_tax_flag IN VARCHAR2,
7051: x_document OUT NOCOPY VARCHAR2
7052: ) is
7053: l_item_type wf_items.item_type%TYPE;
7054: l_item_key wf_items.item_key%TYPE;
7055: l_quote_id NUMBER;
7056: l_event_type VARCHAR2(20);
7057: l_document VARCHAR2(32000) := '';
7058: l_ship_flag VARCHAR2(1);

Line 7497: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

7493: p_tax_flag IN VARCHAR2,
7494: x_document IN OUT NOCOPY VARCHAR2
7495: )IS
7496:
7497: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
7498: l_event_type VARCHAR2(20);
7499: l_document VARCHAR2(32000) := '';
7500: l_string_in VARCHAR2(250);
7501: l_string_out VARCHAR2(250);

Line 8082: l_item_type wf_items.item_type%TYPE;

8078: document IN OUT NOCOPY VARCHAR2,
8079: document_type IN OUT NOCOPY VARCHAR2
8080: )IS
8081:
8082: l_item_type wf_items.item_type%TYPE;
8083: l_item_key wf_items.item_key%TYPE;
8084: l_quote_id NUMBER;
8085: l_event_type VARCHAR2(20);
8086: l_document VARCHAR2(32000) := '';

Line 8083: l_item_key wf_items.item_key%TYPE;

8079: document_type IN OUT NOCOPY VARCHAR2
8080: )IS
8081:
8082: l_item_type wf_items.item_type%TYPE;
8083: l_item_key wf_items.item_key%TYPE;
8084: l_quote_id NUMBER;
8085: l_event_type VARCHAR2(20);
8086: l_document VARCHAR2(32000) := '';
8087: l_ship_flag VARCHAR2(1);

Line 8241: l_item_type wf_items.item_type%TYPE;

8237: document IN OUT NOCOPY VARCHAR2,
8238: document_type IN OUT NOCOPY VARCHAR2
8239: )IS
8240:
8241: l_item_type wf_items.item_type%TYPE;
8242: l_item_key wf_items.item_key%TYPE;
8243: l_quote_id NUMBER;
8244: l_event_type VARCHAR2(20);
8245: l_document VARCHAR2(32000) := '';

Line 8242: l_item_key wf_items.item_key%TYPE;

8238: document_type IN OUT NOCOPY VARCHAR2
8239: )IS
8240:
8241: l_item_type wf_items.item_type%TYPE;
8242: l_item_key wf_items.item_key%TYPE;
8243: l_quote_id NUMBER;
8244: l_event_type VARCHAR2(20);
8245: l_document VARCHAR2(32000) := '';
8246: l_temp_str VARCHAR2(2000):='';

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

8518: document IN OUT NOCOPY VARCHAR2,
8519: document_type IN OUT NOCOPY VARCHAR2
8520: ) IS
8521:
8522: l_item_type wf_items.item_type%TYPE := 'IBEALERT';
8523: l_item_key wf_items.item_key%TYPE;
8524: l_quote_id NUMBER;
8525: l_event_type VARCHAR2(20);
8526: l_contract_id NUMBER;

Line 8523: l_item_key wf_items.item_key%TYPE;

8519: document_type IN OUT NOCOPY VARCHAR2
8520: ) IS
8521:
8522: l_item_type wf_items.item_type%TYPE := 'IBEALERT';
8523: l_item_key wf_items.item_key%TYPE;
8524: l_quote_id NUMBER;
8525: l_event_type VARCHAR2(20);
8526: l_contract_id NUMBER;
8527: l_contract_Number VARCHAR2(120);

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

9037: document IN OUT NOCOPY VARCHAR2,
9038: document_type IN OUT NOCOPY VARCHAR2
9039: ) IS
9040:
9041: l_item_type wf_items.item_type%TYPE := 'IBEALERT';
9042: l_item_key wf_items.item_key%TYPE;
9043: l_quote_id NUMBER;
9044: l_event_type VARCHAR2(20);
9045: l_document VARCHAR2(32000) := '';

Line 9042: l_item_key wf_items.item_key%TYPE;

9038: document_type IN OUT NOCOPY VARCHAR2
9039: ) IS
9040:
9041: l_item_type wf_items.item_type%TYPE := 'IBEALERT';
9042: l_item_key wf_items.item_key%TYPE;
9043: l_quote_id NUMBER;
9044: l_event_type VARCHAR2(20);
9045: l_document VARCHAR2(32000) := '';
9046: l_description mtl_system_items_kfv.description%TYPE;

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

9180: document IN OUT NOCOPY VARCHAR2,
9181: document_type IN OUT NOCOPY VARCHAR2
9182: )IS
9183:
9184: l_item_type wf_items.item_type%TYPE := 'IBEALERT';
9185: l_item_key wf_items.item_key%TYPE;
9186: l_quote_id NUMBER;
9187: l_event_type VARCHAR2(20);
9188: l_document VARCHAR2(32000) := '';

Line 9185: l_item_key wf_items.item_key%TYPE;

9181: document_type IN OUT NOCOPY VARCHAR2
9182: )IS
9183:
9184: l_item_type wf_items.item_type%TYPE := 'IBEALERT';
9185: l_item_key wf_items.item_key%TYPE;
9186: l_quote_id NUMBER;
9187: l_event_type VARCHAR2(20);
9188: l_document VARCHAR2(32000) := '';
9189: l_temp_str VARCHAR2(2000):='';