1 PACKAGE JL_JLCOARCR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JLCOARCRS.pls 120.1 2007/12/25 16:43:46 dwkrishn noship $ */
3 P_CONC_REQUEST_ID NUMBER := 0;
4 P_CUSTOMER_NUMBER_FROM VARCHAR2(40);
5 P_CUSTOMER_NUMBER_TO VARCHAR2(40);
6 P_CUSTOMER_NAME_FROM VARCHAR2(40);
7 P_CUSTOMER_NAME_TO VARCHAR2(40);
8 P_RECEIPT_NUMBER_FROM VARCHAR2(40);
9 P_RECEIPT_NUMBER_TO VARCHAR2(40);
10 P_RECEIPT_DATE_FROM DATE;
11 P_RECEIPT_DATE_TO DATE;
12 P_PAYMENT_METHOD VARCHAR2(40);
13 P_PAYMENT_MODE VARCHAR2(40);
14 P_THIRD_PARTY_ID_FROM VARCHAR2(40);
15 P_THIRD_PARTY_ID_TO VARCHAR2(40);
16 P_SET_OF_BOOKS_ID NUMBER;
17 P_LEGAL_ENTITY_ID NUMBER;
18 C_FUNC_CURRENCY VARCHAR2(25);
19 C_PRECISION NUMBER;
20 C_STRUCT_NUM NUMBER;
21 C_SOB_NAME VARCHAR2(100);
22 C_REPORT_START_DATE DATE;
23 C_REPORT_RUN_TIME VARCHAR2(8);
24 VLOCATION_ID NUMBER;
25 COMPANY_NAME VARCHAR2(60);
26 NIT_NUMBER VARCHAR2(15);
27 DIGIT_VERIF VARCHAR2(2);
28 VADDRESS1 VARCHAR2(120);
29 VADDRESS2 VARCHAR2(120);
30 VREGION VARCHAR2(60);
31 VTOWN_CITY VARCHAR2(60);
32 VADDRESS3 VARCHAR2(120);
33 VCOUNTRY VARCHAR2(60);
34 PROCEDURE GL_GET_SET_OF_BOOKS_INFO(SOBID IN NUMBER
35 ,COAID OUT NOCOPY NUMBER
36 ,SOBNAME OUT NOCOPY VARCHAR2
37 ,FUNC_CURR OUT NOCOPY VARCHAR2
38 ,ERRBUF OUT NOCOPY VARCHAR2);
39 PROCEDURE GET_INFO(CURRENCY_CODE IN VARCHAR2
40 ,PRECISION OUT NOCOPY NUMBER
41 ,EXT_PRECISION OUT NOCOPY NUMBER
42 ,MIN_ACCT_UNIT OUT NOCOPY NUMBER);
43 FUNCTION BEFOREREPORT RETURN BOOLEAN;
44 FUNCTION AFTERREPORT RETURN BOOLEAN;
45 FUNCTION CONVERT_NUMBER2(SEGMENT IN NUMBER) RETURN VARCHAR2;
46 FUNCTION CONVERT_NUMBER(IN_NUMERAL IN INTEGER := 0) RETURN VARCHAR2;
47 FUNCTION GET_WORD_VALUE(P_AMOUNT IN NUMBER
48 ,P_UNIT_SINGULAR IN VARCHAR2
49 ,P_UNIT_PLURAL IN VARCHAR2
50 ,P_SUB_UNIT_SINGULAR IN VARCHAR2
51 ,P_SUB_UNIT_PLURAL IN VARCHAR2
52 ,P_UNIT_RATIO IN NUMBER) RETURN VARCHAR2;
53 FUNCTION PRECISION(CUR_CODE IN VARCHAR2) RETURN NUMBER;
54 FUNCTION CF_INVOICE_NUMFORMULA(INVOICE_NUMBER IN VARCHAR2) RETURN CHAR;
55 FUNCTION C_FUNC_CURRENCY_P RETURN VARCHAR2;
56 FUNCTION C_PRECISION_P RETURN NUMBER;
57 FUNCTION C_STRUCT_NUM_P RETURN NUMBER;
58 FUNCTION C_SOB_NAME_P RETURN VARCHAR2;
59 FUNCTION C_REPORT_START_DATE_P RETURN DATE;
60 FUNCTION C_REPORT_RUN_TIME_P RETURN VARCHAR2;
61 FUNCTION VLOCATION_ID_P RETURN NUMBER;
62 FUNCTION COMPANY_NAME_P RETURN VARCHAR2;
63 FUNCTION NIT_NUMBER_P RETURN VARCHAR2;
64 FUNCTION DIGIT_VERIF_P RETURN VARCHAR2;
65 FUNCTION VADDRESS1_P RETURN VARCHAR2;
66 FUNCTION VADDRESS2_P RETURN VARCHAR2;
67 FUNCTION VREGION_P RETURN VARCHAR2;
68 FUNCTION VTOWN_CITY_P RETURN VARCHAR2;
69 FUNCTION VADDRESS3_P RETURN VARCHAR2;
70 FUNCTION VCOUNTRY_P RETURN VARCHAR2;
71 /* PROCEDURE JG_GET_SET_OF_BOOKS_INFO(SOBID IN NUMBER
72 ,COAID OUT NOCOPY NUMBER
73 ,SOBNAME OUT NOCOPY VARCHAR2
74 ,FUNC_CURR OUT NOCOPY VARCHAR2
75 ,ERRBUF OUT NOCOPY VARCHAR2);
76 PROCEDURE JG_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE IN VARCHAR2
77 ,TYPE_ID IN NUMBER
78 ,NAME OUT NOCOPY VARCHAR2
79 ,ERRBUF OUT NOCOPY VARCHAR2);
80 PROCEDURE JG_GET_LOOKUP_VALUE(LMODE IN VARCHAR2
81 ,CODE IN VARCHAR2
82 ,TYPE IN VARCHAR2
83 ,VALUE OUT NOCOPY VARCHAR2
84 ,ERRBUF OUT NOCOPY VARCHAR2);
85 PROCEDURE JG_GET_FIRST_PERIOD(APP_ID IN NUMBER
86 ,TSET_OF_BOOKS_ID IN NUMBER
87 ,TPERIOD_NAME IN VARCHAR2
88 ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
89 ,ERRBUF OUT NOCOPY VARCHAR2);
90 PROCEDURE JG_GET_FIRST_PERIOD_OF_QUARTER(APP_ID IN NUMBER
91 ,TSET_OF_BOOKS_ID IN NUMBER
92 ,TPERIOD_NAME IN VARCHAR2
93 ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
94 ,ERRBUF OUT NOCOPY VARCHAR2);
95 FUNCTION JG_FORMAT_CURR_AMT(IN_PRECISION IN NUMBER
96 ,IN_AMOUNT_DISP IN VARCHAR2) RETURN VARCHAR2;
97 PROCEDURE GL_GET_PERIOD_DATES(TSET_OF_BOOKS_ID IN NUMBER
98 ,TPERIOD_NAME IN VARCHAR2
99 ,TSTART_DATE OUT NOCOPY DATE
100 ,TEND_DATE OUT NOCOPY DATE
101 ,ERRBUF OUT NOCOPY VARCHAR2);
102 PROCEDURE GL_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE IN VARCHAR2
103 ,TYPE_ID IN NUMBER
104 ,NAME OUT NOCOPY VARCHAR2
105 ,ERRBUF OUT NOCOPY VARCHAR2);
106 PROCEDURE GL_GET_LOOKUP_VALUE(LMODE IN VARCHAR2
107 ,CODE IN VARCHAR2
108 ,TYPE IN VARCHAR2
109 ,VALUE OUT NOCOPY VARCHAR2
110 ,ERRBUF OUT NOCOPY VARCHAR2);
111 PROCEDURE GL_GET_FIRST_PERIOD(TSET_OF_BOOKS_ID IN NUMBER
112 ,TPERIOD_NAME IN VARCHAR2
113 ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
114 ,ERRBUF OUT NOCOPY VARCHAR2);
115 PROCEDURE GL_GET_FIRST_PERIOD_OF_QUARTER(TSET_OF_BOOKS_ID IN NUMBER
116 ,TPERIOD_NAME IN VARCHAR2
117 ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
118 ,ERRBUF OUT NOCOPY VARCHAR2);
119 PROCEDURE GL_GET_CONSOLIDATION_INFO(CONS_ID IN NUMBER
120 ,CONS_NAME OUT NOCOPY VARCHAR2
121 ,METHOD OUT NOCOPY VARCHAR2
122 ,CURR_CODE OUT NOCOPY VARCHAR2
123 ,FROM_SOBID OUT NOCOPY NUMBER
124 ,TO_SOBID OUT NOCOPY NUMBER
125 ,DESCRIPTION OUT NOCOPY VARCHAR2
126 ,START_DATE OUT NOCOPY DATE
127 ,END_DATE OUT NOCOPY DATE
128 ,ERRBUF OUT NOCOPY VARCHAR2);
129 FUNCTION GET_FORMAT_MASK(CURRENCY_CODE IN VARCHAR2
130 ,FIELD_LENGTH IN NUMBER) RETURN VARCHAR2;
131 FUNCTION SAFE_GET_FORMAT_MASK(CURRENCY_CODE IN VARCHAR2
132 ,FIELD_LENGTH IN NUMBER) RETURN VARCHAR2;
133 PROCEDURE BUILD_FORMAT_MASK(FORMAT_MASK OUT NOCOPY VARCHAR2
134 ,FIELD_LENGTH IN NUMBER
135 ,PRECISION IN NUMBER
136 ,MIN_ACCT_UNIT IN NUMBER
137 ,DISP_GRP_SEP IN BOOLEAN
138 ,NEG_FORMAT IN VARCHAR2
139 ,POS_FORMAT IN VARCHAR2);
140 PROCEDURE SAFE_BUILD_FORMAT_MASK(FORMAT_MASK OUT NOCOPY VARCHAR2
141 ,FIELD_LENGTH IN NUMBER
142 ,PRECISION IN NUMBER
143 ,MIN_ACCT_UNIT IN NUMBER
144 ,DISP_GRP_SEP IN BOOLEAN
145 ,NEG_FORMAT IN VARCHAR2
146 ,POS_FORMAT IN VARCHAR2);
147 PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
148 ,NAME IN VARCHAR2);
149 PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
150 ,VALUE IN VARCHAR2
151 ,TRANSLATE IN BOOLEAN);
152 PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
153 PROCEDURE CLEAR;
154 FUNCTION GET_STRING(APPIN IN VARCHAR2
155 ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;
156 FUNCTION GET_NUMBER(APPIN IN VARCHAR2
157 ,NAMEIN IN VARCHAR2) RETURN NUMBER;
158 FUNCTION GET RETURN VARCHAR2;
159 FUNCTION GET_ENCODED RETURN VARCHAR2;
160 PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
161 ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
162 ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
163 PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
164 PROCEDURE RAISE_ERROR;
165 FUNCTION GET_NEXT_SEQUENCE(APPID IN NUMBER
166 ,CAT_CODE IN VARCHAR2
167 ,SOBID IN NUMBER
168 ,MET_CODE IN VARCHAR2
169 ,TRX_DATE IN DATE
170 ,DBSEQNM IN OUT NOCOPY VARCHAR2
171 ,DBSEQID IN OUT NOCOPY INTEGER) RETURN NUMBER;
172 PROCEDURE GET_SEQ_NAME(APPID IN NUMBER
173 ,CAT_CODE IN VARCHAR2
174 ,SOBID IN NUMBER
175 ,MET_CODE IN VARCHAR2
176 ,TRX_DATE IN DATE
177 ,DBSEQNM OUT NOCOPY VARCHAR2
178 ,DBSEQID OUT NOCOPY INTEGER
179 ,SEQASSID OUT NOCOPY INTEGER);
180 FUNCTION GET_NEXT_AUTO_SEQ(DBSEQNM IN VARCHAR2) RETURN NUMBER;
181 FUNCTION GET_NEXT_AUTO_SEQUENCE(APPID IN NUMBER
182 ,CAT_CODE IN VARCHAR2
183 ,SOBID IN NUMBER
184 ,MET_CODE IN VARCHAR2
185 ,TRX_DATE IN VARCHAR2) RETURN NUMBER;
186 FUNCTION GET_NEXT_AUTO_SEQUENCE(APPID IN NUMBER
187 ,CAT_CODE IN VARCHAR2
188 ,SOBID IN NUMBER
189 ,MET_CODE IN VARCHAR2
190 ,TRX_DATE IN DATE) RETURN NUMBER;
191 PROCEDURE CREATE_GAPLESS_SEQUENCES;
192 FUNCTION CREATE_GAPLESS_SEQUENCE(SEQID IN NUMBER
193 ,SEQASSID IN NUMBER) RETURN NUMBER;
194 FUNCTION GET_NEXT_USER_SEQUENCE(FDS_USER_ID IN NUMBER
195 ,SEQASSID IN NUMBER
196 ,SEQID IN NUMBER) RETURN NUMBER;*/
197 END JL_JLCOARCR_XMLP_PKG;
198
199