[Home] [Help]
PACKAGE: APPS.BEN_SAZ_CACHE
Source
1 package ben_saz_cache AUTHID CURRENT_USER as
2 /* $Header: bensazch.pkh 120.0.12010000.1 2008/07/29 12:31:12 appldev ship $*/
3 --
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 --
11 History
12 Version Date Who What?
13 --------- --------- ---------- --------------------------------------------
14 115.0 17-Sep-00 mhoyes Created.
15 115.2 11-dec-2002 hmani NoCopy changes
16 -----------------------------------------------------------------------------
17 */
18 --
19 -- Check if the zip code and service area combination exists in
20 -- ben_svc_area_pstl_zip_rng_f
21 --
22 procedure SAZRZR_Exists
23 (p_svc_area_id in number
24 ,p_zip_code in varchar2
25 ,p_eff_date in date
26 --
27 ,p_exists out nocopy boolean
28 );
29 --
30 ------------------------------------------------------------------------
31 -- DELETE CACHED DATA
32 ------------------------------------------------------------------------
33 procedure clear_down_cache;
34 --
35 END ben_saz_cache;