[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