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 2191: l_style HR_LOCATIONS_ALL.style%TYPE;

2187: p_trl_global_variables_rec IN OUT NOCOPY zx_extract_pkg.trl_global_variables_rec_type,
2188: p_rep_entity_id IN NUMBER)
2189: IS
2190:
2191: l_style HR_LOCATIONS_ALL.style%TYPE;
2192: l_extract_summary_code VARCHAR2(80);
2193: l_rep_context_id NUMBER;
2194: l_rep_context_org_id NUMBER;
2195: l_request_id NUMBER;

Line 2198: l_rep_context_loc_id HR_LOCATIONS_ALL.location_id%TYPE;

2194: l_rep_context_org_id NUMBER;
2195: l_request_id NUMBER;
2196: l_rep_entity_id NUMBER;
2197: l_rep_context_tax_reg_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE;
2198: l_rep_context_loc_id HR_LOCATIONS_ALL.location_id%TYPE;
2199: l_rep_context_name HR_ORGANIZATION_UNITS.name%TYPE;
2200: l_rep_context_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2201: l_rep_context_county HR_LOCATIONS_ALL.region_3%TYPE;
2202: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;

Line 2200: l_rep_context_city HR_LOCATIONS_ALL.town_or_city%TYPE;

2196: l_rep_entity_id NUMBER;
2197: l_rep_context_tax_reg_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE;
2198: l_rep_context_loc_id HR_LOCATIONS_ALL.location_id%TYPE;
2199: l_rep_context_name HR_ORGANIZATION_UNITS.name%TYPE;
2200: l_rep_context_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2201: l_rep_context_county HR_LOCATIONS_ALL.region_3%TYPE;
2202: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;
2203: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;
2204: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;

Line 2201: l_rep_context_county HR_LOCATIONS_ALL.region_3%TYPE;

2197: l_rep_context_tax_reg_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE;
2198: l_rep_context_loc_id HR_LOCATIONS_ALL.location_id%TYPE;
2199: l_rep_context_name HR_ORGANIZATION_UNITS.name%TYPE;
2200: l_rep_context_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2201: l_rep_context_county HR_LOCATIONS_ALL.region_3%TYPE;
2202: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;
2203: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;
2204: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2205: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;

Line 2202: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;

2198: l_rep_context_loc_id HR_LOCATIONS_ALL.location_id%TYPE;
2199: l_rep_context_name HR_ORGANIZATION_UNITS.name%TYPE;
2200: l_rep_context_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2201: l_rep_context_county HR_LOCATIONS_ALL.region_3%TYPE;
2202: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;
2203: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;
2204: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2205: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2206: l_rep_context_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;

Line 2203: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;

2199: l_rep_context_name HR_ORGANIZATION_UNITS.name%TYPE;
2200: l_rep_context_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2201: l_rep_context_county HR_LOCATIONS_ALL.region_3%TYPE;
2202: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;
2203: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;
2204: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2205: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2206: l_rep_context_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2207: l_rep_context_country HR_LOCATIONS_ALL.country%TYPE;

Line 2204: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;

2200: l_rep_context_city HR_LOCATIONS_ALL.town_or_city%TYPE;
2201: l_rep_context_county HR_LOCATIONS_ALL.region_3%TYPE;
2202: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;
2203: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;
2204: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2205: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2206: l_rep_context_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2207: l_rep_context_country HR_LOCATIONS_ALL.country%TYPE;
2208: l_rep_context_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

Line 2205: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;

2201: l_rep_context_county HR_LOCATIONS_ALL.region_3%TYPE;
2202: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;
2203: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;
2204: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2205: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2206: l_rep_context_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2207: l_rep_context_country HR_LOCATIONS_ALL.country%TYPE;
2208: l_rep_context_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2209: l_rep_context_phone_number HR_LOCATIONS_ALL.telephone_number_1%TYPE;

Line 2206: l_rep_context_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;

2202: l_rep_context_state HR_LOCATIONS_ALL.region_2%TYPE;
2203: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;
2204: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2205: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2206: l_rep_context_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2207: l_rep_context_country HR_LOCATIONS_ALL.country%TYPE;
2208: l_rep_context_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2209: l_rep_context_phone_number HR_LOCATIONS_ALL.telephone_number_1%TYPE;
2210: l_rep_context_lvl_mng VARCHAR2(80);

Line 2207: l_rep_context_country HR_LOCATIONS_ALL.country%TYPE;

2203: l_rep_context_province HR_LOCATIONS_ALL.region_1%TYPE;
2204: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2205: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2206: l_rep_context_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2207: l_rep_context_country HR_LOCATIONS_ALL.country%TYPE;
2208: l_rep_context_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2209: l_rep_context_phone_number HR_LOCATIONS_ALL.telephone_number_1%TYPE;
2210: l_rep_context_lvl_mng VARCHAR2(80);
2211: l_rep_context_lvl_code VARCHAR2(30);

Line 2208: l_rep_context_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

2204: l_rep_context_address1 HR_LOCATIONS_ALL.address_line_1%TYPE;
2205: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2206: l_rep_context_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2207: l_rep_context_country HR_LOCATIONS_ALL.country%TYPE;
2208: l_rep_context_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2209: l_rep_context_phone_number HR_LOCATIONS_ALL.telephone_number_1%TYPE;
2210: l_rep_context_lvl_mng VARCHAR2(80);
2211: l_rep_context_lvl_code VARCHAR2(30);
2212: l_matrix_report_flag VARCHAR2(30);

Line 2209: l_rep_context_phone_number HR_LOCATIONS_ALL.telephone_number_1%TYPE;

2205: l_rep_context_address2 HR_LOCATIONS_ALL.address_line_2%TYPE;
2206: l_rep_context_address3 HR_LOCATIONS_ALL.address_line_3%TYPE;
2207: l_rep_context_country HR_LOCATIONS_ALL.country%TYPE;
2208: l_rep_context_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
2209: l_rep_context_phone_number HR_LOCATIONS_ALL.telephone_number_1%TYPE;
2210: l_rep_context_lvl_mng VARCHAR2(80);
2211: l_rep_context_lvl_code VARCHAR2(30);
2212: l_matrix_report_flag VARCHAR2(30);
2213: l_rep_context_entity_region1 VARCHAR2(30);

Line 2807: l_style HR_LOCATIONS_ALL.STYLE%type;

2803: ----------------------------
2804: pr_segments FND_DFLEX.SEGMENTS_DR;
2805: pr_contexts FND_DFLEX.CONTEXTS_DR;
2806: i BINARY_INTEGER;
2807: l_style HR_LOCATIONS_ALL.STYLE%type;
2808: l_context NUMBER;
2809: l_column VARCHAR2(150);
2810:
2811: BEGIN