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 1106: FROM HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI2

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

Line 1276: INSERT INTO hr_organization_information(

1272: X_attribute19 =>NULL,
1273: X_attribute20 =>NULL);
1274: --Classify this organization as an inventory organization.
1275: IF (NVL(p_inventory_org_ind, 'Y') = 'Y') THEN
1276: INSERT INTO hr_organization_information(
1277: ORG_INFORMATION_ID,
1278: ORG_INFORMATION_CONTEXT,
1279: ORGANIZATION_ID,
1280: ORG_INFORMATION1,

Line 1288: hr_organization_information_s.nextval,

1284: LAST_UPDATED_BY,
1285: CREATED_BY,
1286: CREATION_DATE)
1287: VALUES (
1288: hr_organization_information_s.nextval,
1289: 'CLASS',
1290: X_organization_id,
1291: 'INV',
1292: 'Y',

Line 1299: INSERT INTO hr_organization_information(

1295: 0,
1296: 0,
1297: sysdate);
1298: --Define the accounting information from the fiscal policy
1299: INSERT INTO hr_organization_information(
1300: ORG_INFORMATION_ID,
1301: ORG_INFORMATION_CONTEXT,
1302: ORGANIZATION_ID,
1303: ORG_INFORMATION1,

Line 1311: hr_organization_information_s.nextval,

1307: LAST_UPDATED_BY,
1308: CREATED_BY,
1309: CREATION_DATE)
1310: VALUES (
1311: hr_organization_information_s.nextval,
1312: 'Accounting Information',
1313: X_organization_id,
1314: l_orgn_def.set_of_books_id,
1315: l_orgn_def.legal_entity,