[Home] [Help]
PACKAGE: APPS.CTO_AUTO_PURGE_PK
Source
1 PACKAGE cto_auto_purge_pk AUTHID CURRENT_USER AS
2 /*$Header: CTODCFGS.pls 120.3 2008/01/18 16:52:00 abhissri ship $ */
3 /*============================================================================+
4 | Copyright (c) 1999 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 | Oracle Manufacturing |
7 +=============================================================================+
8 | |
9 | FILE NAME : CTODCFGS.pls |
10 | DESCRIPTION : Purge Configurations from bom_ato_configurations table |
11 | HISTORY : |
12 | 26-Nov-2002 : Kundan Sarkar Initial Version |
13 | 21-Jun-2005 : Renga Kannan Added nocopy for out parameters
14 | |
15 =============================================================================*/
16
17
18 g_pkg_name CONSTANT VARCHAR2(30) := 'CTO_AUTO_PURGE_PK';
19
20
21 /**************************************************************************
22 Procedure: AUTO_PURGE
23 Parameters: p_base_model NUMBER -- Base model Id
24 p_config_item NUMBER -- Config Item Id
25 p_created_days_ago NUMBER -- Number of days since creation
26 p_last_ref_days_ago NUMBER -- Number of days since last referenced
27 Description: This procedure is called from the concurrent program Purge
28 Configuration Items .
29 *****************************************************************************/
30 PROCEDURE auto_purge (
31 errbuf OUT NOCOPY VARCHAR2,
32 retcode OUT NOCOPY VARCHAR2,
33 p_created_days_ago NUMBER,
34 p_last_ref_days_ago NUMBER,
35 dummy VARCHAR2,
36 p_config_item NUMBER,
37 dummy2 VARCHAR2,
38 p_base_model NUMBER,
39 p_option_item NUMBER default null ) ;
40 END cto_auto_purge_pk;