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.12020000.3 2012/12/15 01:21:37 nsinghai ship $ */
3:
4: ------------------------------------
5: -- declaration of private procedures

Line 1874: l_parent_geography_tbl HZ_GEOGRAPHY_PUB.parent_geography_tbl_type;

1870: x_return_status IN OUT NOCOPY VARCHAR2
1871: ) IS
1872:
1873: l_count NUMBER;
1874: l_parent_geography_tbl HZ_GEOGRAPHY_PUB.parent_geography_tbl_type;
1875: l_rowid VARCHAR2(64);
1876: l_country_code VARCHAR2(2);
1877: l_master_relation_rec MASTER_RELATION_REC_TYPE;
1878: l_geo_identifier_rec GEO_IDENTIFIER_REC_TYPE;

Line 2332: p_geography_range_rec IN HZ_GEOGRAPHY_PUB.GEOGRAPHY_RANGE_REC_TYPE,

2328: for future use
2329: ------------------------------------------------------------------------------*/
2330:
2331: PROCEDURE do_create_discrete_geography (
2332: p_geography_range_rec IN HZ_GEOGRAPHY_PUB.GEOGRAPHY_RANGE_REC_TYPE,
2333: x_return_status IN OUT NOCOPY VARCHAR2
2334: ) IS
2335: /*
2336: l_geography_range_rec HZ_GEOGRAPHY_PUB.GEOGRAPHY_RANGE_REC_TYPE;

Line 2336: l_geography_range_rec HZ_GEOGRAPHY_PUB.GEOGRAPHY_RANGE_REC_TYPE;

2332: p_geography_range_rec IN HZ_GEOGRAPHY_PUB.GEOGRAPHY_RANGE_REC_TYPE,
2333: x_return_status IN OUT NOCOPY VARCHAR2
2334: ) IS
2335: /*
2336: l_geography_range_rec HZ_GEOGRAPHY_PUB.GEOGRAPHY_RANGE_REC_TYPE;
2337:
2338: l_parent_geo_type VARCHAR2(100);
2339: l_country_code VARCHAR2(100);
2340: l_child_geo_type VARCHAR2(100);

Line 2344: l_master_geography_rec HZ_GEOGRAPHY_PUB.MASTER_GEOGRAPHY_REC_TYPE;

2340: l_child_geo_type VARCHAR2(100);
2341: l_geo_range_from NUMBER;
2342: l_geo_range_to NUMBER;
2343: l_geography_id NUMBER;
2344: l_master_geography_rec HZ_GEOGRAPHY_PUB.MASTER_GEOGRAPHY_REC_TYPE;
2345: l_parent_geography_id_tbl HZ_GEOGRAPHY_PUB.PARENT_GEOGRAPHY_TBL_TYPE;
2346: l_msg_data VARCHAR2(10000);
2347: l_msg_count NUMBER;
2348: l_count NUMBER;

Line 2345: l_parent_geography_id_tbl HZ_GEOGRAPHY_PUB.PARENT_GEOGRAPHY_TBL_TYPE;

2341: l_geo_range_from NUMBER;
2342: l_geo_range_to NUMBER;
2343: l_geography_id NUMBER;
2344: l_master_geography_rec HZ_GEOGRAPHY_PUB.MASTER_GEOGRAPHY_REC_TYPE;
2345: l_parent_geography_id_tbl HZ_GEOGRAPHY_PUB.PARENT_GEOGRAPHY_TBL_TYPE;
2346: l_msg_data VARCHAR2(10000);
2347: l_msg_count NUMBER;
2348: l_count NUMBER;
2349: */

Line 2423: HZ_GEOGRAPHY_PUB.create_master_geography(

2419: AND rel.relationship_type = 'MASTER_REF');
2420:
2421: IF (l_count = 0) THEN
2422: -- create geography
2423: HZ_GEOGRAPHY_PUB.create_master_geography(
2424: p_init_msg_list => FND_API.G_FALSE,
2425: p_master_geography_rec => l_master_geography_rec,
2426: x_geography_id => l_geography_id,
2427: x_return_status => x_return_status,

Line 4426: END HZ_GEOGRAPHY_PUB;

4422: p_count => x_msg_count,
4423: p_data => x_msg_data);
4424: END create_zone;
4425:
4426: END HZ_GEOGRAPHY_PUB;