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.HZ_GNR_UTIL_PKG dependencies on HZ_LOCATION_V2PUB

Line 146: HZ_LOCATION_V2PUB

142: Procedure to do pre-update processing for a given location record. This will
143: be used in GNR program, where it updates the location components.
144:
145: EXTERNAL PROCEDURES/FUNCTIONS ACCESSED :
146: HZ_LOCATION_V2PUB
147: hz_fuzzy_pub
148: hz_timezone_pub
149:
150: ARGUMENTS :

Line 151: IN p_old_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE

147: hz_fuzzy_pub
148: hz_timezone_pub
149:
150: ARGUMENTS :
151: IN p_old_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
152:
153: IN OUT p_new_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
154: IN OUT p_other_location_params HZ_GNR_UTIL_PKG.location_other_param_rec_type
155: (extendible - for future use)

Line 153: IN OUT p_new_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE

149:
150: ARGUMENTS :
151: IN p_old_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
152:
153: IN OUT p_new_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
154: IN OUT p_other_location_params HZ_GNR_UTIL_PKG.location_other_param_rec_type
155: (extendible - for future use)
156:
157: MODIFICATION HISTORY:

Line 161: p_old_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,

157: MODIFICATION HISTORY:
158: 16-FEB-2006 Nishant Singhai Created
159: **/
160: PROCEDURE pre_location_update (
161: p_old_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
162: p_new_location_rec IN OUT NOCOPY HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
163: p_other_location_params IN OUT NOCOPY HZ_GNR_UTIL_PKG.loc_other_param_rec_type,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,

Line 162: p_new_location_rec IN OUT NOCOPY HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,

158: 16-FEB-2006 Nishant Singhai Created
159: **/
160: PROCEDURE pre_location_update (
161: p_old_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
162: p_new_location_rec IN OUT NOCOPY HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
163: p_other_location_params IN OUT NOCOPY HZ_GNR_UTIL_PKG.loc_other_param_rec_type,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2

Line 179: -- Same code as in HZ_LOCATION_V2PUB.UPDATE_LOCATION (to make it modular)

175: BEGIN
176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177:
178: -- get timezone id for changed location, if timezone_id is NULL
179: -- Same code as in HZ_LOCATION_V2PUB.UPDATE_LOCATION (to make it modular)
180: IF (p_new_location_rec.country IS NOT NULL AND
181: NVL(UPPER(p_old_location_rec.country), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.country))
182: OR (p_new_location_rec.city IS NOT NULL AND
183: NVL(UPPER(p_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.city))

Line 249: HZ_LOCATION_V2PUB

245: Procedure to do post-update processing for a given location record. This will
246: be used in GNR program, where it updates the location components.
247:
248: EXTERNAL PROCEDURES/FUNCTIONS ACCESSED :
249: HZ_LOCATION_V2PUB
250: HZ_UTILITY_V2PUB
251: HZ_DQM_SYNC
252: HZ_BUSINESS_EVENT_V2PVT
253: HZ_POPULATE_BOT_PKG

Line 256: IN p_old_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE

252: HZ_BUSINESS_EVENT_V2PVT
253: HZ_POPULATE_BOT_PKG
254:
255: ARGUMENTS :
256: IN p_old_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
257:
258: IN OUT p_new_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
259: IN OUT p_other_location_params HZ_GNR_UTIL_PKG.location_other_param_rec_type
260: (extendible - for future use)

Line 258: IN OUT p_new_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE

254:
255: ARGUMENTS :
256: IN p_old_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
257:
258: IN OUT p_new_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
259: IN OUT p_other_location_params HZ_GNR_UTIL_PKG.location_other_param_rec_type
260: (extendible - for future use)
261:
262: MODIFICATION HISTORY:

Line 266: p_old_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,

262: MODIFICATION HISTORY:
263: 16-FEB-2006 Nishant Singhai Created
264: **/
265: PROCEDURE post_location_update (
266: p_old_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
267: p_new_location_rec IN OUT NOCOPY HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
268: p_other_location_params IN OUT NOCOPY HZ_GNR_UTIL_PKG.loc_other_param_rec_type,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,

Line 267: p_new_location_rec IN OUT NOCOPY HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,

263: 16-FEB-2006 Nishant Singhai Created
264: **/
265: PROCEDURE post_location_update (
266: p_old_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
267: p_new_location_rec IN OUT NOCOPY HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
268: p_other_location_params IN OUT NOCOPY HZ_GNR_UTIL_PKG.loc_other_param_rec_type,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
271: x_msg_data OUT NOCOPY VARCHAR2

Line 2223: l_old_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;

2219: db_wh_update_date DATE;
2220:
2221: l_location_profile_rec hz_location_profile_pvt.location_profile_rec_type;
2222: l_loc_components_rec loc_components_rec_type;
2223: l_old_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
2224: l_new_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
2225: l_other_param_rec HZ_GNR_UTIL_PKG.loc_other_param_rec_type;
2226: l_wh_update_date DATE;
2227: l_address1 VARCHAR2(240);

Line 2224: l_new_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;

2220:
2221: l_location_profile_rec hz_location_profile_pvt.location_profile_rec_type;
2222: l_loc_components_rec loc_components_rec_type;
2223: l_old_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
2224: l_new_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
2225: l_other_param_rec HZ_GNR_UTIL_PKG.loc_other_param_rec_type;
2226: l_wh_update_date DATE;
2227: l_address1 VARCHAR2(240);
2228: l_address2 VARCHAR2(240);