1 PACKAGE AMS_LIST_MAINT_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvlmgs.pls 115.23 2002/11/14 19:27:25 jieli ship $ */
3
4
5 --
6 -- choang - 04-Apr-2000
7 -- bug 1259226 - can't compile package body.
8 TYPE ListEntryType_Rec_Type IS RECORD (
9 list_entry_id NUMBER,
10 list_header_id NUMBER,
11 source_code VARCHAR2(30),
12 arc_list_used_by_source VARCHAR2(30),
13 source_code_for_id NUMBER(30),
14 pin_code VARCHAR2(30),
15 list_entry_source_system_id NUMBER(30),
16 list_entry_source_system_type VARCHAR2(30),
17 view_application_id NUMBER,
18 cell_code VARCHAR2(30),
19 campaign_id NUMBER,
20 channel_schedule_id NUMBER,
21 event_offer_id NUMBER,
22 suffix VARCHAR2(20),
23 first_name VARCHAR2(150),
24 last_name VARCHAR2(150),
25 customer_name VARCHAR2(150),
26 title VARCHAR2(150),
27 address_line1 VARCHAR2(150),
28 address_line2 VARCHAR2(150),
29 city VARCHAR2(50),
30 state VARCHAR2(50),
31 zipcode VARCHAR2(50),
32 country VARCHAR2(100),
33 fax VARCHAR2(50),
34 phone VARCHAR2(50),
35 email_address VARCHAR2(100)
36
37 );
38
39 ---------------------------------------------------------------------
40 -- Procedure
41 -- Create_Source_View
42 --
43 -- PURPOSE
44 -- 1. Creates a view based on the mapping information specified in the AMS_LIST_SRC_TYPES
45 -- and AMS_LIST_SRC_FIELDS tables.
46
47 -- 2. The view will select only the columns which have been mapped to in the FIELD_TABLE_NAME
48 -- column in the AMS_LIST_SRC_FIELDS table.
49
50 -- 3. Each column in the view will be given an alias which corresponds to
51 -- the SOURCE_COLUMN_MEANING column in the AMS_LIST_SRC_FIELDS table.
52
53 -- PARAMETERS
54 -- 1. p_list_source_type specifies the type of mapping which the view is being created for.
55 -- IMPORT or TARGET.
56
57 -- 2. p_source_type_code specifies the mapping code which the view is being created for.
58 --
59
60 -- NOTES
61 --
62 ---------------------------------------------------------------------
63 Procedure Create_Source_View(p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
65 p_commit IN VARCHAR2 := FND_API.g_false,
66 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
67
68 p_user_id IN NUMBER,
69 p_resp_id IN NUMBER,
70 p_resp_appl_id IN NUMBER,
71
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75
76 p_list_source_type VARCHAR2,
77 p_source_type_code VARCHAR2);
78
79 ----------------------------------------------------------------------------------------------------------
80 -- Procedure
81 -- Copy_List
82 --
83 -- PURPOSE
84 -- Copies a List Header and optionally its actions or existing entries.
85
86 -- PARAMETERS
87 -- P_List_Id The List_Header_Id of The List to be Copied.
88 -- P_List_Used_By_ID The Foreign Key to the Entity using the list.
89 -- p_arc_list_used_by The Qualifier code which identifies the type of entity which is using the list.
90 -- P_Copy_Option 'A' Create New List Header and Copy Actions.
91 -- 'E' Create New List Header and create one INCLUDE action of the copied list name.
92 -- P_Repeat_Option If this is a repeating list then this option specifies how to copy the list.
93 -- 'R' create a new list with a generation type of 'REPEAT'.
94 -- 'I' create a new list with a generation type of 'INCREMENTAL', additionally
95 -- create 'EXCLUDE' actions for all previously generated children lists of the
96 -- parent list.
97
98 -- NOTES
99 -- created tdonohoe 10/27/99
100 ---------------------------------------------------------------------------------------------------------
101 Procedure Copy_List (p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
103 p_commit IN VARCHAR2 := FND_API.g_false,
104 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
105
106
107
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111
112 p_list_id IN NUMBER,
113 p_list_used_by_id IN number := NULL,
114 p_arc_list_used_by IN VARCHAR2 := NULL,
115 p_list_type IN VARCHAR2 := NULL,
116 p_copy_option IN VARCHAR2 :='A',
117 p_repeat_option IN VARCHAR2 :='R',
118 x_list_id OUT NOCOPY NUMBER,
119 x_listheader_rec OUT NOCOPY AMS_LISTHEADER_PVT.list_header_rec_type);
120
121
122 ----------------------------------------------------------------------------------------------------------
123 -- Procedure
124 -- Check_List_Association
125 -- PURPOSE
126 -- A List may optionally be associated with a valid marketing activity.
127 -- This Procedure checks that the specified activity and type exist.
128
129 -- PARAMETERS
130 -- P_ARC_LIST_USED_BY , valid values are CAMP,CSCH,EVEH,EVEO.
131 -- P_LIST_USED_BY_ID , the foreign key to the marketing entity table.
132 -- NOTES
133 -- created tdonohoe 11/16/99
134 ---------------------------------------------------------------------------------------------------------
135 Function Check_List_Association(p_arc_list_used_by varchar2,
136 p_list_used_by_id number)
137 Return Varchar2;
138
139
140
141 ----------------------------------------------------------------------------------------------------------
142 -- Procedure
143 -- Update_List_Entry_Source_Code
144
145 -- PURPOSE
146 -- A list may be generated without having an association with a valid marketing activity.
147 -- When at a later date a list is associated then the set of list entries must be updated
148 -- to reflect this association.
149
150 --
151 -- PARAMETERS
152 -- P_ARC_LIST_USED_BY , valid values are CAMP,CSCH,EVEH,EVEO.
153 -- P_LIST_USED_BY_ID , the foreign key to the marketing entity table.
154 -- NOTES
155 -- created tdonohoe 11/22/99
156 ---------------------------------------------------------------------------------------------------------
157 --Function Update_List_Entry_Source_Code(p_list_header_id in number) Return Varchar2;
158
159
160 ----------------------------------------------------------------------------------------------------------
161 -- Procedure
162 -- Schedule_List
163
164 -- PURPOSE
165 -- Called by Concurrent Manager to Schedule The AMS_LISTGENERATION_PKG.GENERATE_LIST procedure.
166 --
167 --
168 -- PARAMETERS
169
170 -- NOTES
171 -- created tdonohoe 11/23/99
172 ---------------------------------------------------------------------------------------------------------
173 Procedure SCHEDULE_LIST(errbuf OUT NOCOPY varchar2,
174 retcode OUT NOCOPY number,
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
177 p_commit IN VARCHAR2 := FND_API.G_FALSE,
178 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179 p_list_header_id IN NUMBER,
180 p_list_used_by_id IN VARCHAR2 := NULL,
181 p_arc_list_used_by IN VARCHAR2 := NULL,
182 p_new_list_name IN VARCHAR2 := NULL,
183 p_copy_entries IN VARCHAR2 := 'Y');
184
185 ----------------------------------------------------------------------------------------------------------
186 -- Procedure
187 -- Submit_List_For_Generation
188
189 -- PURPOSE
190 -- Submit List for Generation to Concurrent Manager at the specified_time.
191 --
192 -- PARAMETERS
193
194 -- NOTES
195 -- created tdonohoe 11/22/99
196 -- modified sugupta 04/24/2000 added timezone id
197 ---------------------------------------------------------------------------------------------------------
198 Procedure Submit_List_For_Generation(p_list_header_id in number,
199 p_user_id IN NUMBER,
200 p_resp_id IN NUMBER,
201 p_list_used_by_id in number := NULL,
202 p_arc_list_used_by in varchar2 := NULL,
203 p_timezone_id in NUMBER := NULL,
204 p_time in DATE := NULL,
205 p_name in varchar2 := NULL,
206 p_copy_entries in varchar2 := 'Y',
207 x_schedule_id OUT NOCOPY number );
208
209
210 ----------------------------------------------------------------------------------------------------------
211 -- Procedure
212 -- Create_Discoverer_Url
213
214 -- PURPOSE
215 -- Creates a URL which will launch Web Discoverer.
216 --
217 -- PARAMETERS
218
219 -- NOTES
220 -- created tdonohoe 09-May-2000
221 ---------------------------------------------------------------------------------------------------------
222 Procedure Create_Discoverer_Url(p_text IN VARCHAR2,
223 p_application_id IN NUMBER,
224 p_responsibility_id IN NUMBER,
225 p_security_group_id IN NUMBER,
226 p_function_id IN NUMBER,
227 p_target IN VARCHAR2,
228 p_session_id IN NUMBER,
229 x_discoverer_url OUT NOCOPY VARCHAR2
230 );
231
232
233 END; -- Package spec