[Home] [Help]
31: -- x_return_status - status of procedure call
32: -- Description: This procedure will firm a delivery
33: --
34: PROCEDURE FIRM
35: (p_del_rows IN wsh_util_core.id_tab_type,
36: x_return_status OUT NOCOPY VARCHAR2);
37:
38: --
39: -- Procedure: Plan
41: -- x_return_status - status of procedure call
42: -- Description: This procedure will Plan a delivery for shipment
43: --
44: PROCEDURE Plan
45: (p_del_rows IN wsh_util_core.id_tab_type,
46: x_return_status OUT NOCOPY VARCHAR2,
47: p_called_for_sc IN BOOLEAN default false);
48:
49: --
53: -- Description: This procedure will unplan a delivery
54: --
55:
56: PROCEDURE Unplan
57: (p_del_rows IN wsh_util_core.id_tab_type,
58: x_return_status OUT NOCOPY VARCHAR2);
59:
60:
61: -- Bug: 2052963
78: -- associated with the Delivery(s).
79: --
80:
81: PROCEDURE Get_Delivery_Defaults
82: (p_del_rows IN wsh_util_core.id_tab_type,
83: p_org_ids IN wsh_util_core.id_tab_type,
84: p_client_ids IN wsh_util_core.id_tab_type, --Modified R12.1.1 LSP PROJECT
85: p_ship_method_code_vals IN ship_method_type,
86: x_autointransit_flag OUT NOCOPY VARCHAR2,
79: --
80:
81: PROCEDURE Get_Delivery_Defaults
82: (p_del_rows IN wsh_util_core.id_tab_type,
83: p_org_ids IN wsh_util_core.id_tab_type,
84: p_client_ids IN wsh_util_core.id_tab_type, --Modified R12.1.1 LSP PROJECT
85: p_ship_method_code_vals IN ship_method_type,
86: x_autointransit_flag OUT NOCOPY VARCHAR2,
87: x_autoclose_flag OUT NOCOPY VARCHAR2,
80:
81: PROCEDURE Get_Delivery_Defaults
82: (p_del_rows IN wsh_util_core.id_tab_type,
83: p_org_ids IN wsh_util_core.id_tab_type,
84: p_client_ids IN wsh_util_core.id_tab_type, --Modified R12.1.1 LSP PROJECT
85: p_ship_method_code_vals IN ship_method_type,
86: x_autointransit_flag OUT NOCOPY VARCHAR2,
87: x_autoclose_flag OUT NOCOPY VARCHAR2,
88: x_report_set_id OUT NOCOPY NUMBER,
115: -- on each delivery and confirms each delivery
116:
117:
118: PROCEDURE Confirm_Delivery
119: (p_del_rows IN wsh_util_core.id_tab_type,
120: p_action_flag IN VARCHAR2,
121: p_intransit_flag IN VARCHAR2,
122: p_close_flag IN VARCHAR2,
123: p_stage_del_flag IN VARCHAR2,
150: -- NOTE: For CONFIRM use confirm_delivery procedure
151: --
152:
153: PROCEDURE Change_Status
154: (p_del_rows IN wsh_util_core.id_tab_type,
155: p_action IN VARCHAR2,
156: p_actual_date IN DATE DEFAULT NULL,
157: x_return_status OUT NOCOPY VARCHAR2,
158: --tkt
184: --
185: -- COMMENTING OUT AS LOAD TENDER FUNCTIONALITY IS TEMPORARILY REMOVED
186: /*
187: PROCEDURE Set_Load_Tender
188: (p_del_rows IN wsh_util_core.id_tab_type,
189: p_action IN VARCHAR2,
190: x_return_status OUT NOCOPY VARCHAR2);
191: */
192: --
196: -- Description: This procedure is used to generate loading sequence for deliveries
197: --
198:
199: PROCEDURE Generate_Loading_Seq
200: (p_del_rows IN wsh_util_core.id_tab_type,
201: x_return_status OUT NOCOPY VARCHAR2);
202:
203:
204: --
229: TYPE TableVarchar3 is TABLE of VARCHAR2(3) INDEX BY BINARY_INTEGER; -- table varchar(3) type
230: TYPE TableDate is TABLE of DATE INDEX BY BINARY_INTEGER;
231:
232:
233: PROCEDURE PROCESS_CARRIER_SELECTION(p_delivery_id_tab IN OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
234: p_batch_id IN NUMBER,
235: p_form_flag IN VARCHAR2,
236: p_organization_id IN NUMBER DEFAULT NULL,
237: -- csun deliveryMerge
246: G_START_OF_PACKING VARCHAR2(1) := 'A';
247: G_START_OF_SHIPPING VARCHAR2(1) := 'W';
248:
249: PROCEDURE Adjust_Planned_Flag(
250: p_delivery_ids IN wsh_util_core.id_tab_type,
251: p_caller IN VARCHAR2,
252: p_force_appending_limit IN VARCHAR2,
253: p_call_lcss IN VARCHAR2 DEFAULT 'N',
254: p_event IN VARCHAR2 DEFAULT NULL,
355:
356: Procedure Unassign_Dels_from_Consol_Del(
357: p_parent_del IN NUMBER,
358: p_caller IN VARCHAR2,
359: p_del_tab IN OUT NOCOPY wsh_util_core.id_tab_type,
360: x_return_status OUT NOCOPY VARCHAR2);
361:
362:
363: --OTM R12, function to check if delivery is empty or not