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.PER_RI_CONFIG_DATAPUMP_ENTITY dependencies on PER_RI_CONFIG_INFORMATION

Line 46: l_configuration_code per_ri_config_information.configuration_code%type;

42: enterprise_location_id
43: from per_ri_config_enterprise_v
44: where configuration_code = cp_configuration_code;
45:
46: l_configuration_code per_ri_config_information.configuration_code%type;
47: l_config_information_id per_ri_config_information.config_information_id%type;
48: l_config_sequence per_ri_config_information.config_sequence%type;
49: l_config_information_category per_ri_config_information.config_information_category%type;
50: l_enterprise_name per_ri_config_information.config_information1%type;

Line 47: l_config_information_id per_ri_config_information.config_information_id%type;

43: from per_ri_config_enterprise_v
44: where configuration_code = cp_configuration_code;
45:
46: l_configuration_code per_ri_config_information.configuration_code%type;
47: l_config_information_id per_ri_config_information.config_information_id%type;
48: l_config_sequence per_ri_config_information.config_sequence%type;
49: l_config_information_category per_ri_config_information.config_information_category%type;
50: l_enterprise_name per_ri_config_information.config_information1%type;
51: l_enterprise_name_original per_ri_config_information.config_information1%type;

Line 48: l_config_sequence per_ri_config_information.config_sequence%type;

44: where configuration_code = cp_configuration_code;
45:
46: l_configuration_code per_ri_config_information.configuration_code%type;
47: l_config_information_id per_ri_config_information.config_information_id%type;
48: l_config_sequence per_ri_config_information.config_sequence%type;
49: l_config_information_category per_ri_config_information.config_information_category%type;
50: l_enterprise_name per_ri_config_information.config_information1%type;
51: l_enterprise_name_original per_ri_config_information.config_information1%type;
52: l_enterprise_short_name per_ri_config_information.config_information1%type;

Line 49: l_config_information_category per_ri_config_information.config_information_category%type;

45:
46: l_configuration_code per_ri_config_information.configuration_code%type;
47: l_config_information_id per_ri_config_information.config_information_id%type;
48: l_config_sequence per_ri_config_information.config_sequence%type;
49: l_config_information_category per_ri_config_information.config_information_category%type;
50: l_enterprise_name per_ri_config_information.config_information1%type;
51: l_enterprise_name_original per_ri_config_information.config_information1%type;
52: l_enterprise_short_name per_ri_config_information.config_information1%type;
53: l_enterprise_hq_country per_ri_config_information.config_information1%type;

Line 50: l_enterprise_name per_ri_config_information.config_information1%type;

46: l_configuration_code per_ri_config_information.configuration_code%type;
47: l_config_information_id per_ri_config_information.config_information_id%type;
48: l_config_sequence per_ri_config_information.config_sequence%type;
49: l_config_information_category per_ri_config_information.config_information_category%type;
50: l_enterprise_name per_ri_config_information.config_information1%type;
51: l_enterprise_name_original per_ri_config_information.config_information1%type;
52: l_enterprise_short_name per_ri_config_information.config_information1%type;
53: l_enterprise_hq_country per_ri_config_information.config_information1%type;
54: l_hr_enterprise_primary_indust per_ri_config_information.config_information1%type;

Line 51: l_enterprise_name_original per_ri_config_information.config_information1%type;

47: l_config_information_id per_ri_config_information.config_information_id%type;
48: l_config_sequence per_ri_config_information.config_sequence%type;
49: l_config_information_category per_ri_config_information.config_information_category%type;
50: l_enterprise_name per_ri_config_information.config_information1%type;
51: l_enterprise_name_original per_ri_config_information.config_information1%type;
52: l_enterprise_short_name per_ri_config_information.config_information1%type;
53: l_enterprise_hq_country per_ri_config_information.config_information1%type;
54: l_hr_enterprise_primary_indust per_ri_config_information.config_information1%type;
55: l_enterprise_location_id per_ri_config_information.config_information1%type;

Line 52: l_enterprise_short_name per_ri_config_information.config_information1%type;

48: l_config_sequence per_ri_config_information.config_sequence%type;
49: l_config_information_category per_ri_config_information.config_information_category%type;
50: l_enterprise_name per_ri_config_information.config_information1%type;
51: l_enterprise_name_original per_ri_config_information.config_information1%type;
52: l_enterprise_short_name per_ri_config_information.config_information1%type;
53: l_enterprise_hq_country per_ri_config_information.config_information1%type;
54: l_hr_enterprise_primary_indust per_ri_config_information.config_information1%type;
55: l_enterprise_location_id per_ri_config_information.config_information1%type;
56:

Line 53: l_enterprise_hq_country per_ri_config_information.config_information1%type;

49: l_config_information_category per_ri_config_information.config_information_category%type;
50: l_enterprise_name per_ri_config_information.config_information1%type;
51: l_enterprise_name_original per_ri_config_information.config_information1%type;
52: l_enterprise_short_name per_ri_config_information.config_information1%type;
53: l_enterprise_hq_country per_ri_config_information.config_information1%type;
54: l_hr_enterprise_primary_indust per_ri_config_information.config_information1%type;
55: l_enterprise_location_id per_ri_config_information.config_information1%type;
56:
57: l_business_group_country_code per_business_groups.name%type;

Line 54: l_hr_enterprise_primary_indust per_ri_config_information.config_information1%type;

50: l_enterprise_name per_ri_config_information.config_information1%type;
51: l_enterprise_name_original per_ri_config_information.config_information1%type;
52: l_enterprise_short_name per_ri_config_information.config_information1%type;
53: l_enterprise_hq_country per_ri_config_information.config_information1%type;
54: l_hr_enterprise_primary_indust per_ri_config_information.config_information1%type;
55: l_enterprise_location_id per_ri_config_information.config_information1%type;
56:
57: l_business_group_country_code per_business_groups.name%type;
58: l_business_group_name per_business_groups.name%type;

Line 55: l_enterprise_location_id per_ri_config_information.config_information1%type;

51: l_enterprise_name_original per_ri_config_information.config_information1%type;
52: l_enterprise_short_name per_ri_config_information.config_information1%type;
53: l_enterprise_hq_country per_ri_config_information.config_information1%type;
54: l_hr_enterprise_primary_indust per_ri_config_information.config_information1%type;
55: l_enterprise_location_id per_ri_config_information.config_information1%type;
56:
57: l_business_group_country_code per_business_groups.name%type;
58: l_business_group_name per_business_groups.name%type;
59: l_ent_location_code per_ri_config_locations.description%type; -- fix for 4457389

Line 347: l_configuration_code per_ri_config_information.configuration_code%type;

343: operating_company_location_id
344: from per_ri_config_oper_comp_v
345: where configuration_code = cp_configuration_code;
346:
347: l_configuration_code per_ri_config_information.configuration_code%type;
348: l_config_information_id per_ri_config_information.config_information_id%type;
349: l_config_sequence per_ri_config_information.config_sequence%type;
350: l_config_information_category per_ri_config_information.config_information_category%type;
351: l_operating_company_name per_ri_config_information.config_information1%type;

Line 348: l_config_information_id per_ri_config_information.config_information_id%type;

344: from per_ri_config_oper_comp_v
345: where configuration_code = cp_configuration_code;
346:
347: l_configuration_code per_ri_config_information.configuration_code%type;
348: l_config_information_id per_ri_config_information.config_information_id%type;
349: l_config_sequence per_ri_config_information.config_sequence%type;
350: l_config_information_category per_ri_config_information.config_information_category%type;
351: l_operating_company_name per_ri_config_information.config_information1%type;
352: l_operating_company_name_orig per_ri_config_information.config_information1%type;

Line 349: l_config_sequence per_ri_config_information.config_sequence%type;

345: where configuration_code = cp_configuration_code;
346:
347: l_configuration_code per_ri_config_information.configuration_code%type;
348: l_config_information_id per_ri_config_information.config_information_id%type;
349: l_config_sequence per_ri_config_information.config_sequence%type;
350: l_config_information_category per_ri_config_information.config_information_category%type;
351: l_operating_company_name per_ri_config_information.config_information1%type;
352: l_operating_company_name_orig per_ri_config_information.config_information1%type;
353: l_operating_company_short_name per_ri_config_information.config_information1%type;

Line 350: l_config_information_category per_ri_config_information.config_information_category%type;

346:
347: l_configuration_code per_ri_config_information.configuration_code%type;
348: l_config_information_id per_ri_config_information.config_information_id%type;
349: l_config_sequence per_ri_config_information.config_sequence%type;
350: l_config_information_category per_ri_config_information.config_information_category%type;
351: l_operating_company_name per_ri_config_information.config_information1%type;
352: l_operating_company_name_orig per_ri_config_information.config_information1%type;
353: l_operating_company_short_name per_ri_config_information.config_information1%type;
354: l_operating_company_hq_country per_ri_config_information.config_information1%type;

Line 351: l_operating_company_name per_ri_config_information.config_information1%type;

347: l_configuration_code per_ri_config_information.configuration_code%type;
348: l_config_information_id per_ri_config_information.config_information_id%type;
349: l_config_sequence per_ri_config_information.config_sequence%type;
350: l_config_information_category per_ri_config_information.config_information_category%type;
351: l_operating_company_name per_ri_config_information.config_information1%type;
352: l_operating_company_name_orig per_ri_config_information.config_information1%type;
353: l_operating_company_short_name per_ri_config_information.config_information1%type;
354: l_operating_company_hq_country per_ri_config_information.config_information1%type;
355: l_operating_comp_location_id per_ri_config_information.config_information1%type;

Line 352: l_operating_company_name_orig per_ri_config_information.config_information1%type;

348: l_config_information_id per_ri_config_information.config_information_id%type;
349: l_config_sequence per_ri_config_information.config_sequence%type;
350: l_config_information_category per_ri_config_information.config_information_category%type;
351: l_operating_company_name per_ri_config_information.config_information1%type;
352: l_operating_company_name_orig per_ri_config_information.config_information1%type;
353: l_operating_company_short_name per_ri_config_information.config_information1%type;
354: l_operating_company_hq_country per_ri_config_information.config_information1%type;
355: l_operating_comp_location_id per_ri_config_information.config_information1%type;
356:

Line 353: l_operating_company_short_name per_ri_config_information.config_information1%type;

349: l_config_sequence per_ri_config_information.config_sequence%type;
350: l_config_information_category per_ri_config_information.config_information_category%type;
351: l_operating_company_name per_ri_config_information.config_information1%type;
352: l_operating_company_name_orig per_ri_config_information.config_information1%type;
353: l_operating_company_short_name per_ri_config_information.config_information1%type;
354: l_operating_company_hq_country per_ri_config_information.config_information1%type;
355: l_operating_comp_location_id per_ri_config_information.config_information1%type;
356:
357: l_business_group_country_code per_business_groups.name%type;

Line 354: l_operating_company_hq_country per_ri_config_information.config_information1%type;

350: l_config_information_category per_ri_config_information.config_information_category%type;
351: l_operating_company_name per_ri_config_information.config_information1%type;
352: l_operating_company_name_orig per_ri_config_information.config_information1%type;
353: l_operating_company_short_name per_ri_config_information.config_information1%type;
354: l_operating_company_hq_country per_ri_config_information.config_information1%type;
355: l_operating_comp_location_id per_ri_config_information.config_information1%type;
356:
357: l_business_group_country_code per_business_groups.name%type;
358: l_business_group_name per_business_groups.name%type;

Line 355: l_operating_comp_location_id per_ri_config_information.config_information1%type;

351: l_operating_company_name per_ri_config_information.config_information1%type;
352: l_operating_company_name_orig per_ri_config_information.config_information1%type;
353: l_operating_company_short_name per_ri_config_information.config_information1%type;
354: l_operating_company_hq_country per_ri_config_information.config_information1%type;
355: l_operating_comp_location_id per_ri_config_information.config_information1%type;
356:
357: l_business_group_country_code per_business_groups.name%type;
358: l_business_group_name per_business_groups.name%type;
359: l_oc_location_code per_ri_config_locations.description%type; -- fix for 4457389

Line 360: l_enterprise_name per_ri_config_information.config_information1%type;

356:
357: l_business_group_country_code per_business_groups.name%type;
358: l_business_group_name per_business_groups.name%type;
359: l_oc_location_code per_ri_config_locations.description%type; -- fix for 4457389
360: l_enterprise_name per_ri_config_information.config_information1%type;
361:
362: l_oc_count number(10) := 0;
363: l_oc_class_count number(10) := 0;
364: l_org_hierarchy_ele_oc_count number(10) := 0;

Line 613: l_configuration_code per_ri_config_information.configuration_code%type;

609: legal_entity_location_id
610: from per_ri_config_legal_entity_v
611: where configuration_code = cp_configuration_code;
612:
613: l_configuration_code per_ri_config_information.configuration_code%type;
614: l_config_information_id per_ri_config_information.config_information_id%type;
615: l_config_sequence per_ri_config_information.config_sequence%type;
616: l_config_information_category per_ri_config_information.config_information_category%type;
617: l_enterprise_name per_ri_config_information.config_information1%type;

Line 614: l_config_information_id per_ri_config_information.config_information_id%type;

610: from per_ri_config_legal_entity_v
611: where configuration_code = cp_configuration_code;
612:
613: l_configuration_code per_ri_config_information.configuration_code%type;
614: l_config_information_id per_ri_config_information.config_information_id%type;
615: l_config_sequence per_ri_config_information.config_sequence%type;
616: l_config_information_category per_ri_config_information.config_information_category%type;
617: l_enterprise_name per_ri_config_information.config_information1%type;
618: l_legal_entity_name per_ri_config_information.config_information1%type;

Line 615: l_config_sequence per_ri_config_information.config_sequence%type;

611: where configuration_code = cp_configuration_code;
612:
613: l_configuration_code per_ri_config_information.configuration_code%type;
614: l_config_information_id per_ri_config_information.config_information_id%type;
615: l_config_sequence per_ri_config_information.config_sequence%type;
616: l_config_information_category per_ri_config_information.config_information_category%type;
617: l_enterprise_name per_ri_config_information.config_information1%type;
618: l_legal_entity_name per_ri_config_information.config_information1%type;
619: l_legal_entity_name_original per_ri_config_information.config_information1%type;

Line 616: l_config_information_category per_ri_config_information.config_information_category%type;

612:
613: l_configuration_code per_ri_config_information.configuration_code%type;
614: l_config_information_id per_ri_config_information.config_information_id%type;
615: l_config_sequence per_ri_config_information.config_sequence%type;
616: l_config_information_category per_ri_config_information.config_information_category%type;
617: l_enterprise_name per_ri_config_information.config_information1%type;
618: l_legal_entity_name per_ri_config_information.config_information1%type;
619: l_legal_entity_name_original per_ri_config_information.config_information1%type;
620: l_legal_entity_short_name per_ri_config_information.config_information1%type;

Line 617: l_enterprise_name per_ri_config_information.config_information1%type;

613: l_configuration_code per_ri_config_information.configuration_code%type;
614: l_config_information_id per_ri_config_information.config_information_id%type;
615: l_config_sequence per_ri_config_information.config_sequence%type;
616: l_config_information_category per_ri_config_information.config_information_category%type;
617: l_enterprise_name per_ri_config_information.config_information1%type;
618: l_legal_entity_name per_ri_config_information.config_information1%type;
619: l_legal_entity_name_original per_ri_config_information.config_information1%type;
620: l_legal_entity_short_name per_ri_config_information.config_information1%type;
621: l_legal_entity_country per_ri_config_information.config_information1%type;

Line 618: l_legal_entity_name per_ri_config_information.config_information1%type;

614: l_config_information_id per_ri_config_information.config_information_id%type;
615: l_config_sequence per_ri_config_information.config_sequence%type;
616: l_config_information_category per_ri_config_information.config_information_category%type;
617: l_enterprise_name per_ri_config_information.config_information1%type;
618: l_legal_entity_name per_ri_config_information.config_information1%type;
619: l_legal_entity_name_original per_ri_config_information.config_information1%type;
620: l_legal_entity_short_name per_ri_config_information.config_information1%type;
621: l_legal_entity_country per_ri_config_information.config_information1%type;
622: l_le_parent_oper_comp per_ri_config_information.config_information1%type;

Line 619: l_legal_entity_name_original per_ri_config_information.config_information1%type;

615: l_config_sequence per_ri_config_information.config_sequence%type;
616: l_config_information_category per_ri_config_information.config_information_category%type;
617: l_enterprise_name per_ri_config_information.config_information1%type;
618: l_legal_entity_name per_ri_config_information.config_information1%type;
619: l_legal_entity_name_original per_ri_config_information.config_information1%type;
620: l_legal_entity_short_name per_ri_config_information.config_information1%type;
621: l_legal_entity_country per_ri_config_information.config_information1%type;
622: l_le_parent_oper_comp per_ri_config_information.config_information1%type;
623: l_legal_entity_location_id per_ri_config_information.config_information1%type;

Line 620: l_legal_entity_short_name per_ri_config_information.config_information1%type;

616: l_config_information_category per_ri_config_information.config_information_category%type;
617: l_enterprise_name per_ri_config_information.config_information1%type;
618: l_legal_entity_name per_ri_config_information.config_information1%type;
619: l_legal_entity_name_original per_ri_config_information.config_information1%type;
620: l_legal_entity_short_name per_ri_config_information.config_information1%type;
621: l_legal_entity_country per_ri_config_information.config_information1%type;
622: l_le_parent_oper_comp per_ri_config_information.config_information1%type;
623: l_legal_entity_location_id per_ri_config_information.config_information1%type;
624:

Line 621: l_legal_entity_country per_ri_config_information.config_information1%type;

617: l_enterprise_name per_ri_config_information.config_information1%type;
618: l_legal_entity_name per_ri_config_information.config_information1%type;
619: l_legal_entity_name_original per_ri_config_information.config_information1%type;
620: l_legal_entity_short_name per_ri_config_information.config_information1%type;
621: l_legal_entity_country per_ri_config_information.config_information1%type;
622: l_le_parent_oper_comp per_ri_config_information.config_information1%type;
623: l_legal_entity_location_id per_ri_config_information.config_information1%type;
624:
625:

Line 622: l_le_parent_oper_comp per_ri_config_information.config_information1%type;

618: l_legal_entity_name per_ri_config_information.config_information1%type;
619: l_legal_entity_name_original per_ri_config_information.config_information1%type;
620: l_legal_entity_short_name per_ri_config_information.config_information1%type;
621: l_legal_entity_country per_ri_config_information.config_information1%type;
622: l_le_parent_oper_comp per_ri_config_information.config_information1%type;
623: l_legal_entity_location_id per_ri_config_information.config_information1%type;
624:
625:
626: l_le_count number(10) := 0;

Line 623: l_legal_entity_location_id per_ri_config_information.config_information1%type;

619: l_legal_entity_name_original per_ri_config_information.config_information1%type;
620: l_legal_entity_short_name per_ri_config_information.config_information1%type;
621: l_legal_entity_country per_ri_config_information.config_information1%type;
622: l_le_parent_oper_comp per_ri_config_information.config_information1%type;
623: l_legal_entity_location_id per_ri_config_information.config_information1%type;
624:
625:
626: l_le_count number(10) := 0;
627: l_le_class_count number(10) := 0;

Line 1251: from per_ri_config_information

1247: -- Bugfix 4133935
1248: -- Need the enterprise BG country
1249: cursor csr_config_information(cp_configuration_code in varchar2) IS
1250: select config_information3 country_code
1251: from per_ri_config_information
1252: where configuration_code = cp_configuration_code
1253: and config_information_category = 'CONFIG ENTERPRISE';
1254:
1255: l_configuration_code per_ri_config_information.configuration_code%type;

Line 1255: l_configuration_code per_ri_config_information.configuration_code%type;

1251: from per_ri_config_information
1252: where configuration_code = cp_configuration_code
1253: and config_information_category = 'CONFIG ENTERPRISE';
1254:
1255: l_configuration_code per_ri_config_information.configuration_code%type;
1256: l_bg_country_name per_ri_config_information.config_information1%type;
1257: l_enterprise_bg_country_code per_ri_config_information.config_information2%type;
1258: l_business_group_name hr_all_organization_units.name%type;
1259: l_batch_header_id number(15);

Line 1256: l_bg_country_name per_ri_config_information.config_information1%type;

1252: where configuration_code = cp_configuration_code
1253: and config_information_category = 'CONFIG ENTERPRISE';
1254:
1255: l_configuration_code per_ri_config_information.configuration_code%type;
1256: l_bg_country_name per_ri_config_information.config_information1%type;
1257: l_enterprise_bg_country_code per_ri_config_information.config_information2%type;
1258: l_business_group_name hr_all_organization_units.name%type;
1259: l_batch_header_id number(15);
1260: l_legislation_code per_business_groups.legislation_code%type;

Line 1257: l_enterprise_bg_country_code per_ri_config_information.config_information2%type;

1253: and config_information_category = 'CONFIG ENTERPRISE';
1254:
1255: l_configuration_code per_ri_config_information.configuration_code%type;
1256: l_bg_country_name per_ri_config_information.config_information1%type;
1257: l_enterprise_bg_country_code per_ri_config_information.config_information2%type;
1258: l_business_group_name hr_all_organization_units.name%type;
1259: l_batch_header_id number(15);
1260: l_legislation_code per_business_groups.legislation_code%type;
1261: l_job_flex_stru_code varchar2(30);