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 1898: FROM ibe_msites_vl

1894:
1895:
1896: /* Cursor c_minisite_name(p_msite number) is
1897: SELECT msite_name
1898: FROM ibe_msites_vl
1899: WHERE msite_id = p_msite;
1900: rec_minisite_name c_minisite_name%rowtype;*/
1901:
1902: --bug 6877589 ukalaiah

Line 3978: l_minisite_name ibe_msites_vl.msite_name%TYPE;

3974: l_postal_code VARCHAR2(60);
3975: l_ship_to_state VARCHAR2(60);
3976: l_ship_to_province VARCHAR2(60);
3977: l_ship_to_county VARCHAR2(60);
3978: l_minisite_name ibe_msites_vl.msite_name%TYPE;
3979: l_shipping_method wsh_carrier_ship_methods_v.ship_method_code_meaning%TYPE;
3980: l_contact_name ibe_quote_headers_v.party_name%TYPE;
3981:
3982: l_ship_and_hand ibe_quote_headers_v.TOTAL_SHIPPING_CHARGE%TYPE;

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

4652: This procedure is responsible to retrive the
4653: speciality store name related to the input parameter msite id.
4654: ********************************************************/
4655: /*This procedure is commented, as minisite name will be obtained from a callback
4656: /*PROCEDURE Get_Speciality_Store_name(p_msite IN IBE_MSITES_VL.MSITE_ID%TYPE,
4657: x_Speciality_Store_Name OUT NOCOPY IBE_MSITES_VL.MSITE_NAME%TYPE) is
4658: CURSOR c_msite_name(p_msite number) IS
4659: SELECT msite_name
4660: FROM ibe_msites_vl

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

4653: speciality store name related to the input parameter msite id.
4654: ********************************************************/
4655: /*This procedure is commented, as minisite name will be obtained from a callback
4656: /*PROCEDURE Get_Speciality_Store_name(p_msite IN IBE_MSITES_VL.MSITE_ID%TYPE,
4657: x_Speciality_Store_Name OUT NOCOPY IBE_MSITES_VL.MSITE_NAME%TYPE) is
4658: CURSOR c_msite_name(p_msite number) IS
4659: SELECT msite_name
4660: FROM ibe_msites_vl
4661: WHERE msite_id = p_msite;

Line 4660: FROM ibe_msites_vl

4656: /*PROCEDURE Get_Speciality_Store_name(p_msite IN IBE_MSITES_VL.MSITE_ID%TYPE,
4657: x_Speciality_Store_Name OUT NOCOPY IBE_MSITES_VL.MSITE_NAME%TYPE) is
4658: CURSOR c_msite_name(p_msite number) IS
4659: SELECT msite_name
4660: FROM ibe_msites_vl
4661: WHERE msite_id = p_msite;
4662: rec_msite_name c_msite_name%rowtype;
4663: BEGIN
4664:

Line 4744: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;

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;
4745: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4746: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4747: x_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4748: x_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

Line 4753: FROM ibe_msites_vl

4749: l_recip_name Varchar2(2000);
4750:
4751: CURSOR c_msite_name(p_msite number) IS
4752: SELECT msite_name
4753: FROM ibe_msites_vl
4754: WHERE msite_id = p_msite;
4755:
4756: CURSOR c_b2c_sharing(c_retrieval_number number) is
4757: select quote_name

Line 4941: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;

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:
4945: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

Line 5176: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;

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:
5180: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

Line 5430: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;

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:
5434: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

Line 10109: FROM ibe_msites_vl

10105:
10106: l_msite_id NUMBER;
10107: CURSOR c_msite_name(c_msite_id number) IS
10108: SELECT msite_name
10109: FROM ibe_msites_vl
10110: WHERE msite_id = c_msite_id;
10111: rec_msite_name c_msite_name%rowtype;
10112:
10113: BEGIN