APPS.IBE_BI_STR_MIG_PVT dependencies on HR_OPERATING_UNITS

Line 12: org_name hr_operating_units.name%TYPE ,

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) );
16:

Line 207: l_valid_org_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE ;

203:
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);

Line 210: l_valid_org_name hr_operating_units.name%TYPE ;

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:
214:

Line 217: FROM hr_operating_units ou

213:
214:
215: CURSOR c_valid_org_id(c_org_id NUMBER) IS
216: SELECT organization_id,name
217: FROM hr_operating_units ou
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

Line 1020: FROM ibe_migration_log mlog, hr_operating_units ou

1016: l_temp_yesno VARCHAR2(200);
1017:
1018: CURSOR c_get_carts_count IS
1019: SELECT count(mlog.attribute1) cnt_cart,ou.organization_id,ou.name
1020: FROM ibe_migration_log mlog, hr_operating_units ou
1021: WHERE attribute5 is null
1022: AND mlog.attribute_idx1= ou.organization_id
1023: GROUP BY mlog.attribute_idx1, ou.organization_id,ou.name;
1024:

Line 1224: SELECT organization_id, name FROM hr_operating_units OU

1220:
1221:
1222:
1223: CURSOR c_valid_orgs is
1224: SELECT organization_id, name FROM hr_operating_units OU
1225: WHERE exists (SELECT qhdr.org_id FROM aso_quote_headers_all qhdr
1226: WHERE ou.organization_id = qhdr.org_id);
1227:
1228: CURSOR c_valid_str is