[Home] [Help]
PACKAGE: APPS.AMS_CONTACT_PREFERENCE_PVT
Source
1 PACKAGE AMS_CONTACT_PREFERENCE_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvcpps.pls 115.7 2002/12/23 22:56:13 vbhandar ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_CONTACT_PREFERENCE_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- ams_contact_pref_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 --
26 -- Required
27 --
28 -- Defaults
29 --
30 -- Note: This is automatic generated record definition, it includes all columns
31 -- defined in the table, developer must manually add or delete some of the attributes.
32 --
33 -- End of Comments
34
35 --===================================================================
36
37 TYPE contact_preference_rec_type IS RECORD (
38
39 contact_preference_id NUMBER,
40 contact_level_table VARCHAR2(30),
41 contact_level_table_id NUMBER,
42 contact_type VARCHAR2(30),
43 preference_code VARCHAR2(30),
44 preference_topic_type VARCHAR2(30),
45 preference_topic_type_id NUMBER,
46 preference_topic_type_code VARCHAR2(30),
47 preference_start_date DATE,
48 preference_end_date DATE,
49 preference_start_time_hr NUMBER,
50 preference_end_time_hr NUMBER,
51 preference_start_time_mi NUMBER,
52 preference_end_time_mi NUMBER,
53 max_no_of_interactions NUMBER,
54 max_no_of_interact_uom_code VARCHAR2(30),
55 requested_by VARCHAR2(30),
56 reason_code VARCHAR2(30),
57 status VARCHAR2(1),
58 created_by_module VARCHAR2(150),
59 application_id NUMBER
60
61 );
62
63 -- ==============================================================================
64 -- Start of Comments
65 -- ==============================================================================
66 -- API Name
67 -- create_contact_preference
68 -- Type
69 -- Private
70 -- Pre-Req
71 --
72 -- Parameters
73 --
74 -- IN
75 -- p_api_version_number IN NUMBER Required
76 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
77 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
78 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
79 -- p_ams_contact_pref_rec IN ams_contact_pref_rec_type Required
80 --
81 -- OUT
82 -- x_return_status OUT VARCHAR2
83 -- x_msg_count OUT NUMBER
84 -- x_msg_data OUT VARCHAR2
85 -- Version : Current version 1.0
86 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
87 -- and basic operation, developer must manually add parameters and business logic as necessary.
88 --
89 -- End of Comments
90 -- ==============================================================================
91 --
92
93
94 PROCEDURE create_contact_preference(
95 p_api_version_number IN NUMBER,
96 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97 p_commit IN VARCHAR2 := FND_API.G_FALSE,
98 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102
103 p_ams_contact_pref_rec IN contact_preference_rec_type ,
104 p_request_id IN NUMBER,
105 x_contact_preference_id OUT NOCOPY NUMBER
106
107 );
108
109 -- ==============================================================================
110 -- Start of Comments
111 -- ==============================================================================
112 -- API Name
113 -- update_contact_preference
114 -- Type
115 -- Private
116 -- Pre-Req
117 --
118 -- Parameters
119 --
120 -- IN
121 -- p_api_version_number IN NUMBER Required
122 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
123 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
124 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
125 -- p_ams_contact_pref_rec IN ams_contact_pref_rec_type Required
126 --
127 -- OUT
128 -- x_return_status OUT VARCHAR2
129 -- x_msg_count OUT NUMBER
130 -- x_msg_data OUT VARCHAR2
131 -- Version : Current version 1.0
132 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
133 -- and basic operation, developer must manually add parameters and business logic as necessary.
134 --
135 -- End of Comments
136 -- ==============================================================================
137 --
138
139
140 PROCEDURE update_contact_preference(
141 p_api_version_number IN NUMBER,
142 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143 p_commit IN VARCHAR2 := FND_API.G_FALSE,
144 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148
149 p_ams_contact_pref_rec IN contact_preference_rec_type ,
150 p_request_id IN NUMBER,
151 px_object_version_number IN OUT NOCOPY NUMBER
152 );
153
154
155 END AMS_CONTACT_PREFERENCE_PVT;