1 PACKAGE PO_BUYER_WORKLOAD_SV AS
2 /* $Header: POXBWMWS.pls 120.0 2005/06/01 13:01:09 appldev noship $*/
3
4 /*===========================================================================
5 PROCEDURE NAME: get_num_unassigned()
6
7 DESCRIPTION: Determines the number of unassigned requistions that meet
8 search criteria. Alse determines the number that
9 are late, urgent and needed within a range of needby dates.
10
11 PARAMETERS: x_needby_date_low IN DATE,
12 x_needby_date_high IN DATE,
13 x_suggested_vendor IN VARCHAR2,
14 x_vendor_site IN VARCHAR2,
15 x_location_id IN NUMBER,
16 x_item_id IN NUMBER,
17 x_item_revision IN VARCHAR2,
18 x_item_description IN VARCHAR2,
19 x_category_id IN NUMBER,
20 x_line_type_id IN NUMBER,
21 x_approval_status_list IN VARCHAR2,
22 x_requisition_header_id IN NUMBER,
23 x_to_person_id IN NUMBER,
24 x_rate_type IN VARCHAR2,
25 x_currency_code IN VARCHAR2,
26 x_rfq_required_list IN VARCHAR2,
27 x_urgent_list IN VARCHAR2,
28 x_sourced_list IN VARCHAR2,
29 x_late_list IN VARCHAR2,
30 x_num_reqs IN OUT NUMBER,
31 x_num_urgent IN OUT NUMBER,
32 x_num_late IN OUT NUMBER,
33 x_num_needed IN OUT NUMBER
34
35 DESIGN REFERENCES: POXRQARQ.dd
36
37 ALGORITHM:
38
39 NOTES:
40
41 OPEN ISSUES:
42
43 CLOSED ISSUES:
44
45 CHANGE HISTORY: CMOK 6/21 Created
46 ===========================================================================*/
47
48 PROCEDURE get_num_unassigned (x_needby_date_low IN DATE,
49 x_needby_date_high IN DATE,
50 x_suggested_vendor IN VARCHAR2,
51 x_vendor_site IN VARCHAR2,
52 x_location_id IN NUMBER,
53 x_item_id IN NUMBER,
54 x_item_revision IN VARCHAR2,
55 x_item_description IN VARCHAR2,
56 x_category_id IN NUMBER,
57 x_line_type_id IN NUMBER,
58 x_approval_status_list IN VARCHAR2,
59 x_requisition_header_id IN NUMBER,
60 x_to_person_id IN NUMBER,
61 x_rate_type IN VARCHAR2,
62 x_currency_code IN VARCHAR2,
63 x_rfq_required_list IN VARCHAR2,
64 x_urgent_list IN VARCHAR2,
65 x_sourced_list IN VARCHAR2,
66 x_late_list IN VARCHAR2,
67 x_unassigned_reqs IN OUT NOCOPY NUMBER,
68 x_unassigned_urgent IN OUT NOCOPY NUMBER,
69 x_unassigned_late IN OUT NOCOPY NUMBER,
70 x_unassigned_needed IN OUT NOCOPY NUMBER);
71
72 /*===========================================================================
73 PROCEDURE NAME: get_num_assigned()
74
75 DESCRIPTION: Determines the number of requistions assigned to a buyer
76 that meet search criteria. Also determines the number that
77 are late, urgent and needed within a range of needby dates.
78
79 PARAMETERS: x_buyer_id IN NUMBER,
80 x_needby_date_low IN DATE,
81 x_needby_date_high IN DATE,
82 x_suggested_vendor IN VARCHAR2,
83 x_vendor_site IN VARCHAR2,
84 x_location_id IN NUMBER,
85 x_item_id IN NUMBER,
86 x_item_revision IN VARCHAR2,
87 x_item_description IN VARCHAR2,
88 x_category_id IN NUMBER,
89 x_line_type_id IN NUMBER,
90 x_approval_status_list IN VARCHAR2,
91 x_requisition_header_id IN NUMBER,
92 x_to_person_id IN NUMBER,
93 x_rate_type IN VARCHAR2,
94 x_currency_code IN VARCHAR2,
95 x_rfq_required_list IN VARCHAR2,
96 x_urgent_list IN VARCHAR2,
97 x_sourced_list IN VARCHAR2,
98 x_late_list IN VARCHAR2,
99 x_num_reqs IN OUT NUMBER,
100 x_num_urgent IN OUT NUMBER,
101 x_num_late IN OUT NUMBER,
102 x_num_needed IN OUT NUMBER
103
104 DESIGN REFERENCES: POXRQARQ.dd
105
106 ALGORITHM:
107
108 NOTES:
109
110 OPEN ISSUES:
111
112 CLOSED ISSUES:
113
114 CHANGE HISTORY: CMOK 6/21 Created
115 ===========================================================================*/
116
117 PROCEDURE get_num_assigned (
118 x_buyer_id IN NUMBER,
119 x_needby_date_low IN DATE,
120 x_needby_date_high IN DATE,
121 x_suggested_vendor IN VARCHAR2,
122 x_vendor_site IN VARCHAR2,
123 x_location_id IN NUMBER,
124 x_item_id IN NUMBER,
125 x_item_revision IN VARCHAR2,
126 x_item_description IN VARCHAR2,
127 x_category_id IN NUMBER,
128 x_line_type_id IN NUMBER,
129 x_approval_status_list IN VARCHAR2,
130 x_requisition_header_id IN NUMBER,
131 x_to_person_id IN NUMBER,
132 x_rate_type IN VARCHAR2,
133 x_currency_code IN VARCHAR2,
134 x_rfq_required_list IN VARCHAR2,
135 x_urgent_list IN VARCHAR2,
136 x_sourced_list IN VARCHAR2,
137 x_late_list IN VARCHAR2,
138 x_num_reqs IN OUT NOCOPY NUMBER,
139 x_num_urgent IN OUT NOCOPY NUMBER,
140 x_num_late IN OUT NOCOPY NUMBER,
141 x_num_needed IN OUT NOCOPY NUMBER);
142
143 /*===========================================================================
144 PROCEDURE NAME: update_buyer_by_rowid()
145
146 DESCRIPTION: Updates requisition lines with the new suggested buyer.
147
148 PARAMETERS: x_new_buyer_id IN NUMBER,
149 x_rowid IN ROWID,
150 x_user_id IN NUMBER,
151 x_login_id IN NUMBER
152
153 DESIGN REFERENCES: POXRQARQ.dd
154
155 ALGORITHM:
156
157 NOTES:
158
159 OPEN ISSUES:
160
161 CLOSED ISSUES:
162
163 CHANGE HISTORY: CMOK 6/21 Created
164 ===========================================================================*/
165
166 PROCEDURE update_buyer_by_rowid(x_new_buyer_id IN NUMBER,
167 x_rowid IN VARCHAR2,
168 x_user_id IN NUMBER,
169 x_login_id IN NUMBER);
170
171 PROCEDURE update_buyers(
172 x_new_buyer_id IN NUMBER,
173 x_old_buyer_id IN NUMBER,
174 x_needby_date_low IN DATE,
175 x_needby_date_high IN DATE,
176 x_suggested_vendor IN VARCHAR2,
177 x_vendor_site IN VARCHAR2,
178 x_location_id IN NUMBER,
179 x_item_id IN NUMBER,
180 x_item_revision IN VARCHAR2,
181 x_item_description IN VARCHAR2,
182 x_category_id IN NUMBER,
183 x_line_type_id IN NUMBER,
184 x_approval_status_list IN VARCHAR2,
185 x_requisition_header_id IN NUMBER,
186 x_to_person_id IN NUMBER,
187 x_rate_type IN VARCHAR2,
188 x_currency_code IN VARCHAR2,
189 x_assigned_list IN VARCHAR2,
190 x_rfq_required_list IN VARCHAR2,
191 x_urgent_list IN VARCHAR2,
192 x_sourced_list IN VARCHAR2,
193 x_late_list IN VARCHAR2,
194 x_user_id IN NUMBER,
195 x_login_id IN NUMBER);
196
197
198 FUNCTION num_open_po (x_agent_id IN NUMBER)
199 return NUMBER;
200 -- pragma restrict_references (num_open_po, WNDS, RNPS, WNPS);
201
202 --<ACHTML R12 Start>
203 PROCEDURE REQ_REASSIGN_ACTION_BULK( p_api_version IN NUMBER
204 ,x_return_status OUT NOCOPY VARCHAR2
205 ,x_error_message OUT NOCOPY VARCHAR2
206 ,p_employee_id IN NUMBER
207 ,p_req_line_id_tbl IN PO_TBL_NUMBER
208 ,p_new_buyer_id IN NUMBER);
209 --<ACHTML R12 End>
210 END;