63:
64:
65: /*Added by Usha for bug 4458010 */
66: PROCEDURE RETRIEVE_GEO_VALUE
67: ( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
68: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
69: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
70: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
71: p_location_type IN VARCHAR2,
64:
65: /*Added by Usha for bug 4458010 */
66: PROCEDURE RETRIEVE_GEO_VALUE
67: ( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
68: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
69: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
70: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
71: p_location_type IN VARCHAR2,
72: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
65: /*Added by Usha for bug 4458010 */
66: PROCEDURE RETRIEVE_GEO_VALUE
67: ( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
68: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
69: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
70: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
71: p_location_type IN VARCHAR2,
72: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
73: p_geography_type IN VARCHAR2,
66: PROCEDURE RETRIEVE_GEO_VALUE
67: ( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,
68: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
69: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
70: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
71: p_location_type IN VARCHAR2,
72: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
73: p_geography_type IN VARCHAR2,
74: x_geography_value OUT NOCOPY VARCHAR2,
68: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,
69: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_id%type,
70: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,
71: p_location_type IN VARCHAR2,
72: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_id%type,
73: p_geography_type IN VARCHAR2,
74: x_geography_value OUT NOCOPY VARCHAR2,
75: x_geography_id OUT NOCOPY NUMBER,
76: x_geo_val_found OUT NOCOPY BOOLEAN);