[Home] [Help]
PACKAGE: APPS.QP_CROSS_ORDER_VOLUME_LOAD
Source
1 PACKAGE QP_Cross_Order_Volume_Load 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;