1 PACKAGE XTR_STOCK_PKG AS
2 /* $Header: xtrstcks.pls 120.3.12010000.2 2008/08/06 10:45:07 srsampat ship $ */
3
4 PROCEDURE INS_STOCK_DDA (p_deal_no IN NUMBER,
5 p_reverse_dda IN BOOLEAN DEFAULT NULL);
6
7 PROCEDURE CANCEL_STOCK (p_deal_no IN NUMBER,
8 p_deal_subtype IN VARCHAR2,
9 p_currency IN VARCHAR2);
10
11 /*============================================================================*/
12 /*=================== BEGIN CASH DIVIDEND PROCEDURES =======================*/
13 /*============================================================================*/
14
15 FUNCTION INVALID_DIV_DATE (p_declare_date IN DATE,
16 p_record_date IN DATE,
17 p_payment_date IN DATE) return BOOLEAN;
18
19 FUNCTION UNIQUE_STOCK_DIV_EXIST(p_stock_issue IN VARCHAR2,
20 p_declare_date IN DATE,
21 p_record_date IN DATE,
22 p_payment_date IN DATE) return BOOLEAN;
23
24 /* Bug 3737048 Overloaded Function to check for uniqueness during update. */
25
26 FUNCTION UNIQUE_STOCK_DIV_EXIST(p_cash_dividend_id IN NUMBER,
27 p_stock_issue IN VARCHAR2,
28 p_declare_date IN DATE,
29 p_record_date IN DATE) return BOOLEAN;
30
31 FUNCTION DISABLE_DELETE (p_div_id IN NUMBER) return BOOLEAN;
32
33 FUNCTION GENERATE_CNT(p_div_id IN NUMBER,
34 p_stock_issue IN VARCHAR2,
35 p_declare_date IN DATE,
36 p_record_date IN DATE,
37 p_payment_date IN DATE,
38 p_div_per_share IN NUMBER) return NUMBER;
39
40 PROCEDURE GENERATE_DIV(p_div_id IN NUMBER,
41 p_stock_issue IN VARCHAR2,
42 p_currency IN VARCHAR2,
43 p_declare_date IN DATE,
44 p_record_date IN DATE,
45 p_payment_date IN DATE,
46 p_div_per_share IN NUMBER,
47 p_sys_user IN VARCHAR2,
48 p_sys_date IN DATE,
49 p_deal_no IN NUMBER DEFAULT NULL,
50 p_reverse IN VARCHAR2 DEFAULT NULL);
51
52 /* Bug 3737048 Added the last argument to GENERATE_DIV procedure. */
53
54 FUNCTION DELETE_CNT (p_div_id IN NUMBER) return NUMBER;
55
56 FUNCTION DELETE_DIV (p_div_id IN NUMBER) return BOOLEAN;
57
58 /*============================================================================*/
59 /*===================== END CASH DIVIDEND PROCEDURES =======================*/
60 /*============================================================================*/
61
62
63 END XTR_STOCK_PKG;