1 PACKAGE WSH_FTE_COMP_CONSTRAINT_PKG as
2 /* $Header: WSHFTCCS.pls 120.0 2005/05/26 17:44:16 appldev noship $ */
3
4 -- Global Variables
5
6 g_session_id NUMBER;
7
8
9 /* Utility Data structures */
10
11 TYPE failed_line_rec_type IS RECORD (
12 failed_line_index NUMBER
13 , entity_line_id NUMBER
14 );
15
16 TYPE failed_line_tab_type IS TABLE OF failed_line_rec_type INDEX BY BINARY_INTEGER;
17
18 TYPE line_group_rec_type IS RECORD (
19 line_group_index NUMBER
20 , entity_line_id NUMBER
21 , line_group_id NUMBER -- Id to suggest which lines can be grouped together
22 );
23
24 TYPE line_group_tab_type IS TABLE OF line_group_rec_type INDEX BY BINARY_INTEGER;
25
26 TYPE cc_group_rec_type IS RECORD (
27 group_index NUMBER
28 , line_group_id NUMBER -- Id to suggest which lines can be grouped together
29 , upd_dlvy_intmed_ship_to VARCHAR2(1) -- NULL means YES
30 , upd_dlvy_ship_method VARCHAR2(1)
31 );
32
33 TYPE cc_group_tab_type IS TABLE OF cc_group_rec_type INDEX BY BINARY_INTEGER;
34
35 --#DUM_LOC(S)
36 TYPE valid_const_cache IS RECORD (
37 valid_const_present BOOLEAN
38 , cache_date DATE
39 );
40
41 /*TYPE deconsol_output_rec_type IS RECORD (
42 deconsol_location NUMBER,
43 entity_id NUMBER,
44 validation_status VARCHAR2(1));
45
46 TYPE deconsol_output_tab_type IS TABLE OF deconsol_output_rec_type INDEX BY BINARY_INTEGER;*/
47
48 g_valid_const_cache valid_const_cache;
49 --#DUM_LOC(E)
50
51
52 -- Wrapper for calling validate_constraint_dlvy with approp. parameters populated for diff. actions
53 -- For compatibility constraints project
54 --auto pack, auto pack master do not have any constraints which are implemented in I so they will not be used as of now
55 -- p_entity_type 'D' for del, 'L' for line, 'T' for trip, 'S' for stop based on this pass p_del_attr_tab or p_det_attr_tab or p_trip_attr_tab or p_stop_attr_tab or just pass p_in_ids
56 -- p_target_id id of container/delivery/trip based on action
57 -- p_in_ids use this only for calling in cases where p_rec_attr_tab is not available
58
59 PROCEDURE validate_constraint_main
60 ( p_api_version_number IN NUMBER,
61 p_init_msg_list IN VARCHAR2,
62 p_entity_type IN VARCHAR2,
63 p_target_id IN NUMBER,
64 p_action_code IN VARCHAR2,
65 p_del_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type ,
66 p_det_attr_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
67 p_trip_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
68 p_stop_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
69 p_in_ids IN wsh_util_core.id_tab_type,
70 p_pickup_stop_id IN NUMBER DEFAULT NULL,
71 p_pickup_loc_id IN NUMBER DEFAULT NULL,
72 p_pickup_stop_seq IN NUMBER DEFAULT NULL,
73 p_dropoff_stop_id IN NUMBER DEFAULT NULL,
74 p_dropoff_loc_id IN NUMBER DEFAULT NULL,
75 p_dropoff_stop_seq IN NUMBER DEFAULT NULL,
76 p_pickup_arr_date IN DATE DEFAULT NULL,
77 p_pickup_dep_date IN DATE DEFAULT NULL,
78 p_dropoff_arr_date IN DATE DEFAULT NULL,
79 p_dropoff_dep_date IN DATE DEFAULT NULL,
80 x_validate_result OUT NOCOPY VARCHAR2,
81 x_failed_lines OUT NOCOPY failed_line_tab_type,
82 x_line_groups OUT NOCOPY line_group_tab_type,
83 x_group_info OUT NOCOPY cc_group_tab_type,
84 x_fail_ids OUT NOCOPY wsh_util_core.id_tab_type,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2
88 );
89
90 PROCEDURE validate_constraint_dleg(
91 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
92 p_action_code IN VARCHAR2,
93 p_delivery_leg_id IN NUMBER DEFAULT NULL,
94 p_delivery_id IN NUMBER,
95 p_sequence_num IN NUMBER DEFAULT NULL,
96 p_location1_id IN NUMBER DEFAULT NULL,
97 p_location2_id IN NUMBER DEFAULT NULL,
98 p_stop1_id IN NUMBER DEFAULT NULL,
99 p_stop2_id IN NUMBER DEFAULT NULL,
100 p_date_1 IN DATE DEFAULT NULL,
101 p_date_2 IN DATE DEFAULT NULL,
102 p_target_trip_id IN NUMBER DEFAULT NULL, -- For DST
103 p_carrier_id IN NUMBER DEFAULT NULL, -- Following 3 for DCE
104 p_mode_code IN VARCHAR2 DEFAULT NULL,
105 p_service_level IN VARCHAR2 DEFAULT NULL,
106 x_validate_result OUT NOCOPY VARCHAR2, -- Constraint Validation result : S / F
107 x_msg_count OUT NOCOPY NUMBER, -- Standard FND functionality
108 x_msg_data OUT NOCOPY VARCHAR2, -- Will return message text only if number of messages = 1
109 x_return_status OUT NOCOPY VARCHAR2);
110
111
112 END WSH_FTE_COMP_CONSTRAINT_PKG;
113