DBA Data[Home] [Help]

APPS.FTE_PROCESS_REQUESTS dependencies on WSH_NEW_DELIVERY_ACTIONS

Line 10: g_object_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;

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 --

Line 549: l_result_consolidation_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;

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;

Line 550: l_result_carrier_id_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;

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;

Line 551: l_result_service_level_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;

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;

Line 552: l_result_mode_of_transport_tab WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;

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;

Line 553: l_result_freight_term_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:

Line 554: l_result_transit_time_min_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:
558: --R12 - Routing Rules Engine

Line 555: l_result_transit_time_max_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
559: l_result_tab FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE;

Line 556: l_ship_method_code_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;
560: l_return_message VARCHAR2(2000);