54: -- 2. If activity_partner_id is passed in, the uniqueness will be checked.
55: -- Raise exception in case of duplicates.
56: -- 3. If activity_partner_id is not passed in, generate a unique one from
57: -- the sequence.
58: -- 4. Please don't pass in any FND_API.g_mess_char/num/date.
59: ---------------------------------------------------------------------
60:
61: PROCEDURE create_act_partner
62: (
60:
61: PROCEDURE create_act_partner
62: (
63: 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: x_return_status OUT NOCOPY VARCHAR2,
61: PROCEDURE create_act_partner
62: (
63: 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: x_return_status OUT NOCOPY VARCHAR2,
69: x_msg_count OUT NOCOPY NUMBER,
62: (
63: 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: x_return_status OUT NOCOPY VARCHAR2,
69: x_msg_count OUT NOCOPY NUMBER,
70: x_msg_data OUT NOCOPY VARCHAR2,
84: -- p_act_partner_rec: the record with new items
85: --
86: -- NOTES
87: -- 1. Raise exception if the object_version_number doesn't match.
88: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
89: -- that column won't be updated.
90: ----------------------------------------------------------------------
91:
92: PROCEDURE update_act_partner
91:
92: PROCEDURE update_act_partner
93: (
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
96: p_commit IN VARCHAR2 := FND_API.g_false,
97: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
98: --p_object_version_number IN NUMBER,
99:
92: PROCEDURE update_act_partner
93: (
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
96: p_commit IN VARCHAR2 := FND_API.g_false,
97: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
98: --p_object_version_number IN NUMBER,
99:
100: x_return_status OUT NOCOPY VARCHAR2,
93: (
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
96: p_commit IN VARCHAR2 := FND_API.g_false,
97: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
98: --p_object_version_number IN NUMBER,
99:
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
122:
123: PROCEDURE delete_act_partner
124: (
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
127: p_commit IN VARCHAR2 := FND_API.g_false,
128:
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
123: PROCEDURE delete_act_partner
124: (
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
127: p_commit IN VARCHAR2 := FND_API.g_false,
128:
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
151:
152: PROCEDURE lock_act_partner
153: (
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
156:
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
173: -- p_act_partner_rec: the activity partner record to be validated
174: --
175: -- NOTES
176: -- 1. p_act_partner_rec should be the complete activity partner record.
177: -- There should not be any FND_API.g_miss_char/num/date in it.
178: ----------------------------------------------------------------------
179:
180: PROCEDURE validate_act_partner
181: (
179:
180: PROCEDURE validate_act_partner
181: (
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
184: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
185:
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
180: PROCEDURE validate_act_partner
181: (
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
184: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
185:
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
223: -- PROCEDURE
224: -- init_act_partner_rec
225: --
226: -- PURPOSE
227: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
228: ---------------------------------------------------------------------
229: PROCEDURE init_act_partner_rec(
230: x_act_partner_rec OUT NOCOPY act_partner_rec_type
231: );
235: -- complete_act_partner_rec
236: --
237: -- PURPOSE
238: -- For update_act_partner, some attributes may be passed in as
239: -- FND_API.g_miss_char/num/date if the user doesn't want to
240: -- update those attributes. This procedure will replace the
241: -- "g_miss" attributes with current database values.
242: --
243: -- PARAMETERS
241: -- "g_miss" attributes with current database values.
242: --
243: -- PARAMETERS
244: -- p_act_partner_rec: the record which may contain attributes as
245: -- FND_API.g_miss_char/num/date
246: -- x_complete_rec: the complete record after all "g_miss" items
247: -- have been replaced by current database values
248: ---------------------------------------------------------------------
249: PROCEDURE complete_act_partner_rec