1 PACKAGE CS_SR_Preferred_Lang_PUB AUTHID CURRENT_USER AS
2 /* $Header: cspprls.pls 115.4 2002/11/30 10:13:44 pkesani noship $ */
3
4
5 PROCEDURE initialize_rec(p_preferred_lang_record IN OUT
6 NOCOPY CS_SR_Preferred_Lang_PVT.preferred_language_rec_type
7 );
8
9
10 --------------------------------------------------------------------------
11 -- Start of comments
12 -- API name : Create_Preferred_Language
13 -- Type : Public
14 -- Function : Creates a Preferred Language in the table CS_SR_PREFERRED_LANG
15 -- Pre-reqs : None.
16 --
17 -- Standard IN Parameters:
18 -- p_api_version IN NUMBER Required
19 -- p_init_msg_list IN VARCHAR2 Optional
20 -- Default = FND_API.G_FALSE
21 -- p_commit IN VARCHAR2 Optional
22 -- Default = FND_API.G_FALSE
23 -- p_validation_level IN NUMBER Optional
24 -- Default = FND_API.G_VALID_LEVEL_FULL
25 --
26 -- Standard OUT Parameters:
27 -- x_return_status OUT VARCHAR2(1)
28 -- x_msg_count OUT NUMBER
29 -- x_msg_data OUT VARCHAR2(2000)
30 --
31 -- Service Request IN Parameters:
32 -- p_resp_appl_id IN NUMBER Optional
33 -- p_resp_id IN NUMBER Optional
34 -- p_user_id IN NUMBER Required
35 -- Application user identifier
36 -- Valid user from fnd_user
37
38 -- p_login_id IN NUMBER Optional
39 -- Identifier of login session
40 --
41 -- p_preferred_language_rec IN preferred_language_rec_type Required
42
43 --
44 -- Version : Initial version 1.0
45 --
46 -- End of comments
47
48
49 PROCEDURE Create_Preferred_Language(
50 p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
52 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 p_resp_appl_id IN NUMBER DEFAULT NULL,
57 p_resp_id IN NUMBER DEFAULT NULL,
58 p_user_id IN NUMBER,
59 p_login_id IN NUMBER DEFAULT NULL,
60 p_preferred_language_rec IN CS_SR_Preferred_Lang_PVT.preferred_language_rec_type
61 );
62
63
64 --------------------------------------------------------------------------
65 -- Start of comments
66 -- API name : Update_Preferred_Language
67 -- Type : Public
68 -- Function : Updates a preferred language in the table CS_SR_PREFERRED_LANG.
69 -- Pre-reqs : None.
70 -- Parameters :
71 -- IN :
72 -- p_api_version IN NUMBER Required
73 -- p_init_msg_list IN VARCHAR2 Optional
74 -- Default = FND_API.G_FALSE
75 -- p_commit IN VARCHAR2 Optional
76 -- Default = FND_API.G_FALSE
77 -- p_validation_level IN NUMBER Optional
78 -- Default = FND_API.G_VALID_LEVEL_FULL
79
80 -- p_pref_lang_id IN NUMBER Required
81 -- p_object_version_number IN NUMBER Required for Web-Apps
82
83 -- p_resp_appl_id IN NUMBER Optional
84 -- p_resp_id IN NUMBER Optional
85 -- p_last_updated_by IN NUMBER Required
86 -- VAlid user from fnd_user
87
88 -- p_last_update_login IN NUMBER Optional
89 -- Default = NULL
90 -- p_last_update_date IN DATE Required
91
92 -- p_service_request_rec IN service_request_rec_type Required
93
94
95 -- OUT :
96 -- x_return_status OUT VARCHAR2(1) Required
97 -- x_msg_count OUT NUMBER Required
98 -- x_msg_data OUT VARCHAR2(2000) Required
99 --
100 -- Version : Current version 1.0
101 --
102 -- Notes:
103 --
104 -- End of comments
105 --------------------------------------------------------------------------
106
107
108 PROCEDURE Update_Preferred_Language
109 ( p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
111 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_pref_lang_id IN NUMBER,
116 p_object_version_number IN NUMBER,
117 p_resp_appl_id IN NUMBER DEFAULT NULL,
118 p_resp_id IN NUMBER DEFAULT NULL,
119 p_user_id IN NUMBER ,
120 p_login_id IN NUMBER DEFAULT NULL,
121 p_last_updated_by IN NUMBER,
122 p_last_update_login IN NUMBER DEFAULT NULL,
123 p_last_update_date IN DATE,
124 p_preferred_language_rec IN CS_SR_Preferred_Lang_PVT.preferred_language_rec_type
125 );
126
127 END CS_SR_Preferred_Lang_PUB;