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,
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,
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,
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,
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,
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,
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
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: );
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:
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;
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
62: -- Pre-Req :
63: -- Parameters:
64: -- IN
65: -- p_api_version_number IN NUMBER Required
66: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
67: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
68: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
69: -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
70: --
63: -- Parameters:
64: -- IN
65: -- p_api_version_number IN NUMBER Required
66: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
67: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
68: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
69: -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
70: --
71: -- OUT:
64: -- IN
65: -- p_api_version_number IN NUMBER Required
66: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
67: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
68: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
69: -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
70: --
71: -- OUT:
72: -- x_return_status OUT VARCHAR2
84:
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91: P_grp_camp_Rec IN grp_camp_Rec_Type := G_MISS_grp_camp_REC,
92: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91: P_grp_camp_Rec IN grp_camp_Rec_Type := G_MISS_grp_camp_REC,
92: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
93: X_GROUP_CAMPAIGN_ID OUT NUMBER,
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91: P_grp_camp_Rec IN grp_camp_Rec_Type := G_MISS_grp_camp_REC,
92: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
93: X_GROUP_CAMPAIGN_ID OUT NUMBER,
94: X_Return_Status OUT VARCHAR2,
104: -- Pre-Req :
105: -- Parameters:
106: -- IN
107: -- p_api_version_number IN NUMBER Required
108: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
109: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
110: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
111: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
112: -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
105: -- Parameters:
106: -- IN
107: -- p_api_version_number IN NUMBER Required
108: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
109: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
110: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
111: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
112: -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
113: --
106: -- IN
107: -- p_api_version_number IN NUMBER Required
108: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
109: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
110: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
111: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
112: -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
113: --
114: -- OUT:
123: --
124: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
125: PROCEDURE Update_grp_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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: P_Identity_Salesforce_Id IN NUMBER := NULL,
131: P_grp_camp_Rec IN grp_camp_Rec_Type,
124: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
125: PROCEDURE Update_grp_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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: P_Identity_Salesforce_Id IN NUMBER := NULL,
131: P_grp_camp_Rec IN grp_camp_Rec_Type,
132: X_Return_Status OUT VARCHAR2,
125: PROCEDURE Update_grp_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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: P_Identity_Salesforce_Id IN NUMBER := NULL,
131: P_grp_camp_Rec IN grp_camp_Rec_Type,
132: X_Return_Status OUT VARCHAR2,
133: X_Msg_Count OUT NUMBER,
142: -- Pre-Req :
143: -- Parameters:
144: -- IN
145: -- p_api_version_number IN NUMBER Required
146: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
147: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
148: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
149: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
150: -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
143: -- Parameters:
144: -- IN
145: -- p_api_version_number IN NUMBER Required
146: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
147: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
148: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
149: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
150: -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
151: --
144: -- IN
145: -- p_api_version_number IN NUMBER Required
146: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
147: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
148: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
149: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
150: -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
151: --
152: -- OUT:
162: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
163: -- The Master delete procedure may not be needed depends on different business requirements.
164: PROCEDURE Delete_grp_camp(
165: P_Api_Version_Number IN NUMBER,
166: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
167: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169: P_identity_salesforce_id IN NUMBER := NULL,
170: P_grp_camp_Rec IN grp_camp_Rec_Type,
163: -- The Master delete procedure may not be needed depends on different business requirements.
164: PROCEDURE Delete_grp_camp(
165: P_Api_Version_Number IN NUMBER,
166: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
167: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169: P_identity_salesforce_id IN NUMBER := NULL,
170: P_grp_camp_Rec IN grp_camp_Rec_Type,
171: X_Return_Status OUT VARCHAR2,
164: PROCEDURE Delete_grp_camp(
165: P_Api_Version_Number IN NUMBER,
166: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
167: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169: P_identity_salesforce_id IN NUMBER := NULL,
170: P_grp_camp_Rec IN grp_camp_Rec_Type,
171: X_Return_Status OUT VARCHAR2,
172: X_Msg_Count OUT NUMBER,
181: -- Pre-Req :
182: -- Parameters:
183: -- IN
184: -- p_api_version_number IN NUMBER Required
185: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
186: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
187: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
188: -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
189: -- Hint: Add List of bind variables here
182: -- Parameters:
183: -- IN
184: -- p_api_version_number IN NUMBER Required
185: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
186: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
187: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
188: -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
189: -- Hint: Add List of bind variables here
190: -- p_rec_requested IN NUMBER Optional Default = 30
192: --
193: -- Return Total Records Count Flag. This flag controls whether the total record count
194: -- and total record amount is returned.
195: --
196: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
197: -- Hint: User defined record type
198: -- p_order_by_tbl IN JTF_PLSQL_API.UTIL_ORDER_BY_TBL_TYPE;
199: --
200: -- OUT:
214: -- End of Comments
215: --
216: PROCEDURE Get_grp_camp(
217: P_Api_Version_Number IN NUMBER,
218: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: P_identity_salesforce_id IN NUMBER := NULL,
221: P_grp_camp_Rec IN ast_grp_camp_PUB.grp_camp_Rec_Type,
222: -- Hint: Add list of bind variables here
215: --
216: PROCEDURE Get_grp_camp(
217: P_Api_Version_Number IN NUMBER,
218: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
219: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: P_identity_salesforce_id IN NUMBER := NULL,
221: P_grp_camp_Rec IN ast_grp_camp_PUB.grp_camp_Rec_Type,
222: -- Hint: Add list of bind variables here
223: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
221: P_grp_camp_Rec IN ast_grp_camp_PUB.grp_camp_Rec_Type,
222: -- Hint: Add list of bind variables here
223: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
224: p_start_rec_prt IN NUMBER := 1,
225: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
226: -- Hint: user defined record type
227: p_order_by_rec IN ast_grp_camp_PUB.grp_camp_sort_rec_type,
228: x_return_status OUT VARCHAR2,
229: x_msg_count OUT NUMBER,
248: --
249: -- End of Comments
250:
251: PROCEDURE Validate_GROUP_CAMPAIGN_ID (
252: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
253: P_Validation_mode IN VARCHAR2,
254: P_GROUP_CAMPAIGN_ID IN NUMBER,
255: -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
256:
270: --
271: -- End of Comments
272:
273: PROCEDURE Validate_GROUP_ID (
274: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
275: P_Validation_mode IN VARCHAR2,
276: P_GROUP_ID IN NUMBER,
277: -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
278:
292: --
293: -- End of Comments
294:
295: PROCEDURE Validate_CAMPAIGN_ID (
296: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
297: P_Validation_mode IN VARCHAR2,
298: P_CAMPAIGN_ID IN NUMBER,
299: -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
300:
314: --
315: -- End of Comments
316:
317: PROCEDURE Validate_START_DATE (
318: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
319: P_Validation_mode IN VARCHAR2,
320: P_START_DATE IN DATE,
321: -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
322:
336: --
337: -- End of Comments
338:
339: PROCEDURE Validate_END_DATE (
340: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
341: P_Validation_mode IN VARCHAR2,
342: P_END_DATE IN DATE,
343: -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
344:
358: --
359: -- End of Comments
360:
361: PROCEDURE Validate_ENABLED_FLAG (
362: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
363: P_Validation_mode IN VARCHAR2,
364: P_ENABLED_FLAG IN VARCHAR2,
365: -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
366:
380: -- 2. Developer can manually added inter-field level validation.
381: -- End of Comments
382:
383: PROCEDURE Validate_grp_camp_rec(
384: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
385: P_Validation_mode IN VARCHAR2,
386: P_grp_camp_Rec IN grp_camp_Rec_Type,
387: X_Return_Status OUT VARCHAR2,
388: X_Msg_Count OUT NUMBER,
400: -- 2. We can also validate table instead of record. There will be an option for user to choose.
401: -- End of Comments
402:
403: PROCEDURE Validate_grp_camp(
404: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
405: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
406: P_Validation_mode IN VARCHAR2,
407: P_grp_camp_Rec IN grp_camp_Rec_Type,
408: X_Return_Status OUT VARCHAR2,
401: -- End of Comments
402:
403: PROCEDURE Validate_grp_camp(
404: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
405: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
406: P_Validation_mode IN VARCHAR2,
407: P_grp_camp_Rec IN grp_camp_Rec_Type,
408: X_Return_Status OUT VARCHAR2,
409: X_Msg_Count OUT NUMBER,