DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_UTIL_CORE

Line 35: (p_del_rows IN wsh_util_core.id_tab_type,

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

Line 45: (p_del_rows IN wsh_util_core.id_tab_type,

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: --

Line 57: (p_del_rows IN wsh_util_core.id_tab_type,

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

Line 82: (p_del_rows IN wsh_util_core.id_tab_type,

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_ship_method_code_vals IN ship_method_type,
85: x_autointransit_flag OUT NOCOPY VARCHAR2,
86: x_autoclose_flag OUT NOCOPY VARCHAR2,

Line 83: p_org_ids IN wsh_util_core.id_tab_type,

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_ship_method_code_vals IN ship_method_type,
85: x_autointransit_flag OUT NOCOPY VARCHAR2,
86: x_autoclose_flag OUT NOCOPY VARCHAR2,
87: x_report_set_id OUT NOCOPY NUMBER,

Line 118: (p_del_rows IN wsh_util_core.id_tab_type,

114: -- on each delivery and confirms each delivery
115:
116:
117: PROCEDURE Confirm_Delivery
118: (p_del_rows IN wsh_util_core.id_tab_type,
119: p_action_flag IN VARCHAR2,
120: p_intransit_flag IN VARCHAR2,
121: p_close_flag IN VARCHAR2,
122: p_stage_del_flag IN VARCHAR2,

Line 153: (p_del_rows IN wsh_util_core.id_tab_type,

149: -- NOTE: For CONFIRM use confirm_delivery procedure
150: --
151:
152: PROCEDURE Change_Status
153: (p_del_rows IN wsh_util_core.id_tab_type,
154: p_action IN VARCHAR2,
155: p_actual_date IN DATE DEFAULT NULL,
156: x_return_status OUT NOCOPY VARCHAR2,
157: --tkt

Line 187: (p_del_rows IN wsh_util_core.id_tab_type,

183: --
184: -- COMMENTING OUT AS LOAD TENDER FUNCTIONALITY IS TEMPORARILY REMOVED
185: /*
186: PROCEDURE Set_Load_Tender
187: (p_del_rows IN wsh_util_core.id_tab_type,
188: p_action IN VARCHAR2,
189: x_return_status OUT NOCOPY VARCHAR2);
190: */
191: --

Line 199: (p_del_rows IN wsh_util_core.id_tab_type,

195: -- Description: This procedure is used to generate loading sequence for deliveries
196: --
197:
198: PROCEDURE Generate_Loading_Seq
199: (p_del_rows IN wsh_util_core.id_tab_type,
200: x_return_status OUT NOCOPY VARCHAR2);
201:
202:
203: --

Line 232: PROCEDURE PROCESS_CARRIER_SELECTION(p_delivery_id_tab IN OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,

228: TYPE TableVarchar3 is TABLE of VARCHAR2(3) INDEX BY BINARY_INTEGER; -- table varchar(3) type
229: TYPE TableDate is TABLE of DATE INDEX BY BINARY_INTEGER;
230:
231:
232: PROCEDURE PROCESS_CARRIER_SELECTION(p_delivery_id_tab IN OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
233: p_batch_id IN NUMBER,
234: p_form_flag IN VARCHAR2,
235: p_organization_id IN NUMBER DEFAULT NULL,
236: -- csun deliveryMerge

Line 249: p_delivery_ids IN wsh_util_core.id_tab_type,

245: G_START_OF_PACKING VARCHAR2(1) := 'A';
246: G_START_OF_SHIPPING VARCHAR2(1) := 'W';
247:
248: PROCEDURE Adjust_Planned_Flag(
249: p_delivery_ids IN wsh_util_core.id_tab_type,
250: p_caller IN VARCHAR2,
251: p_force_appending_limit IN VARCHAR2,
252: p_call_lcss IN VARCHAR2 DEFAULT 'N',
253: p_event IN VARCHAR2 DEFAULT NULL,

Line 358: p_del_tab IN OUT NOCOPY wsh_util_core.id_tab_type,

354:
355: Procedure Unassign_Dels_from_Consol_Del(
356: p_parent_del IN NUMBER,
357: p_caller IN VARCHAR2,
358: p_del_tab IN OUT NOCOPY wsh_util_core.id_tab_type,
359: x_return_status OUT NOCOPY VARCHAR2);
360:
361:
362: --OTM R12, function to check if delivery is empty or not