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_USAGE_DTLS

Line 170: hz_address_usage_dtls_pkg.insert_row(

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(
171: x_usage_dtl_row_id,
172: l_usage_dtl_id,
173: l_usage_id,
174: p_address_usage_dtls_tbl(i).geography_type,

Line 201: ELSIF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U1' THEN

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;
200:
201: ELSIF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U1' THEN
202: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_DTL_ID');
203: FND_MESSAGE.SET_TOKEN('P_USAGE_DTL_ID',l_usage_dtl_id);
204: -- Usage detail ID already exists. Please use a unique ID.
205: FND_MSG_PUB.ADD;

Line 207: ELSIF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U2' THEN

203: FND_MESSAGE.SET_TOKEN('P_USAGE_DTL_ID',l_usage_dtl_id);
204: -- Usage detail ID already exists. Please use a unique ID.
205: FND_MSG_PUB.ADD;
206:
207: ELSIF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U2' THEN
208: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_GEOTYPE');
209: FND_MESSAGE.SET_TOKEN('P_GEOTYPE',l_geotype);
210: FND_MESSAGE.SET_TOKEN('P_USAGE',p_address_usages_rec.usage_code);
211: -- This geography type is already mapped for this usage.

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 625: hz_address_usage_dtls_pkg.insert_row(

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(
626: x_usage_dtl_row_id,
627: l_usage_dtl_id,
628: p_usage_id,
629: p_address_usage_dtls_tbl(i).geography_type,

Line 687: IF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U1' THEN

683: WHEN DUP_VAL_ON_INDEX THEN
684: ROLLBACK TO create_address_usage_dtls;
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
687: IF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U1' THEN
688: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_DTL_ID');
689: -- Usage detail ID already exists. Please use a unique ID.
690: FND_MESSAGE.SET_TOKEN('P_USAGE_DTL_ID',l_usage_dtl_id);
691: FND_MSG_PUB.ADD;

Line 692: ELSIF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U2' THEN

688: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_DTL_ID');
689: -- Usage detail ID already exists. Please use a unique ID.
690: FND_MESSAGE.SET_TOKEN('P_USAGE_DTL_ID',l_usage_dtl_id);
691: FND_MSG_PUB.ADD;
692: ELSIF p_index_name = 'HZ_ADDRESS_USAGE_DTLS_U2' THEN
693: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_USAGE_GEOTYPE');
694: FND_MESSAGE.SET_TOKEN('P_GEOTYPE',l_geotype);
695: FND_MESSAGE.SET_TOKEN('P_USAGE',l_usage_code);
696: -- This geography type is already mapped for this usage.

Line 740: FROM hz_address_usage_dtls

736: l_last_usg_dtl_id NUMBER;
737:
738: CURSOR c_address_usage_dtls IS
739: SELECT usage_dtl_id
740: FROM hz_address_usage_dtls
741: WHERE usage_id = p_usage_id;
742:
743: BEGIN
744:

Line 788: FROM hz_address_usage_dtls

784: IF p_address_usage_dtls_tbl(i).geography_type IS NOT NULL then
785: BEGIN
786: SELECT usage_dtl_id
787: INTO l_usage_dtl_id
788: FROM hz_address_usage_dtls
789: WHERE usage_id = p_usage_id
790: AND geography_type = p_address_usage_dtls_tbl(i).geography_type;
791:
792: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 805: FROM hz_address_usage_dtls

801:
802: BEGIN
803: SELECT count(*)
804: INTO l_count
805: FROM hz_address_usage_dtls
806: WHERE usage_id = p_usage_id;
807:
808: IF l_count < 3 then
809:

Line 813: FROM hz_address_usage_dtls

809:
810: BEGIN
811: SELECT usage_dtl_id
812: INTO l_last_usg_dtl_id
813: FROM hz_address_usage_dtls
814: WHERE usage_id = p_usage_id
815: AND usage_dtl_id <> l_usage_dtl_id;
816:
817: -- delete the other usage detail also because it is only

Line 820: hz_address_usage_dtls_pkg.delete_row(l_last_usg_dtl_id);

816:
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;

Line 842: hz_address_usage_dtls_pkg.delete_row(l_usage_dtl_id);

838:
839: END IF;
840: END;
841:
842: hz_address_usage_dtls_pkg.delete_row(l_usage_dtl_id);
843: END IF;
844: EXIT WHEN i = p_address_usage_dtls_tbl.LAST;
845: i := p_address_usage_dtls_tbl.NEXT(i);
846: END LOOP;

Line 850: hz_address_usage_dtls_pkg.delete_row(i.usage_dtl_id);

846: END LOOP;
847: ELSE
848: FOR i IN c_address_usage_dtls
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;

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: