[Home] [Help]
PACKAGE: APPS.XTR_AUTO_RECONCILIATION
Source
1 PACKAGE XTR_AUTO_RECONCILIATION AUTHID CURRENT_USER AS
2 /*$Header: xtrarecs.pls 120.1.12010000.2 2009/11/04 19:59:20 srsampat ship $ */
3
4
5 -- CONTEXT: CALL = XTR_AUTO_RECONCILIATION.Auto_Reconciliation
6 --
7 -- GLOBAL variables
8 --
9 G_verification_method VARCHAR2(30);
10 --G_pass_code VARCHAR2(2);
11 G_import_reference NUMBER;
12 G_currency VARCHAR2(15);
13 G_account_number VARCHAR2(20);
14
15 --
16 -- Pass in Parameter
17 --
18 G_import_reference_from NUMBER;
19 G_import_reference_to NUMBER;
20 G_acct_num VARCHAR2(20);
21 G_source VARCHAR2(20);
22 G_value_date_from VARCHAR2(30);
23 G_value_date_to VARCHAR2(30);
24 G_incl_rtm VARCHAR2(1);
25 date_from DATE;
26 date_to DATE;
27
28 --
29 -- Procedure
30 --
31 PROCEDURE P_RECONCILE(
32 P_VERIFICATION_METHOD varchar2,
33 P_PASS_CODE IN OUT NOCOPY varchar2,
34 P_IMPORT_REFERENCE NUMBER,
35 P_CURRENCY varchar2,
36 P_CGU$SYSDATE date,
37 P_ACCOUNT_NUMBER VARCHAR2,
38 P_RECORD_IN_PROCESS IN OUT NOCOPY number,
39 P_PARTY_NAME IN OUT NOCOPY varchar2,
40 P_SERIAL_REFERENCE IN OUT NOCOPY varchar2,
41 P_DEBIT_AMOUNT IN OUT NOCOPY number,
42 P_CREDIT_AMOUNT IN OUT NOCOPY NUMBER,
43 P_RECONCILED_YN IN OUT NOCOPY varchar2,
44 P_MIN_REC_NOS IN OUT NOCOPY number,
45 P_MAX_REC_NOS IN OUT NOCOPY number,
46 P_REC_NOS IN OUT NOCOPY number,
47 P_tot_recon IN OUT NOCOPY number,
48 P_INCL_RTM IN varchar2);
49
50
51 PROCEDURE RECALC_DT_DETAILS (p_deal_no NUMBER,
52 p_deal_date DATE,
53 p_company VARCHAR2,
54 p_subtype VARCHAR2,
55 p_product VARCHAR2,
56 p_portfolio VARCHAR2,
57 p_ccy VARCHAR2,
58 p_maturity DATE,
59 p_settle_acct VARCHAR2,
60 p_cparty VARCHAR2,
61 p_client VARCHAR2,
62 p_cparty_acct VARCHAR2,
63 p_dealer VARCHAR2,
64 p_least_inserted VARCHAR2,
65 p_ref_date DATE,
66 p_trans_no NUMBER,
67 p_rec_ref NUMBER,
68 p_rec_pass VARCHAR2,
69 p_limit_code VARCHAR2 );
70
71 PROCEDURE RECALC_ROLL_DETAILS(p_deal_no NUMBER,
72 p_subtype VARCHAR2,
73 p_start_date DATE,
74 p_ccy VARCHAR2,
75 p_trans_no NUMBER,
76 p_rec_ref NUMBER,
77 p_rec_pass VARCHAR2);
78
79 PROCEDURE AUTO_RECONCILIATION (errbuf OUT NOCOPY VARCHAR2,
80 retcode OUT NOCOPY NUMBER,
81 p_source VARCHAR2,
82 p_acct_num VARCHAR2,
83 p_value_date_from VARCHAR2,
84 p_value_date_to VARCHAR2,
85 p_import_reference_from NUMBER,
86 p_import_reference_to NUMBER,
87 p_incl_rtm VARCHAR2 );
88 PROCEDURE REVERSE_ROLL_TRANS_RTMM (P_VERIFICATION_METHOD varchar2,
89 p_min_rec_nos NUMBER,
90 p_max_rec_nos NUMBER,
91 p_calling_method VARCHAR2 ,p_val_date DATE);
92
93 PROCEDURE UPDATE_ROLL_TRANS_RTMM (P_VERIFICATION_METHOD varchar2,
94 p_min_rec_nos NUMBER,
95 p_max_rec_nos NUMBER,
96 p_calling_method VARCHAR2 ,p_val_date DATE);
97
98 PROCEDURE UPDATE_ROLL_TRANS (P_VERIFICATION_METHOD varchar2,
99 p_min_rec_nos NUMBER,
100 p_max_rec_nos NUMBER,
101 p_calling_method VARCHAR2 );
102
103
104 END XTR_AUTO_RECONCILIATION;