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 JTF_UM_USERTYPES_B

Line 320: l_UserType jtf_um_usertypes_b.usertype_key%type := 'B2B';

316:
317: /*Procedure getUserType(pPartyId IN Varchar2,
318: pUserType OUT NOCOPY Varchar2) IS
319: l_PartyType Varchar2(30);
320: l_UserType jtf_um_usertypes_b.usertype_key%type := 'B2B';
321: BEGIN
322: ----DBMS_OUTPUT.PUT('Into getusertype party_id is: '||ppartyid);
323: FOR c_hz_parties_rec IN c_hz_parties(pPartyId) LOOP
324: ----DBMS_OUTPUT.PUT('Opened the cursor loop');

Line 368: l_UserType jtf_um_usertypes_b.usertype_key%type :='ALL';

364: pUserType OUT NOCOPY Varchar2) IS
365:
366: l_api_name CONSTANT VARCHAR2(30) :='getUserType';
367: l_PartyType HZ_PARTIES.PARTY_TYPE%type :='';
368: l_UserType jtf_um_usertypes_b.usertype_key%type :='ALL';
369: l_user_name FND_USER.USER_NAME%type;
370: l_is_pv_partner boolean :=false;
371: l_is_int_primary_user boolean:=false;
372: plsql_block VARCHAR2(500);

Line 383: from jtf_um_usertype_reg a,jtf_um_usertypes_b b, fnd_user c , hz_parties d

379: --
380: -- cursor to retrieve user type from jta tables
381: Cursor c_get_user_type(c_party_id NUMBER) IS
382: select b.usertype_key
383: from jtf_um_usertype_reg a,jtf_um_usertypes_b b, fnd_user c , hz_parties d
384: where a.usertype_id=b.usertype_id and c.user_id = a.user_id
385: and d.party_id = c.customer_id and b.application_id=671
386: and d.party_id = c_party_id;
387:

Line 838: l_usertype jtf_um_usertypes_b.usertype_key%type;

834: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
835: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
836: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
837:
838: l_usertype jtf_um_usertypes_b.usertype_key%type;
839: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
840: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
841: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
842:

Line 922: l_usertype jtf_um_usertypes_b.usertype_key%type;

918: x_contact_first_name OUT NOCOPY HZ_PARTIES.PERSON_FIRST_NAME%TYPE,
919: x_contact_last_name OUT NOCOPY HZ_PARTIES.PERSON_LAST_NAME%TYPE,
920: x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE) IS
921:
922: l_usertype jtf_um_usertypes_b.usertype_key%type;
923: l_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
924: l_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
925: l_partyid HZ_PARTIES.PARTY_ID%TYPE;
926: l_PartyType Varchar2(30);

Line 1005: l_UserType jtf_um_usertypes_b.usertype_key%type := 'ALL';

1001:
1002: l_notifEnabled Varchar2(3) := 'Y';
1003: l_notifName Varchar2(30) := 'QUOTEPUB';
1004: l_OrgId Number := null;
1005: l_UserType jtf_um_usertypes_b.usertype_key%type := 'ALL';
1006:
1007: l_messageName WF_MESSAGES.NAME%TYPE;
1008: l_msgEnabled VARCHAR2(3) :='Y';
1009:

Line 1342: l_UserType jtf_um_usertypes_b.usertype_key%type := 'ALL';

1338: l_notifEnabled Varchar2(3) := 'Y';
1339: l_notifName Varchar2(30) := 'ACCTREGNOTIFICATION';
1340: l_OrgId Number := null;
1341: l_partyNum Varchar2(30);
1342: l_UserType jtf_um_usertypes_b.usertype_key%type := 'ALL';
1343: l_messageName WF_MESSAGES.NAME%TYPE;
1344: l_msgEnabled VARCHAR2(3) :='Y';
1345:
1346: --ab

Line 1361: select approval_id from jtf_um_usertypes_b

1357: Where USR.EMPLOYEE_ID is null
1358: and user_name = c_login_name;
1359: -- ab
1360: Cursor C_get_approval_id(c_usertype VARCHAR2) IS
1361: select approval_id from jtf_um_usertypes_b
1362: where usertype_key=c_usertype and (effective_end_date > sysdate or effective_end_date is null)
1363: and rownum= 1 and application_id=671;
1364:
1365: Cursor C_get_org_num(c_party_id NUMBER) IS

Line 1649: l_UserType jtf_um_usertypes_b.usertype_key%type := 'ALL';

1645: l_event_type Varchar2(30) := 'FORGETLOGIN';
1646: l_notifEnabled Varchar2(3) := 'Y';
1647: l_notifName Varchar2(30) := 'FORGETLOGINNOTIFICATION';
1648: l_OrgId Number := null;
1649: l_UserType jtf_um_usertypes_b.usertype_key%type := 'ALL';
1650:
1651: l_messageName WF_MESSAGES.NAME%TYPE;
1652: l_msgEnabled VARCHAR2(3) :='Y';
1653:

Line 1875: l_UserType jtf_um_usertypes_b.usertype_key%type := 'ALL';

1871:
1872: l_notifEnabled Varchar2(3) := 'Y';
1873: l_notifName Varchar2(30) := 'ORDCONFNOTIFICATION';
1874: l_Orgid Number := null;
1875: l_UserType jtf_um_usertypes_b.usertype_key%type := 'ALL';
1876:
1877: l_messageName WF_MESSAGES.NAME%TYPE;
1878: l_msgEnabled VARCHAR2(3) :='Y';
1879:

Line 2525: l_UserType jtf_um_usertypes_b.usertype_key%type;

2521: l_last_name VARCHAR2(2000);
2522: l_notifEnabled VARCHAR2(3) := 'Y';
2523: l_notifName VARCHAR2(30) ;
2524: l_Orgid NUMBER := null;
2525: l_UserType jtf_um_usertypes_b.usertype_key%type;
2526: l_messageName WF_MESSAGES.NAME%TYPE;
2527: l_msgEnabled VARCHAR2(3) :='Y';
2528: l_minisite_id NUMBER := null; -- bug 8337371, scnagara
2529:

Line 2932: l_UserType jtf_um_usertypes_b.usertype_key%type := 'ALL';

2928:
2929: l_notifEnabled Varchar2(3) := 'Y';
2930: l_notifName Varchar2(30) := 'CANCELORDER';
2931: l_Orgid Number := null;
2932: l_UserType jtf_um_usertypes_b.usertype_key%type := 'ALL';
2933: l_messageName WF_MESSAGES.NAME%TYPE := 'CANCELORDER';
2934: l_msgEnabled VARCHAR2(3) :='Y';
2935:
2936:

Line 3153: l_UserType jtf_um_usertypes_b.usertype_key%type := 'ALL';

3149: l_partyId Number;
3150:
3151: l_notifEnabled Varchar2(3) := 'Y';
3152: l_notifName Varchar2(30) := 'TERMAPPROVEDNOTIF';
3153: l_UserType jtf_um_usertypes_b.usertype_key%type := 'ALL';
3154: l_messageName WF_MESSAGES.NAME%TYPE;
3155: l_msgEnabled VARCHAR2(3) :='Y';
3156: l_permission_to_view_price BOOLEAN;
3157: l_view_net_price_flag VARCHAR2(1);

Line 3529: l_UserType jtf_um_usertypes_b.usertype_key%type := 'ALL';

3525:
3526: l_partyid Number;
3527: l_notifEnabled Varchar2(3) := 'Y';
3528: l_notifName Varchar2(30) := 'CUSTQUOTENOTIFICATION';
3529: l_UserType jtf_um_usertypes_b.usertype_key%type := 'ALL';
3530: l_MessageName WF_MESSAGES.NAME%TYPE;
3531: l_msgEnabled VARCHAR2(3) :='Y';
3532:
3533: BEGIN

Line 3955: l_UserType jtf_um_usertypes_b.usertype_key%type := 'ALL';

3951: l_partyId Number;
3952: l_orgid Number := null;
3953: l_notifEnabled Varchar2(3) := 'Y';
3954: l_notifName Varchar2(30) := 'CUSTASSISTNOTIFICATON';
3955: l_UserType jtf_um_usertypes_b.usertype_key%type := 'ALL';
3956: l_MessageName WF_MESSAGES.NAME%TYPE;
3957: l_msgEnabled VARCHAR2(3) :='Y';
3958:
3959: --Bug 2223507

Line 4739: l_usertype jtf_um_usertypes_b.usertype_key%type := FND_API.G_MISS_CHAR;

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;
4743: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;

Line 4936: l_usertype jtf_um_usertypes_b.usertype_key%type := 'ALL' ;

4932: l_notif_context VARCHAR2(2000);
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 ;

Line 5171: l_usertype jtf_um_usertypes_b.usertype_key%type := 'ALL' ;

5167: l_notif_context VARCHAR2(2000);
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 ;

Line 5425: l_usertype jtf_um_usertypes_b.usertype_key%type := 'ALL' ;

5421: l_notif_context VARCHAR2(2000);
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 ;

Line 5679: l_user_Type jtf_um_usertypes_b.usertype_key%type;

5675: l_owner_first_name VARCHAR2(1000);
5676: l_owner_last_name VARCHAR2(1000);
5677: l_owner_party_id NUMBER;
5678: l_quote_name VARCHAR2(1000);
5679: l_user_Type jtf_um_usertypes_b.usertype_key%type;
5680: l_msg_Enabled VARCHAR2(1);
5681: l_msg_name VARCHAR2(1000);
5682: l_org_id NUMBER;
5683: l_create_adhoc_flag VARCHAR2(10);

Line 5996: l_UserType jtf_um_usertypes_b.usertype_key%type := 'ALL';

5992: l_event_type Varchar2(30) := 'SHAREDCART';
5993: l_notifEnabled Varchar2(3) := 'Y';
5994: l_notifName Varchar2(30) := 'SHAREDCART';
5995: l_OrgId Number := null;
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;

Line 6368: l_user_type jtf_um_usertypes_b.usertype_key%type;

6364: l_errmsg_data VARCHAR2(2000):='';
6365: l_order_id NUMBER;
6366: l_Ship_Method Varchar2(80);
6367: l_view_net_price_flag VARCHAR2(1);
6368: l_user_type jtf_um_usertypes_b.usertype_key%type;
6369: l_notif_name VARCHAR2(20);
6370:
6371:
6372: