1 PACKAGE AMS_FULFILL_PVT AUTHID CURRENT_USER as
2 /* $Header: amsvffms.pls 115.18 2002/12/05 00:57:28 dbiswas ship $ */
3
4 -- Start of Comments
5 --
6 -- NAME
7 -- AMS_FULFILL_PVT
8 --
9 -- PURPOSE
10 -- This package is a Private API for managing fulfillment in
11 -- AMS.
12 --
13 -- Procedures:
14 --
15 -- Ams_Fulfill (see below for specification)
16 --
17 -- NOTES
18 --
19 --
20 -- HISTORY
21 -- 12-nov-1999 ptendulk created
22 -- 27-oct-2000 ptendulk 1.Added user id in Procedure AMS_FULFILL
23 -- 2.Added new procedure AMS_EXEC_SCHEDULE to be called from
24 -- schedule page
25 -- 29-apr-2002 soagrawa removed some APIs that are no more being used
26 -- since we moved to new eblast
27 -- 29-apr-2002 soagrawa Modified for new schedule eblast
28 -- 30-may-2002 soagrawa Added parameter profile_id for ams_fulfill api
29 --
30 -- End of Comments
31 --
32 ----------------------------------------------------------------------------------------
33 ----------------------------------------------------------------------------------------
34 ----------------------------------------------------------------------------------------
35 -------------------------------- Fulfillment PVT Routines ------------------------------
36 ----------------------------------------------------------------------------------------
37 ----------------------------------------------------------------------------------------
38 ----------------------------------------------------------------------------------------
39
40
41 /*****************************************************************************************/
42 -- Start of Comments
43 --
44 -- API name : Ams_Fulfill
45 -- Type : Private
46 -- Function : fulfill the Collaterals as well as Coverletter for the Campaign
47 --
48 -- Pre-reqs : None
49 -- Paramaeters :
50 -- IN :
51 -- standard IN parameters
52 -- p_api_version IN NUMBER := NULL Required
53 -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54 -- p_commit IN VARCHAR2 := FND_API.G_FALSE, Optional
55 --
56 -- API's IN parameters
57 -- p_list_header_id IN number (Header ID of the List to be fulfilled)
58 --
59 -- standard OUT parameters
60 -- x_return_status OUT VARCHAR2(1)
61 -- x_msg_count OUT NUMBER
62 -- x_msg_data OUT VARCHAR2(2000)
63 --
64 --
65 -- Version : Current version 1.0
66 -- Initial version 1.0
67 --
68 -- End Of Comments
69
70
71 PROCEDURE AMS_FULFILL
72 (p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 := FND_API.G_False,
74 p_commit IN VARCHAR2 := FND_API.G_False,
75
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER ,
78 x_msg_data OUT NOCOPY VARCHAR2,
79
80 x_request_history_id OUT NOCOPY NUMBER,
81 -- p_list_header_id IN NUMBER,
82 p_schedule_id IN NUMBER,
83 p_profile_id IN NUMBER := fnd_profile.VALUE('AMF_DEFAULT_MAIL_PROFILE'),
84 p_user_id IN NUMBER := FND_GLOBAL.user_id );
85
86
87 -- Start of Comments
88 --
89 -- NAME
90 -- AMS_EXEC_SCHEDULE
91 --
92 -- PURPOSE
93 -- This procedure is wrapper on ams_fulfill
94 -- It will be called from schedules to execute the list.
95 -- The procedure first updates the list with the schedule details,
96 -- it executes the list , and then updates the list sent out date .
97 --
98 -- NOTES
99 --
100 --
101 -- HISTORY
102 -- 10/27/2000 ptendulk created
103 -- End of Comments
104 PROCEDURE AMS_EXEC_SCHEDULE
105 (p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 := FND_API.G_False,
107 p_commit IN VARCHAR2 := FND_API.G_False,
108
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER ,
111 x_msg_data OUT NOCOPY VARCHAR2,
112
113 p_list_header_id IN NUMBER,
114 p_schedule_id IN NUMBER,
115 p_exec_flag IN VARCHAR2) ;
116
117 -- Start of Comments
118 --
119 -- NAME
120 -- Send_Test_Mail
121 --
122 -- PURPOSE
123 -- This procedure is use to Send the test mail to the test user
124 --
125 -- NOTES
126 --
127 --
128 -- HISTORY
129 -- 22-Jun-2001 ptendulk created
130 -- 29-apr-2002 soagrawa removed
131 --
132 -- End of Comments
133 /*
134 PROCEDURE Send_Test_Email
135 (p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 := FND_API.G_False,
137 p_commit IN VARCHAR2 := FND_API.G_False,
138
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER ,
141 x_msg_data OUT NOCOPY VARCHAR2,
142
143 p_email_address IN VARCHAR2,
144 p_schedule_id IN NUMBER) ;
145 */
146 -- Start of Comments
147 --
148 -- NAME
149 -- Send_Test_Mail
150 --
151 -- PURPOSE
152 -- This procedure is link the Cover letter with the query
153 --
154 -- NOTES
155 -- This api is currently inserting into jtf_amv_query
156 -- once the fulfillment team delivers the api , the
157 -- insert statement will be replaced with the api call
158 --
159 -- HISTORY
160 -- 26-Jun-2001 ptendulk created
161 -- 29-apr-2002 soagrawa removed
162 -- End of Comments
163 /*
164 PROCEDURE Attach_Query
165 (p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 := FND_API.G_False,
167 p_commit IN VARCHAR2 := FND_API.G_False,
168
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER ,
171 x_msg_data OUT NOCOPY VARCHAR2,
172
173 p_query_id IN NUMBER,
174 p_item_id IN NUMBER
175 );
176 */
177 END AMS_Fulfill_PVT;