1385: | DESCRIPTION |
1386: | Validate a party site given the name of the validation procedure |
1387: | |
1388: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1389: | hz_contact_point_v2pub.contact_point_rec_type |
1390: | MODIFICATION HISTORY |
1391: | 11-13-2001 J. del Callar Created. |
1392: +=======================================================================*/
1393:
1391: | 11-13-2001 J. del Callar Created. |
1392: +=======================================================================*/
1393:
1394: PROCEDURE validate_contact_point (
1395: x_contact_point IN hz_contact_point_v2pub.contact_point_rec_type,
1396: x_edi_contact IN hz_contact_point_v2pub.edi_rec_type,
1397: x_eft_contact IN hz_contact_point_v2pub.eft_rec_type,
1398: x_email_contact IN hz_contact_point_v2pub.email_rec_type,
1399: x_phone_contact IN hz_contact_point_v2pub.phone_rec_type,
1392: +=======================================================================*/
1393:
1394: PROCEDURE validate_contact_point (
1395: x_contact_point IN hz_contact_point_v2pub.contact_point_rec_type,
1396: x_edi_contact IN hz_contact_point_v2pub.edi_rec_type,
1397: x_eft_contact IN hz_contact_point_v2pub.eft_rec_type,
1398: x_email_contact IN hz_contact_point_v2pub.email_rec_type,
1399: x_phone_contact IN hz_contact_point_v2pub.phone_rec_type,
1400: x_telex_contact IN hz_contact_point_v2pub.telex_rec_type,
1393:
1394: PROCEDURE validate_contact_point (
1395: x_contact_point IN hz_contact_point_v2pub.contact_point_rec_type,
1396: x_edi_contact IN hz_contact_point_v2pub.edi_rec_type,
1397: x_eft_contact IN hz_contact_point_v2pub.eft_rec_type,
1398: x_email_contact IN hz_contact_point_v2pub.email_rec_type,
1399: x_phone_contact IN hz_contact_point_v2pub.phone_rec_type,
1400: x_telex_contact IN hz_contact_point_v2pub.telex_rec_type,
1401: x_web_contact IN hz_contact_point_v2pub.web_rec_type,
1394: PROCEDURE validate_contact_point (
1395: x_contact_point IN hz_contact_point_v2pub.contact_point_rec_type,
1396: x_edi_contact IN hz_contact_point_v2pub.edi_rec_type,
1397: x_eft_contact IN hz_contact_point_v2pub.eft_rec_type,
1398: x_email_contact IN hz_contact_point_v2pub.email_rec_type,
1399: x_phone_contact IN hz_contact_point_v2pub.phone_rec_type,
1400: x_telex_contact IN hz_contact_point_v2pub.telex_rec_type,
1401: x_web_contact IN hz_contact_point_v2pub.web_rec_type,
1402: x_validation_profile IN VARCHAR2,
1395: x_contact_point IN hz_contact_point_v2pub.contact_point_rec_type,
1396: x_edi_contact IN hz_contact_point_v2pub.edi_rec_type,
1397: x_eft_contact IN hz_contact_point_v2pub.eft_rec_type,
1398: x_email_contact IN hz_contact_point_v2pub.email_rec_type,
1399: x_phone_contact IN hz_contact_point_v2pub.phone_rec_type,
1400: x_telex_contact IN hz_contact_point_v2pub.telex_rec_type,
1401: x_web_contact IN hz_contact_point_v2pub.web_rec_type,
1402: x_validation_profile IN VARCHAR2,
1403: x_temp_id IN NUMBER DEFAULT NULL
1396: x_edi_contact IN hz_contact_point_v2pub.edi_rec_type,
1397: x_eft_contact IN hz_contact_point_v2pub.eft_rec_type,
1398: x_email_contact IN hz_contact_point_v2pub.email_rec_type,
1399: x_phone_contact IN hz_contact_point_v2pub.phone_rec_type,
1400: x_telex_contact IN hz_contact_point_v2pub.telex_rec_type,
1401: x_web_contact IN hz_contact_point_v2pub.web_rec_type,
1402: x_validation_profile IN VARCHAR2,
1403: x_temp_id IN NUMBER DEFAULT NULL
1404: ) IS
1397: x_eft_contact IN hz_contact_point_v2pub.eft_rec_type,
1398: x_email_contact IN hz_contact_point_v2pub.email_rec_type,
1399: x_phone_contact IN hz_contact_point_v2pub.phone_rec_type,
1400: x_telex_contact IN hz_contact_point_v2pub.telex_rec_type,
1401: x_web_contact IN hz_contact_point_v2pub.web_rec_type,
1402: x_validation_profile IN VARCHAR2,
1403: x_temp_id IN NUMBER DEFAULT NULL
1404: ) IS
1405: CURSOR psidcur IS