1658: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME ||l_procedure_name,l_log_msg);
1659: END IF;
1660: END;
1661:
1662: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
1663: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
1664: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
1665: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
1666: p_location_type IN VARCHAR2,
1659: END IF;
1660: END;
1661:
1662: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
1663: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
1664: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
1665: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
1666: p_location_type IN VARCHAR2,
1667: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
1660: END;
1661:
1662: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
1663: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
1664: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
1665: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
1666: p_location_type IN VARCHAR2,
1667: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
1668: p_geography_type IN VARCHAR2,
1661:
1662: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
1663: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
1664: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
1665: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
1666: p_location_type IN VARCHAR2,
1667: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
1668: p_geography_type IN VARCHAR2,
1669: x_geography_value OUT NOCOPY VARCHAR2,
1663: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
1664: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
1665: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
1666: p_location_type IN VARCHAR2,
1667: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
1668: p_geography_type IN VARCHAR2,
1669: x_geography_value OUT NOCOPY VARCHAR2,
1670: x_geography_id OUT NOCOPY NUMBER,
1671: x_geo_val_found OUT NOCOPY BOOLEAN) IS