[Home] [Help]
PACKAGE: APPS.JL_CO_FA_PURGE_PKG
Source
1 PACKAGE jl_co_fa_purge_pkg AUTHID CURRENT_USER AS
2 /* $Header: jlcoftps.pls 120.4.12020000.1 2012/06/27 09:53:55 appldev ship $ */
3
4 ----------------------------------------------------------------------------
5 -- PROCEDURE --
6 -- purge_adjustment --
7 -- --
8 -- DESCRIPTION --
9 -- Use this procedure to purge jl_co-fa_adjustments table --
10 -- --
11 -- PURPOSE: --
12 -- Oracle Applications Rel 11.0 --
13 -- --
14 -- PARAMETERS: --
15 -- p_book --
16 -- p_fiscal_year --
17 -- p_option --
18 -- --
19 -- HISTORY: --
20 -- 08/21/98 Sujit Dalai Created --
21 ----------------------------------------------------------------------------
22
23 PROCEDURE purge_adjustment( ERRBUF OUT NOCOPY VARCHAR2,
24 RETCODE OUT NOCOPY VARCHAR2,
25 p_book VARCHAR2,
26 p_fiscal_year NUMBER,
27 p_option VARCHAR2);
28
29 ----------------------------------------------------------------------------
30 -- PROCEDURE --
31 -- purge_appraisal --
32 -- --
33 -- DESCRIPTION --
34 -- Use this procedure to purge the tables jl_co-fa_appraisals and --
35 -- jl_co_fa_asset_apprs --
36 -- PURPOSE: --
37 -- Oracle Applications Rel 11.0 --
38 -- --
39 -- PARAMETERS: --
40 -- p_fiscal_year --
41 -- p_option --
42 -- --
43 -- HISTORY: --
44 -- 08/21/98 Sujit Dalai Created --
45 -- 04/26/00 Santosh Vaze Bug Fix 1100863: Technical Appraisals can --
46 -- not be archived for the fiscal year if --
47 -- there is any unprocessed appraisal. But --
48 -- there is no prevision in the application --
49 -- to delete the erroneous appraisals. This --
50 -- dead lock is removed in this bug fix. --
51 ----------------------------------------------------------------------------
52 PROCEDURE purge_appraisal( ERRBUF OUT NOCOPY VARCHAR2,
53 RETCODE OUT NOCOPY VARCHAR2,
54 p_fiscal_year NUMBER,
55 p_option VARCHAR2,
56 p_del_unproc_app VARCHAR2);
57
58 END jl_co_fa_purge_pkg;