eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_VENUE_PVT dependencies on FND_API

Line 120: -- 6. Please don't pass in any FND_API.g_miss_char/num/date.

116: -- Raise exception in case of duplicates.
117: -- 3. If a flag column is passed in, check if it is 'Y' or 'N'
118: -- Raise exception for invalid flag.
119: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'
120: -- 6. Please don't pass in any FND_API.g_miss_char/num/date.
121: --------------------------------------------------------------------
122: PROCEDURE Create_Venue (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 124: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

120: -- 6. Please don't pass in any FND_API.g_miss_char/num/date.
121: --------------------------------------------------------------------
122: PROCEDURE Create_Venue (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
125: p_commit IN VARCHAR2 := FND_API.g_false,
126: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
127:
128: x_return_status OUT NOCOPY VARCHAR2,

Line 125: p_commit IN VARCHAR2 := FND_API.g_false,

121: --------------------------------------------------------------------
122: PROCEDURE Create_Venue (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
125: p_commit IN VARCHAR2 := FND_API.g_false,
126: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
127:
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,

Line 126: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

122: PROCEDURE Create_Venue (
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
125: p_commit IN VARCHAR2 := FND_API.g_false,
126: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
127:
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,

Line 154: -- 5. Please don't pass in any FND_API.g_miss_char/num/date.

150: -- Raise exception in case of duplicates.
151: -- 3. If a flag column is passed in, check if it is 'Y' or 'N'
152: -- Raise exception for invalid flag.
153: -- 4. If a flag column is not passed in, default it to 'Y' or 'N'
154: -- 5. Please don't pass in any FND_API.g_miss_char/num/date.
155: --------------------------------------------------------------------
156: PROCEDURE Create_Room (
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 158: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

154: -- 5. Please don't pass in any FND_API.g_miss_char/num/date.
155: --------------------------------------------------------------------
156: PROCEDURE Create_Room (
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
159: p_commit IN VARCHAR2 := FND_API.g_false,
160: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
161:
162: x_return_status OUT NOCOPY VARCHAR2,

Line 159: p_commit IN VARCHAR2 := FND_API.g_false,

155: --------------------------------------------------------------------
156: PROCEDURE Create_Room (
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
159: p_commit IN VARCHAR2 := FND_API.g_false,
160: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
161:
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,

Line 160: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

156: PROCEDURE Create_Room (
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
159: p_commit IN VARCHAR2 := FND_API.g_false,
160: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
161:
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,

Line 183: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,

179: -- p_venue_rec: the record representing AMS_VENUE_VL (without the ROW_ID column).
180: --
181: -- NOTES
182: -- 1. Raise exception if the object_version_number doesn't match.
183: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
184: -- that column won't be updated.
185: --------------------------------------------------------------------
186: PROCEDURE Update_Venue (
187: p_api_version IN NUMBER,

Line 188: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

184: -- that column won't be updated.
185: --------------------------------------------------------------------
186: PROCEDURE Update_Venue (
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
189: p_commit IN VARCHAR2 := FND_API.g_false,
190: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
191:
192: x_return_status OUT NOCOPY VARCHAR2,

Line 189: p_commit IN VARCHAR2 := FND_API.g_false,

185: --------------------------------------------------------------------
186: PROCEDURE Update_Venue (
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
189: p_commit IN VARCHAR2 := FND_API.g_false,
190: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
191:
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,

Line 190: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

186: PROCEDURE Update_Venue (
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
189: p_commit IN VARCHAR2 := FND_API.g_false,
190: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
191:
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,

Line 211: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,

207: -- p_venue_rec: the record representing AMS_VENUE_VL (without the ROW_ID column).
208: --
209: -- NOTES
210: -- 1. Raise exception if the object_version_number doesn't match.
211: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
212: -- that column won't be updated.
213: --------------------------------------------------------------------
214: PROCEDURE Update_Room (
215: p_api_version IN NUMBER,

Line 216: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

212: -- that column won't be updated.
213: --------------------------------------------------------------------
214: PROCEDURE Update_Room (
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
217: p_commit IN VARCHAR2 := FND_API.g_false,
218: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
219:
220: x_return_status OUT NOCOPY VARCHAR2,

Line 217: p_commit IN VARCHAR2 := FND_API.g_false,

213: --------------------------------------------------------------------
214: PROCEDURE Update_Room (
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
217: p_commit IN VARCHAR2 := FND_API.g_false,
218: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
219:
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,

Line 218: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

214: PROCEDURE Update_Room (
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
217: p_commit IN VARCHAR2 := FND_API.g_false,
218: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
219:
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,

Line 246: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

242: -- 1. Raise exception if the object_version_number doesn't match.
243: --------------------------------------------------------------------
244: PROCEDURE Delete_Venue (
245: p_api_version IN NUMBER,
246: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
247: p_commit IN VARCHAR2 := FND_API.g_false,
248: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
249:
250: x_return_status OUT NOCOPY VARCHAR2,

Line 247: p_commit IN VARCHAR2 := FND_API.g_false,

243: --------------------------------------------------------------------
244: PROCEDURE Delete_Venue (
245: p_api_version IN NUMBER,
246: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
247: p_commit IN VARCHAR2 := FND_API.g_false,
248: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
249:
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,

Line 248: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

244: PROCEDURE Delete_Venue (
245: p_api_version IN NUMBER,
246: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
247: p_commit IN VARCHAR2 := FND_API.g_false,
248: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
249:
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2,

Line 276: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

272: -- 1. Raise exception if the object_version_number doesn't match.
273: --------------------------------------------------------------------
274: PROCEDURE Lock_venue (
275: p_api_version IN NUMBER,
276: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
277: p_commit IN VARCHAR2 := FND_API.g_false,
278: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
279:
280: x_return_status OUT NOCOPY VARCHAR2,

Line 277: p_commit IN VARCHAR2 := FND_API.g_false,

273: --------------------------------------------------------------------
274: PROCEDURE Lock_venue (
275: p_api_version IN NUMBER,
276: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
277: p_commit IN VARCHAR2 := FND_API.g_false,
278: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
279:
280: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,

Line 278: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

274: PROCEDURE Lock_venue (
275: p_api_version IN NUMBER,
276: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
277: p_commit IN VARCHAR2 := FND_API.g_false,
278: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
279:
280: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,
282: x_msg_data OUT NOCOPY VARCHAR2,

Line 300: -- should not be any FND_API.g_miss_char/num/date in it.

296: -- p_Venue_rec: the record representing AMS_Venue_VL (without ROW_ID).
297: --
298: -- NOTES
299: -- 1. p_Venue_rec should be the complete Venue record. There
300: -- should not be any FND_API.g_miss_char/num/date in it.
301: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
302: -- an exception, as those values are not handled.
303: --------------------------------------------------------------------
304: PROCEDURE Validate_Venue (

Line 301: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise

297: --
298: -- NOTES
299: -- 1. p_Venue_rec should be the complete Venue record. There
300: -- should not be any FND_API.g_miss_char/num/date in it.
301: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
302: -- an exception, as those values are not handled.
303: --------------------------------------------------------------------
304: PROCEDURE Validate_Venue (
305: p_api_version IN NUMBER,

Line 306: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

302: -- an exception, as those values are not handled.
303: --------------------------------------------------------------------
304: PROCEDURE Validate_Venue (
305: p_api_version IN NUMBER,
306: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
307: p_commit IN VARCHAR2 := FND_API.g_false,
308: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
309:
310: x_return_status OUT NOCOPY VARCHAR2,

Line 307: p_commit IN VARCHAR2 := FND_API.g_false,

303: --------------------------------------------------------------------
304: PROCEDURE Validate_Venue (
305: p_api_version IN NUMBER,
306: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
307: p_commit IN VARCHAR2 := FND_API.g_false,
308: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
309:
310: x_return_status OUT NOCOPY VARCHAR2,
311: x_msg_count OUT NOCOPY NUMBER,

Line 308: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

304: PROCEDURE Validate_Venue (
305: p_api_version IN NUMBER,
306: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
307: p_commit IN VARCHAR2 := FND_API.g_false,
308: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
309:
310: x_return_status OUT NOCOPY VARCHAR2,
311: x_msg_count OUT NOCOPY NUMBER,
312: x_msg_data OUT NOCOPY VARCHAR2,

Line 346: -- as FND_API.g_miss_char/num/date

342: -- Check the record level business rules.
343: --
344: -- PARAMETERS
345: -- p_Venue_rec: the record to be validated; may contain attributes
346: -- as FND_API.g_miss_char/num/date
347: -- p_complete_rec: the complete record after all "g_miss" items
348: -- have been replaced by current database values
349: ---------------------------------------------------------------------
350: PROCEDURE Check_Venue_Record (

Line 361: -- Initialize all attributes to be FND_API.g_miss_char/num/date.

357: -- PROCEDURE
358: -- Init_Venue_Rec
359: --
360: -- PURPOSE
361: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
362: ---------------------------------------------------------------------
363: PROCEDURE Init_Venue_Rec (
364: x_Venue_rec OUT NOCOPY Venue_Rec_Type
365: );

Line 373: -- FND_API.g_miss_char/num/date if the user doesn't want to

369: -- Complete_Venue_Rec
370: --
371: -- PURPOSE
372: -- For Update_Venue, some attributes may be passed in as
373: -- FND_API.g_miss_char/num/date if the user doesn't want to
374: -- update those attributes. This procedure will replace the
375: -- "g_miss" attributes with current database values.
376: --
377: -- PARAMETERS

Line 379: -- FND_API.g_miss_char/num/date

375: -- "g_miss" attributes with current database values.
376: --
377: -- PARAMETERS
378: -- p_Venue_rec: the record which may contain attributes as
379: -- FND_API.g_miss_char/num/date
380: -- x_complete_rec: the complete record after all "g_miss" items
381: -- have been replaced by current database values
382: ---------------------------------------------------------------------
383: PROCEDURE Complete_Venue_Rec (

Line 399: -- FND_API.g_miss_char/num/date

395: -- hz_location_pub.create_location
396: --
397: -- PARAMETERS
398: -- p_Venue_loc_rec: the record which may contain attributes as
399: -- FND_API.g_miss_char/num/date
400: -- HZ_PARTY_PUB.G_MISS_CONTENT_SOURCE_TYPE BugFix sikalyan TCAV2 Uptake
401: ---------------------------------------------------------------------
402: TYPE Location_Rec_Type IS RECORD
403: (

Line 404: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

400: -- HZ_PARTY_PUB.G_MISS_CONTENT_SOURCE_TYPE BugFix sikalyan TCAV2 Uptake
401: ---------------------------------------------------------------------
402: TYPE Location_Rec_Type IS RECORD
403: (
404: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
405: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
406: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
407: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
408: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 405: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

401: ---------------------------------------------------------------------
402: TYPE Location_Rec_Type IS RECORD
403: (
404: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
405: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
406: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
407: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
408: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
409: COUNTRY_CODE VARCHAR2(80) := FND_API.G_MISS_CHAR,

Line 406: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

402: TYPE Location_Rec_Type IS RECORD
403: (
404: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
405: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
406: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
407: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
408: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
409: COUNTRY_CODE VARCHAR2(80) := FND_API.G_MISS_CHAR,
410: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 407: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

403: (
404: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
405: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
406: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
407: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
408: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
409: COUNTRY_CODE VARCHAR2(80) := FND_API.G_MISS_CHAR,
410: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
411: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 408: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

404: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
405: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
406: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
407: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
408: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
409: COUNTRY_CODE VARCHAR2(80) := FND_API.G_MISS_CHAR,
410: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
411: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
412: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 409: COUNTRY_CODE VARCHAR2(80) := FND_API.G_MISS_CHAR,

405: ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
406: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
407: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
408: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
409: COUNTRY_CODE VARCHAR2(80) := FND_API.G_MISS_CHAR,
410: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
411: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
412: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
413: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 410: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,

406: ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
407: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
408: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
409: COUNTRY_CODE VARCHAR2(80) := FND_API.G_MISS_CHAR,
410: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
411: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
412: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
413: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
414: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 411: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,

407: ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
408: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
409: COUNTRY_CODE VARCHAR2(80) := FND_API.G_MISS_CHAR,
410: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
411: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
412: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
413: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
414: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
415: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 412: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,

408: ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
409: COUNTRY_CODE VARCHAR2(80) := FND_API.G_MISS_CHAR,
410: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
411: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
412: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
413: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
414: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
415: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
416: ORIG_SYSTEM_REFERENCE VARCHAR2(240):= FND_API.G_MISS_CHAR,

Line 413: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,

409: COUNTRY_CODE VARCHAR2(80) := FND_API.G_MISS_CHAR,
410: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
411: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
412: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
413: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
414: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
415: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
416: ORIG_SYSTEM_REFERENCE VARCHAR2(240):= FND_API.G_MISS_CHAR,
417: CONTENT_SOURCE_TYPE VARCHAR2(30):= HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE

Line 414: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,

410: COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
411: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
412: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
413: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
414: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
415: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
416: ORIG_SYSTEM_REFERENCE VARCHAR2(240):= FND_API.G_MISS_CHAR,
417: CONTENT_SOURCE_TYPE VARCHAR2(30):= HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE
418:

Line 415: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,

411: CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
412: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
413: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
414: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
415: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
416: ORIG_SYSTEM_REFERENCE VARCHAR2(240):= FND_API.G_MISS_CHAR,
417: CONTENT_SOURCE_TYPE VARCHAR2(30):= HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE
418:
419: );

Line 416: ORIG_SYSTEM_REFERENCE VARCHAR2(240):= FND_API.G_MISS_CHAR,

412: POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
413: STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
414: PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
415: COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
416: ORIG_SYSTEM_REFERENCE VARCHAR2(240):= FND_API.G_MISS_CHAR,
417: CONTENT_SOURCE_TYPE VARCHAR2(30):= HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE
418:
419: );
420: