[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