DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_PKG dependencies on WSH_DELIVERY_DETAILS_INV

Line 1925: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

1921: l_organization_id NUMBER := NULL;
1922: l_subinventory VARCHAR2(10) := NULL;
1923: l_serial_number VARCHAR2(30) := NULL;
1924: l_transaction_temp_id NUMBER := NULL;
1925: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
1926: l_return_status VARCHAR2(5) := NULL;
1927:
1928: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI changes
1929: l_dbi_rs VARCHAR2(1); -- Return Status from DBI API

Line 2018: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);

2014: IF l_delivery_detail_id IS NOT NULL THEN
2015: IF l_serial_number IS NOT NULL OR l_transaction_temp_id IS NOT NULL THEN
2016: --
2017: IF l_debug_on THEN
2018: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
2019: END IF;
2020: --
2021: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(
2022: p_delivery_detail_id => l_delivery_detail_id,

Line 2021: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(

2017: IF l_debug_on THEN
2018: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
2019: END IF;
2020: --
2021: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(
2022: p_delivery_detail_id => l_delivery_detail_id,
2023: p_inventory_item_id => l_inventory_item_id,
2024: p_organization_id => l_organization_id,
2025: p_subinventory => l_subinventory,

Line 2031: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

2027: x_return_status => l_return_status);
2028:
2029: --
2030: IF l_debug_on THEN
2031: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
2032: END IF;
2033: --
2034: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number(
2035: p_delivery_detail_id => l_delivery_detail_id,

Line 2034: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number(

2030: IF l_debug_on THEN
2031: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
2032: END IF;
2033: --
2034: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number(
2035: p_delivery_detail_id => l_delivery_detail_id,
2036: p_serial_number_code => l_inv_controls_rec.serial_code,
2037: p_serial_number => l_serial_number,
2038: p_transaction_temp_id => l_transaction_temp_id,