636: END ;
637: END LOOP;
638: END;
639:
640: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
641: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
642: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
643: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
644: p_location_type IN VARCHAR2,
637: END LOOP;
638: END;
639:
640: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
641: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
642: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
643: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
644: p_location_type IN VARCHAR2,
645: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
638: END;
639:
640: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
641: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
642: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
643: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
644: p_location_type IN VARCHAR2,
645: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
646: p_geography_type IN VARCHAR2,
639:
640: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
641: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
642: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
643: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
644: p_location_type IN VARCHAR2,
645: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
646: p_geography_type IN VARCHAR2,
647: x_geography_value OUT NOCOPY VARCHAR2,
641: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
642: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
643: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
644: p_location_type IN VARCHAR2,
645: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
646: p_geography_type IN VARCHAR2,
647: x_geography_value OUT NOCOPY VARCHAR2,
648: x_geo_val_found OUT NOCOPY BOOLEAN) IS
649: