1 PACKAGE JTF_TTY_UPLOAD_PUB AS
2 /* $Header: jtfptuns.pls 120.0 2005/06/02 18:21:06 appldev noship $ */
3 -- Start of Comments
4 -- ---------------------------------------------------
5 -- PACKAGE NAME: JTF_TTY_UPLOAD_PUB
6 -- ---------------------------------------------------
7 -- PURPOSE
8 -- This is to store the commonly used (hand-tuned) SQL
9 -- used by the TAE Generation Program
10 --
11 -- Procedures:
12 -- (see below for specification)
13 --
14 -- NOTES
15 -- This package is available for PUBLIC use
16 --
17 -- HISTORY
18 -- 08/29/03 JDOCHERT Created
19 --
20 -- End of Comments
21 --
22
23 PROCEDURE create_tg_na ( ERRBUF OUT NOCOPY VARCHAR2,
24 RETCODE OUT NOCOPY VARCHAR2,
25 p_terr_group_name IN VARCHAR2,
26 p_add_salesteam IN VARCHAR2 := 'N',
27 p_Debug_Flag IN VARCHAR2 := 'N',
28 p_SQL_Trace IN VARCHAR2 := 'N'
29 );
30
31
32 END JTF_TTY_UPLOAD_PUB;
33