[Home] [Help]
PACKAGE: APPS.JA_JAINEXCLIABILITY_XMLP_PKG
Source
1 PACKAGE JA_JAINEXCLIABILITY_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JAINEXCLIABILITYS.pls 120.1 2007/12/25 16:18:47 dwkrishn noship $ */
3 P_ORGANIZATION_ID NUMBER;
4
5 P_LOCATION_ID NUMBER;
6
7 P_TRN_FROM_DATE DATE;
8
9 P_TRN_TO_DATE DATE;
10
11 P_ORGANIZATION_NAME VARCHAR2(240);
12
13 P_RANGE VARCHAR2(50);
14
15 P_ADDRESS_LINE_1 VARCHAR2(240);
16
17 P_ADDRESS_LINE_2 VARCHAR2(240);
18
19 P_ADDRESS_LINE_3 VARCHAR2(240);
20
21 P_CIRCLE VARCHAR2(50);
22
23 P_COLLECT VARCHAR2(50);
24
25 P_DESCRIPTION VARCHAR2(240);
26
27 P_DIVISION VARCHAR2(50);
28
29 P_EC_CODE VARCHAR2(50);
30
31 P_CENOBRG23A NUMBER;
32
33 P_CENCTRG23A NUMBER;
34
35 P_CENCURG23A NUMBER;
36
37 P_CENCBRG23A NUMBER;
38
39 P_SEDOBRG23A NUMBER;
40
41 P_SEDCTRG23A NUMBER;
42
43 P_SEDCURG23A NUMBER;
44
45 P_SEDCBRG23A NUMBER;
46
47 P_ADLOBRG23A NUMBER;
48
49 P_ADLCTRG23A NUMBER;
50
51 P_ADLCURG23A NUMBER;
52
53 P_ADLCBRG23A NUMBER;
54
55 P_TOTCT NUMBER;
56
57 P_TOTCU NUMBER;
58
59 P_TOTCB NUMBER;
60
61 P_TOTOB NUMBER;
62
63 P_CENOBRG23C NUMBER;
64
65 P_ADLOBRG23C NUMBER;
66
67 P_SEDOBRG23C NUMBER;
68
69 P_CENCTRG23C NUMBER;
70
71 P_SEDCTRG23C NUMBER;
72
73 P_ADLCTRG23C NUMBER;
74
75 P_CENCURG23C NUMBER;
76
77 P_SEDCURG23C NUMBER;
78
79 P_ADLCURG23C NUMBER;
80
81 P_CENCBRG23C NUMBER;
82
83 P_SEDCBRG23C NUMBER;
84
85 P_ADLCBRG23C NUMBER;
86
87 P_CENOBPLA NUMBER;
88
89 P_ADLOBPLA NUMBER;
90
91 P_SEDOBPLA NUMBER;
92
93 P_SEDCTPLA NUMBER;
94
95 P_ADLCTPLA NUMBER;
96
97 P_CENCUPLA NUMBER;
98
99 P_SEDCUPLA NUMBER;
100
101 P_ADLCUPLA NUMBER;
102
103 P_CENCBPLA NUMBER;
104
105 P_SEDCBPLA NUMBER;
106
107 P_ADLCBPLA NUMBER;
108
109 P_CENCTPLA NUMBER;
110
111 P_CONC_REQUEST_ID NUMBER;
112
113 FUNCTION BEFOREREPORT RETURN BOOLEAN;
114
115 FUNCTION AFTERREPORT RETURN BOOLEAN;
116
117 END JA_JAINEXCLIABILITY_XMLP_PKG;
118