APPS.INV_MIGRATE_PROCESS_ORG dependencies on HR_ORGANIZATION_INFORMATION

Line 292: UPDATE hr_organization_information

288: IF Cur_get_oper_unit%FOUND THEN
289: l_legal_entity := gmf_migration.get_legal_entity_id (p_co_code => l_co_code,
290: p_source_type => 'N');
291: /*Bug 5228725 - Added the org_information_context clause */
292: UPDATE hr_organization_information
293: SET org_information2 = l_legal_entity
294: WHERE organization_id = l_rec.organization_id
295: AND org_information_context = 'Accounting Information';
296: END IF;

Line 1104: FROM HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI2

1100: SELECT HOU.BUSINESS_GROUP_ID,
1101: DECODE(HOI2.ORG_INFORMATION_CONTEXT, 'Accounting Information', TO_NUMBER(HOI2.ORG_INFORMATION1), TO_NUMBER(NULL)) SET_OF_BOOKS_ID,
1102: DECODE(HOI2.ORG_INFORMATION_CONTEXT, 'Accounting Information', TO_NUMBER(HOI2.ORG_INFORMATION3), TO_NUMBER(NULL)) OPERATING_UNIT,
1103: DECODE(HOI2.ORG_INFORMATION_CONTEXT, 'Accounting Information', TO_NUMBER(HOI2.ORG_INFORMATION2), null) LEGAL_ENTITY
1104: FROM HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI2
1105: WHERE HOU.organization_id = V_orgn_id
1106: AND HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
1107: AND ( HOI2.ORG_INFORMATION_CONTEXT || '') ='Accounting Information';
1108:

Line 1254: INSERT INTO hr_organization_information(

1250: X_attribute19 =>NULL,
1251: X_attribute20 =>NULL);
1252: --Classify this organization as an inventory organization.
1253: IF (NVL(p_inventory_org_ind, 'Y') = 'Y') THEN
1254: INSERT INTO hr_organization_information(
1255: ORG_INFORMATION_ID,
1256: ORG_INFORMATION_CONTEXT,
1257: ORGANIZATION_ID,
1258: ORG_INFORMATION1,

Line 1266: hr_organization_information_s.nextval,

1262: LAST_UPDATED_BY,
1263: CREATED_BY,
1264: CREATION_DATE)
1265: VALUES (
1266: hr_organization_information_s.nextval,
1267: 'CLASS',
1268: X_organization_id,
1269: 'INV',
1270: 'Y',

Line 1277: INSERT INTO hr_organization_information(

1273: 0,
1274: 0,
1275: sysdate);
1276: --Define the accounting information from the fiscal policy
1277: INSERT INTO hr_organization_information(
1278: ORG_INFORMATION_ID,
1279: ORG_INFORMATION_CONTEXT,
1280: ORGANIZATION_ID,
1281: ORG_INFORMATION1,

Line 1289: hr_organization_information_s.nextval,

1285: LAST_UPDATED_BY,
1286: CREATED_BY,
1287: CREATION_DATE)
1288: VALUES (
1289: hr_organization_information_s.nextval,
1290: 'Accounting Information',
1291: X_organization_id,
1292: l_orgn_def.set_of_books_id,
1293: l_orgn_def.legal_entity,