1 PACKAGE CHV_INQ_SV AUTHID CURRENT_USER as
2 /* $Header: CHVSIN1S.pls 115.2 2002/11/26 23:39:08 sbull ship $ */
3
4 /*===========================================================================
5 PACKAGE NAME: CHV_INQ_SV
6
7 DESCRIPTION: This package contains the server side CHV Inquiry
8 Application Program Interfaces (APIs).
9
10 CLIENT/SERVER: Server
11
12 OWNER: Sri Rumalla
13
14 FUNCTION/PROCEDURE:
15 ===========================================================================*/
16
17 /*===========================================================================
18 PROCEDURE NAME: get_receipt_quantity()
19
20 DESCRIPTION: This procedure will return the last receipt
21 info to the calling module including the converted
22 quantity in purchasing unit_of_measure
23
24
25 PARAMETERS: p_last_receipt_transaction_id in number
26 p_item_id in number
27 p_purchasing_unit_of_measure in varchar2
28 p_purchasing_quantity in out number
29 p_shipment_number in out varchar2
30 p_receipt_transaction_date in out date
31
32
33
34 DESIGN REFERENCES:
35
36 ALGORITHM:
37
38 NOTES:
39
40 OPEN ISSUES:
41
42 CLOSED ISSUES:
43
44 CHANGE HISTORY: Created 11-MAY-95 SRUMALLA
45 ===========================================================================*/
46 PROCEDURE get_receipt_qty(p_last_receipt_transaction_id in number,
47 p_item_id in number,
48 p_purchasing_unit_of_measure in varchar2,
49 p_purchasing_quantity in out NOCOPY number,
50 p_shipment_number in out NOCOPY varchar2,
51 p_receipt_transaction_date in out NOCOPY date) ;
52
53 /*===========================================================================
54
55 PROCEDURE NAME: get_bucket_dates()
56
57 DESCRIPTION: This procedure will get the column name from
58 and will select the bucket start date and end date
59 from chv_horizontal_schedules and return to the
60 workbench form.
61
62 PARAMETERS: p_schedule_id
63 p_schedule_item_id
64 p_column_name
65 p_bucket_descriptor
66 p_bucket_start_date
67 p_bucket_end_date
68
69 DESIGN REFERENCES:
70
71 ALGORITHM:
72
73 NOTES:
74
75 OPEN ISSUES:
76
77 CLOSED ISSUES:
78
79 CHANGE HISTORY: Created 29-MAY-95 SRUMALLA
80 ===========================================================================*/
81 PROCEDURE get_bucket_dates(p_schedule_id IN NUMBER,
82 p_schedule_item_id IN NUMBER,
83 p_column_name IN VARCHAR2,
84 p_bucket_descriptor IN OUT NOCOPY VARCHAR2,
85 p_bucket_start_date IN OUT NOCOPY DATE,
86 p_bucket_end_date IN OUT NOCOPY DATE) ;
87
88 /*===========================================================================
89 FUNCTION NAME: get_asl_org()
90
91 DESCRIPTION: This function will retreive the local organization
92 id from po_asl_attributes based on the supplier/site/
93 item/org. If the local does not exist the function
94 will return -1(global org).
95
96
97 PARAMETERS:
98
99
100
101 DESIGN REFERENCES:
102
103 ALGORITHM:
104
105 NOTES:
106
107 OPEN ISSUES:
108
109 CLOSED ISSUES:
110
111 CHANGE HISTORY: Created 11-MAY-95 SRUMALLA
112 ===========================================================================*/
113 FUNCTION get_asl_org(p_organization_id IN NUMBER,
114 p_vendor_id IN NUMBER,
115 p_vendor_site_id IN NUMBER,
116 p_item_id IN NUMBER)
117 RETURN NUMBER;
118
119 --PRAGMA RESTRICT_REFERENCES(get_asl_org,WNDS,RNPS,WNPS);
120
121
122 /*===========================================================================
123 FUNCTION NAME: get_last_receipt_id()
124
125 DESCRIPTION: This function will get the last receipt id which is
126 used by the CHVSSCUM for to retrieve the last receipt
127 details
128
129
130 PARAMETERS:
131
132
133
134 DESIGN REFERENCES:
135
136 ALGORITHM:
137
138 NOTES:
139
140 OPEN ISSUES:
141
142 CLOSED ISSUES:
143
144
145 CHANGE HISTORY: Created 7/30/96 SASMITH
146 ===========================================================================*/
147 function get_last_receipt_id(x_vendor_id in number,
148 x_vendor_site_id in number,
149 x_item_id in number,
150 x_organization_id in number,
151 x_cum_period_start_date in date,
152 x_cum_period_end_date in date)
153 return number;
154 --PRAGMA RESTRICT_REFERENCES(get_last_receipt_id,WNDS,RNPS,WNPS);
155
156 /*===========================================================================
157 FUNCTION NAME: get_bucket_type()
158
159 DESCRIPTION: This function will retreive the displayed field
160 for the bucket.
161
162
163 PARAMETERS: p_bucket_type_code
164
165
166 DESIGN REFERENCES:
167
168 ALGORITHM:
169
170 NOTES:
171
172 OPEN ISSUES:
173
174 CLOSED ISSUES:
175
176 CHANGE HISTORY: Created 08-AUG-96 SRUMALLA
177 ===========================================================================*/
178
179 FUNCTION get_bucket_type(p_bucket_type_code in varchar2)
180 RETURN VARCHAR2 ;
181
182 --PRAGMA RESTRICT_REFERENCES(get_bucket_type,WNDS,RNPS,WNPS);
183
184 END CHV_INQ_SV ;