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_ADDRESS_USAGES_PUB dependencies on HZ_ADDRESS_USAGES

Line 1: PACKAGE BODY HZ_ADDRESS_USAGES_PUB AS

1: PACKAGE BODY HZ_ADDRESS_USAGES_PUB AS
2: /* $Header: ARHGNRSB.pls 120.4 2006/04/11 00:27:07 nsinghai noship $ */
3:
4: PROCEDURE do_create_address_usages(
5: p_address_usages_rec IN address_usages_rec_type,

Line 118: SELECT HZ_ADDRESS_USAGES_S.nextval

114:
115:
116: BEGIN --insert row
117:
118: SELECT HZ_ADDRESS_USAGES_S.nextval
119: INTO l_usage_id
120: FROM dual;
121:
122: hz_address_usages_pkg.insert_row(

Line 122: hz_address_usages_pkg.insert_row(

118: SELECT HZ_ADDRESS_USAGES_S.nextval
119: INTO l_usage_id
120: FROM dual;
121:
122: hz_address_usages_pkg.insert_row(
123: l_usage_row_id,
124: l_usage_id,
125: p_address_usages_rec.map_id,
126: p_address_usages_rec.usage_code,

Line 166: SELECT HZ_ADDRESS_USAGES_S.nextval

162:
163: -- The below variable is to display the geography type in case of unique error from pkg API
164: l_geotype := p_address_usage_dtls_tbl(i).geography_type;
165:
166: SELECT HZ_ADDRESS_USAGES_S.nextval
167: INTO l_usage_dtl_id
168: FROM dual;
169:
170: hz_address_usage_dtls_pkg.insert_row(

Line 189: IF p_index_name = 'HZ_ADDRESS_USAGES_U1' THEN

185: WHEN DUP_VAL_ON_INDEX THEN
186: ROLLBACK TO do_create_address_usages;
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
189: IF p_index_name = 'HZ_ADDRESS_USAGES_U1' THEN
190: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_ID');
191: FND_MESSAGE.SET_TOKEN('P_USAGE_ID',l_usage_id);
192: -- Usage ID already exists. Please use a unique ID
193: FND_MSG_PUB.ADD;

Line 195: ELSIF p_index_name = 'HZ_ADDRESS_USAGES_U2' THEN

191: FND_MESSAGE.SET_TOKEN('P_USAGE_ID',l_usage_id);
192: -- Usage ID already exists. Please use a unique ID
193: FND_MSG_PUB.ADD;
194:
195: ELSIF p_index_name = 'HZ_ADDRESS_USAGES_U2' THEN
196: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_USAGE_ROW_EXISTS');
197: FND_MESSAGE.SET_TOKEN('P_USAGE',p_address_usages_rec.usage_code);
198: -- The mapping already exists for this usage. Please use another mapping.
199: FND_MSG_PUB.ADD;

Line 330: db_object_version_number hz_address_usages.object_version_number%TYPE;

326: l_count NUMBER;
327: pkg_name VARCHAR2(1000);
328: l_drp_sql VARCHAR2(1000);
329:
330: db_object_version_number hz_address_usages.object_version_number%TYPE;
331: db_map_id hz_address_usages.map_id%TYPE;
332: db_usage_code hz_address_usages.usage_code%TYPE;
333: db_status_flag hz_address_usages.status_flag%TYPE;
334: db_created_by hz_address_usages.created_by%TYPE;

Line 331: db_map_id hz_address_usages.map_id%TYPE;

327: pkg_name VARCHAR2(1000);
328: l_drp_sql VARCHAR2(1000);
329:
330: db_object_version_number hz_address_usages.object_version_number%TYPE;
331: db_map_id hz_address_usages.map_id%TYPE;
332: db_usage_code hz_address_usages.usage_code%TYPE;
333: db_status_flag hz_address_usages.status_flag%TYPE;
334: db_created_by hz_address_usages.created_by%TYPE;
335: db_creation_date hz_address_usages.creation_date%TYPE;

Line 332: db_usage_code hz_address_usages.usage_code%TYPE;

328: l_drp_sql VARCHAR2(1000);
329:
330: db_object_version_number hz_address_usages.object_version_number%TYPE;
331: db_map_id hz_address_usages.map_id%TYPE;
332: db_usage_code hz_address_usages.usage_code%TYPE;
333: db_status_flag hz_address_usages.status_flag%TYPE;
334: db_created_by hz_address_usages.created_by%TYPE;
335: db_creation_date hz_address_usages.creation_date%TYPE;
336: db_last_updated_by hz_address_usages.last_updated_by%TYPE;

Line 333: db_status_flag hz_address_usages.status_flag%TYPE;

329:
330: db_object_version_number hz_address_usages.object_version_number%TYPE;
331: db_map_id hz_address_usages.map_id%TYPE;
332: db_usage_code hz_address_usages.usage_code%TYPE;
333: db_status_flag hz_address_usages.status_flag%TYPE;
334: db_created_by hz_address_usages.created_by%TYPE;
335: db_creation_date hz_address_usages.creation_date%TYPE;
336: db_last_updated_by hz_address_usages.last_updated_by%TYPE;
337: db_last_update_date hz_address_usages.last_update_date%TYPE;

Line 334: db_created_by hz_address_usages.created_by%TYPE;

330: db_object_version_number hz_address_usages.object_version_number%TYPE;
331: db_map_id hz_address_usages.map_id%TYPE;
332: db_usage_code hz_address_usages.usage_code%TYPE;
333: db_status_flag hz_address_usages.status_flag%TYPE;
334: db_created_by hz_address_usages.created_by%TYPE;
335: db_creation_date hz_address_usages.creation_date%TYPE;
336: db_last_updated_by hz_address_usages.last_updated_by%TYPE;
337: db_last_update_date hz_address_usages.last_update_date%TYPE;
338: db_last_update_login hz_address_usages.last_update_login%TYPE;

Line 335: db_creation_date hz_address_usages.creation_date%TYPE;

331: db_map_id hz_address_usages.map_id%TYPE;
332: db_usage_code hz_address_usages.usage_code%TYPE;
333: db_status_flag hz_address_usages.status_flag%TYPE;
334: db_created_by hz_address_usages.created_by%TYPE;
335: db_creation_date hz_address_usages.creation_date%TYPE;
336: db_last_updated_by hz_address_usages.last_updated_by%TYPE;
337: db_last_update_date hz_address_usages.last_update_date%TYPE;
338: db_last_update_login hz_address_usages.last_update_login%TYPE;
339: db_created_by_module hz_address_usages.created_by_module%TYPE;

Line 336: db_last_updated_by hz_address_usages.last_updated_by%TYPE;

332: db_usage_code hz_address_usages.usage_code%TYPE;
333: db_status_flag hz_address_usages.status_flag%TYPE;
334: db_created_by hz_address_usages.created_by%TYPE;
335: db_creation_date hz_address_usages.creation_date%TYPE;
336: db_last_updated_by hz_address_usages.last_updated_by%TYPE;
337: db_last_update_date hz_address_usages.last_update_date%TYPE;
338: db_last_update_login hz_address_usages.last_update_login%TYPE;
339: db_created_by_module hz_address_usages.created_by_module%TYPE;
340: db_application_id hz_address_usages.application_id%TYPE;

Line 337: db_last_update_date hz_address_usages.last_update_date%TYPE;

333: db_status_flag hz_address_usages.status_flag%TYPE;
334: db_created_by hz_address_usages.created_by%TYPE;
335: db_creation_date hz_address_usages.creation_date%TYPE;
336: db_last_updated_by hz_address_usages.last_updated_by%TYPE;
337: db_last_update_date hz_address_usages.last_update_date%TYPE;
338: db_last_update_login hz_address_usages.last_update_login%TYPE;
339: db_created_by_module hz_address_usages.created_by_module%TYPE;
340: db_application_id hz_address_usages.application_id%TYPE;
341:

Line 338: db_last_update_login hz_address_usages.last_update_login%TYPE;

334: db_created_by hz_address_usages.created_by%TYPE;
335: db_creation_date hz_address_usages.creation_date%TYPE;
336: db_last_updated_by hz_address_usages.last_updated_by%TYPE;
337: db_last_update_date hz_address_usages.last_update_date%TYPE;
338: db_last_update_login hz_address_usages.last_update_login%TYPE;
339: db_created_by_module hz_address_usages.created_by_module%TYPE;
340: db_application_id hz_address_usages.application_id%TYPE;
341:
342: BEGIN

Line 339: db_created_by_module hz_address_usages.created_by_module%TYPE;

335: db_creation_date hz_address_usages.creation_date%TYPE;
336: db_last_updated_by hz_address_usages.last_updated_by%TYPE;
337: db_last_update_date hz_address_usages.last_update_date%TYPE;
338: db_last_update_login hz_address_usages.last_update_login%TYPE;
339: db_created_by_module hz_address_usages.created_by_module%TYPE;
340: db_application_id hz_address_usages.application_id%TYPE;
341:
342: BEGIN
343:

Line 340: db_application_id hz_address_usages.application_id%TYPE;

336: db_last_updated_by hz_address_usages.last_updated_by%TYPE;
337: db_last_update_date hz_address_usages.last_update_date%TYPE;
338: db_last_update_login hz_address_usages.last_update_login%TYPE;
339: db_created_by_module hz_address_usages.created_by_module%TYPE;
340: db_application_id hz_address_usages.application_id%TYPE;
341:
342: BEGIN
343:
344: -- Standard start of API savepoint

Line 365: FROM hz_address_usages

361: last_update_date, last_update_login, created_by_module, application_id
362: INTO l_usage_row_id, l_usage_id, db_object_version_number, db_map_id,
363: db_usage_code, db_status_flag, db_created_by, db_creation_date, db_last_updated_by,
364: db_last_update_date, db_last_update_login, db_created_by_module, db_application_id
365: FROM hz_address_usages
366: WHERE usage_id = p_usage_id;
367: EXCEPTION WHEN NO_DATA_FOUND THEN
368: x_return_status := FND_API.G_RET_STS_ERROR;
369: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_ID');

Line 400: FROM hz_address_usages

396: last_update_date, last_update_login, created_by_module, application_id
397: INTO l_usage_row_id, l_usage_id, db_object_version_number, db_map_id,
398: db_usage_code, db_status_flag, db_created_by, db_creation_date, db_last_updated_by,
399: db_last_update_date, db_last_update_login, db_created_by_module, db_application_id
400: FROM hz_address_usages
401: WHERE map_id = p_map_id
402: AND usage_code = p_usage_code;
403: EXCEPTION WHEN NO_DATA_FOUND THEN
404: x_return_status := FND_API.G_RET_STS_ERROR;

Line 415: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ADDRESS_USAGES');

411: END IF;
412:
413: IF db_object_version_number <> x_object_version_number THEN
414: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
415: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ADDRESS_USAGES');
416: FND_MSG_PUB.ADD;
417: RAISE FND_API.G_EXC_ERROR;
418: END IF;
419:

Line 420: hz_address_usages_pkg.Lock_Row (

416: FND_MSG_PUB.ADD;
417: RAISE FND_API.G_EXC_ERROR;
418: END IF;
419:
420: hz_address_usages_pkg.Lock_Row (
421: x_rowid => l_usage_row_id,
422: x_usage_id => l_usage_id,
423: x_map_id => db_map_id,
424: x_usage_code => db_usage_code,

Line 438: hz_address_usages_pkg.Update_Row (

434:
435: --dbms_output.put_line(' message update : l_usage_row_id '|| l_usage_row_id);
436: l_object_version_number := x_object_version_number +1;
437:
438: hz_address_usages_pkg.Update_Row (
439: x_rowid => l_usage_row_id,
440: x_usage_id => l_usage_id,
441: x_map_id => db_map_id,
442: x_usage_code => db_usage_code,

Line 454: FROM Hz_address_usages usg, Hz_address_usage_dtls dtl

450: x_object_version_number := l_object_version_number;
451:
452: SELECT count(*)
453: INTO l_count
454: FROM Hz_address_usages usg, Hz_address_usage_dtls dtl
455: WHERE usg.map_id = db_map_id
456: AND usg.status_flag = 'A'
457: AND dtl.usage_id = usg.usage_id;
458:

Line 573: FROM hz_address_usages

569: ELSE
570: BEGIN
571: SELECT map_id, usage_code, status_flag
572: INTO l_map_id, l_usage_code, l_status_flag
573: FROM hz_address_usages
574: WHERE usage_id = p_usage_id;
575:
576: EXCEPTION WHEN NO_DATA_FOUND THEN
577: x_return_status := FND_API.G_RET_STS_ERROR;

Line 621: SELECT HZ_ADDRESS_USAGES_S.nextval

617:
618: -- The below variable is to display the geography type in case of unique error from pkg API
619: l_geotype := p_address_usage_dtls_tbl(i).geography_type;
620:
621: SELECT HZ_ADDRESS_USAGES_S.nextval
622: INTO l_usage_dtl_id
623: FROM dual;
624:
625: hz_address_usage_dtls_pkg.insert_row(

Line 769: FROM hz_address_usages

765:
766: BEGIN
767: SELECT map_id, usage_code, status_flag
768: INTO l_map_id, l_usage_code, l_status_flag
769: FROM hz_address_usages
770: WHERE usage_id = p_usage_id;
771:
772: EXCEPTION WHEN NO_DATA_FOUND THEN
773: x_return_status := FND_API.G_RET_STS_ERROR;

Line 821: hz_address_usages_pkg.delete_row(p_usage_id);

817: -- delete the other usage detail also because it is only
818: -- one left can can not exist without any other usage detail
819: -- Bug 5096570 (Nishant 10-Apr-2006)
820: hz_address_usage_dtls_pkg.delete_row(l_last_usg_dtl_id);
821: hz_address_usages_pkg.delete_row(p_usage_id);
822: -- Set i to LAST, so that it does not check any other geo type
823: -- as there is no use (all are deleted)
824: i := p_address_usage_dtls_tbl.LAST;
825: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 835: hz_address_usages_pkg.delete_row(p_usage_id);

831: -- At least two geography types are required for a usage
832: FND_MSG_PUB.ADD;
833: RAISE FND_API.G_EXC_ERROR;
834: */
835: hz_address_usages_pkg.delete_row(p_usage_id);
836: i := p_address_usage_dtls_tbl.LAST;
837: END;
838:
839: END IF;

Line 853: hz_address_usages_pkg.delete_row(p_usage_id);

849: LOOP
850: hz_address_usage_dtls_pkg.delete_row(i.usage_dtl_id);
851: EXIT WHEN c_address_usage_dtls%NOTFOUND;
852: END LOOP;
853: hz_address_usages_pkg.delete_row(p_usage_id);
854: END IF;
855:
856: SELECT count(*)
857: INTO l_count

Line 858: FROM Hz_address_usages usg, Hz_address_usage_dtls dtl

854: END IF;
855:
856: SELECT count(*)
857: INTO l_count
858: FROM Hz_address_usages usg, Hz_address_usage_dtls dtl
859: WHERE usg.map_id = l_map_id
860: AND usg.status_flag = 'A'
861: AND dtl.usage_id = usg.usage_id;
862:

Line 932: END HZ_ADDRESS_USAGES_PUB;

928: p_data => x_msg_data);
929:
930: END delete_address_usages;
931:
932: END HZ_ADDRESS_USAGES_PUB;