DBA Data[Home] [Help]

PACKAGE: APPS.CTO_ORDER_PURGE

Source


1 PACKAGE CTO_ORDER_PURGE AUTHID CURRENT_USER as
2 /* $Header: CTOPURGS.pls 120.1 2005/06/06 10:07:54 appldev  $ */
3 /*
4  *=========================================================================*
5  |                                                                         |
6  | Copyright (c) 2001, Oracle Corporation, Redwood Shores, California, USA |
7  |                           All rights reserved.                          |
8  |                                                                         |
9  *=========================================================================*
10  |                                                                         |
11  | NAME                                                                    |
12  |            CTO ORDER PURGE package spec                                 |
13  |                                                                         |
14  | DESCRIPTION                                                             |
15  |   PL/SQL package spec containing the spec deletion routine  for         |
16  |   purging the data in CTO tables which were inserted during             |
17  |   creation of orders                                                    |
18  | ARGUMENTS                                                               |
19  |   Input :  Please see the individual function or procedure.             |
20  |                                                                         |
21  | HISTORY                                                                 |
22  |   Date      Author   Comments                                           |
23  | --------- -------- ---------------------------------------------------- |
24  |  05/09/2001  kkonada  intial creation of spec for cto table purge	   |
25  |  06/01/2005  rekannan Added nocopy hint to out parameters
26  *=========================================================================*/
27 
28 PROCEDURE cto_purge_tables
29           ( p_header_id       IN NUMBER,
30             x_error_msg       OUT NOCOPY VARCHAR2,
31             x_return_status   OUT NOCOPY VARCHAR2
32            );
33 
34 END CTO_ORDER_PURGE;