PACKAGE: APPS.JL_JLBRRINV_XMLP_PKG

Source

1 PACKAGE JL_JLBRRINV_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JLBRRINVS.pls 120.1 2007/12/25 16:42:16 dwkrishn noship $ */
3   P_SET_OF_BOOKS_ID NUMBER;
4 
5   P_SOB_ID NUMBER;
6 
7   P_MIN_PRECISION NUMBER;
8 
9   P_CONC_REQUEST_ID NUMBER;
10 
11   P_END_OF_REPORT VARCHAR2(21);
12 
13   P_NO_DATA_FOUND VARCHAR2(21);
14 
15   P_USER_ID NUMBER;
16 
17   P_CUSTOMER_TRX_ID NUMBER;
18 
19   P_ISSUE_DATE_HIGH DATE;
20 
21   P_TRX_NUMBER_HIGH VARCHAR2(32767);
22 
23   P_INVOICE_PRINT_SUBMIT VARCHAR2(30);
24 
25   P_SUB_SERIES VARCHAR2(50);
26 
27   P_TRX_NUMBER VARCHAR2(32767);
28 
29   CP_OPERATION_NATURE VARCHAR2(50);
30 
31   CP_OPERATION_CODE VARCHAR2(150);
32 
33   CP_FREIGHT_CITY VARCHAR2(12);
34 
35   CP_FREIGHT_STATE VARCHAR2(158);
36 
37   CP_FREIGHT_ADDRESS VARCHAR2(158);
38 
39   CP_FREIGHT_INSCRIPTION_NUMBER VARCHAR2(460);
40 
41   CP_FREIGHT_NAME VARCHAR2(80);
42 
43   CP_ICMS_TAX_AMOUNT NUMBER;
44 
45   CP_ICMS_TAX_BASE_AMOUNT NUMBER;
46 
47   CP_IPI_TAX_RATE NUMBER;
48 
49   CP_ICMSST_TAX_BASE_AMOUNT NUMBER;
50 
51   CP_BASE_CURRENCY_CODE VARCHAR2(15);
52 
53   CP_BASE_PRECISION NUMBER;
54 
55   H_OPERATION_UNIT NUMBER;
56 
57   C_INV_FORM_PREDICATE VARCHAR2(300);
58 
59   H_SO_ORGANIZATION NUMBER;
60 
61   FUNCTION AFTERREPORT RETURN BOOLEAN;
62 
63   FUNCTION BEFOREREPORT RETURN BOOLEAN;
64 
65   PROCEDURE GET_BASE_CURR_DATA;
66 
67   PROCEDURE RAISE_ERR(ERRNO IN VARCHAR2
68                      ,MSGNAME IN VARCHAR2);
69 
70   PROCEDURE RAISE_ORA_ERR(ERRNO IN VARCHAR2);
71 
72   FUNCTION CF_ICMS_TAXFORMULA(C_DTL_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
73 
74   FUNCTION CF_ISS_TAX_AMOUNTFORMULA(C_DTL_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
75 
76   FUNCTION CF_IRJ_TAX_AMOUNTFORMULA(C_DTL_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
77 
78   FUNCTION CF_ICMSST_TAX_AMOUNTFORMULA(C_DTL_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
79 
80   FUNCTION CF_ITEM_CODEFORMULA(C_INVENTORY_ID IN NUMBER) RETURN VARCHAR2;
81 
82   FUNCTION CF_TOTAL_PRICEFORMULA(CS_TOTAL_PRICE IN NUMBER
83                                 ,CS_TOTAL_BASE_ICMS IN NUMBER) RETURN NUMBER;
84 
85   PROCEDURE PRINTING_COUNT(X_TRX_NUMBER IN VARCHAR2
86                           ,CUST_TRX_ID IN NUMBER);
87 
88   FUNCTION CCF_STATE_INSC_SUBSTITUTIONFOR(C_SHIP_TO_SITE_USE_ID IN NUMBER
89                                          ,C_TRX_DATE IN DATE) RETURN VARCHAR2;
90 
91   FUNCTION CF_BRANDFORMULA RETURN VARCHAR2;
92 
93   FUNCTION CF_AMOUNT_WORDSFORMULA(CS_AMOUNT_DUE IN NUMBER) RETURN VARCHAR2;
94 
95   FUNCTION SET_P_WHERE RETURN BOOLEAN;
96 
97   FUNCTION CF_ADDITIONAL_INFOFORMULA(C_CUSTOMER_TRX_ID IN NUMBER
98                                     ,C_STATUS_TRX IN VARCHAR2) RETURN VARCHAR2;
99 
100   FUNCTION CF_FREIGHT_STATE_INS_NUMBERFOR(SHIP_VIA IN VARCHAR2) RETURN VARCHAR2;
101 
102   FUNCTION CF_IPI_TAX_AMOUNTFORMULA(C_DTL_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
103 
104   FUNCTION CF_TOTAL_EXTENDED_AMOUNTFORMUL(CS_TOTAL_EXTENDED_AMOUNT IN NUMBER) RETURN NUMBER;
105 
106   FUNCTION CF_OPR_CODEFORMULA(C_OPERATION_CODE IN VARCHAR2) RETURN VARCHAR2;
107 
108   FUNCTION CF_PRINTING_COUNT(TRX_NUM IN VARCHAR2
109                             ,C_CUSTOMER_TRX_ID IN NUMBER) RETURN NUMBER;
110 
111   FUNCTION CP_OPERATION_NATURE_P RETURN VARCHAR2;
112 
113   FUNCTION CP_OPERATION_CODE_P RETURN VARCHAR2;
114 
115   FUNCTION CP_FREIGHT_CITY_P RETURN VARCHAR2;
116 
117   FUNCTION CP_FREIGHT_STATE_P RETURN VARCHAR2;
118 
119   FUNCTION CP_FREIGHT_ADDRESS_P RETURN VARCHAR2;
120 
121   FUNCTION CF_FREIGHT_INSCRIPTION_NUMBER RETURN VARCHAR2;
122 
123   FUNCTION CP_FREIGHT_NAME_P RETURN VARCHAR2;
124 
125   FUNCTION CP_ICMS_TAX_AMOUNT_P RETURN NUMBER;
126 
127   FUNCTION CP_ICMS_TAX_BASE_AMOUNT_P RETURN NUMBER;
128 
129   FUNCTION CP_IPI_TAX_RATE_P RETURN NUMBER;
130 
131   FUNCTION CP_ICMSST_TAX_BASE_AMOUNT_P RETURN NUMBER;
132 
133   FUNCTION CP_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
134 
135   FUNCTION CP_BASE_PRECISION_P RETURN NUMBER;
136 
137   FUNCTION H_OPERATION_UNIT_P RETURN NUMBER;
138 
139   FUNCTION C_INV_FORM_PREDICATE_P RETURN VARCHAR2;
140 
141   FUNCTION H_SO_ORGANIZATION_P RETURN NUMBER;
142 
143   PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
144                     ,NAME IN VARCHAR2);
145 
146   PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
147                      ,VALUE IN VARCHAR2
148                      ,TRANSLATE IN BOOLEAN);
149 
150   PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
151 
152   PROCEDURE CLEAR;
153 
154   FUNCTION GET_STRING(APPIN IN VARCHAR2
155                      ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;
156 
157   FUNCTION GET RETURN VARCHAR2;
158 
159   FUNCTION GET_ENCODED RETURN VARCHAR2;
160 
161   PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
162                          ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
163                          ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
164 
165   PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
166 
167   PROCEDURE RAISE_ERROR;
168 
169   FUNCTION BR_CONVERT_AMOUNT(X_INVOICE_AMOUNT IN NUMBER
170                             ,X_CURRENCY_NAME IN VARCHAR2) RETURN VARCHAR2;
171 
172 END JL_JLBRRINV_XMLP_PKG;
173 
174