DBA Data[Home] [Help]

APPS.WSH_MDC_SRS dependencies on WSH_FTE_CONSTRAINT_FRAMEWORK

Line 13: -- WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type.

9: -- TYPE : addnl_del_attr_rec_type
10: --
11: -- COMMENT : The delivery details are stored in two parallel tables.
12: -- The generic information is stored using the type
13: -- WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type.
14: -- All the additional details are stored using the record
15: -- described below.
16: --========================================================================
17:

Line 198: x_delivery_tab OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type,

194: -- COMMENT : This procedure fetches the deliveries to be consolidated.
195: --========================================================================
196: PROCEDURE Get_Deliveries(
197: p_sel_del_attr IN select_del_flags_rec_type,
198: x_delivery_tab OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type,
199: x_delivery_addnl_attr_tab OUT NOCOPY addnl_del_attr_tab_type,
200: x_return_status OUT NOCOPY VARCHAR2);
201:
202:

Line 226: x_delivery_tab IN OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type,

222: PROCEDURE Set_Intermediate_Location(
223: p_consol_loc_id IN NUMBER,
224: p_override_ship_to_flag IN VARCHAR2,
225: p_rule_zone_id IN NUMBER,
226: x_delivery_tab IN OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type,
227: x_delivery_addnl_attr_tab IN OUT NOCOPY addnl_del_attr_tab_type,
228: x_failed_records IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
229: x_return_status OUT NOCOPY VARCHAR2);
230:

Line 267: x_delivery_rec IN OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type,

263: -- The procedure also clears out all the non-grouping
264: -- attributes from the delivery records
265: --========================================================================
266: PROCEDURE Get_Hash_Value(
267: x_delivery_rec IN OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type,
268: x_delivery_addnl_attr_rec IN OUT NOCOPY addnl_del_attr_rec_type,
269: p_group_by_flags IN group_by_flags_rec_type,
270: p_hash_base IN NUMBER,
271: p_hash_size IN NUMBER,

Line 298: x_delivery_tab IN OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type,

294: -- The max consolidation trip weight and trip name prefix
295: -- can also be specified.
296: --========================================================================
297: PROCEDURE Create_Consolidations(
298: x_delivery_tab IN OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type,
299: x_delivery_addnl_attr_tab IN OUT NOCOPY addnl_del_attr_tab_type,
300: p_group_tab IN grp_attr_tab_type,
301: p_max_trip_weight IN NUMBER,
302: p_max_weight_uom IN VARCHAR2,

Line 324: x_delivery_tab IN OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type,

320: -- COMMENT : This procedure takes the delivery records and and creates
321: -- cdeconsolidation trips for the deliveries.
322: --========================================================================
323: PROCEDURE Create_Deconsol_Trips(
324: x_delivery_tab IN OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type,
325: x_delivery_addnl_attr_tab IN OUT NOCOPY addnl_del_attr_tab_type,
326: p_consol_trip_id IN WSH_UTIL_CORE.id_tab_type,
327: p_trip_name_prefix IN VARCHAR2,
328: x_trips_all IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,