[Home] [Help]
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
148: and populate the org_info14 column
149: since this is now done elsewhere.
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
155: insert rows into pay_user_column_instances_f
156: whenever a new business group is created.
378: --
379: cursor sel_startup_per_types is
380: select system_person_type,user_person_type
381: ,default_flag
382: from per_startup_person_types_tl
383: where userenv('LANG') = language
384: order by system_person_type,user_person_type;
385: --
386: cursor get_usr_rows is
427: --
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
445: ,p_organization_id
446: ,psp.default_flag
447: ,psp.system_person_type
448: ,psp.user_person_type
449: FROM per_startup_person_types_tl psp
450: WHERE psp.language = userenv('LANG');
451: --
452: -- Bug Number: 3303179: Used l_ow_count instead of using SQL%ROWCOUNT multiple times.
453: --
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: --
486: -- Bug Number: 3303179: Used l_ow_count instead of using SQL%ROWCOUNT multiple times.