[Home] [Help]
PACKAGE: APPS.XTR_XTRMILNS_XMLP_PKG
Source
1 PACKAGE XTR_XTRMILNS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: XTRMILNSS.pls 120.1 2007/12/28 12:57:01 npannamp noship $ */
3 REPORT_SHORT_NAME VARCHAR2(240):='REVIEW LOAN SECURITY DETAILS';
4 VALUER VARCHAR2(40);
5 Z2SECURITY_REF VARCHAR2(300);
6 Z1VALUATION_REVIEWS_BEFORE VARCHAR2(300);
7 Z2ISSUED_BY VARCHAR2(300);
8 Z2END_OF_REPORT VARCHAR2(300);
9 Z1ORDER_BY_PTY_MGR VARCHAR2(300);
10 Z2SEC_VALUE VARCHAR2(300);
11 Z1PARAMETERS VARCHAR2(300);
12 Z1PARTY_CODE VARCHAR2(300);
13 Z1VALUATION_AMOUNT VARCHAR2(300);
14 Z1NAME VARCHAR2(300);
15 Z1PRIORITY_SUM VARCHAR2(300);
16 Z2PARTY_ACCT_MANAGER VARCHAR2(300);
17 Z2VALUE_DATE VARCHAR2(300);
18 Z2SECURITY_DESCRIPTION VARCHAR2(300);
19 Z1VALUER VARCHAR2(300);
20 Z1ACCT_MGR VARCHAR2(300);
21 Z2COMPANY VARCHAR2(300);
22 Z2PRIORITY_SUM VARCHAR2(300);
23 Z2PAGE VARCHAR2(300);
24 P_CONC_REQUEST_ID NUMBER;
25 COMPANY_NAME_HEADER VARCHAR2(80);
26 P_SQL_TRACE VARCHAR2(32767);
27 P_DISPLAY_DEBUG VARCHAR2(32767);
28 ORDER_BY_PTY_MGR2 VARCHAR2(40);
29 PARTY_CODE2 VARCHAR2(7);
30 ACCOUNT_MANAGER2 VARCHAR2(10);
31 VALUER2 VARCHAR2(7);
32 BEFORE_VALUE_DATE2 DATE;
33 OVER_VALUATION2 NUMBER;
34 OVER_PRIORITY_SUM2 VARCHAR2(40);
35 P_CPARTY VARCHAR2(7);
36 P_PRIORITY_TOTAL NUMBER;
37 P_VALIDATION_AMOUNT NUMBER;
38 P_BEFORE_DATE DATE;
39 P_VALUER VARCHAR2(7);
40 P_CPARTY_NAME VARCHAR2(60);
41 P_SORT_BY VARCHAR2(32767);
42 P_ACCOUNT_MANAGER VARCHAR2(10);
43 REPORT_DATE VARCHAR2(100);
44 P_FACTOR VARCHAR2(10);
45 AMT_UNIT2 NUMBER;
46 LP_FACTOR_DESC VARCHAR2(32767);
47 Z1P_FACTOR VARCHAR2(300);
48 P_COMPANY VARCHAR2(30);
49 Z1COMPANY VARCHAR2(300);
50 Z2PARTY_NAME1 VARCHAR2(300);
51 CP_PARA VARCHAR2(30);
52 FUNCTION CF_SET_PARAFORMULA RETURN VARCHAR2;
53 FUNCTION BEFOREREPORT RETURN BOOLEAN;
54 FUNCTION AFTERREPORT RETURN BOOLEAN;
55 FUNCTION AFTERPFORM RETURN BOOLEAN;
56 FUNCTION CP_PARA_P RETURN VARCHAR2;
57 END XTR_XTRMILNS_XMLP_PKG;
58