6: --
7: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_PROCESS_REQUESTS';
8: --
9:
10: g_object_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
11:
12: -- -------------------------------------------------------------------------- --
13: -- --
14: -- NAME: GET_CUSTOMER_SITE --
545: l_rule_name VARCHAR2(80);
546:
547: --R12 Glog Integration
548: l_otm_installed VARCHAR2(1);
549: l_result_consolidation_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
550: l_result_carrier_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
551: l_result_service_level_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
552: l_result_mode_of_transport_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
553: l_result_freight_term_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
546:
547: --R12 Glog Integration
548: l_otm_installed VARCHAR2(1);
549: l_result_consolidation_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
550: l_result_carrier_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
551: l_result_service_level_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
552: l_result_mode_of_transport_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
553: l_result_freight_term_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
554: l_result_transit_time_min_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
547: --R12 Glog Integration
548: l_otm_installed VARCHAR2(1);
549: l_result_consolidation_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
550: l_result_carrier_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
551: l_result_service_level_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
552: l_result_mode_of_transport_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
553: l_result_freight_term_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
554: l_result_transit_time_min_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
555: l_result_transit_time_max_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
548: l_otm_installed VARCHAR2(1);
549: l_result_consolidation_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
550: l_result_carrier_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
551: l_result_service_level_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
552: l_result_mode_of_transport_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
553: l_result_freight_term_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
554: l_result_transit_time_min_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
555: l_result_transit_time_max_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
556: l_ship_method_code_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
549: l_result_consolidation_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
550: l_result_carrier_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
551: l_result_service_level_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
552: l_result_mode_of_transport_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
553: l_result_freight_term_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
554: l_result_transit_time_min_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
555: l_result_transit_time_max_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
556: l_ship_method_code_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
557:
550: l_result_carrier_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
551: l_result_service_level_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
552: l_result_mode_of_transport_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
553: l_result_freight_term_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
554: l_result_transit_time_min_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
555: l_result_transit_time_max_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
556: l_ship_method_code_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
557:
558: --R12 - Routing Rules Engine
551: l_result_service_level_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
552: l_result_mode_of_transport_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
553: l_result_freight_term_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
554: l_result_transit_time_min_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
555: l_result_transit_time_max_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
556: l_ship_method_code_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
557:
558: --R12 - Routing Rules Engine
559: l_result_tab FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE;
552: l_result_mode_of_transport_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
553: l_result_freight_term_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
554: l_result_transit_time_min_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
555: l_result_transit_time_max_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
556: l_ship_method_code_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
557:
558: --R12 - Routing Rules Engine
559: l_result_tab FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE;
560: l_return_message VARCHAR2(2000);