66: invite_end_date DATE,
67: order_header_id NUMBER,
68: invited_by_partner_id NUMBER,
69: trxn_extension_id NUMBER,
70: EMAIL_CONTENT VARCHAR2(4000):= FND_API.G_MISS_CHAR
71: );
72:
73: g_miss_invite_headers_rec invite_headers_rec_type := NULL;
74: TYPE invite_headers_tbl_type IS TABLE OF invite_headers_rec_type INDEX BY BINARY_INTEGER;
86: -- Parameters
87: --
88: -- IN
89: -- p_api_version_number IN NUMBER Required
90: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
91: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
93: -- p_invite_headers_rec IN invite_headers_rec_type Required
94: --
87: --
88: -- IN
89: -- p_api_version_number IN NUMBER Required
90: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
91: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
93: -- p_invite_headers_rec IN invite_headers_rec_type Required
94: --
95: -- OUT
88: -- IN
89: -- p_api_version_number IN NUMBER Required
90: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
91: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
93: -- p_invite_headers_rec IN invite_headers_rec_type Required
94: --
95: -- OUT
96: -- x_return_status OUT VARCHAR2
108: -- ==============================================================================
109:
110: PROCEDURE Create_Invite_Headers(
111: p_api_version_number IN NUMBER,
112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113: p_commit IN VARCHAR2 := FND_API.G_FALSE,
114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115:
116: x_return_status OUT NOCOPY VARCHAR2,
109:
110: PROCEDURE Create_Invite_Headers(
111: p_api_version_number IN NUMBER,
112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113: p_commit IN VARCHAR2 := FND_API.G_FALSE,
114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115:
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
110: PROCEDURE Create_Invite_Headers(
111: p_api_version_number IN NUMBER,
112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113: p_commit IN VARCHAR2 := FND_API.G_FALSE,
114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115:
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
133: -- Parameters
134: --
135: -- IN
136: -- p_api_version_number IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
138: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_invite_headers_rec IN invite_headers_rec_type Required
141: --
134: --
135: -- IN
136: -- p_api_version_number IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
138: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_invite_headers_rec IN invite_headers_rec_type Required
141: --
142: -- OUT
135: -- IN
136: -- p_api_version_number IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
138: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_invite_headers_rec IN invite_headers_rec_type Required
141: --
142: -- OUT
143: -- x_return_status OUT VARCHAR2
155: -- ==============================================================================
156:
157: PROCEDURE Update_Invite_Headers(
158: p_api_version_number IN NUMBER,
159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
160: p_commit IN VARCHAR2 := FND_API.G_FALSE,
161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
162:
163: x_return_status OUT NOCOPY VARCHAR2,
156:
157: PROCEDURE Update_Invite_Headers(
158: p_api_version_number IN NUMBER,
159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
160: p_commit IN VARCHAR2 := FND_API.G_FALSE,
161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
162:
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
157: PROCEDURE Update_Invite_Headers(
158: p_api_version_number IN NUMBER,
159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
160: p_commit IN VARCHAR2 := FND_API.G_FALSE,
161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
162:
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
179: -- Parameters
180: --
181: -- IN
182: -- p_api_version_number IN NUMBER Required
183: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
184: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
185: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
186: -- p_INVITE_HEADER_ID IN NUMBER
187: -- p_object_version_number IN NUMBER Optional Default = NULL
180: --
181: -- IN
182: -- p_api_version_number IN NUMBER Required
183: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
184: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
185: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
186: -- p_INVITE_HEADER_ID IN NUMBER
187: -- p_object_version_number IN NUMBER Optional Default = NULL
188: --
181: -- IN
182: -- p_api_version_number IN NUMBER Required
183: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
184: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
185: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
186: -- p_INVITE_HEADER_ID IN NUMBER
187: -- p_object_version_number IN NUMBER Optional Default = NULL
188: --
189: -- OUT
202: -- ==============================================================================
203:
204: PROCEDURE Delete_Invite_Headers(
205: p_api_version_number IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207: p_commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
203:
204: PROCEDURE Delete_Invite_Headers(
205: p_api_version_number IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207: p_commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
204: PROCEDURE Delete_Invite_Headers(
205: p_api_version_number IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207: p_commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_INVITE_HEADER_ID IN NUMBER,
225: -- Parameters
226: --
227: -- IN
228: -- p_api_version_number IN NUMBER Required
229: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
230: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
232: -- p_invite_headers_rec IN invite_headers_rec_type Required
233: --
226: --
227: -- IN
228: -- p_api_version_number IN NUMBER Required
229: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
230: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
232: -- p_invite_headers_rec IN invite_headers_rec_type Required
233: --
234: -- OUT
227: -- IN
228: -- p_api_version_number IN NUMBER Required
229: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
230: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
232: -- p_invite_headers_rec IN invite_headers_rec_type Required
233: --
234: -- OUT
235: -- x_return_status OUT VARCHAR2
247: -- ==============================================================================
248:
249: PROCEDURE Lock_Invite_Headers(
250: p_api_version_number IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252:
253: x_return_status OUT NOCOPY VARCHAR2,
254: x_msg_count OUT NOCOPY NUMBER,
255: x_msg_data OUT NOCOPY VARCHAR2,
281:
282:
283: PROCEDURE Validate_Invite_Headers(
284: p_api_version_number IN NUMBER,
285: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
286: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
287: p_invite_headers_rec IN invite_headers_rec_type,
288: p_validation_mode IN VARCHAR2,
289: x_return_status OUT NOCOPY VARCHAR2,
282:
283: PROCEDURE Validate_Invite_Headers(
284: p_api_version_number IN NUMBER,
285: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
286: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
287: p_invite_headers_rec IN invite_headers_rec_type,
288: p_validation_mode IN VARCHAR2,
289: x_return_status OUT NOCOPY VARCHAR2,
290: x_msg_count OUT NOCOPY NUMBER,
340:
341:
342: PROCEDURE Validate_Invite_Headers_Rec (
343: p_api_version_number IN NUMBER,
344: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
345: x_return_status OUT NOCOPY VARCHAR2,
346: x_msg_count OUT NOCOPY NUMBER,
347: x_msg_data OUT NOCOPY VARCHAR2,
348: p_invite_headers_rec IN invite_headers_rec_type