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