APPS.ZX_TCM_GEO_JUR_PKG dependencies on HZ_GEO_GET_PUB

Line 592: x_zone_tbl OUT NOCOPY HZ_GEO_GET_PUB.zone_tbl_type,

588: ( p_location_id IN NUMBER,
589: p_location_type IN VARCHAR2,
590: p_zone_type IN VARCHAR2,
591: p_trx_date IN DATE,
592: x_zone_tbl OUT NOCOPY HZ_GEO_GET_PUB.zone_tbl_type,
593: x_return_status OUT NOCOPY VARCHAR2) IS
594:
595:
596:

Line 615: -- The following 3 variables are added to make the external api (HZ_GEO_GET_PUB.get_zone)

611: -- Logging Infra
612: l_procedure_name CONSTANT VARCHAR2(30) := 'get_zone';
613: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
614:
615: -- The following 3 variables are added to make the external api (HZ_GEO_GET_PUB.get_zone)
616: -- calling place to compile. Needs to be removed later...
617: l_init_msg_list VARCHAR2(30);
618: x_msg_count NUMBER;
619: x_msg_data VARCHAR2(2000);

Line 653: l_log_msg := 'B: hz_geo_get_pub.get_zone: in: '||'p_location_table_name='||x_location_table_name||

649: x_location_table_name);
650:
651: -- Logging Infra: Statement level: "B" means "B"reak point
652: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
653: l_log_msg := 'B: hz_geo_get_pub.get_zone: in: '||'p_location_table_name='||x_location_table_name||
654: ', p_location_id='||p_location_id||', p_zone_type=' ||p_zone_type||', p_date='||p_trx_date;
655: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
656: END IF;
657:

Line 746: HZ_GEO_GET_PUB.get_zone(

742: END IF;
743:
744: -- Once table name is got, call TCA's get_zone API
745:
746: HZ_GEO_GET_PUB.get_zone(
747: x_location_table_name,
748: p_location_id,
749: p_zone_type,
750: p_trx_date,

Line 765: l_log_msg := 'R: hz_geo_get_pub.get_zone: out: x_zone_id='||x_zone_tbl(i).zone_id||', x_zone_code='||x_zone_tbl(i).zone_code||

761: -- Logging Infra: Statement level: "R" means "R"eturned value to a caller
762: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
763: IF x_zone_tbl.count > 0 THEN
764: FOR i in x_zone_tbl.first..x_zone_tbl.last LOOP
765: l_log_msg := 'R: hz_geo_get_pub.get_zone: out: x_zone_id='||x_zone_tbl(i).zone_id||', x_zone_code='||x_zone_tbl(i).zone_code||
766: ', x_zone_name='||x_zone_tbl(i).zone_name||', x_return_status='||x_return_status;
767: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
768: END LOOP;
769: END IF;

Line 850: l_zone_tbl HZ_GEO_GET_PUB.zone_tbl_type;

846: l_geography_type geography_type_use_type;
847: l_geography_use geography_type_use_type;
848: l_geography_type_num geography_type_num_type;
849: l_inner_city_jurisdiction_flag VARCHAR2(30);
850: l_zone_tbl HZ_GEO_GET_PUB.zone_tbl_type;
851: l_country_or_group_code VARCHAR2(30);
852: l_regime_country_code VARCHAR2(30);
853: l_loc_country_code VARCHAR2(30);
854: l_country_regime_flag VARCHAR2(1);