DBA Data[Home] [Help]

APPS.PV_PG_INVITE_HEADERS_PVT dependencies on FND_API

Line 70: EMAIL_CONTENT VARCHAR2(4000):= FND_API.G_MISS_CHAR

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;

Line 90: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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: --

Line 91: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 92: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 113: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 137: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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: --

Line 138: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 160: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 183: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 184: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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: --

Line 185: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 207: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 229: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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: --

Line 230: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 231: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 285: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 286: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 344: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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