1 PACKAGE XTR_STOCK_POSITION_P AUTHID CURRENT_USER as
2 /* $Header: xtrsposs.pls 120.1 2005/10/27 09:59:21 eaggarwa noship $*/
3
4 PROCEDURE MAINTAIN_STK_POSITION_HISTORY(
5 P_START_DATE IN DATE,
6 P_DEAL_NUMBER IN NUMBER,
7 P_TRANSACTION_NUMBER IN NUMBER,
8 P_COMPANY_CODE IN VARCHAR2,
9 P_CURRENCY IN VARCHAR2,
10 P_DEAL_TYPE IN VARCHAR2,
11 P_DEAL_SUBTYPE IN VARCHAR2,
12 P_PRODUCT_TYPE IN VARCHAR2,
13 P_PORTFOLIO_CODE IN VARCHAR2,
14 P_CPARTY_CODE IN VARCHAR2,
15 P_CONTRA_CCY IN VARCHAR2,
16 P_CURRENCY_COMBINATION IN VARCHAR2,
17 P_ACCOUNT_NO IN VARCHAR2,
18 P_TRANSACTION_RATE IN NUMBER,
19 P_YEAR_CALC_TYPE IN VARCHAR2,
20 P_BASE_REF_AMOUNT IN NUMBER,
21 P_BASE_RATE IN NUMBER,
22 P_STATUS_CODE IN VARCHAR2,
23 P_INTEREST IN NUMBER,
24 P_ACTION IN VARCHAR2
25
26 );
27
28 PROCEDURE SNAPSHOT_STK_POSITION_HISTORY(
29 P_AS_AT_DATE IN DATE,
30 P_DEAL_NUMBER IN NUMBER,
31 P_TRANSACTION_NUMBER IN NUMBER,
32 P_COMPANY_CODE IN VARCHAR2,
33 P_CURRENCY IN VARCHAR2,
34 P_DEAL_TYPE IN VARCHAR2,
35 P_DEAL_SUBTYPE IN VARCHAR2,
36 P_PRODUCT_TYPE IN VARCHAR2,
37 P_PORTFOLIO_CODE IN VARCHAR2,
38 P_CPARTY_CODE IN VARCHAR2,
39 P_CONTRA_CCY IN VARCHAR2,
40 P_CURRENCY_COMBINATION IN VARCHAR2,
41 P_ACCOUNT_NO IN VARCHAR2,
42 P_TRANSACTION_RATE IN NUMBER,
43 P_YEAR_CALC_TYPE IN VARCHAR2,
44 P_BASE_REF_AMOUNT IN NUMBER,
45 P_BASE_RATE IN NUMBER,
46 P_STATUS_CODE IN VARCHAR2,
47 P_START_DATE IN DATE,
48 P_INTEREST IN NUMBER,
49 P_START_AMOUNT IN NUMBER
50 );
51
52
53 PROCEDURE SNAPSHOT_STK_COST_OF_FUNDS(errbuf OUT NOCOPY VARCHAR2,
54 retcode OUT NOCOPY NUMBER,
55 p_deal_number IN NUMBER default NULL);
56
57
58 END XTR_STOCK_POSITION_P;
59