[Home] [Help]
PACKAGE: APPS.XTR_XTRLIEXP_XMLP_PKG
Source
1 PACKAGE XTR_XTRLIEXP_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: XTRLIEXPS.pls 120.1 2007/12/28 12:53:10 npannamp noship $ */
3 REPORT_DATE2 DATE;
4
5 REPORT_NOS VARCHAR2(30);
6
7 REPORT_SHORT_NAME VARCHAR2(80);
8
9 REPORT_GROUP VARCHAR2(32767);
10
11 VERSION_NUM NUMBER;
12
13 USE_DEFAULTS VARCHAR2(1);
14
15 COMPANY_CODE VARCHAR2(7);
16
17 LIMIT_CODE VARCHAR2(7);
18
19 FROM_DATE DATE;
20
21 P_FROM_DATE1 varchar2(15);
22
23 Z2AMOUNT_DATE VARCHAR2(300);
24
25 Z2HCE_AMOUNT VARCHAR2(300);
26
27 Z2END_OF_REPORT VARCHAR2(300);
28
29 Z2EXCEEDED_BY VARCHAR2(300);
30
31 Z2DEALER_CODE VARCHAR2(300);
32
33 Z2DISCRIPTION_OF_EXCEPTION VARCHAR2(300);
34
35 Z2EXCEEDED_ON_DATE VARCHAR2(300);
36
37 Z1PARAMETERS VARCHAR2(300);
38
39 Z1COMPANY_CODE VARCHAR2(300);
40
41 Z1LIMIT_CODE VARCHAR2(300);
42
43 Z1FROM_DATE VARCHAR2(300);
44
45 Z2DEAL_NUMBER VARCHAR2(300);
46
47 Z2LIMIT_PARTY VARCHAR2(300);
48
49 Z2LIMIT_AMOUNT VARCHAR2(300);
50
51 Z2PAGE VARCHAR2(300);
52
53 P_SQL_TRACE VARCHAR2(32767);
54
55 COMPANY_NAME_HEADER VARCHAR2(80);
56
57 P_CONC_REQUEST_ID NUMBER;
58
59 P_COMPANY VARCHAR2(7);
60
61 P_LIMIT_CODE VARCHAR2(7);
62
63 P_FROM_DATE DATE;
64
65 P_DISPLAY_DEBUG VARCHAR2(32767);
66
67 REPORT_SHORT_NAME2 VARCHAR2(240);
68
69 REPORT_DATE VARCHAR2(300);
70
71 FROM_DATE2 DATE;
72
73 COMPANY_CODE2 VARCHAR2(7);
74
75 LIMIT_CODE2 VARCHAR2(7);
76
77 P_FACTOR VARCHAR2(10);
78
79 AMT_UNIT2 NUMBER;
80
81 LP_FACTOR_DESC VARCHAR2(32767);
82
83 Z1P_FACTOR VARCHAR2(300);
84
85 CP_PARA VARCHAR2(30);
86
87 FUNCTION CF_SET_PARAFORMULA RETURN VARCHAR2;
88
89 FUNCTION CF_DESCRIPTIONFORMULA(QRY_LIMIT_CHECK_TYPE IN VARCHAR2
90 ,QRY_EXCEPTION_TYPE IN VARCHAR2) RETURN VARCHAR2;
91
92 FUNCTION COMPANY_CODEVALIDTRIGGER RETURN BOOLEAN;
93
94 FUNCTION LIMIT_CODEVALIDTRIGGER RETURN BOOLEAN;
95
96 FUNCTION BEFOREREPORT RETURN BOOLEAN;
97
98 FUNCTION AFTERREPORT RETURN BOOLEAN;
99
100 FUNCTION AFTERPFORM RETURN BOOLEAN;
101
102 FUNCTION CP_PARA_P RETURN VARCHAR2;
103
104 END XTR_XTRLIEXP_XMLP_PKG;
105