DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_PUB dependencies on HZ_GEOGRAPHY_PUB

Line 1: PACKAGE BODY HZ_GEOGRAPHY_PUB AS

1: PACKAGE BODY HZ_GEOGRAPHY_PUB AS
2: /*$Header: ARHGEOSB.pls 120.39 2007/11/15 01:47:12 nsinghai ship $ */
3:
4: ------------------------------------
5: -- declaration of private procedures

Line 1861: l_parent_geography_tbl HZ_GEOGRAPHY_PUB.parent_geography_tbl_type;

1857: x_return_status IN OUT NOCOPY VARCHAR2
1858: ) IS
1859:
1860: l_count NUMBER;
1861: l_parent_geography_tbl HZ_GEOGRAPHY_PUB.parent_geography_tbl_type;
1862: l_rowid VARCHAR2(64);
1863: l_country_code VARCHAR2(2);
1864: l_master_relation_rec MASTER_RELATION_REC_TYPE;
1865: l_geo_identifier_rec GEO_IDENTIFIER_REC_TYPE;

Line 2319: p_geography_range_rec IN HZ_GEOGRAPHY_PUB.GEOGRAPHY_RANGE_REC_TYPE,

2315: for future use
2316: ------------------------------------------------------------------------------*/
2317:
2318: PROCEDURE do_create_discrete_geography (
2319: p_geography_range_rec IN HZ_GEOGRAPHY_PUB.GEOGRAPHY_RANGE_REC_TYPE,
2320: x_return_status IN OUT NOCOPY VARCHAR2
2321: ) IS
2322: /*
2323: l_geography_range_rec HZ_GEOGRAPHY_PUB.GEOGRAPHY_RANGE_REC_TYPE;

Line 2323: l_geography_range_rec HZ_GEOGRAPHY_PUB.GEOGRAPHY_RANGE_REC_TYPE;

2319: p_geography_range_rec IN HZ_GEOGRAPHY_PUB.GEOGRAPHY_RANGE_REC_TYPE,
2320: x_return_status IN OUT NOCOPY VARCHAR2
2321: ) IS
2322: /*
2323: l_geography_range_rec HZ_GEOGRAPHY_PUB.GEOGRAPHY_RANGE_REC_TYPE;
2324:
2325: l_parent_geo_type VARCHAR2(100);
2326: l_country_code VARCHAR2(100);
2327: l_child_geo_type VARCHAR2(100);

Line 2331: l_master_geography_rec HZ_GEOGRAPHY_PUB.MASTER_GEOGRAPHY_REC_TYPE;

2327: l_child_geo_type VARCHAR2(100);
2328: l_geo_range_from NUMBER;
2329: l_geo_range_to NUMBER;
2330: l_geography_id NUMBER;
2331: l_master_geography_rec HZ_GEOGRAPHY_PUB.MASTER_GEOGRAPHY_REC_TYPE;
2332: l_parent_geography_id_tbl HZ_GEOGRAPHY_PUB.PARENT_GEOGRAPHY_TBL_TYPE;
2333: l_msg_data VARCHAR2(10000);
2334: l_msg_count NUMBER;
2335: l_count NUMBER;

Line 2332: l_parent_geography_id_tbl HZ_GEOGRAPHY_PUB.PARENT_GEOGRAPHY_TBL_TYPE;

2328: l_geo_range_from NUMBER;
2329: l_geo_range_to NUMBER;
2330: l_geography_id NUMBER;
2331: l_master_geography_rec HZ_GEOGRAPHY_PUB.MASTER_GEOGRAPHY_REC_TYPE;
2332: l_parent_geography_id_tbl HZ_GEOGRAPHY_PUB.PARENT_GEOGRAPHY_TBL_TYPE;
2333: l_msg_data VARCHAR2(10000);
2334: l_msg_count NUMBER;
2335: l_count NUMBER;
2336: */

Line 2410: HZ_GEOGRAPHY_PUB.create_master_geography(

2406: AND rel.relationship_type = 'MASTER_REF');
2407:
2408: IF (l_count = 0) THEN
2409: -- create geography
2410: HZ_GEOGRAPHY_PUB.create_master_geography(
2411: p_init_msg_list => FND_API.G_FALSE,
2412: p_master_geography_rec => l_master_geography_rec,
2413: x_geography_id => l_geography_id,
2414: x_return_status => x_return_status,

Line 4413: END HZ_GEOGRAPHY_PUB;

4409: p_count => x_msg_count,
4410: p_data => x_msg_data);
4411: END create_zone;
4412:
4413: END HZ_GEOGRAPHY_PUB;