[Home] [Help]
139: 115.3 10-DEC-98 VTreiger MLS modications for New Business Group.
140: 115.4 11-DEC-98 MStewart Added code in insert_bus_grp_details
141: to create a security group and
142: populate the org_information14 column.
143: 115.5 29-DEC-98 VTreiger Modified per_person_types table population,
144: because we support only one table
145: per_startup_person_types_tl.
146:
147: 115.6 13-JAN-99 MStewart Removed code to create security group
146:
147: 115.6 13-JAN-99 MStewart Removed code to create security group
148: and populate the org_info14 column
149: since this is now done elsewhere.
150: 115.7 20-JAN-99 VTreiger Modified per_person_types table population,
151: because the latest version of translated table
152: PER_STARTUP_PERSON_TYPES_TL now has column
153: DEFAULT_FLAG.
154: 115.11 11-JUN-99 MElori-M Added cursor get_usr_rows and code to
428: --
429: hr_utility.set_location('hr_organization.insert_bus_grp_details',1);
430: -- MLS modification
431: -- we have only one table per_startup_person_types_tl !!!!
432: INSERT INTO per_person_types
433: (seeded_person_type_key
434: ,person_type_id
435: ,active_flag
436: ,business_group_id
439: ,user_person_type
440: )
441: SELECT
442: seeded_person_type_key
443: ,per_person_types_s.nextval
444: ,'Y'
445: ,p_organization_id
446: ,psp.default_flag
447: ,psp.system_person_type
466: --
467: -- MLS
468: --
469: hr_utility.set_location('hr_organization.insert_bus_grp_details',101);
470: INSERT INTO per_person_types_tl
471: (person_type_id
472: ,user_person_type
473: ,language
474: ,source_lang
477: ppt.person_type_id
478: ,pptl.user_person_type
479: ,pptl.language
480: ,pptl.source_lang
481: FROM PER_PERSON_TYPES ppt,
482: PER_STARTUP_PERSON_TYPES_TL pptl
483: WHERE ppt.business_group_id = p_organization_id
484: AND ppt.seeded_person_type_key = pptl.seeded_person_type_key;
485: --