1 PACKAGE XTR_FPS3_P as
2 /* $Header: xtrfps3s.pls 120.5 2005/06/29 07:53:34 badiredd ship $ */
3 ----------------------------------------------------------------------------------------------------------------
4 PROCEDURE CHK_DEAL_SUBTYPE (l_deal_type IN VARCHAR2,
5 l_deal_subtype IN VARCHAR2,
6 l_subtype_name IN OUT NOCOPY VARCHAR2,
7 l_limit_weighting IN OUT NOCOPY NUMBER,
8 l_tolerance IN OUT NOCOPY NUMBER,
9 l_err_code OUT NOCOPY NUMBER,
10 l_level OUT NOCOPY VARCHAR2);
11 PROCEDURE IMPORT_GL_HOLIDAYS(p_calendar_in IN gl_transaction_calendar.name%TYPE,
12 p_currency_in IN xtr_holidays.currency%TYPE);
13 PROCEDURE CHK_HOLIDAY (in_date IN DATE,
14 l_currency IN VARCHAR2,
15 l_err_code OUT NOCOPY NUMBER,
16 l_level OUT NOCOPY VARCHAR2);
17 PROCEDURE CHK_NO_PORTFOLIOS (l_company_code IN VARCHAR2,
18 l_deal_number IN NUMBER,
19 l_err_code OUT NOCOPY NUMBER,
20 l_level OUT NOCOPY VARCHAR2);
21 PROCEDURE CHK_PORT_CODE (l_portfolio_code IN VARCHAR2,
22 l_company_code IN VARCHAR2,
23 l_portfolio_name IN OUT NOCOPY VARCHAR2,
24 l_err_code OUT NOCOPY NUMBER,
25 l_level OUT NOCOPY VARCHAR2);
26 PROCEDURE CHK_PORT_CONST ( l_portfolio_code IN VARCHAR2,
27 l_deal_number IN NUMBER,
28 l_err_code OUT NOCOPY NUMBER,
29 l_level OUT NOCOPY VARCHAR2);
30 PROCEDURE CHK_PRINCIPAL_BANK (l_company_code IN VARCHAR2,
31 l_currency IN VARCHAR2,
32 l_prin_adjust IN NUMBER,
33 l_prin_acct IN VARCHAR2,
34 l_err_code OUT NOCOPY NUMBER,
35 l_level OUT NOCOPY VARCHAR2);
36 PROCEDURE CHK_PRINTER_NAME(l_p_name IN VARCHAR2,
37 l_p_value IN OUT NOCOPY VARCHAR2,
38 l_err_code OUT NOCOPY NUMBER,
39 l_level OUT NOCOPY VARCHAR2);
40 PROCEDURE CHK_ROLLOVER (l_deal_number IN NUMBER,
41 l_start_date IN DATE,
42 l_err_code OUT NOCOPY NUMBER,
43 l_level OUT NOCOPY VARCHAR2);
44 PROCEDURE CHK_STATUS_CODE (l_status_code IN VARCHAR2,
45 l_deal_type IN VARCHAR2,
46 l_record_status IN VARCHAR2,
47 l_status_name IN OUT NOCOPY VARCHAR2,
48 l_statcode_updateable IN OUT NOCOPY VARCHAR2,
49 l_err_code OUT NOCOPY NUMBER,
50 l_level OUT NOCOPY VARCHAR2);
51 PROCEDURE CHK_FX_TOLERANCE (l_rate IN NUMBER,
52 l_currency_a IN VARCHAR2,
53 l_currency_b IN VARCHAR2,
54 l_tolerance IN NUMBER,
55 l_err_code OUT NOCOPY NUMBER,
56 l_level OUT NOCOPY VARCHAR2);
57 PROCEDURE CHK_TOLERANCE (l_rate IN NUMBER,
58 l_currency IN VARCHAR2,
59 l_tolerance IN NUMBER,
60 l_period IN NUMBER,
61 l_unique_id IN VARCHAR2,
62 l_err_code OUT NOCOPY NUMBER,
63 l_level OUT NOCOPY VARCHAR2);
64 PROCEDURE CHK_TIME_RESTRICTIONS (l_deal_type IN VARCHAR2,
65 l_deal_subtype IN VARCHAR2,
66 l_product_type IN VARCHAR2,
67 l_cparty_code IN VARCHAR2,
68 l_date IN DATE,
69 l_max_date OUT NOCOPY DATE,
70 l_err_code OUT NOCOPY NUMBER,
71 l_level OUT NOCOPY VARCHAR2);
72
73 --start bug 2804548
74 FUNCTION previous_bus_day(p_date IN DATE,
75 p_ccy IN VARCHAR2) RETURN DATE;
76
77 FUNCTION following_bus_day(p_date IN DATE,
78 p_ccy IN VARCHAR2) RETURN DATE;
79
80 FUNCTION mod_following_bus_day(p_date IN DATE,
81 p_ccy IN VARCHAR2) RETURN DATE;
82
83 FUNCTION mod_previous_bus_day(p_date IN DATE,
84 p_ccy IN VARCHAR2) RETURN DATE;
85
86 TYPE settlementbasis_out_rec is record (date_out DATE);
87 TYPE settlementbasis_in_rec is record (date_in DATE,
88 settlement_basis xtr_bond_issues.settlement_basis%TYPE,
89 ccy xtr_bond_issues.currency%TYPE);
90 PROCEDURE settlement_basis_calc(p_in_rec IN settlementbasis_in_rec,
91 p_out_rec IN OUT NOCOPY settlementbasis_out_rec);
92
93 TYPE validation_out_rec is record (yes BOOLEAN);
94 TYPE validation_in_rec is record (deal_type xtr_deal_types.deal_type%TYPE,
95 bond_issue_code xtr_bond_issues.bond_issue_code%TYPE,
96 bond_coupon_date DATE);
97
98 PROCEDURE settled_validation(p_in_rec IN validation_in_rec,
99 p_out_rec IN OUT NOCOPY validation_out_rec);
100
101
102 PROCEDURE journaled_validation(p_in_rec IN validation_in_rec,
103 p_out_rec IN OUT NOCOPY validation_out_rec);
104
105
106 PROCEDURE reconciled_validation(p_in_rec IN validation_in_rec,
107 p_out_rec IN OUT NOCOPY validation_out_rec);
108
109
110 PROCEDURE accrued_validation(p_in_rec IN validation_in_rec,
111 p_out_rec IN OUT NOCOPY validation_out_rec);
112
113 --end bug 2804548
114 ----------------------------------------------------------------------------------------------------------------
115 end XTR_FPS3_P;