PACKAGE: APPS.CHV_INQ_SV2

Source

1 PACKAGE CHV_INQ_SV2 AUTHID CURRENT_USER as
2 /* $Header: CHVSIN2S.pls 115.1 99/10/11 17:16:32 porting shi $ */
3 
4 /*===========================================================================
5   PACKAGE NAME:		CHV_INQ_SV2
6 
7   DESCRIPTION:		This package contains the server side CHV Inquiry
8 			Application Program Interfaces (APIs).
9 
10   CLIENT/SERVER:	Server
11 
12   OWNER:		Kim Powell
13 
14   FUNCTION/PROCEDURE:
15 ===========================================================================*/
16 
17 FUNCTION get_last_receipt_num(p_org_id in number,
18 			 p_item_id in number,
19 			 p_vendor_id in number,
20 			 p_vendor_site_id in number,
21 			 p_cum_period_start_date date,
22 			 p_cum_period_end_date date)
23                                 RETURN VARCHAR2 ;
24 
25 --PRAGMA RESTRICT_REFERENCES(get_last_receipt_num,WNDS);
26 
27 FUNCTION get_last_receipt_date(p_org_id in number,
28 			 p_item_id in number,
29 			 p_vendor_id in number,
30 			 p_vendor_site_id in number,
31 			 p_cum_period_start_date date,
32 			 p_cum_period_end_date date)
33                                 RETURN DATE ;
34 
35 --PRAGMA RESTRICT_REFERENCES(get_last_receipt_date,WNDS);
36 
37 FUNCTION get_last_receipt_quantity(p_org_id in number,
38 			 p_item_id in number,
39 			 p_vendor_id in number,
40 			 p_vendor_site_id in number,
41 			 p_cum_period_start_date date,
42 			 p_cum_period_end_date date,
43 			 p_purchasing_uom varchar2)
44                                 RETURN NUMBER ;
45 
46 --PRAGMA RESTRICT_REFERENCES(get_last_receipt_quantity,WNDS);
47 
48 FUNCTION get_cum_received_purch(X_vendor_id IN NUMBER,
49                                 X_vendor_site_id IN NUMBER,
50                                 X_item_id IN NUMBER,
51                                 X_organization_id IN NUMBER,
52                                 X_rtv_transactions_included IN VARCHAR2,
53                                 X_cum_period_start IN DATE,
54                                 X_cum_period_end IN DATE,
55                                 X_purchasing_unit_of_measure IN VARCHAR2)
56 					RETURN NUMBER;
57 
58 --PRAGMA RESTRICT_REFERENCES(get_cum_received_purch,WNDS);
59 
60 function get_purchasing_uom_qty(x_primary_quantity in number,
61 				x_primary_unit_of_measure in varchar2,
62 				x_vendor_id in number,
63 				x_vendor_site_id in number,
64 				x_organization_id in number,
65 				x_item_id in number)
66 		 return number;
67 
68 --PRAGMA RESTRICT_REFERENCES(get_purchasing_uom_qty,WNDS);
69 
70 
71 END CHV_INQ_SV2;