PACKAGE: APPS.XTR_XTRTMSTM_XMLP_PKG

Source

1 PACKAGE XTR_XTRTMSTM_XMLP_PKG AS
2 /* $Header: XTRTMSTMS.pls 120.1 2007/12/28 13:03:56 npannamp noship $ */
3   REPORT_SHORT_NAME VARCHAR2(240) := 'RETAIL TERM DEPOSIT/ADVANCES STATEMENTS';
4 
5   AS_AT_DATE1 DATE;
6 
7   Z2CUSTOMER_NO VARCHAR2(100);
8 
9   Z2AS_AT VARCHAR2(100);
10 
11   Z2PLEASE_RETAIN_STATEMENT VARCHAR2(100);
12 
13   Z2A_FEE_IS_PAYABLE VARCHAR2(100);
14 
15   Z2ON_REPLACEMENTS VARCHAR2(100);
16 
17   Z2START_DATE VARCHAR2(100);
18 
19   Z2INT_SETTLED VARCHAR2(100);
20 
21   Z2PRINCIPAL VARCHAR2(100);
22 
23   Z2BALANCE VARCHAR2(100);
24 
25   Z2PRINCIPAL_DEDUCTIONS_AS_AT VARCHAR2(100);
26 
27   Z2INTEREST_REPAID_AS_AT VARCHAR2(100);
28 
29   Z2INITIAL_AMOUNT VARCHAR2(100);
30 
31   Z2DATE VARCHAR2(100);
32 
33   Z2TOTAL_TO_SETTLE_AS_AT VARCHAR2(100);
34 
35   Z2ACTION_TYPE VARCHAR2(100);
36 
37   Z2AMOUNT_NAME VARCHAR2(100);
38 
39   Z2TOTAL_SETTLED VARCHAR2(100);
40 
41   Z2STATEMENT_OF_ACCOUNTS VARCHAR2(100);
42 
43   P_SQL_TRACE VARCHAR2(32767);
44 
45   P_DISPLAY_DEBUG VARCHAR2(32767);
46 
47   P_CONC_REQUEST_ID NUMBER;
48 
49   COMPANY_NAME_HEADER VARCHAR2(80);
50 
51   AS_AT_DATE2 DATE;
52   LAS_AT_DATE2 VARCHAR2(13);
53 
54   DEAL_NO2 VARCHAR2(38);
55 
56   CPARTY_CODE2 VARCHAR2(40);
57 
58   DEAL_SUBTYPE2 VARCHAR2(80);
59 
60   P_CLIENT VARCHAR2(32767);
61 
62   P_DEAL_NUMBER NUMBER;
63 
64   P_TO_DATE VARCHAR2(30);
65   LP_TO_DATE date;
66 
67   P_DEPOSIT_ADVANCE VARCHAR2(80);
68 
69   REPORT_DATE VARCHAR2(100);
70 
71   AS_AT_DATE3 DATE;
72 
73   P_FROM_DATE VARCHAR2(30);
74   LP_FROM_DATE date;
75 
76   Z_LOAN_NO VARCHAR2(100);
77 
78   Z_DEP_NO VARCHAR2(100);
79 
80   Z_OF_YOUR VARCHAR2(100);
81 
82   Z_LOAN_FOLLOW VARCHAR2(100);
83 
84   Z_DEP_FOLLOW VARCHAR2(100);
85 
86   REF_TYPE VARCHAR2(256);
87 
88   PRIN_DED NUMBER;
89 
90   PI_RECD NUMBER;
91 
92   ADJUST_PRIN NUMBER;
93 
94   ACTUAL_BAL NUMBER;
95 
96   NET_DUE NUMBER;
97 
98   CP_PARA VARCHAR2(32767);
99 
100   FUNCTION STATE_DATEFORMULA RETURN DATE;
101 
102   FUNCTION REF_TYPE1FORMULA(REFERENCE varchar2) RETURN VARCHAR2;
103 
104   FUNCTION REF_TYPEFORMULA RETURN VARCHAR2;
105 
106   FUNCTION PRIN_DED1FORMULA(REFERENCE varchar2, ADJUST_PRINCIPAL number) RETURN VARCHAR2;
107 
108   FUNCTION PRIN_DEDFORMULA RETURN NUMBER;
109 
110   FUNCTION PI_RECD1FORMULA(ADJUST_INTEREST number, ADJUST_PRIN number) RETURN VARCHAR2;
111 
112   FUNCTION PI_RECDFORMULA RETURN NUMBER;
113 
114   FUNCTION ADJUST_PRIN1FORMULA(REFERENCE varchar2, ADJUST_PRINCIPAL number) RETURN VARCHAR2;
115 
116   FUNCTION ADJUST_PRINFORMULA RETURN NUMBER;
117 
118   FUNCTION ACTUAL_BAL1FORMULA(REFERENCE varchar2, BALANCE_CFWD number, PRIN_DECRSE number) RETURN VARCHAR2;
119 
120   FUNCTION ACTUAL_BALFORMULA RETURN NUMBER;
121 
122   FUNCTION DATE_NOWFORMULA RETURN DATE;
123 
124   FUNCTION NET_DUE1FORMULA(INTEREST_DUE number, BALANCE_DUE number) RETURN VARCHAR2;
125 
126   FUNCTION NET_DUEFORMULA RETURN NUMBER;
127 
128   FUNCTION BEFOREPFORM RETURN BOOLEAN;
129 
130   FUNCTION CF_SET_PARAFORMULA RETURN VARCHAR2;
131 
132   FUNCTION BEFOREREPORT RETURN BOOLEAN;
133 
134   FUNCTION AFTERPFORM RETURN BOOLEAN;
135 
136   FUNCTION AFTERREPORT RETURN BOOLEAN;
137 
138   FUNCTION REF_TYPE_P RETURN VARCHAR2;
139 
140   FUNCTION PRIN_DED_P RETURN NUMBER;
141 
142   FUNCTION PI_RECD_P RETURN NUMBER;
143 
144   FUNCTION ADJUST_PRIN_P RETURN NUMBER;
145 
146   FUNCTION ACTUAL_BAL_P RETURN NUMBER;
147 
148   FUNCTION NET_DUE_P RETURN NUMBER;
149 
150   FUNCTION CP_PARA_P RETURN VARCHAR2;
151 
152 END XTR_XTRTMSTM_XMLP_PKG;
153