1 PACKAGE FTE_TENDER_WF AUTHID CURRENT_USER AS
2 /* $Header: FTETEWFS.pls 120.2 2005/08/16 16:29:15 hbhagava noship $ */
3
4 PROCEDURE GET_DOCK_CLOSE_DATE (p_loc_id IN NUMBER,
5 p_tender_date IN DATE,
6 x_dock_close_date OUT NOCOPY DATE,
7 x_return_status OUT NOCOPY VARCHAR2);
8
9 PROCEDURE INITIALIZE_TENDER_REQUEST(itemtype in varchar2,
10 itemkey in varchar2,
11 actid in number,
12 funcmode in varchar2,
13 resultout out NOCOPY varchar2);
14
15
16 PROCEDURE FINALIZE_TENDER_REQUEST(itemtype in varchar2,
17 itemkey in varchar2,
18 actid in number,
19 funcmode in varchar2,
20 resultout out NOCOPY varchar2);
21
22 PROCEDURE FINALIZE_UPDATE_TENDER(itemtype in varchar2,
23 itemkey in varchar2,
24 actid in number,
25 funcmode in varchar2,
26 resultout out NOCOPY varchar2);
27
28
29 PROCEDURE IS_TENDER_MODIFIED(itemtype in varchar2,
30 itemkey in varchar2,
31 actid in number,
32 funcmode in varchar2,
33 resultout out NOCOPY varchar2);
34
35 PROCEDURE IS_REMINDER_ENABLED(itemtype in varchar2,
36 itemkey in varchar2,
37 actid in number,
38 funcmode in varchar2,
39 resultout out NOCOPY varchar2);
40
41 PROCEDURE CALCULATE_WAIT_TIME(itemtype in varchar2,
42 itemkey in varchar2,
43 actid in number,
44 funcmode in varchar2,
45 resultout out NOCOPY varchar2);
46
47 PROCEDURE FINALIZE_NORESPONSE(itemtype in varchar2,
48 itemkey in varchar2,
49 actid in number,
50 funcmode in varchar2,
51 resultout out NOCOPY varchar2);
52
53 PROCEDURE FINALIZE_AUTO_ACCEPT(itemtype in varchar2,
54 itemkey in varchar2,
55 actid in number,
56 funcmode in varchar2,
57 resultout out NOCOPY varchar2);
58
59 PROCEDURE IS_AUTO_ACCEPT_ENABLED(itemtype in varchar2,
60 itemkey in varchar2,
61 actid in number,
62 funcmode in varchar2,
63 resultout out NOCOPY varchar2);
64
65 PROCEDURE GET_TENDER_INFO(
66 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
67 p_tender_id IN NUMBER,
68 x_return_status out NOCOPY VARCHAR2,
69 x_msg_count out NOCOPY NUMBER,
70 x_msg_data out NOCOPY VARCHAR2,
71 x_response_by out NOCOPY DATE,
72 x_shipper_wait_time OUT NOCOPY VARCHAR2,
73 x_remaining_time OUT NOCOPY VARCHAR2,
74 x_routing_inst out NOCOPY VARCHAR2,
75 x_tendered_date out NOCOPY DATE,
76 x_carrier_remarks out NOCOPY VARCHAR2,
77 x_mode_of_transport OUT NOCOPY VARCHAR2);
78
79 PROCEDURE RAISE_TENDER_ACCEPT( itemtype in varchar2,
80 itemkey in varchar2,
81 actid in number,
82 funcmode in varchar2,
83 resultout out NOCOPY varchar2);
84
85 PROCEDURE RAISE_TENDER_REJECT( itemtype in varchar2,
86 itemkey in varchar2,
87 actid in number,
88 funcmode in varchar2,
89 resultout out NOCOPY varchar2);
90
91 PROCEDURE UPDATE_CARRIER_RESPONSE(
92 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
93 p_tender_id IN NUMBER,
94 p_tender_status IN VARCHAR2,
95 p_wf_item_key IN VARCHAR2,
96 p_remarks IN VARCHAR2,
97 p_initial_pickup_date IN DATE,
98 p_ultimate_dropoff_date IN DATE,
99 p_vehicle_number IN VARCHAR2,
100 p_operator IN VARCHAR2,
101 p_carrier_ref_number IN VARCHAR2,
102 p_call_source IN VARCHAR2,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2);
106
107 PROCEDURE GET_ITEM_INFO(
108 P_ITEM_TYPE IN VARCHAR2,
109 P_ITEM_KEY IN VARCHAR2,
110 X_SHIPPER_NAME OUT NOCOPY VARCHAR2,
111 X_TENDERED_DATE OUT NOCOPY DATE,
112 X_RESPOND_BY_DATE OUT NOCOPY DATE,
113 X_VEHICLE_TYPE OUT NOCOPY VARCHAR2,
114 X_VEHICLE_CLASS OUT NOCOPY VARCHAR2);
115
116 PROCEDURE VALIDATE_XML_INFO(
117 P_TENDER_NUMBER IN NUMBER,
118 P_TENDER_STATUS IN VARCHAR2,
119 P_WF_ITEM_KEY IN VARCHAR2,
120 P_SHIPMENT_STATUS_ID IN NUMBER,
121 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
122
123
124 --Rel 12 HBHAGAVA
125 --{
126
127 PROCEDURE GET_NOTIF_TYPE(itemtype in varchar2,
128 itemkey in varchar2,
129 actid in number,
130 funcmode in varchar2,
131 resultout out NOCOPY varchar2);
132
133 PROCEDURE LOG_HISTORY(itemtype in varchar2,
134 itemkey in varchar2,
135 actid in number,
136 funcmode in varchar2,
137 resultout out NOCOPY varchar2);
138
139 PROCEDURE RAISE_XML_OUTBOUND(itemtype in varchar2,
140 itemkey in varchar2,
141 actid in number,
142 funcmode in varchar2,
143 resultout out NOCOPY varchar2);
144
145
146 PROCEDURE EXPAND_RANK_LIST(itemtype in varchar2,
147 itemkey in varchar2,
148 actid in number,
149 funcmode in varchar2,
150 resultout out NOCOPY varchar2);
151
152 PROCEDURE IS_RANK_LIST_EXHAUSTED(itemtype in varchar2,
153 itemkey in varchar2,
154 actid in number,
155 funcmode in varchar2,
156 resultout out NOCOPY varchar2);
157
158
159 PROCEDURE REMOVE_SERVICE_APPLY_NEXT(itemtype in varchar2,
160 itemkey in varchar2,
161 actid in number,
162 funcmode in varchar2,
163 resultout out NOCOPY varchar2);
164
165 PROCEDURE AUTO_TENDER_SERVICE(itemtype in varchar2,
166 itemkey in varchar2,
167 actid in number,
168 funcmode in varchar2,
169 resultout out NOCOPY varchar2);
170
171 PROCEDURE FTETENDER_SELECTOR(itemtype in varchar2,
172 itemkey in varchar2,
173 actid in number,
174 funcmode in varchar2,
175 resultout out NOCOPY varchar2);
176
177
178 --}
179
180
181 END FTE_TENDER_WF;