APPS.IBE_BI_STR_MIG_PVT dependencies on IBE_MSITES_VL

Line 11: minisite_name ibe_msites_vl.msite_name%TYPE,

7:
8: type g_org_mapping is RECORD(
9: minisite_id aso_quote_headers_all.minisite_id%TYPE,
10: org_id aso_quote_headers_all.org_id%TYPE,
11: minisite_name ibe_msites_vl.msite_name%TYPE,
12: org_name hr_operating_units.name%TYPE ,
13: is_valid_org varchar2(1),
14: is_valid_str varchar2(1),
15: is_duplicate_org varchar2(1) );

Line 208: l_valid_minisite_id IBE_MSITES_VL.MSITE_ID%TYPE ;

204:
205: PROCEDURE Validate_params IS
206:
207: l_valid_org_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE ;
208: l_valid_minisite_id IBE_MSITES_VL.MSITE_ID%TYPE ;
209: l_valid_minisite_name ibe_msites_vl.msite_name%TYPE;
210: l_valid_org_name hr_operating_units.name%TYPE ;
211: l_temp_msg VARCHAR2(2000);
212: invalid_str_org_input EXCEPTION;

Line 209: l_valid_minisite_name ibe_msites_vl.msite_name%TYPE;

205: PROCEDURE Validate_params IS
206:
207: l_valid_org_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE ;
208: l_valid_minisite_id IBE_MSITES_VL.MSITE_ID%TYPE ;
209: l_valid_minisite_name ibe_msites_vl.msite_name%TYPE;
210: l_valid_org_name hr_operating_units.name%TYPE ;
211: l_temp_msg VARCHAR2(2000);
212: invalid_str_org_input EXCEPTION;
213:

Line 222: FROM ibe_msites_vl str

218: WHERE ou.organization_id = c_org_id ;
219:
220: CURSOR c_valid_msite_id(c_msite_id NUMBER ) IS
221: SELECT msite_id,msite_name
222: FROM ibe_msites_vl str
223: WHERE str.msite_id = c_msite_id
224: AND str.site_type= 'I'; -- Changed as per the Bug # 4394901
225:
226: m NUMBER;

Line 1231: FROM ibe_msites_vl

1227:
1228: CURSOR c_valid_str is
1229: SELECT distinct MSITE_ID,
1230: msite_name
1231: FROM ibe_msites_vl
1232: WHERE msite_id <> 1
1233: AND site_type= 'I'; -- Changed as per the Bug # 4394901
1234:
1235: BEGIN