DBA Data[Home] [Help]

PACKAGE: APPS.CSFW_SETUP_PKG

Source


1 PACKAGE CSFW_SETUP_PKG AUTHID CURRENT_USER AS
2 /* $Header: csfwsetups.pls 120.2 2011/01/05 11:15:50 shadas noship $ */
3 
4   PROCEDURE insert_phonetics_row
5     (
6       p_phonetics_id      IN VARCHAR2 ,
7       p_language          IN VARCHAR2 ,
8       p_phonetic          IN VARCHAR2 ,
9       p_code              IN VARCHAR2 ,
10       p_description       IN VARCHAR2 ,
11       p_enabled_flag      IN VARCHAR2 ,
12       p_start_date_active IN VARCHAR2 ,
13       p_end_date_active   IN VARCHAR2 ,
14       p_created_by        IN VARCHAR2 ,
15       p_creation_date     IN VARCHAR2 ,
16       p_last_updated_by   IN VARCHAR2 ,
17       p_last_update_login IN VARCHAR2 ,
18       p_last_update_date  IN VARCHAR2 );
19 
20   PROCEDURE update_phonetics_row
21     (
22       p_phonetics_id      IN VARCHAR2 ,
23       p_language          IN VARCHAR2 ,
24       p_phonetic          IN VARCHAR2 ,
25       p_code              IN VARCHAR2 ,
26       p_description       IN VARCHAR2 ,
27       p_enabled_flag      IN VARCHAR2 ,
28       p_start_date_active IN VARCHAR2 ,
29       p_end_date_active   IN VARCHAR2 ,
30       p_created_by        IN VARCHAR2 ,
31       p_creation_date     IN VARCHAR2 ,
32       p_last_updated_by   IN VARCHAR2 ,
33       p_last_update_login IN VARCHAR2 ,
34       p_last_update_date  IN VARCHAR2 );
35 
36   PROCEDURE load_phonetics_row
37     (
38       p_phonetics_id      IN VARCHAR2 ,
39       p_language          IN VARCHAR2 ,
40       p_phonetic          IN VARCHAR2 ,
41       p_code              IN VARCHAR2 ,
42       p_description       IN VARCHAR2 ,
43       p_enabled_flag      IN VARCHAR2 ,
44       p_start_date_active IN VARCHAR2 ,
45       p_end_date_active   IN VARCHAR2 ,
46       p_created_by        IN VARCHAR2 ,
47       p_creation_date     IN VARCHAR2 ,
48       p_last_updated_by   IN VARCHAR2 ,
49       p_last_update_login IN VARCHAR2 ,
50       p_last_update_date  IN VARCHAR2 );
51 
52 	PROCEDURE purge_server_session (
53 	    errbuf           OUT    NOCOPY    VARCHAR2,
54 		retcode          OUT    NOCOPY    VARCHAR2,
55 		p_caller		IN VARCHAR2 := 'CSFWPRGE',
56 		p_end_date		IN VARCHAR2 := NULL
57 	);
58 
59 END CSFW_SETUP_PKG;
60