40:
41:
42: --Added for Funtional workflow
43: l_organization_id NUMBER;
44: l_parameter_list wf_parameter_list_t;
45: l_delivery_id_tk NUMBER;
46: l_return_statuswf VARCHAR2(1);
47:
48: l_received_date DATE;
907: l_tracking_id_type VARCHAR2(30);
908:
909: --Added for Funtional workflow
910: l_organization_id NUMBER;
911: l_parameter_list wf_parameter_list_t;
912:
913: -- Added for Bug
914: l_received_date DATE;
915:
1980: l_delivery_id NUMBER;
1981:
1982: --Added for Funtional Tracking workflow
1983: l_organization_id_tk NUMBER;
1984: l_parameter_list_tk wf_parameter_list_t;
1985: l_delivery_id_tk NUMBER;
1986: l_return_statuswf VARCHAR2(1);
1987:
1988: l_stop_id_tab FTE_ID_TAB_TYPE;
1994: p_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1995: p_entity_id_tab WSH_UTIL_CORE.id_tab_type;
1996:
1997: --For Workflow Impact on ITM
1998: l_parameter_list wf_parameter_list_t;
1999:
2000: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2001: --
2002: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'call_last_delivery_leg';