1 Package ota_chat_swi As
2 /* $Header: otchaswi.pkh 120.2 2006/03/06 02:27 rdola noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------------< create_chat >-----------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: ota_chat_api.create_chat
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_chat
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_name in varchar2
30 ,p_description in varchar2 default null
31 ,p_business_group_id in number
32 ,p_start_date_active in date default null
33 ,p_end_date_active in date default null
34 ,p_start_time_active in varchar2 default null
35 ,p_end_time_active in varchar2 default NULL
36 ,p_timezone_code IN VARCHAR2 DEFAULT NULL
37 ,p_public_flag in varchar2 default null
38 ,p_chat_id in number
39 ,p_object_version_number out nocopy number
40 ,p_return_status out nocopy varchar2
41 );
42 -- ----------------------------------------------------------------------------
43 -- |------------------------------< update_chat >-----------------------------|
44 -- ----------------------------------------------------------------------------
45 -- {Start of comments}
46 --
47 -- Description:
48 -- This procedure is the self-service wrapper procedure to the following
49 -- API: ota_chat_api.update_chat
50 --
51 -- Pre-requisites
52 -- All 'IN' parameters to this procedure have been appropriately derived.
53 --
54 -- Post Success:
55 -- p_return_status will return value indicating success.
56 --
57 -- Post Failure:
58 -- p_return_status will return value indication failure.
59 --
60 -- Access Status:
61 -- Internal Development use only.
62 --
63 -- {End of comments}
64 -- ----------------------------------------------------------------------------
65 PROCEDURE update_chat
66 (p_validate in number default hr_api.g_false_num
67 ,p_effective_date in date
68 ,p_name in varchar2
69 ,p_description in varchar2
70 ,p_business_group_id in number
71 ,p_start_date_active in date default hr_api.g_date
72 ,p_end_date_active in date default hr_api.g_date
73 ,p_start_time_active in varchar2 default hr_api.g_varchar2
74 ,p_end_time_active in varchar2 default hr_api.g_varchar2
75 ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
76 ,p_public_flag in varchar2 default hr_api.g_varchar2
77 ,p_chat_id in number
78 ,p_object_version_number in out nocopy number
79 ,p_return_status out nocopy varchar2
80 );
81 -- ----------------------------------------------------------------------------
82 -- |------------------------------< delete_chat >-----------------------------|
83 -- ----------------------------------------------------------------------------
84 -- {Start of comments}
85 --
86 -- Description:
87 -- This procedure is the self-service wrapper procedure to the following
88 -- API: ota_chat_api.delete_chat
89 --
90 -- Pre-requisites
91 -- All 'IN' parameters to this procedure have been appropriately derived.
92 --
93 -- Post Success:
94 -- p_return_status will return value indicating success.
95 --
96 -- Post Failure:
97 -- p_return_status will return value indication failure.
98 --
99 -- Access Status:
100 -- Internal Development use only.
101 --
102 -- {End of comments}
103 -- ----------------------------------------------------------------------------
104 PROCEDURE delete_chat
105 (p_validate in number default hr_api.g_false_num
106 ,p_chat_id in number
107 ,p_object_version_number in number
108 ,p_return_status out nocopy varchar2
109 );
110 end ota_chat_swi;