DBA Data[Home] [Help]

APPS.ARI_SELF_REGISTRATION_PKG dependencies on HZ_CONTACT_POINT_V2PUB

Line 1457: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

1453:
1454: l_profile_id number;
1455: l_cust_site_use_id NUMBER;
1456:
1457: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
1458: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
1459: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1460: l_procedure_name VARCHAR2(50) := '.CreateContactPointInternal';
1461: l_debug_info VARCHAR2(300);

Line 1458: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;

1454: l_profile_id number;
1455: l_cust_site_use_id NUMBER;
1456:
1457: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
1458: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
1459: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1460: l_procedure_name VARCHAR2(50) := '.CreateContactPointInternal';
1461: l_debug_info VARCHAR2(300);
1462:

Line 1459: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;

1455: l_cust_site_use_id NUMBER;
1456:
1457: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
1458: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
1459: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
1460: l_procedure_name VARCHAR2(50) := '.CreateContactPointInternal';
1461: l_debug_info VARCHAR2(300);
1462:
1463: X_Return_Status VARCHAR2(20);

Line 1540: HZ_CONTACT_POINT_V2PUB.create_contact_point (

1536: IF (PG_DEBUG = 'Y') THEN
1537: arp_standard.debug(l_debug_info);
1538: END IF;
1539:
1540: HZ_CONTACT_POINT_V2PUB.create_contact_point (
1541: p_contact_point_rec => l_contact_point_rec,
1542: p_email_rec => l_email_rec,
1543: x_contact_point_id => l_contact_point_id,
1544: x_return_status => X_Return_Status,

Line 1562: HZ_CONTACT_POINT_V2PUB.update_contact_point (

1558: FROM HZ_CONTACT_POINTS
1559: WHERE contact_point_id = l_contact_point_id;
1560:
1561:
1562: HZ_CONTACT_POINT_V2PUB.update_contact_point (
1563: p_contact_point_rec => l_contact_point_rec,
1564: p_email_rec => l_email_rec,
1565: p_object_version_number => l_object_version_number,
1566: x_return_status => X_Return_Status,

Line 1637: HZ_CONTACT_POINT_V2PUB.create_contact_point (

1633: IF (PG_DEBUG = 'Y') THEN
1634: arp_standard.debug(l_debug_info);
1635: END IF;
1636:
1637: HZ_CONTACT_POINT_V2PUB.create_contact_point (
1638: p_contact_point_rec => l_contact_point_rec,
1639: p_phone_rec => l_phone_rec,
1640: x_contact_point_id => l_contact_point_id,
1641: x_return_status => X_Return_Status,

Line 1658: HZ_CONTACT_POINT_V2PUB.update_contact_point (

1654: INTO l_object_version_number
1655: FROM HZ_CONTACT_POINTS
1656: WHERE contact_point_id = l_contact_point_id;
1657:
1658: HZ_CONTACT_POINT_V2PUB.update_contact_point (
1659: p_contact_point_rec => l_contact_point_rec,
1660: p_phone_rec => l_phone_rec,
1661: p_object_version_number => l_object_version_number,
1662: x_return_status => X_Return_Status,