DBA Data[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;