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 IBE_MSITES_VL

Line 1888: FROM ibe_msites_vl

1884:
1885:
1886: /* Cursor c_minisite_name(p_msite number) is
1887: SELECT msite_name
1888: FROM ibe_msites_vl
1889: WHERE msite_id = p_msite;
1890: rec_minisite_name c_minisite_name%rowtype;*/
1891:
1892: BEGIN

Line 3883: l_minisite_name ibe_msites_vl.msite_name%TYPE;

3879: l_postal_code VARCHAR2(60);
3880: l_ship_to_state VARCHAR2(60);
3881: l_ship_to_province VARCHAR2(60);
3882: l_ship_to_county VARCHAR2(60);
3883: l_minisite_name ibe_msites_vl.msite_name%TYPE;
3884: l_shipping_method wsh_carrier_ship_methods_v.ship_method_code_meaning%TYPE;
3885: l_contact_name ibe_quote_headers_v.party_name%TYPE;
3886:
3887: l_ship_and_hand ibe_quote_headers_v.TOTAL_SHIPPING_CHARGE%TYPE;

Line 4561: /*PROCEDURE Get_Speciality_Store_name(p_msite IN IBE_MSITES_VL.MSITE_ID%TYPE,

4557: This procedure is responsible to retrive the
4558: speciality store name related to the input parameter msite id.
4559: ********************************************************/
4560: /*This procedure is commented, as minisite name will be obtained from a callback
4561: /*PROCEDURE Get_Speciality_Store_name(p_msite IN IBE_MSITES_VL.MSITE_ID%TYPE,
4562: x_Speciality_Store_Name OUT NOCOPY IBE_MSITES_VL.MSITE_NAME%TYPE) is
4563: CURSOR c_msite_name(p_msite number) IS
4564: SELECT msite_name
4565: FROM ibe_msites_vl

Line 4562: x_Speciality_Store_Name OUT NOCOPY IBE_MSITES_VL.MSITE_NAME%TYPE) is

4558: speciality store name related to the input parameter msite id.
4559: ********************************************************/
4560: /*This procedure is commented, as minisite name will be obtained from a callback
4561: /*PROCEDURE Get_Speciality_Store_name(p_msite IN IBE_MSITES_VL.MSITE_ID%TYPE,
4562: x_Speciality_Store_Name OUT NOCOPY IBE_MSITES_VL.MSITE_NAME%TYPE) is
4563: CURSOR c_msite_name(p_msite number) IS
4564: SELECT msite_name
4565: FROM ibe_msites_vl
4566: WHERE msite_id = p_msite;

Line 4565: FROM ibe_msites_vl

4561: /*PROCEDURE Get_Speciality_Store_name(p_msite IN IBE_MSITES_VL.MSITE_ID%TYPE,
4562: x_Speciality_Store_Name OUT NOCOPY IBE_MSITES_VL.MSITE_NAME%TYPE) is
4563: CURSOR c_msite_name(p_msite number) IS
4564: SELECT msite_name
4565: FROM ibe_msites_vl
4566: WHERE msite_id = p_msite;
4567: rec_msite_name c_msite_name%rowtype;
4568: BEGIN
4569:

Line 4649: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;

4645: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
4646: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4647: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;
4648: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;
4649: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4650: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4651: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4652: x_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4653: x_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

Line 4658: FROM ibe_msites_vl

4654: l_recip_name Varchar2(2000);
4655:
4656: CURSOR c_msite_name(p_msite number) IS
4657: SELECT msite_name
4658: FROM ibe_msites_vl
4659: WHERE msite_id = p_msite;
4660:
4661: CURSOR c_b2c_sharing(c_retrieval_number number) is
4662: select quote_name

Line 4846: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;

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;
4847: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4848: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4849:
4850: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

Line 5081: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;

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;
5082: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5083: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
5084:
5085: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

Line 5335: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;

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;
5336: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5337: l_is_it_quote varchar2(1) := FND_API.G_FALSE;
5338:
5339: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

Line 10014: FROM ibe_msites_vl

10010:
10011: l_msite_id NUMBER;
10012: CURSOR c_msite_name(c_msite_id number) IS
10013: SELECT msite_name
10014: FROM ibe_msites_vl
10015: WHERE msite_id = c_msite_id;
10016: rec_msite_name c_msite_name%rowtype;
10017:
10018: BEGIN