eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ORGANIZATION dependencies on HR_ORGANIZATION

Line 1: PACKAGE BODY hr_organization AS

1: PACKAGE BODY hr_organization AS
2: /* $Header: peorganz.pkb 120.1 2008/02/06 12:01:45 pchowdav ship $ */
3: /*
4: ******************************************************************
5: * *

Line 24: Name : hr_organization (BODY)

20: * *
21: ******************************************************************
22: ==================================================================
23:
24: Name : hr_organization (BODY)
25:
26: Description : Contains the definition of organization procedures
27: as declared in the hr_organization package header
28:

Line 27: as declared in the hr_organization package header

23:
24: Name : hr_organization (BODY)
25:
26: Description : Contains the definition of organization procedures
27: as declared in the hr_organization package header
28:
29: Uses : hr_utility
30:
31: Change List

Line 77: 70.21 04-MAY-93 TMATHERS changed HR_ORGANIZATION_UNITS

73: unique name check to stop
74: TOO_MANY_ROWS exception firing.
75: When a BG and an org in the current
76: BG have the same name.
77: 70.21 04-MAY-93 TMATHERS changed HR_ORGANIZATION_UNITS
78: to HR_ALL_ORGANIZATION_UNITS in
79: unique name check
80: 70.22 06-MAY-93 SZWILLIA Changed above back as security does
81: not apply in packages.(Always created

Line 231: hr_utility.set_location('hr_organization.ins_si_type', 1);

227: --
228: l_special_info_type_id number;
229: begin
230: --
231: hr_utility.set_location('hr_organization.ins_si_type', 1);
232: select per_special_info_types_s.nextval
233: into l_special_info_type_id
234: from dual;
235: --

Line 283: hr_utility.set_location('Entering hr_organization.seed_benefit_data',1);

279: l_dbms_sql_feedback integer;
280: --
281: begin
282: --
283: hr_utility.set_location('Entering hr_organization.seed_benefit_data',1);
284: --
285: -- Seed benefit life events
286: --
287: l_cursor_handle := dbms_sql.open_cursor;

Line 337: hr_utility.set_location('Leaving hr_organization.seed_benefit_data',1);

333: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
334: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
335: dbms_sql.close_cursor(l_cursor_handle);
336: --
337: hr_utility.set_location('Leaving hr_organization.seed_benefit_data',1);
338: --
339: end seed_benefit_data;
340: ----------------------- insert_bus_grp_details -------------------
341: -- Called by hr_org_info_ari

Line 429: hr_utility.set_location('hr_organization.insert_bus_grp_details',1);

425: c_consolidation_set_name_len NUMBER(9) := 60;
426: begin
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

Line 460: 'hr_organization.insert_bus_grp_details');

456: --
457: if l_row_count = 0 then
458: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
459: hr_utility.set_message_token('PROCEDURE',
460: 'hr_organization.insert_bus_grp_details');
461: hr_utility.set_message_token('STEP','1');
462: hr_utility.raise_error;
463: end if;
464: --

Line 469: hr_utility.set_location('hr_organization.insert_bus_grp_details',101);

465: l_row_count := 0;
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

Line 494: 'hr_organization.insert_bus_grp_details');

490: --
491: if l_row_count = 0 then
492: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
493: hr_utility.set_message_token('PROCEDURE',
494: 'hr_organization.insert_bus_grp_details');
495: hr_utility.set_message_token('STEP','101');
496: hr_utility.raise_error;
497: end if;
498: --

Line 503: hr_utility.set_location('hr_organization.insert_bus_grp_details',2);

499: l_row_count := 0;
500: --
501: -- MLS end
502: --
503: hr_utility.set_location('hr_organization.insert_bus_grp_details',2);
504: INSERT INTO per_number_generation_controls
505: (business_group_id
506: ,type
507: ,next_value)

Line 514: hr_utility.set_location('hr_organization.insert_bus_grp_details',3);

510: ,'EMP'
511: ,1);
512: --
513: --
514: hr_utility.set_location('hr_organization.insert_bus_grp_details',3);
515: INSERT INTO per_number_generation_controls
516: (business_group_id
517: ,type
518: ,next_value)

Line 525: hr_utility.set_location('hr_organization.insert_bus_grp_details',4);

521: ,'APL'
522: ,1);
523: --
524: --
525: hr_utility.set_location('hr_organization.insert_bus_grp_details',4);
526: INSERT INTO per_number_generation_controls
527: (business_group_id
528: ,type
529: ,next_value)

Line 536: hr_utility.set_location('hr_organization.insert_bus_grp_details',5);

532: ,'CWK'
533: ,1);
534: --
535: begin
536: hr_utility.set_location('hr_organization.insert_bus_grp_details',5);
537: SELECT 'Y'
538: INTO l_install_mode
539: FROM sys.dual
540: WHERE NOT EXISTS (SELECT null

Line 554: hr_utility.set_location('hr_organization.insert_bus_grp_details',6);

550: -- If AOL product version is not 6.0.27 we have an install of 10.6 or higher,
551: -- and the APPS account will exist.
552: --
553: begin
554: hr_utility.set_location('hr_organization.insert_bus_grp_details',6);
555: SELECT 'N'
556: INTO l_apps_account
557: FROM fnd_product_installations
558: WHERE application_id = 0

Line 580: hr_utility.set_location('hr_organization.insert_bus_grp_details',8);

576: -- Set the secure_oracle_username for the View All security profile to the
577: -- Oracle ID for the APPS account. This can be derived by looking in
578: -- fnd_oracle_userid f1r an oracle_username with oracle_id = 900
579: --
580: hr_utility.set_location('hr_organization.insert_bus_grp_details',8);
581: INSERT INTO per_security_profiles
582: (security_profile_id
583: ,business_group_id
584: ,include_top_organization_flag

Line 638: 'hr_organization.insert_bus_grp_details');

634: --
635: if SQL%ROWCOUNT = 0 then
636: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
637: hr_utility.set_message_token('PROCEDURE',
638: 'hr_organization.insert_bus_grp_details');
639: hr_utility.set_message_token('STEP','8');
640: hr_utility.raise_error;
641: end if;
642: --

Line 675: hr_utility.set_location('hr_organization.insert_bus_grp_details',9);

671: ,p_last_update_date
672: ,p_last_updated_by
673: ,p_last_update_login);
674: --
675: hr_utility.set_location('hr_organization.insert_bus_grp_details',9);
676: begin
677: INSERT INTO pay_consolidation_sets
678: (consolidation_set_id
679: ,business_group_id

Line 704: hr_utility.set_location('hr_organization.insert_bus_grp_details',91);

700: -- Bug Number: 3303179: Used l_ow_count instead of using SQL%ROWCOUNT after the hr_utility call.
701: --
702: l_row_count := SQL%ROWCOUNT;
703: --
704: hr_utility.set_location('hr_organization.insert_bus_grp_details',91);
705:
706: if l_row_count = 0 then
707: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
708: hr_utility.set_message_token('PROCEDURE',

Line 709: 'hr_organization.insert_bus_grp_details');

705:
706: if l_row_count = 0 then
707: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
708: hr_utility.set_message_token('PROCEDURE',
709: 'hr_organization.insert_bus_grp_details');
710: hr_utility.set_message_token('STEP','9');
711: hr_utility.raise_error;
712: end if;
713: exception

Line 715: hr_utility.set_location('hr_organization.insert_bus_grp_details',92);

711: hr_utility.raise_error;
712: end if;
713: exception
714: when no_data_found then
715: hr_utility.set_location('hr_organization.insert_bus_grp_details',92);
716: null;
717: when others then
718: hr_utility.set_location('hr_organization.insert_bus_grp_details',93);
719: raise;

Line 718: hr_utility.set_location('hr_organization.insert_bus_grp_details',93);

714: when no_data_found then
715: hr_utility.set_location('hr_organization.insert_bus_grp_details',92);
716: null;
717: when others then
718: hr_utility.set_location('hr_organization.insert_bus_grp_details',93);
719: raise;
720: end;
721: --
722: l_row_count := 0;

Line 730: hr_utility.set_location('hr_organization.insert_bus_grp_details',10);

726: --
727: fetch get_usr_rows into l_usr_row_id, l_usr_col_id;
728: exit when get_usr_rows%NOTFOUND;
729: --
730: hr_utility.set_location('hr_organization.insert_bus_grp_details',10);
731: -- VT added condition for Org API call
732: IF NOT hr_ori_shd.return_api_dml_status THEN
733: INSERT INTO pay_user_column_instances_f
734: (user_column_instance_id

Line 802: hr_utility.set_location('hr_organization.insert_bus_grp_details',101);

798: --
799: --fix for bug 6792619.
800: l_row_count := SQL%ROWCOUNT;
801: --
802: hr_utility.set_location('hr_organization.insert_bus_grp_details',101);
803:
804: if l_row_count = 0 then
805: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
806: hr_utility.set_message_token('PROCEDURE',

Line 807: 'hr_organization.insert_bus_grp_details');

803:
804: if l_row_count = 0 then
805: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
806: hr_utility.set_message_token('PROCEDURE',
807: 'hr_organization.insert_bus_grp_details');
808: hr_utility.set_message_token('STEP','9');
809: hr_utility.raise_error;
810: end if;
811: hr_utility.set_location('hr_organization.insert_bus_grp_details',102);

Line 811: hr_utility.set_location('hr_organization.insert_bus_grp_details',102);

807: 'hr_organization.insert_bus_grp_details');
808: hr_utility.set_message_token('STEP','9');
809: hr_utility.raise_error;
810: end if;
811: hr_utility.set_location('hr_organization.insert_bus_grp_details',102);
812:
813: end loop;
814: close get_usr_rows;
815: --

Line 835: hr_utility.set_location('hr_organization.insert_bus_grp_details', 8);

831: -- US startup data delivery. This procedure is run by Autoinstall
832: -- during creation of the Setup Business Group.
833: --
834: --
835: hr_utility.set_location('hr_organization.insert_bus_grp_details', 8);
836: --
837: -- Ideally we would create ADA special info type rows if business group being
838: -- inserted is a US business group. But cannot check legislation_code on
839: -- per_business_groups due to mutating table error.

Line 979: hr_utility.set_location('hr_organization.unique_name',1);

975: --
976: begin
977: --
978: --
979: hr_utility.set_location('hr_organization.unique_name',1);
980: SELECT 'Y'
981: INTO org_check
982: FROM sys.dual
983: WHERE exists

Line 986: FROM hr_organization_units org

982: FROM sys.dual
983: WHERE exists
984: (
985: SELECT 'Name Already Exists'
986: FROM hr_organization_units org
987: WHERE (org.organization_id <> p_organization_id
988: OR p_organization_id IS NULL)
989: AND p_organization_name = org.name
990: AND (org.business_group_id + 0 = p_business_group_id

Line 1016: hr_utility.set_location('hr_organization.date_range',1);

1012: l_eot DATE := to_date('31/12/4712','DD/MM/YYYY');
1013: --
1014: begin
1015: --
1016: hr_utility.set_location('hr_organization.date_range',1);
1017: --
1018: if p_date_from is null then
1019: hr_utility.set_message(801,'HR_6021_ALL_START_END_DATE');
1020: hr_utility.raise_error;

Line 1054: hr_utility.set_location('hr_organization.org_predel_check',1);

1050: if p_organization_id = p_business_group_id then
1051: begin
1052: begin
1053: -- Do Any rows Exist in PER_PEOPLE_F.
1054: hr_utility.set_location('hr_organization.org_predel_check',1);
1055: select '1'
1056: into l_test_func
1057: from sys.dual
1058: where exists ( select 1

Line 1072: -- Do Any rows Exist in HR_ORGANIZATION_UNITS.

1068: null;
1069: end;
1070: --
1071: begin
1072: -- Do Any rows Exist in HR_ORGANIZATION_UNITS.
1073: hr_utility.set_location('hr_organization.org_predel_check',2);
1074: select '1'
1075: into l_test_func
1076: from sys.dual

Line 1073: hr_utility.set_location('hr_organization.org_predel_check',2);

1069: end;
1070: --
1071: begin
1072: -- Do Any rows Exist in HR_ORGANIZATION_UNITS.
1073: hr_utility.set_location('hr_organization.org_predel_check',2);
1074: select '1'
1075: into l_test_func
1076: from sys.dual
1077: where exists ( select 1

Line 1078: from HR_ORGANIZATION_UNITS x

1074: select '1'
1075: into l_test_func
1076: from sys.dual
1077: where exists ( select 1
1078: from HR_ORGANIZATION_UNITS x
1079: where x.business_group_id = p_business_group_id
1080: and x.organization_id <> p_business_group_id);
1081: --
1082: if SQL%ROWCOUNT >0 THEN

Line 1094: hr_utility.set_location('hr_organization.org_predel_check',3);

1090: --
1091: --
1092: begin
1093: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.
1094: hr_utility.set_location('hr_organization.org_predel_check',3);
1095: select '1'
1096: into l_test_func
1097: from sys.dual
1098: where exists ( select 1

Line 1117: hr_utility.set_location('hr_organization.org_predel_check',4);

1113: -- Now do all Organization specific checks.
1114: --
1115: begin
1116: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.
1117: hr_utility.set_location('hr_organization.org_predel_check',4);
1118: select '1'
1119: into l_test_func
1120: from sys.dual
1121: where exists ( select 1

Line 1136: hr_utility.set_location('hr_organization.org_predel_check',5);

1132: end;
1133: --
1134: begin
1135: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.
1136: hr_utility.set_location('hr_organization.org_predel_check',5);
1137: select '1'
1138: into l_test_func
1139: from sys.dual
1140: where exists ( select 1

Line 1155: hr_utility.set_location('hr_organization.org_predel_check', 6);

1151: end;
1152: --
1153: begin
1154: -- Do any rows exist in BEN_BENEFICIARIES_F
1155: hr_utility.set_location('hr_organization.org_predel_check', 6);
1156: select '1'
1157: into l_test_func
1158: from sys.dual
1159: where exists (select 1

Line 1195: hr_utility.set_location('hr_organization.hr_weak_bg_chk',1);

1191: begin
1192: --
1193: begin
1194: -- Doing check on PER_ASSIGNMENTS_F.
1195: hr_utility.set_location('hr_organization.hr_weak_bg_chk',1);
1196: select '1'
1197: into l_test_func
1198: from sys.dual
1199: where exists ( select 1

Line 1214: hr_utility.set_location('hr_organization.hr_weak_bg_chk',2);

1210: end;
1211: --
1212: begin
1213: -- Doing check on PER_ASSIGNMENTS_F.
1214: hr_utility.set_location('hr_organization.hr_weak_bg_chk',2);
1215: select '1'
1216: into l_test_func
1217: from sys.dual
1218: where exists ( select 1

Line 1233: hr_utility.set_location('hr_organization.hr_weak_bg_chk',3);

1229: end;
1230: --
1231: begin
1232: -- Doing check on PER_ORG_STRUCTURE_ELEMENTS.
1233: hr_utility.set_location('hr_organization.hr_weak_bg_chk',3);
1234: select '1'
1235: into l_test_func
1236: from sys.dual
1237: where exists ( select 1

Line 1252: hr_utility.set_location('hr_organization.hr_weak_bg_chk',4);

1248: end;
1249: --
1250: begin
1251: -- Doing check on PER_ORG_STRUCTURE_ELEMENTS.
1252: hr_utility.set_location('hr_organization.hr_weak_bg_chk',4);
1253: select '1'
1254: into l_test_func
1255: from sys.dual
1256: where exists ( select 1

Line 1272: hr_utility.set_location('hr_organization.hr_weak_bg_chk',5);

1268: --
1269: --
1270: begin
1271: -- Doing check on PER_SECURITY_PROFILES.
1272: hr_utility.set_location('hr_organization.hr_weak_bg_chk',5);
1273: select '1'
1274: into l_test_func
1275: from sys.dual
1276: where exists ( select 1

Line 1301: END hr_organization;

1297: hr_utility.raise_error;
1298: end;
1299: ----------------------------------- End of get_flex_msg ----------------------
1300:
1301: END hr_organization;