PACKAGE: APPS.JL_JLCOPCWT_XMLP_PKG

Source

1 PACKAGE JL_JLCOPCWT_XMLP_PKG AS
2 /* $Header: JLCOPCWTS.pls 120.1 2007/12/25 16:51:44 dwkrishn noship $ */
3   P_DEBUG_SWITCH VARCHAR2(1);
4 
5   P_CONC_REQUEST_ID NUMBER := 0;
6 
7   P_MIN_PRECISION NUMBER := 0;
8 
9   P_DATE_FROM VARCHAR2(40);
10 
11   P_DATE_TO VARCHAR2(40);
12 
13   P_LOCATION_ID VARCHAR2(40);
14 
15   P_SUPPLIER_ID NUMBER;
16 
17   P_SUPPLIER_FROM VARCHAR2(240);
18 
19   P_SUPPLIER_TO VARCHAR2(240);
20 
21   P_SUPP_NUM_FROM VARCHAR2(30);
22 
23   P_SUPP_NUM_TO VARCHAR2(30);
24 
25    P_SUPPLIER_FROM_1 VARCHAR2(240);
26 
27   P_SUPPLIER_TO_1 VARCHAR2(240);
28 
29   P_SUPP_NUM_FROM_1 VARCHAR2(30);
30 
31   P_SUPP_NUM_TO_1 VARCHAR2(30);
32 
33   P_SELECTED_SUPPLIERS VARCHAR2(1000);
34 
35   P_AWT_TYPE VARCHAR2(100);
36 
37   P_SELECTED_DATES VARCHAR2(1000);
38 
39   P_AWT_TYPE_CODE VARCHAR2(1000);
40 
41   P_LEGAL_ENTITY_ID NUMBER;
42 
43   P_REPORTING_LEVEL VARCHAR2(60);
44 
45   P_REPORTING_CONTEXT NUMBER;
46 
47   LP_AP_INVOICES_WH VARCHAR2(2000);
48 
49   LP_AP_INVOICE_DISTRIBUTIONS_WH VARCHAR2(2000);
50 
51   P_ORGS VARCHAR2(2000);
52 
53   C_BASE_CURRENCY_CODE VARCHAR2(15);
54 
55   C_BASE_PRECISION NUMBER;
56 
57   C_BASE_MIN_ACCT_UNIT NUMBER;
58 
59   C_BASE_DESCRIPTION VARCHAR2(240);
60 
61   C_COMPANY_NAME_HEADER VARCHAR2(50);
62 
63   C_REPORT_START_DATE DATE;
64 
65   C_NLS_YES VARCHAR2(80);
66 
67   C_NLS_NO VARCHAR2(80);
68 
69   C_NLS_ALL VARCHAR2(25);
70 
71   C_NLS_NO_DATA_EXISTS VARCHAR2(240);
72 
73   C_REPORT_RUN_TIME VARCHAR2(8);
74 
75   C_CHART_OF_ACCOUNTS_ID NUMBER := 50105;
76 
77   C_LOCATION_ID NUMBER;
78 
79   C_NLS_END_OF_REPORT VARCHAR2(80);
80 
81   C_PROFILE_COUNTRY_CODE VARCHAR2(32767);
82 
83   FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN;
84 
85   FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
86 
87   FUNCTION GET_NLS_STRINGS RETURN BOOLEAN;
88 
89   FUNCTION BEFOREREPORT RETURN BOOLEAN;
90 
91   FUNCTION AFTERREPORT RETURN BOOLEAN;
92 
93   FUNCTION FSELECTEDSUPPLIERS RETURN VARCHAR2;
94 
95   FUNCTION ACCEPT_PARAMETER(PARAMETER_NAME IN VARCHAR2) RETURN BOOLEAN;
96 
97   FUNCTION P_SUPPLIER_FROMVALIDTRIGGER RETURN BOOLEAN;
98 
99   FUNCTION P_SUPPLIER_IDVALIDTRIGGER0116 RETURN BOOLEAN;
100 
101   FUNCTION AFTERPFORM RETURN BOOLEAN;
102 
103   FUNCTION CALCULATE_VAT_AMOUNT(P_TAX_NAME IN VARCHAR2
104                                ,P_VENDOR_ID IN NUMBER
105                                ,P_VENDOR_NUMBER IN VARCHAR2) RETURN NUMBER;
106 
107   FUNCTION CF_VAT_AMOUNTFORMULA(CERTIFICATE_TYPE IN VARCHAR2
108                                ,TAX_NAME IN VARCHAR2
109                                ,VENDOR_ID IN NUMBER
110                                ,VENDOR_NUMBER IN VARCHAR2) RETURN NUMBER;
111 
112   FUNCTION CF_DATE_FROMFORMULA RETURN VARCHAR2;
113 
114   FUNCTION CF_DATE_TOFORMULA RETURN VARCHAR2;
115 
116   FUNCTION FSELECTEDDATES RETURN VARCHAR2;
117 
118   FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
119 
120   FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
121 
122   FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
123 
124   FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
125 
126   FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
127 
128   FUNCTION C_REPORT_START_DATE_P RETURN DATE;
129 
130   FUNCTION C_NLS_YES_P RETURN VARCHAR2;
131 
132   FUNCTION C_NLS_NO_P RETURN VARCHAR2;
133 
134   FUNCTION C_NLS_ALL_P RETURN VARCHAR2;
135 
136   FUNCTION C_NLS_NO_DATA_EXISTS_P RETURN VARCHAR2;
137 
138   FUNCTION C_REPORT_RUN_TIME_P RETURN VARCHAR2;
139 
140   FUNCTION C_CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
141 
142   FUNCTION C_LOCATION_ID_P RETURN NUMBER;
143 
144   FUNCTION C_NLS_END_OF_REPORT_P RETURN VARCHAR2;
145 
146   FUNCTION C_PROFILE_COUNTRY_CODE_P RETURN VARCHAR2;
147 
148 END JL_JLCOPCWT_XMLP_PKG;
149 
150 
151