DBA Data[Home] [Help]

APPS.IBE_QUOTE_SAVESHARE_V2_PVT dependencies on HZ_CONTACT_POINT_V2PUB

Line 1432: l_contact_points_rec hz_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

1428: l_created_by_module VARCHAR2(30) := 'SHARED CARTS';
1429:
1430: l_test number;
1431:
1432: l_contact_points_rec hz_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
1433:
1434: l_email_rec hz_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE
1435: := hz_CONTACT_POINT_V2PUB.g_miss_EMAIL_REC;
1436: l_web_rec hz_CONTACT_POINT_V2PUB.web_REC_TYPE

Line 1434: l_email_rec hz_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE

1430: l_test number;
1431:
1432: l_contact_points_rec hz_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
1433:
1434: l_email_rec hz_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE
1435: := hz_CONTACT_POINT_V2PUB.g_miss_EMAIL_REC;
1436: l_web_rec hz_CONTACT_POINT_V2PUB.web_REC_TYPE
1437: := hz_CONTACT_POINT_V2PUB.g_miss_web_REC;
1438:

Line 1435: := hz_CONTACT_POINT_V2PUB.g_miss_EMAIL_REC;

1431:
1432: l_contact_points_rec hz_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
1433:
1434: l_email_rec hz_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE
1435: := hz_CONTACT_POINT_V2PUB.g_miss_EMAIL_REC;
1436: l_web_rec hz_CONTACT_POINT_V2PUB.web_REC_TYPE
1437: := hz_CONTACT_POINT_V2PUB.g_miss_web_REC;
1438:
1439: Cursor c_getContactInfo(c_owner_table_id Number

Line 1436: l_web_rec hz_CONTACT_POINT_V2PUB.web_REC_TYPE

1432: l_contact_points_rec hz_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
1433:
1434: l_email_rec hz_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE
1435: := hz_CONTACT_POINT_V2PUB.g_miss_EMAIL_REC;
1436: l_web_rec hz_CONTACT_POINT_V2PUB.web_REC_TYPE
1437: := hz_CONTACT_POINT_V2PUB.g_miss_web_REC;
1438:
1439: Cursor c_getContactInfo(c_owner_table_id Number
1440: ,c_contact_point_type varchar2

Line 1437: := hz_CONTACT_POINT_V2PUB.g_miss_web_REC;

1433:
1434: l_email_rec hz_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE
1435: := hz_CONTACT_POINT_V2PUB.g_miss_EMAIL_REC;
1436: l_web_rec hz_CONTACT_POINT_V2PUB.web_REC_TYPE
1437: := hz_CONTACT_POINT_V2PUB.g_miss_web_REC;
1438:
1439: Cursor c_getContactInfo(c_owner_table_id Number
1440: ,c_contact_point_type varchar2
1441: ,c_owner_table_name varchar2) IS

Line 1511: hz_contact_point_v2pub.create_contact_point

1507: || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
1508: END IF;
1509:
1510: --DBMS_OUTPUT.PUT_LINE('Create contact point ');
1511: hz_contact_point_v2pub.create_contact_point
1512: ( p_init_msg_list => FND_API.G_FALSE
1513: ,p_contact_point_rec => l_contact_points_rec
1514: ,p_web_rec => l_web_rec
1515: ,p_email_rec => l_email_rec

Line 1545: hz_contact_point_v2pub.update_contact_point(

1541: IBE_UTIL.DEBUG('call hz_conteact_point_pub.update_contact_points at'
1542: || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
1543: END IF;
1544:
1545: hz_contact_point_v2pub.update_contact_point(
1546: p_init_msg_list => FND_API.G_FALSE
1547: ,p_contact_point_rec => l_contact_points_rec
1548: ,p_web_rec => l_web_rec
1549: ,p_email_rec => l_email_rec

Line 2688: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

2684: l_api_version CONSTANT NUMBER := 1.0;
2685: l_url VARCHAR2(2000);
2686: l_owner_partyid NUMBER;
2687: l_owner_accountid NUMBER;
2688: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
2689: l_party_id NUMBER;
2690: l_contact_point_id NUMBER;
2691: l_object_version_number NUMBER;
2692:

Line 2783: HZ_CONTACT_POINT_V2PUB.update_contact_point(

2779: if(l_party_id is NULL) THEN
2780: l_contact_point_rec.contact_point_id := l_contact_point_id;
2781: l_contact_point_rec.status := 'I';
2782: l_contact_point_rec.primary_flag := 'N';
2783: HZ_CONTACT_POINT_V2PUB.update_contact_point(
2784: p_init_msg_list => FND_API.G_FALSE,
2785: p_contact_point_rec => l_contact_point_rec,
2786: p_object_version_number => l_object_version_number,
2787: x_return_status => x_return_status,