[Home] [Help]
PACKAGE: APPS.WSH_INTERFACE_COMMON_ACTIONS
Source
1 PACKAGE WSH_INTERFACE_COMMON_ACTIONS as
2 /* $Header: WSHINCAS.pls 120.0.12000000.1 2007/01/16 05:46:46 appldev ship $ */
3
4
5 C_SDEBUG CONSTANT NUMBER := wsh_debug_sv.C_LEVEL1;
6 C_DEBUG CONSTANT NUMBER := wsh_debug_sv.C_LEVEL2;
7
8 --===================
9 -- PUBLIC VARS
10 --===================
11
12 -- Global variables and tables
13 G_Update_Attributes_Tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
14 G_Packing_Detail_Tab WSH_INTERFACE_COMMON_ACTIONS.PackingDetailTabType;
15 G_SERIAL_RANGE_TAB WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;
16
17 TYPE PackingDetailRecType IS RECORD(
18 delivery_detail_id NUMBER,
19 parent_delivery_detail_id NUMBER);
20
21 TYPE PackingDetailTabType IS TABLE of PackingDetailRecType
22 INDEX BY BINARY_INTEGER;
23
24 --===================
25 -- PROCEDURES
26 --===================
27
28 /*
29 -----------------------------------------------------------------------------
30 PROCEDURE : Update_Interface_Assignments
31 PARAMETERS : p_parent_delivery_detail_id
32 p_parent_detail_interface_id
33 x_return_status - return status of API
34 DESCRIPTION :
35
36 ------------------------------------------------------------------------------
37 */
38
39
40 PROCEDURE Update_Contnr_Int_Assignments(
41 p_parent_delivery_detail_id IN NUMBER,
42 p_parent_detail_interface_id IN NUMBER,
43 x_return_status OUT NOCOPY VARCHAR2);
44
45 PROCEDURE process_interfaced_del_details(
46 p_delivery_interface_id IN NUMBER,
47 p_delivery_id IN NUMBER DEFAULT NULL,
48 p_new_delivery_id IN NUMBER DEFAULT NULL,
49 p_action_code IN VARCHAR2,
50 x_return_status OUT NOCOPY VARCHAR2);
51
52 PROCEDURE process_interfaced_deliveries(
53 p_delivery_interface_id IN NUMBER,
54 p_action_code IN VARCHAR2,
55 x_dlvy_id OUT NOCOPY NUMBER,
56 x_return_status OUT NOCOPY VARCHAR2);
57
58 PROCEDURE Process_Splits(
59 p_delivery_interface_id IN NUMBER,
60 p_delivery_id IN NUMBER,
61 x_return_status OUT NOCOPY VARCHAR2);
62
63 PROCEDURE Pack_Lines(
64 x_return_status OUT NOCOPY VARCHAR2);
65
66 PROCEDURE Process_Non_Splits(
67 p_delivery_interface_id IN NUMBER,
68 p_delivery_id IN NUMBER,
69 p_new_delivery_id IN NUMBER,
70 p_action_code IN VARCHAR2,
71 x_return_status OUT NOCOPY VARCHAR2);
72
73 PROCEDURE Process_Cancel(
74 p_delivery_id IN NUMBER,
75 x_return_status OUT NOCOPY VARCHAR2);
76
77 PROCEDURE Delivery_Interface_Wrapper(
78 p_delivery_interface_id IN NUMBER,
79 p_action_code IN VARCHAR2,
80 x_delivery_id IN OUT NOCOPY NUMBER,
81 x_return_status OUT NOCOPY VARCHAR2);
82
83 PROCEDURE process_int_freight_costs(
84 p_delivery_interface_id IN NUMBER DEFAULT NULL,
85 p_del_detail_interface_id IN NUMBER DEFAULT NULL,
86 p_stop_interface_id IN NUMBER DEFAULT NULL,
87 p_trip_interface_id IN NUMBER DEFAULT NULL,
88 x_return_status OUT NOCOPY VARCHAR2);
89
90 PROCEDURE Create_Update_Trip_For_dlvy(
91 p_delivery_id IN NUMBER,
92 x_pickup_stop_id OUT NOCOPY NUMBER,
93 x_dropoff_stop_id OUT NOCOPY NUMBER,
94 x_trip_id OUT NOCOPY NUMBER,
95 x_return_status OUT NOCOPY VARCHAR2);
96
97 PROCEDURE Int_Trip_Stop_Info(
98 p_delivery_interface_id IN NUMBER,
99 p_act_dep_date IN DATE,
100 p_dep_seal_code IN VARCHAR2,
101 p_act_arr_date IN DATE,
102 p_trip_vehicle_num IN VARCHAR2,
103 p_trip_veh_num_pfx IN VARCHAR2,
104 p_trip_route_id IN NUMBER,
105 p_trip_routing_ins IN VARCHAR2,
106 --Bug 3458160
107 p_operator IN VARCHAR2,
108 x_return_status OUT NOCOPY VARCHAR2);
109
110 PROCEDURE Lock_Delivery_And_Details(
111 p_delivery_id IN NUMBER,
112 x_return_status OUT NOCOPY VARCHAR2);
113
114
115 END WSH_INTERFACE_COMMON_ACTIONS;