[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;