PACKAGE: APPS.QP_CROSS_ORDER_VOLUME_LOAD

Source

1 PACKAGE  QP_Cross_Order_Volume_Load AUTHID CURRENT_USER AS
2 /* $Header: QPXCOVLS.pls 120.3 2006/10/03 11:54:28 nirmkuma noship $ */
3   -- Spec variables
4   -- row who columns
5 
6     P_created_by 	NUMBER    DEFAULT FND_GLOBAL.USER_ID;
7     P_creation_date  	DATE      DEFAULT SYSDATE;
8     P_login_id       	NUMBER    DEFAULT FND_GLOBAL.LOGIN_ID;
9     P_program_appl_id   NUMBER    DEFAULT FND_GLOBAL.PROG_APPL_ID;
10     P_conc_program_id   NUMBER    DEFAULT FND_GLOBAL.CONC_PROGRAM_ID;
11     P_request_id        NUMBER    DEFAULT FND_GLOBAL.CONC_REQUEST_ID;
12     P_sob_id            NUMBER    ;
13     P_user_id           NUMBER    DEFAULT FND_GLOBAL.USER_ID;
14     err_buff		    VARCHAR2(2000);
15     retcode		    NUMBER;
16 
17   PROCEDURE create_crossordvol_brk
18 		  (err_buff out NOCOPY /* file.sql.39 change */ VARCHAR2,
19 		   retcode out NOCOPY /* file.sql.39 change */ NUMBER,
20 		   x_org_id NUMBER,
21 		   x_load_effective_date VARCHAR2);
22 
23   PROCEDURE get_customer_total_amnts(x_cross_ordr_vol_perd1 	NUMBER,
24                                      x_cross_ordr_vol_perd2 	NUMBER,
25                                      x_cross_ordr_vol_perd3 	NUMBER,
26 							  x_sob_currency              VARCHAR2);
27 
28   FUNCTION get_uom_code(pitem_id NUMBER,porg_id NUMBER) RETURN VARCHAR2;
29 
30  -- PRAGMA RESTRICT_REFERENCES(get_uom_code,WNDS,WNPS);
31 
32   FUNCTION get_converted_qty(pitem_id NUMBER,porg_id NUMBER,pordr_qty NUMBER,porduom VARCHAR2) RETURN NUMBER;
33 
34   FUNCTION get_value(req_date DATE,perd_val NUMBER,p_inval NUMBER,
35    p_invaltwo NUMBER) RETURN NUMBER;
36 
37   FUNCTION convert_to_base_curr(p_trans_amount NUMBER, p_from_currency VARCHAR2,
38 						  p_to_currency VARCHAR2, p_conversion_date DATE,
39 						  p_conversion_rate NUMBER, p_conversion_type VARCHAR2)
40 						  RETURN NUMBER;
41 END QP_Cross_Order_Volume_Load;