[Home] [Help]
PACKAGE: APPS.XTR_XTRTMBLT_XMLP_PKG
Source
1 PACKAGE XTR_XTRTMBLT_XMLP_PKG AS
2 /* $Header: XTRTMBLTS.pls 120.1 2007/12/28 13:02:12 npannamp noship $ */
3 REPORT_SHORT_NAME VARCHAR2(240);
4
5 COMPANY VARCHAR2(7);
6
7 Z2CPARTY VARCHAR2(100);
8
9 Z2MATURITY VARCHAR2(100);
10
11 Z2END_OF_REPORT VARCHAR2(100);
12
13 Z2ACCRUED VARCHAR2(100);
14
15 Z2INTEREST VARCHAR2(100);
16
17 Z2PRINCIPAL_BALANCE VARCHAR2(100);
18
19 Z1PARAMETERS VARCHAR2(100);
20
21 Z1PARTY_CODE VARCHAR2(100);
22
23 Z1DEAL_SUBTYPE VARCHAR2(100);
24
25 Z1NAME VARCHAR2(100);
26
27 Z1BALANCES_FROM VARCHAR2(100);
28
29 Z1COMPANY VARCHAR2(100);
30
31 Z1ACCT_MGR VARCHAR2(100);
32
33 Z1PRODUCT VARCHAR2(100);
34
35 Z1AS_AT VARCHAR2(100);
36
37 Z1OVERDUES_ONLY VARCHAR2(100);
38
39 Z2CODE VARCHAR2(100);
40
41 Z2TOTALS VARCHAR2(100);
42
43 Z2REF VARCHAR2(100);
44
45 Z2NUMBER VARCHAR2(100);
46
47 Z2CCY VARCHAR2(100);
48
49 Z2COMMENCE VARCHAR2(100);
50
51 Z2RECENT_ROLLOVER VARCHAR2(100);
52
53 Z2PAGE VARCHAR2(100);
54
55 COMPANY_NAME_HEADER VARCHAR2(80);
56
57 P_CONC_REQUEST_ID NUMBER;
58
59 P_SQL_TRACE VARCHAR2(32767);
60
61 P_DISPLAY_DEBUG VARCHAR2(32767);
62
63 AS_AT_DATE2 DATE;
64 --LAS_AT_DATE2 DATE;
65
66 CPARTY_CODE2 VARCHAR2(40);
67
68 COMPANY2 VARCHAR2(40);
69
70 PRODUCT_TYPE2 VARCHAR2(40);
71
72 DEAL_SUBTYPE2 VARCHAR2(40);
73
74 CPARTY_NAME2 VARCHAR2(40);
75
76 ACCOUNT_MANAGER2 VARCHAR2(40);
77
78 BALANCES_FROM2 VARCHAR2(40);
79
80 OVERDUE_ONLY2 VARCHAR2(40);
81
82 P_COMPANY VARCHAR2(32767);
83
84 P_CPARTY VARCHAR2(32767);
85
86 P_CPARTY_NAME VARCHAR2(60);
87
88 P_AS_OF_DATE VARCHAR2(100);
89 LP_AS_OF_DATE VARCHAR2(100);
90
91 --P_AS_OF_DATE DATE;
92 --LP_AS_OF_DATE DATE;
93
94 P_DEPOSIT_ADVANCE VARCHAR2(32767);
95
96 P_PRODUCT_TYPE VARCHAR2(32767);
97
98 P_BALANCES_FROM NUMBER;
99
100 P_ACCOUNT_MANAGER VARCHAR2(32767);
101
102 P_OVERDUE_AMOUNTS_ONLY VARCHAR2(32767);
103
104 REPORT_DATE VARCHAR2(100);
105
106 CP_PARA VARCHAR2(32767);
107
108 FUNCTION CF_SET_PARAFORMULA RETURN VARCHAR2;
109
110 FUNCTION BEFOREREPORT RETURN BOOLEAN;
111
112 FUNCTION AFTERREPORT RETURN BOOLEAN;
113
114 FUNCTION AFTERPFORM RETURN BOOLEAN;
115
116 FUNCTION BEFOREPFORM RETURN BOOLEAN;
117
118 FUNCTION CP_PARA_P RETURN VARCHAR2;
119
120 END XTR_XTRTMBLT_XMLP_PKG;
121