[Home] [Help]
PACKAGE: APPS.WSH_INTERFACE_COMMON_ACTIONS
Source
1 PACKAGE WSH_INTERFACE_COMMON_ACTIONS AUTHID CURRENT_USER as
2 /* $Header: WSHINCAS.pls 120.0.12010000.2 2010/02/26 07:06:25 sankarun 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 -- TPW - Distributed changes
20 src_container_flag VARCHAR2(1),
21 parent_delivery_detail_id NUMBER);
22
23 TYPE PackingDetailTabType IS TABLE of PackingDetailRecType
24 INDEX BY BINARY_INTEGER;
25
26 --===================
27 -- PROCEDURES
28 --===================
29
30 /*
31 -----------------------------------------------------------------------------
32 PROCEDURE : Update_Interface_Assignments
33 PARAMETERS : p_parent_delivery_detail_id
34 p_parent_detail_interface_id
35 x_return_status - return status of API
36 DESCRIPTION :
37
38 ------------------------------------------------------------------------------
39 */
40
41
42 PROCEDURE Update_Contnr_Int_Assignments(
43 p_parent_delivery_detail_id IN NUMBER,
44 p_parent_detail_interface_id IN NUMBER,
45 x_return_status OUT NOCOPY VARCHAR2);
46
47 PROCEDURE process_interfaced_del_details(
48 p_delivery_interface_id IN NUMBER,
49 p_delivery_id IN NUMBER DEFAULT NULL,
50 p_new_delivery_id IN NUMBER DEFAULT NULL,
51 p_action_code IN VARCHAR2,
52 x_return_status OUT NOCOPY VARCHAR2);
53
54 PROCEDURE process_interfaced_deliveries(
55 p_delivery_interface_id IN NUMBER,
56 p_action_code IN VARCHAR2,
57 x_dlvy_id OUT NOCOPY NUMBER,
58 x_return_status OUT NOCOPY VARCHAR2);
59
60 PROCEDURE Process_Splits(
61 p_delivery_interface_id IN NUMBER,
62 p_delivery_id IN NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2);
64
65 PROCEDURE Pack_Lines(
66 x_return_status OUT NOCOPY VARCHAR2);
67
68 PROCEDURE Process_Non_Splits(
69 p_delivery_interface_id IN NUMBER,
70 p_delivery_id IN NUMBER,
71 p_new_delivery_id IN NUMBER,
72 p_action_code IN VARCHAR2,
73 x_return_status OUT NOCOPY VARCHAR2);
74
75 PROCEDURE Process_Cancel(
76 p_delivery_id IN NUMBER,
77 x_return_status OUT NOCOPY VARCHAR2);
78
79 PROCEDURE Delivery_Interface_Wrapper(
80 p_delivery_interface_id IN NUMBER,
81 p_action_code IN VARCHAR2,
82 x_delivery_id IN OUT NOCOPY NUMBER,
83 x_return_status OUT NOCOPY VARCHAR2);
84
85 PROCEDURE process_int_freight_costs(
86 p_delivery_interface_id IN NUMBER DEFAULT NULL,
87 p_del_detail_interface_id IN NUMBER DEFAULT NULL,
88 -- TPW - Distributed changes
89 p_delivery_detail_id IN NUMBER DEFAULT NULL,
90 p_stop_interface_id IN NUMBER DEFAULT NULL,
91 p_trip_interface_id IN NUMBER DEFAULT NULL,
92 x_return_status OUT NOCOPY VARCHAR2);
93
94 PROCEDURE Create_Update_Trip_For_dlvy(
95 p_delivery_id IN NUMBER,
96 x_pickup_stop_id OUT NOCOPY NUMBER,
97 x_dropoff_stop_id OUT NOCOPY NUMBER,
98 x_trip_id OUT NOCOPY NUMBER,
99 x_return_status OUT NOCOPY VARCHAR2);
100
101 PROCEDURE Int_Trip_Stop_Info(
102 p_delivery_interface_id IN NUMBER,
103 p_act_dep_date IN DATE,
104 p_dep_seal_code IN VARCHAR2,
105 p_act_arr_date IN DATE,
106 p_trip_vehicle_num IN VARCHAR2,
107 p_trip_veh_num_pfx IN VARCHAR2,
108 p_trip_route_id IN NUMBER,
109 p_trip_routing_ins IN VARCHAR2,
110 --Bug 3458160
111 p_operator IN VARCHAR2,
112 x_return_status OUT NOCOPY VARCHAR2);
113
114 PROCEDURE Lock_Delivery_And_Details(
115 p_delivery_id IN NUMBER,
116 x_return_status OUT NOCOPY VARCHAR2);
117
118
119 END WSH_INTERFACE_COMMON_ACTIONS;