[Home] [Help]
PACKAGE: APPS.JL_ZZ_GLOBE_VAL_PKG
Source
1 PACKAGE JL_ZZ_GLOBE_VAL_PKG AUTHID CURRENT_USER AS
2 /* $Header: jlzzglvs.pls 120.4 2005/10/30 02:05:52 appldev ship $ */
3
4 --
5 -- Procedure Name:
6 -- count_void_trx_type
7 -- Called From:
8 -- RAXSUCTT_ZZ_RA_CUST_TTYPES_BV
9 -- Purpose:
10 -- Return the number of Void Transaction Types
11 --
12 FUNCTION count_void_trx_type(
13 p_country_code IN VARCHAR2,
14 p_cust_trx_type_id IN NUMBER) RETURN NUMBER;
15
16 --
17 -- Procedure Name:
18 -- get_copy_status
19 -- Called From:
20 -- ARXTWMAI_ZZ_TGW_HEADER_BV
21 -- Purpose:
22 -- Gets copy statuses
23 --
24 PROCEDURE get_copy_status(
25 p_country_code IN VARCHAR2,
26 p_customer_trx_id IN NUMBER,
27 p_copy_status_code OUT NOCOPY VARCHAR2,
28 p_copy_status_meaning OUT NOCOPY VARCHAR2);
29
30 --
31 -- Procedure Name:
32 -- get_orig_trx_type
33 -- Called From:
34 -- ARXTWMAI_ZZ_CP_ORIG_TRX_TYPE
35 -- Purpose:
36 -- Return cust_trx_type_id of specified customer_trx_id
37 --
38 PROCEDURE get_orig_trx_type(
39 p_customer_trx_id IN NUMBER,
40 p_cust_trx_type_id OUT NOCOPY NUMBER);
41
42 --
43 -- Procedure Name:
44 -- chk_company_name_unique
45 -- Called From:
46 -- PERWSLOC_ZZ_LOC_BV
47 -- Purpose:
48 -- To check uniqueness of company name(GLOBAL_ATTRIBUTE8 of AR/CL/CO).
49 --
50 PROCEDURE chk_company_name_unique(
51 p_rowid IN VARCHAR2,
52 p_country_code IN VARCHAR2,
53 p_company_name IN VARCHAR2,
54 p_message_code OUT NOCOPY VARCHAR2);
55
56 --
57 -- Procedure Name:
58 -- get_last_attrs
59 -- Called From:
60 -- FAXSUBCT_ZZ_LAST_REV_RUN_BV
61 -- Purpose:
62 -- Return last inflation adjusted, revaluation and closed period
63 -- for a given book.
64 --
65 PROCEDURE get_last_attrs(
66 p_book_type_code IN VARCHAR2,
67 p_last_inf_adj OUT NOCOPY VARCHAR2,
68 p_last_reval OUT NOCOPY VARCHAR2,
69 p_last_closed_period OUT NOCOPY VARCHAR2,
70 p_last_period_posted OUT NOCOPY VARCHAR2);
71 --
72 -- Procedure Name:
73 -- get_last_period_ctr
74 -- Called From:
75 -- JLCO_FA
76 -- Purpose:
77 -- Return last period counter
78 -- for a deprn calendar given.
79 --
80
81 PROCEDURE get_last_period_ctr(
82 p_deprn_calendar IN VARCHAR2,
83 p_current_fiscal_year IN NUMBER,
84 p_current_period_num IN NUMBER,
85 p_last_period_counter OUT NOCOPY NUMBER);
86
87 --
88 -- Function Name:
89 -- verify_adjust_flag
90 -- Called From:
91 -- FAXDPRUN_ZZ_DPRN_RUN_BV
92 -- Purpose:
93 -- If the book is adjustable, then verify if inflation adjustment
94 -- has been run.
95 --
96 -- 03/22/00 Santosh Vaze Bug Fix 1235190 : Added a better suited
97 -- message for the situation where Colombian Generate JE process is not run.
98 -- The following package now returns different flags for different scenarios.
99
100 FUNCTION verify_adjust_flag(
101 p_country_code IN VARCHAR2,
102 p_book_type_code IN VARCHAR2,
103 p_period_name IN VARCHAR2) RETURN NUMBER;
104
105 --
106 -- Function Name:
107 -- verify_book_synchro
108 -- Called From:
109 -- FAXDPRUN_ZZ_DPRN_RUN_BV
110 -- Purpose:
111 -- Verify if the given book has 'Tax' or 'Corporative' associated
112 -- books, and if those books are or not out NOCOPY of synchrony in ran periods.
113 --
114
115 FUNCTION verify_book_synchro(
116 p_book_type_code IN VARCHAR2,
117 p_period_name IN VARCHAR2) RETURN BOOLEAN;
118
119
120
121 /*
122 * Function Name:
123 * is_foreign_supplier()
124 * Called From:
125 * APXINWKB_AR_INV_SUM_FOLDER_BV
126 * Purpose:
127 * Return TRUE if it is a foreign supplier; FALSE otherwise
128 */
129 FUNCTION is_foreign_supplier(p_vendor_id IN NUMBER) RETURN BOOLEAN;
130
131
132 /*
133 * Function Name:
134 * get_ship_to_location_code()
135 * Called From:
136 * APXINWKB_AR_D_SUM_FOLDER_BV
137 * Purpose:
138 * Return ship to location code
139 */
140 FUNCTION get_ship_to_location_code(p_po_distribution_id IN NUMBER) RETURN VARCHAR2;
141
142
143 /*
144 * Function Name:
145 * get_vendor_name()
146 * Called From:
147 * APXINWKB_ZZ_SPECIAL_MENU_SPC6
148 * Purpose:
149 * Return vendor_name given the tax payer ID(Vendor Number)
150 */
151 FUNCTION get_vendor_name(p_taxpayer_id IN VARCHAR2) RETURN VARCHAR2;
152
153
154 /*
155 * Function Name:
156 * get_vendor_id()
157 * Called From:
158 * APXINWKB_ZZ_SPECIAL_MENU_SPC6
159 * Purpose:
160 * Bug 4055807: Return vendor_id given the vendor number
161 */
162 FUNCTION get_vendor_id(p_vendor_number IN VARCHAR2) RETURN NUMBER;
163
164
165 /*
166 * Procedure Name:
167 * get_awt_type_attributes()
168 * Called From:
169 * APXTADTC_AR_TAX_CODES_BV and APXTADTC_CO_TAX_CODES_BV
170 * Purpose:
171 * Return Argentine and Colombian AWT type attributes given the AWT type code
172 */
173 PROCEDURE get_awt_type_attributes(p_awt_type_code IN VARCHAR2,
174 p_jurisdiction_type OUT NOCOPY VARCHAR2,
175 p_foreign_supplier_flag OUT NOCOPY VARCHAR2,
176 p_min_tax_amount_level OUT NOCOPY VARCHAR2,
177 p_min_wh_amount_level OUT NOCOPY VARCHAR2,
178 p_cumulative_payment_flag OUT NOCOPY VARCHAR2,
179 p_vat_inclusive_flag OUT NOCOPY VARCHAR2,
180 p_user_defined_formula_flag OUT NOCOPY VARCHAR2);
181
182
183 /*
184 * Function Name:
185 * exist_legal_address_site()
186 * Called From:
187 * APXVDMVD_ZZ_SITE_BV
188 * Purpose:
189 * Return TRUE if there is already a site chosen as the legal address;
190 * FALSE otherwise.
191 */
192 FUNCTION exist_legal_address_site(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER) RETURN BOOLEAN;
193
194 --
195 -- Procedure Name:
196 -- get_last_start_date
197 -- Called From:
198 -- FAXASSET_FA_ASSET_BV
199 -- Purpose:
200 -- Return last Inflation Start Date, for a given asset.
201 --
202
203 PROCEDURE get_last_start_date( p_asset_id IN NUMBER,
204 p_last_start_date OUT NOCOPY VARCHAR2);
205
206
207 --
208 -- Function Name:
209 -- eval_asset_reval
210 -- Called From:
211 -- FAXASSET_FA_ASSET_BV
212 -- Purpose:
213 -- Verify is Inflation Adjustment has been applied at
214 -- least once to the given asset.
215 --
216
217 FUNCTION eval_asset_reval( p_asset_id IN NUMBER) RETURN BOOLEAN;
218
219 --
220 -- Procedure Name :
221 -- get_location_row_id
222 -- Called from PERWSLOC_ZZ_LOC_PREIU
223 -- Purpose :
224 -- To Verify Unique Company Name in Locations , This row id passed to
225 -- chk_company_name_unique procedure
226
227 PROCEDURE get_location_row_id(p_location_id IN NUMBER, p_row_id OUT NOCOPY VARCHAR2);
228
229
230 END JL_ZZ_GLOBE_VAL_PKG;