DBA Data[Home] [Help]

PACKAGE: APPS.JL_JLARPCWT_XMLP_PKG

Source


1 PACKAGE JL_JLARPCWT_XMLP_PKG AS
2 /* $Header: JLARPCWTS.pls 120.1 2007/12/25 16:33:51 dwkrishn noship $ */
3   P_DEBUG_SWITCH VARCHAR2(1);
4 
5   P_CONC_REQUEST_ID NUMBER := 0;
6 
7   P_MIN_PRECISION NUMBER;
8 
9   P_CHECKRUN_NAME VARCHAR2(50);
10 
11   P_AWT_TYPE_CODE VARCHAR2(100);
12 
13   P_CERTIFICATE_NUMBER NUMBER;
14 
15   P_DATE_FROM VARCHAR2(40);
16 
17   P_DATE_TO VARCHAR2(40);
18 
19   P_SELECTED_SUPPLIERS VARCHAR2(1000);
20 
21   P_SUPPLIER_FROM VARCHAR2(240);
22 
23   P_SUPPLIER_TO VARCHAR2(240);
24 
25   P_SUPPLIER_ID NUMBER;
26 
27   P_SUPP_NUM_FROM VARCHAR2(30);
28 
29   P_SUPP_NUM_TO VARCHAR2(30);
30 
31   P_PARAMETER_MSG VARCHAR2(200);
32 
33   P_OK_PARAMETER_FLAG VARCHAR2(32767);
34 
35   P_LEGAL_ENTITY_ID NUMBER;
36 
37   P_PAYMENT_INSTRUCTION NUMBER;
38 
39   LP_JL_AR_AP_AWT_CERTIF_ALL_WH VARCHAR2(500);
40 
41   P_REPORTING_LEVEL VARCHAR2(60);
42 
43   P_REPORTING_CONTEXT VARCHAR2(60);
44 
45   C_BASE_CURRENCY_CODE VARCHAR2(15);
46 
47   C_BASE_PRECISION NUMBER;
48 
49   C_BASE_MIN_ACCT_UNIT NUMBER;
50 
51   C_BASE_DESCRIPTION VARCHAR2(240);
52 
53   C_COMPANY_NAME_HEADER VARCHAR2(50);
54 
55   C_REPORT_START_DATE DATE;
56 
57   C_NLS_YES VARCHAR2(80);
58 
59   C_NLS_NO VARCHAR2(80);
60 
61   C_NLS_ALL VARCHAR2(25);
62 
63   C_NLS_NO_DATA_EXISTS VARCHAR2(240);
64 
65   C_REPORT_RUN_TIME VARCHAR2(8);
66 
67   C_CHART_OF_ACCOUNTS_ID NUMBER := 50105;
68 
69   C_NLS_END_OF_REPORT VARCHAR2(80);
70 
71   C_PROFILE_COUNTRY_CODE VARCHAR2(32767);
72 
73   FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN;
74 
75   FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
76 
77   FUNCTION GET_NLS_STRINGS RETURN BOOLEAN;
78 
79   FUNCTION BEFOREREPORT RETURN BOOLEAN;
80 
81   FUNCTION AFTERREPORT RETURN BOOLEAN;
82 
83   FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
84 
85   FUNCTION CALCULATE_RUN_TIME RETURN BOOLEAN;
86 
87   FUNCTION CF_1FORMULA(JURISDICTION_TYPE IN VARCHAR2
88                       ,TAXABLE_BASE_AMOUNT_BASIS IN VARCHAR2
89                       ,AWT_TYPE_CODE IN VARCHAR2
90                       ,CREDIT_LETTER_FLAG IN VARCHAR2) RETURN VARCHAR2;
91 
92   FUNCTION CF_PAYMENT_AMOUNTFORMULA(CHECK_NUMBER IN NUMBER) RETURN NUMBER;
93 
94   FUNCTION UPDATE_CERTIFICATE_STATUS(V_AWT_TYPE_CODE IN VARCHAR2
95                                     ,V_CERTIFICATE_NUMBER IN NUMBER) RETURN BOOLEAN;
96 
97   FUNCTION CF_COMP_NUM_AGENT_RETENCION7FO(CF_CERTIFICATE_TYPE IN VARCHAR2
98                                          ,COMP_PRIMARY_ID_NUMBER IN VARCHAR2
99                                          ,COMP_TAX_AUTHORITY_ID IN NUMBER
100                                          ,COMP_TAX_AUTHORITY_TYPE IN VARCHAR2) RETURN VARCHAR2;
101 
102   FUNCTION CF_SUPP_PROVINCE_NUMBERFORMULA(CF_CERTIFICATE_TYPE IN VARCHAR2
103                                          ,SUPP_PRIMARY_ID_NUMBER IN VARCHAR2
104                                          ,SUPP_TAX_AUTHORITY_ID IN NUMBER
105                                          ,SUPP_TAX_AUTHORITY_TYPE IN VARCHAR2
106                                          ,WITHHOLDING_DATE IN DATE) RETURN VARCHAR2;
107 
108   FUNCTION PROVINCE_NAMEFORMULA(CF_CERTIFICATE_TYPE IN VARCHAR2
109                                ,PROVINCE_CODE IN VARCHAR2) RETURN VARCHAR2;
110 
111   FUNCTION P_SUPPLIER_IDVALIDTRIGGER RETURN BOOLEAN;
112 
113   FUNCTION ACCEPT_PARAMETER(PARAMETER_NAME IN VARCHAR2) RETURN BOOLEAN;
114 
115   FUNCTION FSELECTEDSUPPLIERS RETURN VARCHAR2;
116 
117   FUNCTION AFTERPFORM RETURN BOOLEAN;
118 
119   FUNCTION CF_1FORMULA0039(AWT_TYPE_CODE IN VARCHAR2
120                           ,CERTIFICATE_NUMBER_NUM IN NUMBER) RETURN VARCHAR2;
121 
122   FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
123 
124   FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
125 
126   FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
127 
128   FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
129 
130   FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
131 
132   FUNCTION C_REPORT_START_DATE_P RETURN DATE;
133 
134   FUNCTION C_NLS_YES_P RETURN VARCHAR2;
135 
136   FUNCTION C_NLS_NO_P RETURN VARCHAR2;
137 
138   FUNCTION C_NLS_ALL_P RETURN VARCHAR2;
139 
140   FUNCTION C_NLS_NO_DATA_EXISTS_P RETURN VARCHAR2;
141 
142   FUNCTION C_REPORT_RUN_TIME_P RETURN VARCHAR2;
143 
144   FUNCTION C_CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
145 
146   FUNCTION C_NLS_END_OF_REPORT_P RETURN VARCHAR2;
147 
148   FUNCTION C_PROFILE_COUNTRY_CODE_P RETURN VARCHAR2;
149 
150 END JL_JLARPCWT_XMLP_PKG;
151 
152