APPS.EGO_PARTY_PUB dependencies on HZ_CONTACT_POINTS

Line 935: l_status hz_contact_points.status%TYPE;

931: l_contact_point_id NUMBER;
932: l_email_address VARCHAR2(2000);
933: l_object_version_no_contact NUMBER;
934:
935: l_status hz_contact_points.status%TYPE;
936: l_email_format hz_contact_points.email_format%TYPE;
937:
938: -- To store last Modified Date
939: l_Sysdate DATE := Sysdate;

Line 936: l_email_format hz_contact_points.email_format%TYPE;

932: l_email_address VARCHAR2(2000);
933: l_object_version_no_contact NUMBER;
934:
935: l_status hz_contact_points.status%TYPE;
936: l_email_format hz_contact_points.email_format%TYPE;
937:
938: -- To store last Modified Date
939: l_Sysdate DATE := Sysdate;
940: l_last_update_date DATE;

Line 972: FROM hz_contact_points

968: AND SYSDATE between start_date and NVL(end_date,SYSDATE);
969:
970: CURSOR c_get_contact_details (cp_group_id IN NUMBER) IS
971: SELECT contact_point_id, object_version_number, email_address, status, email_format
972: FROM hz_contact_points
973: WHERE owner_table_id = cp_group_id
974: AND owner_table_name = 'HZ_PARTIES'
975: AND status = 'A';
976:

Line 1055: -- do not create any records into HZ_CONTACT_POINTS

1051:
1052: IF l_email_address IS NULL THEN
1053: -- no record created earlier
1054: IF p_email_address IS NULL THEN
1055: -- do not create any records into HZ_CONTACT_POINTS
1056: mdebug('UPDATE_GROUP: No need to create Contact Point during update of Group');
1057: ELSE
1058: -- contact point required. Need to create one.
1059: l_contact_point_rec.contact_point_type := 'EMAIL';

Line 1383: FROM hz_contact_points

1379: -- AND SYSDATE between start_date and NVL(end_date,SYSDATE);
1380:
1381: CURSOR c_get_contact_point (cp_group_id IN NUMBER) IS
1382: SELECT contact_point_id, object_version_number
1383: FROM hz_contact_points
1384: WHERE owner_table_id = cp_group_id
1385: AND owner_table_name = 'HZ_PARTIES'
1386: AND status = 'A';
1387: