DBA Data[Home] [Help]

APPS.FTE_SOURCE_LINE_CONSOLIDATION dependencies on WSH_DELIVERY_AUTOCREATE

Line 141: x_group_by_flags OUT NOCOPY WSH_DELIVERY_AUTOCREATE.group_by_flags_rec_type) IS

137: PROCEDURE Create_Hash(p_source_line_rec IN FTE_PROCESS_REQUESTS.fte_source_line_rec,
138: p_action IN VARCHAR2,
139: x_hash_value OUT NOCOPY NUMBER,
140: x_hash_string OUT NOCOPY VARCHAR2,
141: x_group_by_flags OUT NOCOPY WSH_DELIVERY_AUTOCREATE.group_by_flags_rec_type) IS
142:
143: l_hash_string VARCHAR2(1000) := NULL;
144: l_hash_value NUMBER;
145:

Line 146: l_group_by_flags WSH_DELIVERY_AUTOCREATE.group_by_flags_rec_type;

142:
143: l_hash_string VARCHAR2(1000) := NULL;
144: l_hash_value NUMBER;
145:
146: l_group_by_flags WSH_DELIVERY_AUTOCREATE.group_by_flags_rec_type;
147: l_status VARCHAR2(10);
148:
149: l_con_hash_rec source_header_hash_rec;
150:

Line 185: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);

181: --
182: -- Debug Statements
183: --
184: IF l_debug_on THEN
185: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);
186: END IF;
187: --
188: WSH_DELIVERY_AUTOCREATE.Get_Group_By_Attr(p_organization_id => p_source_line_rec.ship_from_org_id,
189: x_group_by_flags => l_group_by_flags,

Line 188: WSH_DELIVERY_AUTOCREATE.Get_Group_By_Attr(p_organization_id => p_source_line_rec.ship_from_org_id,

184: IF l_debug_on THEN
185: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);
186: END IF;
187: --
188: WSH_DELIVERY_AUTOCREATE.Get_Group_By_Attr(p_organization_id => p_source_line_rec.ship_from_org_id,
189: x_group_by_flags => l_group_by_flags,
190: x_return_status => l_status);
191:
192: --

Line 346: l_group_by_flags WSH_DELIVERY_AUTOCREATE.group_by_flags_rec_type;

342: l_hash_value NUMBER;
343: l_generic_carrier VARCHAR2(1);
344: l_override_ship_method BOOLEAN;
345:
346: l_group_by_flags WSH_DELIVERY_AUTOCREATE.group_by_flags_rec_type;
347:
348: --bug 6707893: Added p_inv_id parameter in WSH_WV_UTILS.convert_uom called in the cursor
349: CURSOR get_converted_wv(p_org_id NUMBER, p_inv_id NUMBER, p_source_qty NUMBER,
350: p_source_qty_uom VARCHAR2, p_weight_uom VARCHAR2,