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.
PACKAGE: APPS.HR_LOCATION_RECORD

Source


1 PACKAGE hr_location_record AUTHID CURRENT_USER AS
2 /* $Header: hrlocqry.pkh 120.0.12010000.3 2009/01/22 09:45:33 srgnanas noship $ */
3 /*#
4 * This is the source file to query location details
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname HR_LOCATION
8 */
9 
10 TYPE location_rectype IS RECORD
11 	(
12 	location_id hr_locations.location_id%TYPE,
13 	location_code hr_locations.location_code%TYPE,
14 	location_use hr_locations.location_use%TYPE,
15 	business_group_id hr_locations.business_group_id%TYPE,
16 	description hr_locations.description%TYPE,
17 	ship_to_location_id hr_locations.ship_to_location_id%TYPE,
18 	ship_to_site_flag hr_locations.ship_to_site_flag%TYPE,
19 	receiving_site_flag hr_locations.receiving_site_flag%TYPE,
20 	bill_to_site_flag hr_locations.bill_to_site_flag%TYPE,
21 	in_organization_flag hr_locations.in_organization_flag%TYPE,
22 	office_site_flag hr_locations.office_site_flag%TYPE,
23 	designated_receiver_id hr_locations.designated_receiver_id%TYPE,
24 	inventory_organization_id hr_locations.inventory_organization_id%TYPE,
25 	tax_name hr_locations.tax_name%TYPE,
26 	inactive_date hr_locations.inactive_date%TYPE,
27 	style hr_locations.style%TYPE,
28 	address_line_1 hr_locations.address_line_1%TYPE,
29 	address_line_2 hr_locations.address_line_2%TYPE,
30 	address_line_3 hr_locations.address_line_3%TYPE,
31 	town_or_city hr_locations.town_or_city%TYPE,
32 	country hr_locations.country%TYPE,
33 	postal_code hr_locations.postal_code%TYPE,
34 	region_1 hr_locations.region_1%TYPE,
35 	region_2 hr_locations.region_2%TYPE,
36 	region_3 hr_locations.region_3%TYPE,
37 	telephone_number_1 hr_locations.telephone_number_1%TYPE,
38 	telephone_number_2 hr_locations.telephone_number_2%TYPE,
39 	telephone_number_3 hr_locations.telephone_number_3%TYPE,
40 	loc_information13 hr_locations.loc_information13%TYPE,
41 	loc_information14 hr_locations.loc_information14%TYPE,
42 	loc_information15 hr_locations.loc_information15%TYPE,
43 	loc_information16 hr_locations.loc_information16%TYPE,
44 	loc_information17 hr_locations.loc_information17%TYPE,
45 	loc_information18 hr_locations.loc_information18%TYPE,
46 	loc_information19 hr_locations.loc_information19%TYPE,
47 	loc_information20 hr_locations.loc_information20%TYPE,
48 	attribute_category hr_locations.attribute_category%TYPE,
49 	attribute1 hr_locations.attribute1%TYPE,
50 	attribute2 hr_locations.attribute2%TYPE,
51 	attribute3 hr_locations.attribute3%TYPE,
52 	attribute4 hr_locations.attribute4%TYPE,
53 	attribute5 hr_locations.attribute5%TYPE,
54 	attribute6 hr_locations.attribute6%TYPE,
55 	attribute7 hr_locations.attribute7%TYPE,
56 	attribute8 hr_locations.attribute8%TYPE,
57 	attribute9 hr_locations.attribute9%TYPE,
58 	attribute10 hr_locations.attribute10%TYPE,
59 	attribute11 hr_locations.attribute11%TYPE,
60 	attribute12 hr_locations.attribute12%TYPE,
61 	attribute13 hr_locations.attribute13%TYPE,
62 	attribute14 hr_locations.attribute14%TYPE,
63 	attribute15 hr_locations.attribute15%TYPE,
64 	attribute16 hr_locations.attribute16%TYPE,
65 	attribute17 hr_locations.attribute17%TYPE,
66 	attribute18 hr_locations.attribute18%TYPE,
67 	attribute19 hr_locations.attribute19%TYPE,
68 	attribute20 hr_locations.attribute20%TYPE,
69 	global_attribute_category hr_locations.global_attribute_category%TYPE,
70 	global_attribute1 hr_locations.global_attribute1%TYPE,
71 	global_attribute2 hr_locations.global_attribute2%TYPE,
72 	global_attribute3 hr_locations.global_attribute3%TYPE,
73 	global_attribute4 hr_locations.global_attribute4%TYPE,
74 	global_attribute5 hr_locations.global_attribute5%TYPE,
75 	global_attribute6 hr_locations.global_attribute6%TYPE,
76 	global_attribute7 hr_locations.global_attribute7%TYPE,
77 	global_attribute8 hr_locations.global_attribute8%TYPE,
78 	global_attribute9 hr_locations.global_attribute9%TYPE,
79 	global_attribute10 hr_locations.global_attribute10%TYPE,
80 	global_attribute11 hr_locations.global_attribute11%TYPE,
81 	global_attribute12 hr_locations.global_attribute12%TYPE,
82 	global_attribute13 hr_locations.global_attribute13%TYPE,
83 	global_attribute14 hr_locations.global_attribute14%TYPE,
84 	global_attribute15 hr_locations.global_attribute15%TYPE,
85 	global_attribute16 hr_locations.global_attribute16%TYPE,
86 	global_attribute17 hr_locations.global_attribute17%TYPE,
87 	global_attribute18 hr_locations.global_attribute18%TYPE,
88 	global_attribute19 hr_locations.global_attribute19%TYPE,
89 	global_attribute20 hr_locations.global_attribute20%TYPE,
90 	last_update_date hr_locations.last_update_date%TYPE,
94 	creation_date hr_locations.creation_date%TYPE,
91 	last_updated_by hr_locations.last_updated_by%TYPE,
92 	last_update_login hr_locations.last_update_login%TYPE,
93 	created_by hr_locations.created_by%TYPE,
95 	entered_by hr_locations.entered_by%TYPE,
96 	tp_header_id hr_locations.tp_header_id%TYPE,
97 	ece_tp_location_code hr_locations.ece_tp_location_code%TYPE,
98 	object_version_number hr_locations.object_version_number%TYPE,
99 	legal_address_flag hr_locations.legal_address_flag%TYPE,
100 	timezone_code hr_locations.timezone_code%TYPE
101 	);
102 
103 TYPE location_tabletype IS TABLE OF location_rectype NOT NULL;
104 
105 TYPE location_input_rectype IS RECORD
106     (
107         location_id               hr_locations.location_id%TYPE DEFAULT NULL,
108         start_location_id         hr_locations.location_id%TYPE DEFAULT NULL,
109         end_location_id           hr_locations.location_id%TYPE DEFAULT NULL,
110         business_group_id         hr_locations.business_group_id%TYPE DEFAULT NULL
111     );
112 
113 /*#
114 * This is procedure for querying location details.
115 * @rep:displayname Get Location Details
116 * @rep:category BUSINESS_ENTITY HR_LOCATION
117 * @rep:scope public
118 * @rep:lifecycle active
119 */
120 PROCEDURE get_location_details(p_query_options  IN  location_input_rectype
121                               ,p_locations      OUT NOCOPY location_tabletype);
122 END hr_location_record;