APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on ZX_LINES

Line 640: PROCEDURE RETRIEVE_GEO_VALUE( p_event_class_mapping_id IN ZX_LINES_DET_FACTORS.event_class_mapping_id%type,

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,

Line 641: p_trx_id IN ZX_LINES_DET_FACTORS.trx_id%type,

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,

Line 642: p_trx_line_id IN ZX_LINES_DET_FACTORS.trx_line_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,

Line 643: p_trx_level_type IN ZX_LINES_DET_FACTORS.trx_level_type%type,

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,

Line 645: p_location_id IN ZX_LINES_DET_FACTORS.ship_to_location_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,
648: x_geo_val_found OUT NOCOPY BOOLEAN) IS
649:

Line 865: l_place_of_supply ZX_LINES.place_of_supply_type_code%type;

861: IS
862:
863: P_REPORT_NAME VARCHAR2(30);
864: P_REQUEST_ID NUMBER;
865: l_place_of_supply ZX_LINES.place_of_supply_type_code%type;
866: l_location_type_tbl ZX_TCM_GEO_JUR_PKG.location_type_tbl_type;
867: l_location_id_tbl ZX_TCM_GEO_JUR_PKG.location_id_tbl_type;
868: l_geo_val_found BOOLEAN;
869: x_return_status VARCHAR2(1);