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.ZX_EXTRACT_PKG dependencies on HR_LOCATIONS_ALL

Line 36: g_rep_context_city hr_locations_all.town_or_city%type;

32: g_creation_date date;
33: g_last_updated_by number(15);
34: g_last_update_date date;
35: g_last_update_login number(15);
36: g_rep_context_city hr_locations_all.town_or_city%type;
37: g_rep_context_region_1 hr_locations_all.region_3%type;
38: g_rep_context_region_2 hr_locations_all.region_2%type;
39: g_rep_context_region_3 hr_locations_all.region_1%type;
40: g_rep_context_address1 hr_locations_all.address_line_1%type;

Line 37: g_rep_context_region_1 hr_locations_all.region_3%type;

33: g_last_updated_by number(15);
34: g_last_update_date date;
35: g_last_update_login number(15);
36: g_rep_context_city hr_locations_all.town_or_city%type;
37: g_rep_context_region_1 hr_locations_all.region_3%type;
38: g_rep_context_region_2 hr_locations_all.region_2%type;
39: g_rep_context_region_3 hr_locations_all.region_1%type;
40: g_rep_context_address1 hr_locations_all.address_line_1%type;
41: g_rep_context_address2 hr_locations_all.address_line_2%type;

Line 38: g_rep_context_region_2 hr_locations_all.region_2%type;

34: g_last_update_date date;
35: g_last_update_login number(15);
36: g_rep_context_city hr_locations_all.town_or_city%type;
37: g_rep_context_region_1 hr_locations_all.region_3%type;
38: g_rep_context_region_2 hr_locations_all.region_2%type;
39: g_rep_context_region_3 hr_locations_all.region_1%type;
40: g_rep_context_address1 hr_locations_all.address_line_1%type;
41: g_rep_context_address2 hr_locations_all.address_line_2%type;
42: g_rep_context_address3 hr_locations_all.address_line_3%type;

Line 39: g_rep_context_region_3 hr_locations_all.region_1%type;

35: g_last_update_login number(15);
36: g_rep_context_city hr_locations_all.town_or_city%type;
37: g_rep_context_region_1 hr_locations_all.region_3%type;
38: g_rep_context_region_2 hr_locations_all.region_2%type;
39: g_rep_context_region_3 hr_locations_all.region_1%type;
40: g_rep_context_address1 hr_locations_all.address_line_1%type;
41: g_rep_context_address2 hr_locations_all.address_line_2%type;
42: g_rep_context_address3 hr_locations_all.address_line_3%type;
43: g_rep_context_country hr_locations_all.country%type;

Line 40: g_rep_context_address1 hr_locations_all.address_line_1%type;

36: g_rep_context_city hr_locations_all.town_or_city%type;
37: g_rep_context_region_1 hr_locations_all.region_3%type;
38: g_rep_context_region_2 hr_locations_all.region_2%type;
39: g_rep_context_region_3 hr_locations_all.region_1%type;
40: g_rep_context_address1 hr_locations_all.address_line_1%type;
41: g_rep_context_address2 hr_locations_all.address_line_2%type;
42: g_rep_context_address3 hr_locations_all.address_line_3%type;
43: g_rep_context_country hr_locations_all.country%type;
44: g_rep_context_postal_code hr_locations_all.postal_code%type;

Line 41: g_rep_context_address2 hr_locations_all.address_line_2%type;

37: g_rep_context_region_1 hr_locations_all.region_3%type;
38: g_rep_context_region_2 hr_locations_all.region_2%type;
39: g_rep_context_region_3 hr_locations_all.region_1%type;
40: g_rep_context_address1 hr_locations_all.address_line_1%type;
41: g_rep_context_address2 hr_locations_all.address_line_2%type;
42: g_rep_context_address3 hr_locations_all.address_line_3%type;
43: g_rep_context_country hr_locations_all.country%type;
44: g_rep_context_postal_code hr_locations_all.postal_code%type;
45: g_rep_context_phone_number hr_locations_all.telephone_number_1%type;

Line 42: g_rep_context_address3 hr_locations_all.address_line_3%type;

38: g_rep_context_region_2 hr_locations_all.region_2%type;
39: g_rep_context_region_3 hr_locations_all.region_1%type;
40: g_rep_context_address1 hr_locations_all.address_line_1%type;
41: g_rep_context_address2 hr_locations_all.address_line_2%type;
42: g_rep_context_address3 hr_locations_all.address_line_3%type;
43: g_rep_context_country hr_locations_all.country%type;
44: g_rep_context_postal_code hr_locations_all.postal_code%type;
45: g_rep_context_phone_number hr_locations_all.telephone_number_1%type;
46:

Line 43: g_rep_context_country hr_locations_all.country%type;

39: g_rep_context_region_3 hr_locations_all.region_1%type;
40: g_rep_context_address1 hr_locations_all.address_line_1%type;
41: g_rep_context_address2 hr_locations_all.address_line_2%type;
42: g_rep_context_address3 hr_locations_all.address_line_3%type;
43: g_rep_context_country hr_locations_all.country%type;
44: g_rep_context_postal_code hr_locations_all.postal_code%type;
45: g_rep_context_phone_number hr_locations_all.telephone_number_1%type;
46:
47: l_multi_org_flag fnd_product_groups.multi_org_flag%type;

Line 44: g_rep_context_postal_code hr_locations_all.postal_code%type;

40: g_rep_context_address1 hr_locations_all.address_line_1%type;
41: g_rep_context_address2 hr_locations_all.address_line_2%type;
42: g_rep_context_address3 hr_locations_all.address_line_3%type;
43: g_rep_context_country hr_locations_all.country%type;
44: g_rep_context_postal_code hr_locations_all.postal_code%type;
45: g_rep_context_phone_number hr_locations_all.telephone_number_1%type;
46:
47: l_multi_org_flag fnd_product_groups.multi_org_flag%type;
48: l_mrc_reporting_sob_id NUMBER;

Line 45: g_rep_context_phone_number hr_locations_all.telephone_number_1%type;

41: g_rep_context_address2 hr_locations_all.address_line_2%type;
42: g_rep_context_address3 hr_locations_all.address_line_3%type;
43: g_rep_context_country hr_locations_all.country%type;
44: g_rep_context_postal_code hr_locations_all.postal_code%type;
45: g_rep_context_phone_number hr_locations_all.telephone_number_1%type;
46:
47: l_multi_org_flag fnd_product_groups.multi_org_flag%type;
48: l_mrc_reporting_sob_id NUMBER;
49: g_balancing_segment VARCHAR2(25);

Line 2652: l_style HR_LOCATIONS_ALL.style%TYPE;

2648: p_trl_global_variables_rec IN OUT NOCOPY zx_extract_pkg.trl_global_variables_rec_type,
2649: p_rep_entity_id IN NUMBER)
2650: IS
2651:
2652: l_style HR_LOCATIONS_ALL.style%TYPE;
2653: l_extract_summary_code VARCHAR2(80);
2654: l_rep_context_id NUMBER;
2655: l_rep_context_org_id NUMBER;
2656: l_request_id NUMBER;

Line 2659: l_rep_context_loc_id HR_LOCATIONS_ALL.location_id%TYPE;

2655: l_rep_context_org_id NUMBER;
2656: l_request_id NUMBER;
2657: l_rep_entity_id NUMBER;
2658: l_rep_context_tax_reg_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE;
2659: l_rep_context_loc_id HR_LOCATIONS_ALL.location_id%TYPE;
2660: l_rep_context_name HR_ORGANIZATION_UNITS.name%TYPE;
2661: l_rep_context_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2662: l_rep_context_county HR_LOCATIONS_ALL.region_3%TYPE;
2663: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;

Line 2661: l_rep_context_city HR_LOCATIONS_ALL.town_or_city%TYPE;

2657: l_rep_entity_id NUMBER;
2658: l_rep_context_tax_reg_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE;
2659: l_rep_context_loc_id HR_LOCATIONS_ALL.location_id%TYPE;
2660: l_rep_context_name HR_ORGANIZATION_UNITS.name%TYPE;
2661: l_rep_context_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2662: l_rep_context_county HR_LOCATIONS_ALL.region_3%TYPE;
2663: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;
2664: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;
2665: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;

Line 2662: l_rep_context_county HR_LOCATIONS_ALL.region_3%TYPE;

2658: l_rep_context_tax_reg_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE;
2659: l_rep_context_loc_id HR_LOCATIONS_ALL.location_id%TYPE;
2660: l_rep_context_name HR_ORGANIZATION_UNITS.name%TYPE;
2661: l_rep_context_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2662: l_rep_context_county HR_LOCATIONS_ALL.region_3%TYPE;
2663: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;
2664: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;
2665: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2666: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;

Line 2663: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;

2659: l_rep_context_loc_id HR_LOCATIONS_ALL.location_id%TYPE;
2660: l_rep_context_name HR_ORGANIZATION_UNITS.name%TYPE;
2661: l_rep_context_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2662: l_rep_context_county HR_LOCATIONS_ALL.region_3%TYPE;
2663: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;
2664: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;
2665: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2666: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2667: l_rep_context_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;

Line 2664: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;

2660: l_rep_context_name HR_ORGANIZATION_UNITS.name%TYPE;
2661: l_rep_context_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2662: l_rep_context_county HR_LOCATIONS_ALL.region_3%TYPE;
2663: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;
2664: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;
2665: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2666: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2667: l_rep_context_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2668: l_rep_context_country HR_LOCATIONS_ALL.country%TYPE;

Line 2665: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;

2661: l_rep_context_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2662: l_rep_context_county HR_LOCATIONS_ALL.region_3%TYPE;
2663: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;
2664: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;
2665: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2666: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2667: l_rep_context_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2668: l_rep_context_country HR_LOCATIONS_ALL.country%TYPE;
2669: l_rep_context_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

Line 2666: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;

2662: l_rep_context_county HR_LOCATIONS_ALL.region_3%TYPE;
2663: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;
2664: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;
2665: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2666: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2667: l_rep_context_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2668: l_rep_context_country HR_LOCATIONS_ALL.country%TYPE;
2669: l_rep_context_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2670: l_rep_context_phone_number HR_LOCATIONS_ALL.telephone_number_1%TYPE;

Line 2667: l_rep_context_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;

2663: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;
2664: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;
2665: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2666: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2667: l_rep_context_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2668: l_rep_context_country HR_LOCATIONS_ALL.country%TYPE;
2669: l_rep_context_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2670: l_rep_context_phone_number HR_LOCATIONS_ALL.telephone_number_1%TYPE;
2671: l_rep_context_lvl_mng VARCHAR2(80);

Line 2668: l_rep_context_country HR_LOCATIONS_ALL.country%TYPE;

2664: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;
2665: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2666: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2667: l_rep_context_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2668: l_rep_context_country HR_LOCATIONS_ALL.country%TYPE;
2669: l_rep_context_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2670: l_rep_context_phone_number HR_LOCATIONS_ALL.telephone_number_1%TYPE;
2671: l_rep_context_lvl_mng VARCHAR2(80);
2672: l_rep_context_lvl_code VARCHAR2(30);

Line 2669: l_rep_context_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

2665: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2666: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2667: l_rep_context_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2668: l_rep_context_country HR_LOCATIONS_ALL.country%TYPE;
2669: l_rep_context_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2670: l_rep_context_phone_number HR_LOCATIONS_ALL.telephone_number_1%TYPE;
2671: l_rep_context_lvl_mng VARCHAR2(80);
2672: l_rep_context_lvl_code VARCHAR2(30);
2673: l_matrix_report_flag VARCHAR2(30);

Line 2670: l_rep_context_phone_number HR_LOCATIONS_ALL.telephone_number_1%TYPE;

2666: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2667: l_rep_context_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2668: l_rep_context_country HR_LOCATIONS_ALL.country%TYPE;
2669: l_rep_context_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2670: l_rep_context_phone_number HR_LOCATIONS_ALL.telephone_number_1%TYPE;
2671: l_rep_context_lvl_mng VARCHAR2(80);
2672: l_rep_context_lvl_code VARCHAR2(30);
2673: l_matrix_report_flag VARCHAR2(30);
2674: l_rep_context_entity_region1 VARCHAR2(30);

Line 3266: l_style HR_LOCATIONS_ALL.STYLE%type;

3262: ----------------------------
3263: pr_segments FND_DFLEX.SEGMENTS_DR;
3264: pr_contexts FND_DFLEX.CONTEXTS_DR;
3265: i BINARY_INTEGER;
3266: l_style HR_LOCATIONS_ALL.STYLE%type;
3267: l_context NUMBER;
3268: l_column VARCHAR2(150);
3269:
3270: BEGIN