1 PACKAGE XTR_MISC_P AS
2 /* $Header: xtrprc3s.pls 120.1.12010000.2 2008/08/06 10:44:20 srsampat ship $ */
3 --
4 -- Stored procedures/functions
5 --
6 PROCEDURE FPS_AUDIT(p_audit_requested_by IN VARCHAR2,
7 p_event_name IN VARCHAR2,
8 p_date_from IN VARCHAR2,
9 p_date_to IN VARCHAR2);
10
11 PROCEDURE MAINTAIN_LANGUAGE(l_form IN VARCHAR2,
12 l_item IN VARCHAR2,
13 l_old_val IN VARCHAR2,
14 l_new_val IN VARCHAR2,
15 l_option IN VARCHAR2,
16 l_language IN VARCHAR2,
17 l_original_text IN VARCHAR2); -- 3424625 Added new parameter
18
19 PROCEDURE DEAL_ACTIONS(p_deal_type IN VARCHAR2,
20 p_deal_number IN NUMBER,
21 p_transaction_number IN NUMBER,
22 p_action_type IN VARCHAR2,
23 p_cparty_code IN VARCHAR2,
24 p_client_code IN VARCHAR2,
25 p_date_created IN DATE,
26 p_company_code IN VARCHAR2,
27 p_status_code IN VARCHAR2,
28 p_file_name IN VARCHAR2,
29 p_deal_subtype IN VARCHAR2,
30 p_currency IN VARCHAR2,
31 p_cparty_advice IN VARCHAR2,
32 p_client_advice IN VARCHAR2,
33 p_amount IN NUMBER,
34 p_org_flag IN VARCHAR2);
35
36 PROCEDURE INS_ACTUALS(
37 p_company_code IN varchar2,
38 p_currency IN varchar2,
39 p_portfolio_code IN varchar2,
40 p_from_date IN date,
41 p_to_date IN date,
42 p_fund_invest IN varchar2,
43 p_amount_unit IN number,
44 p_inc_ig IN varchar2,
45 p_unique_ref_number IN number,
46 p_company_name IN varchar2,
47 p_port_name IN varchar2,
48 p_floating_less IN varchar2);
49
50 PROCEDURE VALIDATE_DEALS( p_deal_no IN NUMBER,
51 p_trans_no IN NUMBER,
52 p_deal_type IN VARCHAR2,
53 p_action_type IN VARCHAR2,
54 p_validated_by IN VARCHAR2);
55
56 PROCEDURE MAINT_PROJECTED_BALANCES;
57
58 PROCEDURE CHK_PRO_AUTH(
59 p_event IN VARCHAR2,
60 p_company_code IN VARCHAR2,
61 p_user IN VARCHAR2,
62 p_deal_type IN VARCHAR2,
63 p_action IN VARCHAR2);
64 PROCEDURE SETOFF;
65
66
67 END XTR_MISC_P;