DBA Data[Home] [Help]

PACKAGE: APPS.POS_SCO_TOLERANCE_PVT

Source


1 PACKAGE POS_SCO_TOLERANCE_PVT AUTHID CURRENT_USER AS
2 /* $Header: POSPTOLS.pls 120.9 2006/08/23 12:16:12 svadlama noship $ */
3 
4   G_PKG_NAME  CONSTANT    VARCHAR2(30) := 'POS_SCO_TOLERANCE_PVT';
5   G_FILE_NAME CONSTANT    VARCHAR2(30) := 'POSPTOLS.pls';
6 
7 
8 PROCEDURE INITIALIZE_TOL_VALUES               (itemtype        IN VARCHAR2,
9   	                                       itemkey         IN VARCHAR2,
10   	                                       actid           IN NUMBER,
11   	                                       funcmode        IN VARCHAR2,
12                                                resultout       OUT NOCOPY VARCHAR2);
13 
14 PROCEDURE PROMISE_DATE_WITHIN_TOL             (itemtype        IN  VARCHAR2,
15  	                                       itemkey         IN  VARCHAR2,
16  	                                       actid           IN  NUMBER,
17  	                                       funcmode        IN  VARCHAR2,
18                                                resultout       OUT NOCOPY VARCHAR2);
19 
20 PROCEDURE UNIT_PRICE_WITHIN_TOL               (itemtype        IN VARCHAR2,
21  	                                       itemkey         IN VARCHAR2,
22  	                                       actid           IN NUMBER,
23  	                                       funcmode        IN VARCHAR2,
24                                                resultout       OUT NOCOPY VARCHAR2);
25 
26 PROCEDURE SHIP_QUANTITY_WITHIN_TOL            (itemtype        IN VARCHAR2,
27  	                                       itemkey         IN VARCHAR2,
28  	                                       actid           IN NUMBER,
29  	                                       funcmode        IN VARCHAR2,
30                                                resultout       OUT NOCOPY VARCHAR2);
31 
32 PROCEDURE DOC_AMOUNT_WITHIN_TOL               (itemtype        IN VARCHAR2,
33  	                                       itemkey         IN VARCHAR2,
34  	                                       actid           IN NUMBER,
35  	                                       funcmode        IN VARCHAR2,
36                                                resultout       OUT NOCOPY VARCHAR2);
37 
38 FUNCTION CALCULATE_NEW_DOC_AMOUNT(  p_po_header_id IN NUMBER , p_po_release_id IN NUMBER, p_complex_po_style IN VARCHAR2)
39 RETURN NUMBER;
40 
41 
42 PROCEDURE LINE_AMOUNT_WITHIN_TOL              (itemtype        IN VARCHAR2,
43  	                                       itemkey         IN VARCHAR2,
44  	                                       actid           IN NUMBER,
45  	                                       funcmode        IN VARCHAR2,
46                                                resultout       OUT NOCOPY VARCHAR2);
47 
48 FUNCTION  CALCULATE_NEW_LINE_AMOUNT( p_po_header_id IN NUMBER, p_po_release_id IN NUMBER, p_po_line_id IN NUMBER, p_complex_po_style IN VARCHAR2)
49 RETURN NUMBER;
50 
51 PROCEDURE SHIP_AMOUNT_WITHIN_TOL              (itemtype        IN VARCHAR2,
52  	                                       itemkey         IN VARCHAR2,
53  	                                       actid           IN NUMBER,
54  	                                       funcmode        IN VARCHAR2,
55                                                resultout       OUT NOCOPY VARCHAR2);
56 
57 FUNCTION CALCULATE_NEW_SHIP_AMOUNT( p_po_header_id         IN NUMBER,
58                                     p_po_release_id        IN NUMBER,
59                                     p_line_location_id     IN NUMBER,
60                                     p_split_flag           IN VARCHAR2,
61                                     p_po_style_type        IN VARCHAR2,
62                                     p_po_shipment_num      IN NUMBER)
63 RETURN NUMBER;
64 
65 
66 PROCEDURE ROUTE_TO_REQUESTER                  (itemtype        IN VARCHAR2,
67   	                                       itemkey         IN VARCHAR2,
68   	                                       actid           IN NUMBER,
69   	                                       funcmode        IN VARCHAR2,
70                                                resultout       OUT NOCOPY VARCHAR2);
71 
72 PROCEDURE MARK_SCO_FOR_REQ                    (itemtype        IN VARCHAR2,
73 		                               itemkey         IN VARCHAR2,
74         		                       actid           IN NUMBER,
75 	            	                       funcmode        IN VARCHAR2,
76                                                resultout       OUT NOCOPY VARCHAR2);
77 
78 PROCEDURE ROUTE_SCO_BIZ_RULES                 (itemtype        IN VARCHAR2,
79  	                                       itemkey         IN VARCHAR2,
80  	                                       actid           IN NUMBER,
81  	                                       funcmode        IN VARCHAR2,
82                                                resultout       OUT NOCOPY VARCHAR2);
83 
84 PROCEDURE AUTO_APP_BIZ_RULES                  (itemtype        IN VARCHAR2,
85    	                                       itemkey         IN VARCHAR2,
86    	                                       actid           IN NUMBER,
87    	                                       funcmode        IN VARCHAR2,
88                                                resultout       OUT NOCOPY VARCHAR2);
89 
90 
91 PROCEDURE PROMISE_DATE_CHANGE                 (itemtype        IN VARCHAR2,
92   	                                       itemkey         IN VARCHAR2,
93   	                                       actid           IN NUMBER,
94   	                                       funcmode        IN VARCHAR2,
95                                                resultout       OUT NOCOPY VARCHAR2);
96 
97 
98 PROCEDURE INITIATE_RCO_FLOW                   (itemtype        IN VARCHAR2,
99      	                                       itemkey         IN VARCHAR2,
100      	                                       actid           IN NUMBER,
101      	                                       funcmode        IN VARCHAR2,
102                                                resultout       OUT NOCOPY VARCHAR2);
103 
104 
105 PROCEDURE START_RCO_WORKFLOW                  (itemtype        IN VARCHAR2,
106    	                                       itemkey         IN VARCHAR2,
107    	                                       actid           IN NUMBER,
108    	                                       funcmode        IN VARCHAR2,
109                                                resultout       OUT NOCOPY VARCHAR2) ;
110 
111 
112 PROCEDURE INITIATERCOFLOW                     (p_po_header_id    IN NUMBER,
113                                                p_po_release_id   IN NUMBER,
114                                                x_change_group_id OUT NOCOPY NUMBER) ;
115 
116 PROCEDURE STARTRCOWORKFLOW                    (p_change_request_group_id IN NUMBER);
117 
118 
119 PROCEDURE LOG_MESSAGE                         (p_proc_name      IN VARCHAR2,
120                                                p_text           IN VARCHAR2,
121                                                p_log_data       IN VARCHAR2);
122 
123 
124 FUNCTION CHANGE_WITHIN_TOL                    (p_oldValue         IN NUMBER,
125                                                p_newValue         IN NUMBER,
126 	                                       p_maxINcrement_per IN NUMBER,
127 	                                       p_maxDecrement_per IN NUMBER,
128 	                                       p_maxINcrement_val IN NUMBER,
129 	                                       p_maxDecrement_val IN NUMBER)
130 RETURN BOOLEAN;
131 
132 
133 
134 FUNCTION CHANGE_WITHIN_TOL_DATE               (p_oldValue         IN DATE,
135 		                               p_newValue         IN DATE,
136 		                               p_maxINcrement     IN NUMBER,
137 		                               p_maxDecrement     IN NUMBER)
138 
139 RETURN BOOLEAN ;
140 
141 
142 
143 FUNCTION ROUTE_SCO_BIZ_RULES_CHECK            (p_po_header_id     IN NUMBER,
144                                                p_po_release_id    IN NUMBER,
145                                                p_doc_type         IN VARCHAR2,
146                                                p_change_group_id  IN NUMBER)
147 
148 RETURN BOOLEAN ;
149 
150 
151 FUNCTION AUTO_APP_BIZ_RULES_CHECK             (p_po_header_id     IN NUMBER,
152                                                p_po_release_id    IN NUMBER,
153                                                p_doc_type         IN VARCHAR2)
154 
155 RETURN BOOLEAN ;
156 
157 
158 
159 FUNCTION ROUTETOREQUESTER                     (p_po_header_id     IN NUMBER,
160                                                p_change_group_id  IN NUMBER,
161                                                p_doc_type         IN VARCHAR2,
162                                                p_prm_date_app_flag IN VARCHAR2,
163                                                p_ship_qty_app_flag IN VARCHAR2,
164                                                p_unit_price_app_flag IN VARCHAR2)
165 
166 RETURN BOOLEAN;
167 
168 FUNCTION PROMISEDATECHANGE                    (p_po_header_id     IN NUMBER,
169                                                p_change_group_id  IN NUMBER)
170 
171 RETURN BOOLEAN;
172 
173 
174 
175 END POS_SCO_TOLERANCE_PVT;