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_GEO_UI_UTIL_PUB dependencies on HZ_ADDRESS_USAGES_PUB

Line 165: l_address_usages_rec HZ_ADDRESS_USAGES_PUB.address_usages_rec_type;

161: j number;
162: k number := 1;
163: l number := 0;
164:
165: l_address_usages_rec HZ_ADDRESS_USAGES_PUB.address_usages_rec_type;
166: l_address_usage_dtls_tbl HZ_ADDRESS_USAGES_PUB.address_usage_dtls_tbl_type;
167: l_address_usage_dtls_del_tbl HZ_ADDRESS_USAGES_PUB.address_usage_dtls_tbl_type;
168:
169: l_return_status VARCHAR2(10);

Line 166: l_address_usage_dtls_tbl HZ_ADDRESS_USAGES_PUB.address_usage_dtls_tbl_type;

162: k number := 1;
163: l number := 0;
164:
165: l_address_usages_rec HZ_ADDRESS_USAGES_PUB.address_usages_rec_type;
166: l_address_usage_dtls_tbl HZ_ADDRESS_USAGES_PUB.address_usage_dtls_tbl_type;
167: l_address_usage_dtls_del_tbl HZ_ADDRESS_USAGES_PUB.address_usage_dtls_tbl_type;
168:
169: l_return_status VARCHAR2(10);
170: l_msg_data VARCHAR2(2000);

Line 167: l_address_usage_dtls_del_tbl HZ_ADDRESS_USAGES_PUB.address_usage_dtls_tbl_type;

163: l number := 0;
164:
165: l_address_usages_rec HZ_ADDRESS_USAGES_PUB.address_usages_rec_type;
166: l_address_usage_dtls_tbl HZ_ADDRESS_USAGES_PUB.address_usage_dtls_tbl_type;
167: l_address_usage_dtls_del_tbl HZ_ADDRESS_USAGES_PUB.address_usage_dtls_tbl_type;
168:
169: l_return_status VARCHAR2(10);
170: l_msg_data VARCHAR2(2000);
171: l_msg_count NUMBER;

Line 247: hz_address_usages_pub.create_address_usages(p_address_usages_rec => l_address_usages_rec,

243: end if;
244: END LOOP;
245: if(l_address_usage_dtls_tbl.count > 0)
246: then
247: hz_address_usages_pub.create_address_usages(p_address_usages_rec => l_address_usages_rec,
248: p_address_usage_dtls_tbl => l_address_usage_dtls_tbl,
249: p_init_msg_list => FND_API.G_FALSE,
250: x_usage_id => l_tax_id_ret,
251: x_return_status => l_return_status,

Line 287: hz_address_usages_pub.create_address_usage_dtls(

283: l_address_usage_dtls_tbl(1).geography_type := p_tax_tbl(i).geography_type;
284: l_address_usage_dtls_tbl(1).created_by_module := 'HZ_GEO_HIERARCHY';
285: l_address_usage_dtls_tbl(1).application_id := 222;
286: -- insert dtl record
287: hz_address_usages_pub.create_address_usage_dtls(
288: p_usage_id => l_tax_usage_id,
289: p_address_usage_dtls_tbl => l_address_usage_dtls_tbl,
290: x_usage_dtl_id => l_tax_id_ret,
291: p_init_msg_list => FND_API.G_FALSE,

Line 332: hz_address_usages_pub.delete_address_usages(p_usage_id => l_tax_usage_id,

328: END LOOP;
329:
330: if del_usg = true and (del_all_usg = false or l <> p_tax_tbl.last)
331: then
332: hz_address_usages_pub.delete_address_usages(p_usage_id => l_tax_usage_id,
333: p_address_usage_dtls_tbl => l_address_usage_dtls_del_tbl,
334: p_init_msg_list => FND_API.G_FALSE,
335: x_return_status => l_return_status,
336: x_msg_count => l_msg_count,

Line 346: hz_address_usages_pub.delete_address_usages(p_usage_id => l_tax_usage_id,

342:
343: elsif del_usg = true and (del_all_usg = true and (l = p_tax_tbl.last ))
344: then
345: l_address_usage_dtls_del_tbl.delete;
346: hz_address_usages_pub.delete_address_usages(p_usage_id => l_tax_usage_id,
347: p_address_usage_dtls_tbl => l_address_usage_dtls_del_tbl,
348: p_init_msg_list => FND_API.G_FALSE,
349: x_return_status => l_return_status,
350: x_msg_count => l_msg_count,

Line 402: hz_address_usages_pub.create_address_usages(p_address_usages_rec => l_address_usages_rec,

398: end if;
399: END LOOP;
400: if(l_address_usage_dtls_tbl.count > 0)
401: then
402: hz_address_usages_pub.create_address_usages(p_address_usages_rec => l_address_usages_rec,
403: p_address_usage_dtls_tbl => l_address_usage_dtls_tbl,
404: p_init_msg_list => FND_API.G_FALSE,
405: x_usage_id => l_geo_id_ret,
406: x_return_status => l_return_status,

Line 440: hz_address_usages_pub.create_address_usage_dtls(

436: l_address_usage_dtls_tbl(1).geography_type := p_geo_tbl(i).geography_type;
437: l_address_usage_dtls_tbl(1).created_by_module := 'HZ_GEO_HIERARCHY';
438: l_address_usage_dtls_tbl(1).application_id := 222;
439: -- insert dtl record
440: hz_address_usages_pub.create_address_usage_dtls(
441: p_usage_id => l_geo_usage_id,
442: p_address_usage_dtls_tbl => l_address_usage_dtls_tbl,
443: x_usage_dtl_id => l_geo_id_ret,
444: p_init_msg_list => FND_API.G_FALSE,

Line 484: hz_address_usages_pub.delete_address_usages(p_usage_id => l_geo_usage_id,

480: END LOOP;
481:
482: if del_usg = true and (del_all_usg = false or l <> p_geo_tbl.last)
483: then
484: hz_address_usages_pub.delete_address_usages(p_usage_id => l_geo_usage_id,
485: p_address_usage_dtls_tbl => l_address_usage_dtls_del_tbl,
486: p_init_msg_list => FND_API.G_FALSE,
487: x_return_status => l_return_status,
488: x_msg_count => l_msg_count,

Line 498: hz_address_usages_pub.delete_address_usages(p_usage_id => l_geo_usage_id,

494:
495: elsif del_usg = true and (del_all_usg = true and (l = p_geo_tbl.last ))
496: then
497: l_address_usage_dtls_del_tbl.delete;
498: hz_address_usages_pub.delete_address_usages(p_usage_id => l_geo_usage_id,
499: p_address_usage_dtls_tbl => l_address_usage_dtls_del_tbl,
500: p_init_msg_list => FND_API.G_FALSE,
501: x_return_status => l_return_status,
502: x_msg_count => l_msg_count,