1 PACKAGE AST_rs_camp_PUB AUTHID CURRENT_USER as
2 /* $Header: astprcas.pls 115.3 2002/02/05 17:26:41 pkm ship $ */
3 -- Start of Comments
4 -- Package name : AST_rs_camp_PUB
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:rs_camp_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- RS_CAMPAIGN_ID
19 -- RESOURCE_ID
20 -- CAMPAIGN_ID
21 -- START_DATE
22 -- END_DATE
23 -- STATUS
24 -- ENABLED_FLAG
25 -- CREATED_BY
26 -- CREATION_DATE
27 -- LAST_UPDATED_BY
28 -- LAST_UPDATE_DATE
29 -- LAST_UPDATE_LOGIN
30 --
31 -- Required:
32 -- Defaults:
33 -- Note: This is automatic generated record definition, it includes all columns
34 -- defined in the table, developer must manually add or delete some of the attributes.
35 --
36 -- End of Comments
37
38 TYPE rs_camp_Rec_Type IS RECORD
39 (
40 RS_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
41 RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
42 CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
43 START_DATE DATE := FND_API.G_MISS_DATE,
44 END_DATE DATE := FND_API.G_MISS_DATE,
45 STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,
46 ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48 CREATION_DATE DATE := FND_API.G_MISS_DATE,
49 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
51 LAST_UPDATE_LOGIN VARCHAR2(240) := FND_API.G_MISS_CHAR
52 );
53
54 G_MISS_rs_camp_REC rs_camp_Rec_Type;
55 TYPE rs_camp_Tbl_Type IS TABLE OF rs_camp_Rec_Type
56 INDEX BY BINARY_INTEGER;
57 G_MISS_rs_camp_TBL rs_camp_Tbl_Type;
58
59 TYPE rs_camp_sort_rec_type IS RECORD
60 (
61 -- Please define your own sort by record here.
62 RESOURCE_ID NUMBER := NULL
63 );
64
65 -- *******************************************************
66 -- Start of Comments
67 -- *******************************************************
68 -- API Name: Create_rs_camp
69 -- Type : Public
70 -- Pre-Req :
71 -- Parameters:
72 -- IN
73 -- p_api_version_number IN NUMBER Required
74 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
75 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
76 -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
77 --
78 -- OUT:
79 -- x_return_status OUT VARCHAR2
80 -- x_msg_count OUT NUMBER
81 -- x_msg_data OUT VARCHAR2
82 -- Version : Current version 2.0
83 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
84 -- and basic operation, developer must manually add parameters and business logic as necessary.
85 --
86 -- End of Comments
87 --
88 PROCEDURE Create_rs_camp(
89 P_Api_Version_Number IN NUMBER,
90 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92 P_rs_camp_Rec IN rs_camp_Rec_Type := G_MISS_rs_camp_REC,
93 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
94 X_RS_CAMPAIGN_ID OUT NUMBER,
95 X_Return_Status OUT VARCHAR2,
96 X_Msg_Count OUT NUMBER,
97 X_Msg_Data OUT VARCHAR2
98 );
99
100 -- *******************************************************
101 -- Start of Comments
102 -- *******************************************************
103 -- API Name: Update_rs_camp
104 -- Type : Public
105 -- Pre-Req :
106 -- Parameters:
107 -- IN
108 -- p_api_version_number IN NUMBER Required
109 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
112 -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
113 --
114 -- OUT:
115 -- x_return_status OUT VARCHAR2
116 -- x_msg_count OUT NUMBER
117 -- x_msg_data OUT VARCHAR2
118 -- Version : Current version 2.0
119 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
120 -- and basic operation, developer must manually add parameters and business logic as necessary.
121 --
122 -- End of Comments
123 --
124 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
125 PROCEDURE Update_rs_camp(
126 P_Api_Version_Number IN NUMBER,
127 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
128 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
129 P_Identity_Salesforce_Id IN NUMBER := NULL,
130 P_rs_camp_Rec IN rs_camp_Rec_Type,
131 X_Return_Status OUT VARCHAR2,
132 X_Msg_Count OUT NUMBER,
133 X_Msg_Data OUT VARCHAR2
134 );
135
136 -- *******************************************************
137 -- Start of Comments
138 -- *******************************************************
139 -- API Name: Delete_rs_camp
140 -- Type : Public
141 -- Pre-Req :
142 -- Parameters:
143 -- IN
144 -- p_api_version_number IN NUMBER Required
145 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
146 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
147 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
148 -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
149 --
150 -- OUT:
151 -- x_return_status OUT VARCHAR2
152 -- x_msg_count OUT NUMBER
153 -- x_msg_data OUT VARCHAR2
154 -- Version : Current version 2.0
155 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
156 -- and basic operation, developer must manually add parameters and business logic as necessary.
157 --
158 -- End of Comments
159 --
160 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
161 -- The Master delete procedure may not be needed depends on different business requirements.
162 PROCEDURE Delete_rs_camp(
163 P_Api_Version_Number IN NUMBER,
164 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
166 P_identity_salesforce_id IN NUMBER := NULL,
167 P_rs_camp_Rec IN rs_camp_Rec_Type,
168 X_Return_Status OUT VARCHAR2,
169 X_Msg_Count OUT NUMBER,
170 X_Msg_Data OUT VARCHAR2
171 );
172
173 -- *******************************************************
174 -- Start of Comments
175 -- *******************************************************
176 -- API Name: Get_rs_camp
177 -- Type : Public
178 -- Pre-Req :
179 -- Parameters:
180 -- IN
181 -- p_api_version_number IN NUMBER Required
182 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
184 -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
185 -- Hint: Add List of bind variables here
186 -- p_rec_requested IN NUMBER Optional Default = 30
187 -- p_start_rec_ptr IN NUMBER Optional Default = 1
188 --
189 -- Return Total Records Count Flag. This flag controls whether the total record count
190 -- and total record amount is returned.
191 --
192 -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
193 -- Hint: User defined record type
194 -- p_order_by_tbl IN JTF_PLSQL_API.UTIL_ORDER_BY_TBL_TYPE;
195 --
196 -- OUT:
197 -- x_return_status OUT VARCHAR2
198 -- x_msg_count OUT NUMBER
199 -- x_msg_data OUT VARCHAR2
200 -- X_rs_camp_Tbl OUT rs_camp_Rec_Type
201 -- x_returned_rec_count OUT NUMBER
202 -- x_next_rec_ptr OUT NUMBER
203 -- x_tot_rec_count OUT NUMBER
204 -- other optional out parameters
205 -- x_tot_rec_amount OUT NUMBER
206 -- Version : Current version 2.0
207 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
208 -- and basic operation, developer must manually add parameters and business logic as necessary.
209 --
210 -- End of Comments
211 --
212 PROCEDURE Get_rs_camp(
213 P_Api_Version_Number IN NUMBER,
214 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
215 P_identity_salesforce_id IN NUMBER := NULL,
216 P_rs_camp_Rec IN AST_rs_camp_PUB.rs_camp_Rec_Type,
217 -- Hint: Add list of bind variables here
218 p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
219 p_start_rec_prt IN NUMBER := 1,
220 p_return_tot_count IN NUMBER := FND_API.G_FALSE,
221 -- Hint: user defined record type
222 p_order_by_rec IN AST_rs_camp_PUB.rs_camp_sort_rec_type,
223 x_return_status OUT VARCHAR2,
224 x_msg_count OUT NUMBER,
225 x_msg_data OUT VARCHAR2,
226 X_rs_camp_Tbl OUT AST_rs_camp_PUB.rs_camp_Tbl_Type,
227 x_returned_rec_count OUT NUMBER,
228 x_next_rec_ptr OUT NUMBER,
229 x_tot_rec_count OUT NUMBER
230 -- other optional parameters
231 -- x_tot_rec_amount OUT NUMBER
232 );
233
234 End AST_rs_camp_PUB;