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.PN_EXP_TO_CAD_ITF dependencies on PN_LOCATIONS

Line 7: -- ( PN_LOCATIONS --> PN_LOCATIONS_ITF )

3:
4: -------------------------------------------------------------------
5: -- for loading Locations Info into the Interface Table ( FOR CAFM )
6: -- ( Run AS a Conc Process )
7: -- ( PN_LOCATIONS --> PN_LOCATIONS_ITF )
8: -- 30-AUG-06 Shabda o As part of bug # 5449595, we now pas canonical dates
9: -- This method expects non canonical too, so we change it back to non canonical.
10: -------------------------------------------------------------------
11: PROCEDURE exp_to_cad_itf (

Line 80: -- ( PN_LOCATIONS --> PN_LOCATIONS_ITF )

76:
77: -----------------------------------------------------------------------------
78: -- FOR loading Locations Info into the Interface Table ( FOR CAFM )
79: -- ( Run AS a Conc Process )
80: -- ( PN_LOCATIONS --> PN_LOCATIONS_ITF )
81: -- 15-JUL-05 hareesha o Bug 4284035 - Replaced pn_addresses with _ALL table.
82: -- 29-SEP-05 Hareesha o ATG mandated changes for SQL literals using dbms_sql.
83: -----------------------------------------------------------------------------
84: PROCEDURE exp_loc_to_cad_itf (

Line 116: v_location_id PN_LOCATIONS.LOCATION_ID%TYPE;

112: v_counter NUMBER := 0;
113: v_fail NUMBER := 0;
114: v_success NUMBER := 0;
115:
116: v_location_id PN_LOCATIONS.LOCATION_ID%TYPE;
117: v_location_code PN_LOCATIONS.LOCATION_CODE%TYPE;
118: v_location_type_lookup_code PN_LOCATIONS.LOCATION_TYPE_LOOKUP_CODE%TYPE;
119: v_space_type_lookup_code PN_LOCATIONS.SPACE_TYPE_LOOKUP_CODE%TYPE;
120: v_last_update_date PN_LOCATIONS.LAST_UPDATE_DATE%TYPE;

Line 117: v_location_code PN_LOCATIONS.LOCATION_CODE%TYPE;

113: v_fail NUMBER := 0;
114: v_success NUMBER := 0;
115:
116: v_location_id PN_LOCATIONS.LOCATION_ID%TYPE;
117: v_location_code PN_LOCATIONS.LOCATION_CODE%TYPE;
118: v_location_type_lookup_code PN_LOCATIONS.LOCATION_TYPE_LOOKUP_CODE%TYPE;
119: v_space_type_lookup_code PN_LOCATIONS.SPACE_TYPE_LOOKUP_CODE%TYPE;
120: v_last_update_date PN_LOCATIONS.LAST_UPDATE_DATE%TYPE;
121: v_creation_date PN_LOCATIONS.CREATION_DATE%TYPE;

Line 118: v_location_type_lookup_code PN_LOCATIONS.LOCATION_TYPE_LOOKUP_CODE%TYPE;

114: v_success NUMBER := 0;
115:
116: v_location_id PN_LOCATIONS.LOCATION_ID%TYPE;
117: v_location_code PN_LOCATIONS.LOCATION_CODE%TYPE;
118: v_location_type_lookup_code PN_LOCATIONS.LOCATION_TYPE_LOOKUP_CODE%TYPE;
119: v_space_type_lookup_code PN_LOCATIONS.SPACE_TYPE_LOOKUP_CODE%TYPE;
120: v_last_update_date PN_LOCATIONS.LAST_UPDATE_DATE%TYPE;
121: v_creation_date PN_LOCATIONS.CREATION_DATE%TYPE;
122: v_parent_location_id PN_LOCATIONS.PARENT_LOCATION_ID%TYPE;

Line 119: v_space_type_lookup_code PN_LOCATIONS.SPACE_TYPE_LOOKUP_CODE%TYPE;

115:
116: v_location_id PN_LOCATIONS.LOCATION_ID%TYPE;
117: v_location_code PN_LOCATIONS.LOCATION_CODE%TYPE;
118: v_location_type_lookup_code PN_LOCATIONS.LOCATION_TYPE_LOOKUP_CODE%TYPE;
119: v_space_type_lookup_code PN_LOCATIONS.SPACE_TYPE_LOOKUP_CODE%TYPE;
120: v_last_update_date PN_LOCATIONS.LAST_UPDATE_DATE%TYPE;
121: v_creation_date PN_LOCATIONS.CREATION_DATE%TYPE;
122: v_parent_location_id PN_LOCATIONS.PARENT_LOCATION_ID%TYPE;
123: v_lease_or_owned PN_LOCATIONS.LEASE_OR_OWNED%TYPE;

Line 120: v_last_update_date PN_LOCATIONS.LAST_UPDATE_DATE%TYPE;

116: v_location_id PN_LOCATIONS.LOCATION_ID%TYPE;
117: v_location_code PN_LOCATIONS.LOCATION_CODE%TYPE;
118: v_location_type_lookup_code PN_LOCATIONS.LOCATION_TYPE_LOOKUP_CODE%TYPE;
119: v_space_type_lookup_code PN_LOCATIONS.SPACE_TYPE_LOOKUP_CODE%TYPE;
120: v_last_update_date PN_LOCATIONS.LAST_UPDATE_DATE%TYPE;
121: v_creation_date PN_LOCATIONS.CREATION_DATE%TYPE;
122: v_parent_location_id PN_LOCATIONS.PARENT_LOCATION_ID%TYPE;
123: v_lease_or_owned PN_LOCATIONS.LEASE_OR_OWNED%TYPE;
124: v_building PN_LOCATIONS.BUILDING%TYPE;

Line 121: v_creation_date PN_LOCATIONS.CREATION_DATE%TYPE;

117: v_location_code PN_LOCATIONS.LOCATION_CODE%TYPE;
118: v_location_type_lookup_code PN_LOCATIONS.LOCATION_TYPE_LOOKUP_CODE%TYPE;
119: v_space_type_lookup_code PN_LOCATIONS.SPACE_TYPE_LOOKUP_CODE%TYPE;
120: v_last_update_date PN_LOCATIONS.LAST_UPDATE_DATE%TYPE;
121: v_creation_date PN_LOCATIONS.CREATION_DATE%TYPE;
122: v_parent_location_id PN_LOCATIONS.PARENT_LOCATION_ID%TYPE;
123: v_lease_or_owned PN_LOCATIONS.LEASE_OR_OWNED%TYPE;
124: v_building PN_LOCATIONS.BUILDING%TYPE;
125: v_floor PN_LOCATIONS.FLOOR%TYPE;

Line 122: v_parent_location_id PN_LOCATIONS.PARENT_LOCATION_ID%TYPE;

118: v_location_type_lookup_code PN_LOCATIONS.LOCATION_TYPE_LOOKUP_CODE%TYPE;
119: v_space_type_lookup_code PN_LOCATIONS.SPACE_TYPE_LOOKUP_CODE%TYPE;
120: v_last_update_date PN_LOCATIONS.LAST_UPDATE_DATE%TYPE;
121: v_creation_date PN_LOCATIONS.CREATION_DATE%TYPE;
122: v_parent_location_id PN_LOCATIONS.PARENT_LOCATION_ID%TYPE;
123: v_lease_or_owned PN_LOCATIONS.LEASE_OR_OWNED%TYPE;
124: v_building PN_LOCATIONS.BUILDING%TYPE;
125: v_floor PN_LOCATIONS.FLOOR%TYPE;
126: v_office PN_LOCATIONS.OFFICE%TYPE;

Line 123: v_lease_or_owned PN_LOCATIONS.LEASE_OR_OWNED%TYPE;

119: v_space_type_lookup_code PN_LOCATIONS.SPACE_TYPE_LOOKUP_CODE%TYPE;
120: v_last_update_date PN_LOCATIONS.LAST_UPDATE_DATE%TYPE;
121: v_creation_date PN_LOCATIONS.CREATION_DATE%TYPE;
122: v_parent_location_id PN_LOCATIONS.PARENT_LOCATION_ID%TYPE;
123: v_lease_or_owned PN_LOCATIONS.LEASE_OR_OWNED%TYPE;
124: v_building PN_LOCATIONS.BUILDING%TYPE;
125: v_floor PN_LOCATIONS.FLOOR%TYPE;
126: v_office PN_LOCATIONS.OFFICE%TYPE;
127: v_address_line1 PN_ADDRESSES.ADDRESS_LINE1%TYPE;

Line 124: v_building PN_LOCATIONS.BUILDING%TYPE;

120: v_last_update_date PN_LOCATIONS.LAST_UPDATE_DATE%TYPE;
121: v_creation_date PN_LOCATIONS.CREATION_DATE%TYPE;
122: v_parent_location_id PN_LOCATIONS.PARENT_LOCATION_ID%TYPE;
123: v_lease_or_owned PN_LOCATIONS.LEASE_OR_OWNED%TYPE;
124: v_building PN_LOCATIONS.BUILDING%TYPE;
125: v_floor PN_LOCATIONS.FLOOR%TYPE;
126: v_office PN_LOCATIONS.OFFICE%TYPE;
127: v_address_line1 PN_ADDRESSES.ADDRESS_LINE1%TYPE;
128: v_address_line2 PN_ADDRESSES.ADDRESS_LINE2%TYPE;

Line 125: v_floor PN_LOCATIONS.FLOOR%TYPE;

121: v_creation_date PN_LOCATIONS.CREATION_DATE%TYPE;
122: v_parent_location_id PN_LOCATIONS.PARENT_LOCATION_ID%TYPE;
123: v_lease_or_owned PN_LOCATIONS.LEASE_OR_OWNED%TYPE;
124: v_building PN_LOCATIONS.BUILDING%TYPE;
125: v_floor PN_LOCATIONS.FLOOR%TYPE;
126: v_office PN_LOCATIONS.OFFICE%TYPE;
127: v_address_line1 PN_ADDRESSES.ADDRESS_LINE1%TYPE;
128: v_address_line2 PN_ADDRESSES.ADDRESS_LINE2%TYPE;
129: v_address_line3 PN_ADDRESSES.ADDRESS_LINE3%TYPE;

Line 126: v_office PN_LOCATIONS.OFFICE%TYPE;

122: v_parent_location_id PN_LOCATIONS.PARENT_LOCATION_ID%TYPE;
123: v_lease_or_owned PN_LOCATIONS.LEASE_OR_OWNED%TYPE;
124: v_building PN_LOCATIONS.BUILDING%TYPE;
125: v_floor PN_LOCATIONS.FLOOR%TYPE;
126: v_office PN_LOCATIONS.OFFICE%TYPE;
127: v_address_line1 PN_ADDRESSES.ADDRESS_LINE1%TYPE;
128: v_address_line2 PN_ADDRESSES.ADDRESS_LINE2%TYPE;
129: v_address_line3 PN_ADDRESSES.ADDRESS_LINE3%TYPE;
130: v_address_line4 PN_ADDRESSES.ADDRESS_LINE4%TYPE;

Line 138: v_max_capacity PN_LOCATIONS.MAX_CAPACITY%TYPE;

134: v_province PN_ADDRESSES.PROVINCE%TYPE;
135: v_zip_code PN_ADDRESSES.ZIP_CODE%TYPE;
136: v_country PN_ADDRESSES.COUNTRY%TYPE;
137: v_address_style PN_ADDRESSES.ADDRESS_STYLE%TYPE;
138: v_max_capacity PN_LOCATIONS.MAX_CAPACITY%TYPE;
139: v_rentable_area PN_LOCATIONS.RENTABLE_AREA%TYPE;
140: v_optimum_capacity PN_LOCATIONS.OPTIMUM_CAPACITY%TYPE;
141: v_usable_area PN_LOCATIONS.USABLE_AREA%TYPE;
142: v_allocate_cost_center_code PN_LOCATIONS.ALLOCATE_COST_CENTER_CODE%TYPE;

Line 139: v_rentable_area PN_LOCATIONS.RENTABLE_AREA%TYPE;

135: v_zip_code PN_ADDRESSES.ZIP_CODE%TYPE;
136: v_country PN_ADDRESSES.COUNTRY%TYPE;
137: v_address_style PN_ADDRESSES.ADDRESS_STYLE%TYPE;
138: v_max_capacity PN_LOCATIONS.MAX_CAPACITY%TYPE;
139: v_rentable_area PN_LOCATIONS.RENTABLE_AREA%TYPE;
140: v_optimum_capacity PN_LOCATIONS.OPTIMUM_CAPACITY%TYPE;
141: v_usable_area PN_LOCATIONS.USABLE_AREA%TYPE;
142: v_allocate_cost_center_code PN_LOCATIONS.ALLOCATE_COST_CENTER_CODE%TYPE;
143: v_uom_code PN_LOCATIONS.UOM_CODE%TYPE;

Line 140: v_optimum_capacity PN_LOCATIONS.OPTIMUM_CAPACITY%TYPE;

136: v_country PN_ADDRESSES.COUNTRY%TYPE;
137: v_address_style PN_ADDRESSES.ADDRESS_STYLE%TYPE;
138: v_max_capacity PN_LOCATIONS.MAX_CAPACITY%TYPE;
139: v_rentable_area PN_LOCATIONS.RENTABLE_AREA%TYPE;
140: v_optimum_capacity PN_LOCATIONS.OPTIMUM_CAPACITY%TYPE;
141: v_usable_area PN_LOCATIONS.USABLE_AREA%TYPE;
142: v_allocate_cost_center_code PN_LOCATIONS.ALLOCATE_COST_CENTER_CODE%TYPE;
143: v_uom_code PN_LOCATIONS.UOM_CODE%TYPE;
144: v_last_update_login PN_LOCATIONS.LAST_UPDATE_LOGIN%TYPE;

Line 141: v_usable_area PN_LOCATIONS.USABLE_AREA%TYPE;

137: v_address_style PN_ADDRESSES.ADDRESS_STYLE%TYPE;
138: v_max_capacity PN_LOCATIONS.MAX_CAPACITY%TYPE;
139: v_rentable_area PN_LOCATIONS.RENTABLE_AREA%TYPE;
140: v_optimum_capacity PN_LOCATIONS.OPTIMUM_CAPACITY%TYPE;
141: v_usable_area PN_LOCATIONS.USABLE_AREA%TYPE;
142: v_allocate_cost_center_code PN_LOCATIONS.ALLOCATE_COST_CENTER_CODE%TYPE;
143: v_uom_code PN_LOCATIONS.UOM_CODE%TYPE;
144: v_last_update_login PN_LOCATIONS.LAST_UPDATE_LOGIN%TYPE;
145: v_last_updated_by PN_LOCATIONS.LAST_UPDATED_BY%TYPE;

Line 142: v_allocate_cost_center_code PN_LOCATIONS.ALLOCATE_COST_CENTER_CODE%TYPE;

138: v_max_capacity PN_LOCATIONS.MAX_CAPACITY%TYPE;
139: v_rentable_area PN_LOCATIONS.RENTABLE_AREA%TYPE;
140: v_optimum_capacity PN_LOCATIONS.OPTIMUM_CAPACITY%TYPE;
141: v_usable_area PN_LOCATIONS.USABLE_AREA%TYPE;
142: v_allocate_cost_center_code PN_LOCATIONS.ALLOCATE_COST_CENTER_CODE%TYPE;
143: v_uom_code PN_LOCATIONS.UOM_CODE%TYPE;
144: v_last_update_login PN_LOCATIONS.LAST_UPDATE_LOGIN%TYPE;
145: v_last_updated_by PN_LOCATIONS.LAST_UPDATED_BY%TYPE;
146: v_created_by PN_LOCATIONS.CREATED_BY%TYPE;

Line 143: v_uom_code PN_LOCATIONS.UOM_CODE%TYPE;

139: v_rentable_area PN_LOCATIONS.RENTABLE_AREA%TYPE;
140: v_optimum_capacity PN_LOCATIONS.OPTIMUM_CAPACITY%TYPE;
141: v_usable_area PN_LOCATIONS.USABLE_AREA%TYPE;
142: v_allocate_cost_center_code PN_LOCATIONS.ALLOCATE_COST_CENTER_CODE%TYPE;
143: v_uom_code PN_LOCATIONS.UOM_CODE%TYPE;
144: v_last_update_login PN_LOCATIONS.LAST_UPDATE_LOGIN%TYPE;
145: v_last_updated_by PN_LOCATIONS.LAST_UPDATED_BY%TYPE;
146: v_created_by PN_LOCATIONS.CREATED_BY%TYPE;
147: v_attribute_category VARCHAR2(30);

Line 144: v_last_update_login PN_LOCATIONS.LAST_UPDATE_LOGIN%TYPE;

140: v_optimum_capacity PN_LOCATIONS.OPTIMUM_CAPACITY%TYPE;
141: v_usable_area PN_LOCATIONS.USABLE_AREA%TYPE;
142: v_allocate_cost_center_code PN_LOCATIONS.ALLOCATE_COST_CENTER_CODE%TYPE;
143: v_uom_code PN_LOCATIONS.UOM_CODE%TYPE;
144: v_last_update_login PN_LOCATIONS.LAST_UPDATE_LOGIN%TYPE;
145: v_last_updated_by PN_LOCATIONS.LAST_UPDATED_BY%TYPE;
146: v_created_by PN_LOCATIONS.CREATED_BY%TYPE;
147: v_attribute_category VARCHAR2(30);
148: v_attribute1 VARCHAR2 ( 150 );

Line 145: v_last_updated_by PN_LOCATIONS.LAST_UPDATED_BY%TYPE;

141: v_usable_area PN_LOCATIONS.USABLE_AREA%TYPE;
142: v_allocate_cost_center_code PN_LOCATIONS.ALLOCATE_COST_CENTER_CODE%TYPE;
143: v_uom_code PN_LOCATIONS.UOM_CODE%TYPE;
144: v_last_update_login PN_LOCATIONS.LAST_UPDATE_LOGIN%TYPE;
145: v_last_updated_by PN_LOCATIONS.LAST_UPDATED_BY%TYPE;
146: v_created_by PN_LOCATIONS.CREATED_BY%TYPE;
147: v_attribute_category VARCHAR2(30);
148: v_attribute1 VARCHAR2 ( 150 );
149: v_attribute2 VARCHAR2 ( 150 );

Line 146: v_created_by PN_LOCATIONS.CREATED_BY%TYPE;

142: v_allocate_cost_center_code PN_LOCATIONS.ALLOCATE_COST_CENTER_CODE%TYPE;
143: v_uom_code PN_LOCATIONS.UOM_CODE%TYPE;
144: v_last_update_login PN_LOCATIONS.LAST_UPDATE_LOGIN%TYPE;
145: v_last_updated_by PN_LOCATIONS.LAST_UPDATED_BY%TYPE;
146: v_created_by PN_LOCATIONS.CREATED_BY%TYPE;
147: v_attribute_category VARCHAR2(30);
148: v_attribute1 VARCHAR2 ( 150 );
149: v_attribute2 VARCHAR2 ( 150 );
150: v_attribute3 VARCHAR2 ( 150 );

Line 179: v_source PN_LOCATIONS.SOURCE%TYPE;

175: v_addr_attribute12 VARCHAR2 ( 150 );
176: v_addr_attribute13 VARCHAR2 ( 150 );
177: v_addr_attribute14 VARCHAR2 ( 150 );
178: v_addr_attribute15 VARCHAR2 ( 150 );
179: v_source PN_LOCATIONS.SOURCE%TYPE;
180: v_gross_area PN_LOCATIONS.GROSS_AREA%TYPE;
181: v_assignable_area PN_LOCATIONS.ASSIGNABLE_AREA%TYPE;
182: v_class PN_LOCATIONS.CLASS%TYPE;
183: v_status_type PN_LOCATIONS.STATUS_TYPE%TYPE;

Line 180: v_gross_area PN_LOCATIONS.GROSS_AREA%TYPE;

176: v_addr_attribute13 VARCHAR2 ( 150 );
177: v_addr_attribute14 VARCHAR2 ( 150 );
178: v_addr_attribute15 VARCHAR2 ( 150 );
179: v_source PN_LOCATIONS.SOURCE%TYPE;
180: v_gross_area PN_LOCATIONS.GROSS_AREA%TYPE;
181: v_assignable_area PN_LOCATIONS.ASSIGNABLE_AREA%TYPE;
182: v_class PN_LOCATIONS.CLASS%TYPE;
183: v_status_type PN_LOCATIONS.STATUS_TYPE%TYPE;
184: v_suite PN_LOCATIONS.SUITE%TYPE;

Line 181: v_assignable_area PN_LOCATIONS.ASSIGNABLE_AREA%TYPE;

177: v_addr_attribute14 VARCHAR2 ( 150 );
178: v_addr_attribute15 VARCHAR2 ( 150 );
179: v_source PN_LOCATIONS.SOURCE%TYPE;
180: v_gross_area PN_LOCATIONS.GROSS_AREA%TYPE;
181: v_assignable_area PN_LOCATIONS.ASSIGNABLE_AREA%TYPE;
182: v_class PN_LOCATIONS.CLASS%TYPE;
183: v_status_type PN_LOCATIONS.STATUS_TYPE%TYPE;
184: v_suite PN_LOCATIONS.SUITE%TYPE;
185: v_common_area PN_LOCATIONS.COMMON_AREA%TYPE;

Line 182: v_class PN_LOCATIONS.CLASS%TYPE;

178: v_addr_attribute15 VARCHAR2 ( 150 );
179: v_source PN_LOCATIONS.SOURCE%TYPE;
180: v_gross_area PN_LOCATIONS.GROSS_AREA%TYPE;
181: v_assignable_area PN_LOCATIONS.ASSIGNABLE_AREA%TYPE;
182: v_class PN_LOCATIONS.CLASS%TYPE;
183: v_status_type PN_LOCATIONS.STATUS_TYPE%TYPE;
184: v_suite PN_LOCATIONS.SUITE%TYPE;
185: v_common_area PN_LOCATIONS.COMMON_AREA%TYPE;
186: v_common_area_flag PN_LOCATIONS.COMMON_AREA_FLAG%TYPE;

Line 183: v_status_type PN_LOCATIONS.STATUS_TYPE%TYPE;

179: v_source PN_LOCATIONS.SOURCE%TYPE;
180: v_gross_area PN_LOCATIONS.GROSS_AREA%TYPE;
181: v_assignable_area PN_LOCATIONS.ASSIGNABLE_AREA%TYPE;
182: v_class PN_LOCATIONS.CLASS%TYPE;
183: v_status_type PN_LOCATIONS.STATUS_TYPE%TYPE;
184: v_suite PN_LOCATIONS.SUITE%TYPE;
185: v_common_area PN_LOCATIONS.COMMON_AREA%TYPE;
186: v_common_area_flag PN_LOCATIONS.COMMON_AREA_FLAG%TYPE;
187: v_function_type_lookup_code PN_LOCATIONS.FUNCTION_TYPE_LOOKUP_CODE%TYPE; --BUG#2198182

Line 184: v_suite PN_LOCATIONS.SUITE%TYPE;

180: v_gross_area PN_LOCATIONS.GROSS_AREA%TYPE;
181: v_assignable_area PN_LOCATIONS.ASSIGNABLE_AREA%TYPE;
182: v_class PN_LOCATIONS.CLASS%TYPE;
183: v_status_type PN_LOCATIONS.STATUS_TYPE%TYPE;
184: v_suite PN_LOCATIONS.SUITE%TYPE;
185: v_common_area PN_LOCATIONS.COMMON_AREA%TYPE;
186: v_common_area_flag PN_LOCATIONS.COMMON_AREA_FLAG%TYPE;
187: v_function_type_lookup_code PN_LOCATIONS.FUNCTION_TYPE_LOOKUP_CODE%TYPE; --BUG#2198182
188: v_active_start_date PN_LOCATIONS.ACTIVE_START_DATE%TYPE;

Line 185: v_common_area PN_LOCATIONS.COMMON_AREA%TYPE;

181: v_assignable_area PN_LOCATIONS.ASSIGNABLE_AREA%TYPE;
182: v_class PN_LOCATIONS.CLASS%TYPE;
183: v_status_type PN_LOCATIONS.STATUS_TYPE%TYPE;
184: v_suite PN_LOCATIONS.SUITE%TYPE;
185: v_common_area PN_LOCATIONS.COMMON_AREA%TYPE;
186: v_common_area_flag PN_LOCATIONS.COMMON_AREA_FLAG%TYPE;
187: v_function_type_lookup_code PN_LOCATIONS.FUNCTION_TYPE_LOOKUP_CODE%TYPE; --BUG#2198182
188: v_active_start_date PN_LOCATIONS.ACTIVE_START_DATE%TYPE;
189: v_active_end_date PN_LOCATIONS.ACTIVE_END_DATE%TYPE;

Line 186: v_common_area_flag PN_LOCATIONS.COMMON_AREA_FLAG%TYPE;

182: v_class PN_LOCATIONS.CLASS%TYPE;
183: v_status_type PN_LOCATIONS.STATUS_TYPE%TYPE;
184: v_suite PN_LOCATIONS.SUITE%TYPE;
185: v_common_area PN_LOCATIONS.COMMON_AREA%TYPE;
186: v_common_area_flag PN_LOCATIONS.COMMON_AREA_FLAG%TYPE;
187: v_function_type_lookup_code PN_LOCATIONS.FUNCTION_TYPE_LOOKUP_CODE%TYPE; --BUG#2198182
188: v_active_start_date PN_LOCATIONS.ACTIVE_START_DATE%TYPE;
189: v_active_end_date PN_LOCATIONS.ACTIVE_END_DATE%TYPE;
190: l_cursor INTEGER;

Line 187: v_function_type_lookup_code PN_LOCATIONS.FUNCTION_TYPE_LOOKUP_CODE%TYPE; --BUG#2198182

183: v_status_type PN_LOCATIONS.STATUS_TYPE%TYPE;
184: v_suite PN_LOCATIONS.SUITE%TYPE;
185: v_common_area PN_LOCATIONS.COMMON_AREA%TYPE;
186: v_common_area_flag PN_LOCATIONS.COMMON_AREA_FLAG%TYPE;
187: v_function_type_lookup_code PN_LOCATIONS.FUNCTION_TYPE_LOOKUP_CODE%TYPE; --BUG#2198182
188: v_active_start_date PN_LOCATIONS.ACTIVE_START_DATE%TYPE;
189: v_active_end_date PN_LOCATIONS.ACTIVE_END_DATE%TYPE;
190: l_cursor INTEGER;
191: l_statement VARCHAR2(10000);

Line 188: v_active_start_date PN_LOCATIONS.ACTIVE_START_DATE%TYPE;

184: v_suite PN_LOCATIONS.SUITE%TYPE;
185: v_common_area PN_LOCATIONS.COMMON_AREA%TYPE;
186: v_common_area_flag PN_LOCATIONS.COMMON_AREA_FLAG%TYPE;
187: v_function_type_lookup_code PN_LOCATIONS.FUNCTION_TYPE_LOOKUP_CODE%TYPE; --BUG#2198182
188: v_active_start_date PN_LOCATIONS.ACTIVE_START_DATE%TYPE;
189: v_active_end_date PN_LOCATIONS.ACTIVE_END_DATE%TYPE;
190: l_cursor INTEGER;
191: l_statement VARCHAR2(10000);
192: l_locn_type VARCHAR2(30);

Line 189: v_active_end_date PN_LOCATIONS.ACTIVE_END_DATE%TYPE;

185: v_common_area PN_LOCATIONS.COMMON_AREA%TYPE;
186: v_common_area_flag PN_LOCATIONS.COMMON_AREA_FLAG%TYPE;
187: v_function_type_lookup_code PN_LOCATIONS.FUNCTION_TYPE_LOOKUP_CODE%TYPE; --BUG#2198182
188: v_active_start_date PN_LOCATIONS.ACTIVE_START_DATE%TYPE;
189: v_active_end_date PN_LOCATIONS.ACTIVE_END_DATE%TYPE;
190: l_cursor INTEGER;
191: l_statement VARCHAR2(10000);
192: l_locn_type VARCHAR2(30);
193: l_locn_code_from VARCHAR2(90);

Line 197: v_standard_type_lookup_code PN_LOCATIONS.STANDARD_TYPE_LOOKUP_CODE%TYPE; --BUG#5359173

193: l_locn_code_from VARCHAR2(90);
194: l_locn_code_to VARCHAR2(90);
195: l_rows INTEGER;
196: l_count INTEGER;
197: v_standard_type_lookup_code PN_LOCATIONS.STANDARD_TYPE_LOOKUP_CODE%TYPE; --BUG#5359173
198:
199: BEGIN
200:
201: fnd_message.set_name ('PN','PN_HRSYNC_LOC_TYPE');

Line 279: PN_LOCATIONS L,

275: L.ACTIVE_START_DATE,
276: L.ACTIVE_END_DATE,
277: L.STANDARD_TYPE_LOOKUP_CODE ---BUG#5359173
278: FROM
279: PN_LOCATIONS L,
280: PN_ADDRESSES_ALL A
281: WHERE
282: L.ADDRESS_ID = A.ADDRESS_ID (+)
283: AND L.LAST_UPDATE_DATE >= TRUNC(:date_from )

Line 495: FROM PN_LOCATIONS_ITF

491:
492: BEGIN
493: SELECT 1
494: INTO exists_in_itf
495: FROM PN_LOCATIONS_ITF
496: WHERE location_id = v_location_id
497: AND active_start_date = v_active_start_date
498: AND active_END_date = v_active_end_date;
499: EXCEPTION

Line 517: -- Insert the fetched data into PN_LOCATIONS_ITF table.

513:
514: IF (exists_in_itf = 0) THEN
515:
516:
517: -- Insert the fetched data into PN_LOCATIONS_ITF table.
518:
519: INSERT INTO PN_LOCATIONS_ITF (
520: BATCH_NAME,
521: ENTRY_TYPE,

Line 519: INSERT INTO PN_LOCATIONS_ITF (

515:
516:
517: -- Insert the fetched data into PN_LOCATIONS_ITF table.
518:
519: INSERT INTO PN_LOCATIONS_ITF (
520: BATCH_NAME,
521: ENTRY_TYPE,
522: LOCATION_ID,
523: LOCATION_CODE,

Line 687: UPDATE PN_LOCATIONS_ITF SET

683: -- Update data IN ITF table
684:
685: IF (exists_in_itf = 1) THEN
686:
687: UPDATE PN_LOCATIONS_ITF SET
688: BATCH_NAME = p_batch_name,
689: ENTRY_TYPE = 'U',
690: LOCATION_ID = v_location_id,
691: LOCATION_CODE = v_LOCATION_CODE,

Line 847: -- 15-JUL-05 hareesha o Bug 4284035 - Replaced PN_LOCATIONS with _ALL table.

843: -----------------------------------------------------------------------------
844: -- For loading Space Allocations Info into the Interface Table ( FOR CAFM )
845: -- ( Run AS a Conc Process )
846: -- ( PN_SPACE_ALLOCATIONS --> PN_EMP_SPACE_ASSIGN_ITF )
847: -- 15-JUL-05 hareesha o Bug 4284035 - Replaced PN_LOCATIONS with _ALL table.
848: -- 04-OCT-05 Hareesha o ATG mandated changes for SQL literals using dbms_sql
849: -- 28-AUG-06 Shabda o Bug 5449595 - Added changes to accomodate
850: -- project_id and task_id
851: -- 29-AUG-06 SHABDA o Bug 5449595 - Removed long log messages. Removed unused

Line 969: PN_LOCATIONS LO,

965: SP.UTILIZED_AREA,
966: SP.PROJECT_ID,
967: SP.TASK_ID
968: FROM
969: PN_LOCATIONS LO,
970: PN_SPACE_ASSIGN_EMP_ALL SP
971: WHERE
972: LO.location_id = SP.location_id
973: AND TRUNC(:as_of_date) between