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.HZ_CONTACT_POINT_V2PUB dependencies on HZ_CONTACT_POINTS

Line 244: -- hz_contact_points_pkg.insert_row

240: -- hz_registry_validate_v2pub.validate_web_contact_point
241: -- hz_registry_validate_v2pub.validate_phone_contact_point
242: -- hz_registry_validate_v2pub.validate_telex_contact_point
243: -- hz_registry_validate_v2pub.validate_email_contact_point
244: -- hz_contact_points_pkg.insert_row
245: -- hz_phone_number_pkg.transpose
246: --
247: -- ARGUMENTS
248: -- IN/OUT:

Line 298: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;

294: l_msg_data VARCHAR2(2000);
295:
296: l_formatted_phone_number VARCHAR2(100);
297: l_country_code hz_locations.country%TYPE;
298: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
299:
300: l_edi_rec edi_rec_type;
301: l_email_rec email_rec_type;
302: l_phone_rec phone_rec_type;

Line 336: FROM hz_contact_points

332: CURSOR c_cp (p_owner_table_name IN VARCHAR2,
333: p_owner_table_id IN NUMBER,
334: p_contact_point_type IN VARCHAR2) IS
335: SELECT 'Y'
336: FROM hz_contact_points
337: WHERE owner_table_name = p_owner_table_name
338: AND owner_table_id = p_owner_table_id
339: AND contact_point_type = p_contact_point_type
340: /* AND HZ_MIXNM_UTILITY.isDataSourceSelected (

Line 714: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Insert_Row (+)',

710:
711:
712: -- Debug info.
713: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
714: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Insert_Row (+)',
715: p_prefix=>l_debug_prefix,
716: p_msg_level=>fnd_log.level_procedure);
717: END IF;
718:

Line 720: hz_contact_points_pkg.insert_row (

716: p_msg_level=>fnd_log.level_procedure);
717: END IF;
718:
719: -- Call table-handler.
720: hz_contact_points_pkg.insert_row (
721: x_contact_point_id => p_contact_point_rec.contact_point_id,
722: x_contact_point_type => p_contact_point_rec.contact_point_type,
723: x_status => p_contact_point_rec.status,
724: x_owner_table_name => p_contact_point_rec.owner_table_name,

Line 869: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Insert_Row (-) ' ||

865: --End of Bug No: 3131865.
866:
867: -- Debug info.
868: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
869: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Insert_Row (-) ' ||
870: 'x_contact_point_id = ' ||p_contact_point_rec.contact_point_id,
871: p_prefix=>l_debug_prefix,
872: p_msg_level=>fnd_log.level_procedure);
873: END IF;

Line 880: l_orig_sys_reference_rec.owner_table_name := 'HZ_CONTACT_POINTS';

876: and p_contact_point_rec.orig_system <>fnd_api.g_miss_char
877: then
878: l_orig_sys_reference_rec.orig_system := p_contact_point_rec.orig_system;
879: l_orig_sys_reference_rec.orig_system_reference := p_contact_point_rec.orig_system_reference;
880: l_orig_sys_reference_rec.owner_table_name := 'HZ_CONTACT_POINTS';
881: l_orig_sys_reference_rec.owner_table_id := p_contact_point_rec.contact_point_id;
882: l_orig_sys_reference_rec.created_by_module := p_contact_point_rec.created_by_module;
883:
884: hz_orig_system_ref_pub.create_orig_system_reference(

Line 919: -- hz_contact_points_pkg.update_row

915: -- hz_registry_validate_v2pub.validate_web_contact_point
916: -- hz_registry_validate_v2pub.validate_phone_contact_point
917: -- hz_registry_validate_v2pub.validate_telex_contact_point
918: -- hz_registry_validate_v2pub.validate_email_contact_point
919: -- hz_contact_points_pkg.update_row
920: -- hz_phone_number_pkg.transpose
921: --
922: -- ARGUMENTS
923: -- IN/OUT:

Line 982: l_owner_table_name hz_contact_points.owner_table_name%TYPE;

978: l_msg_data VARCHAR2(2000);
979:
980: l_formatted_phone_number VARCHAR2(100);
981: l_country_code hz_locations.country%TYPE;
982: l_owner_table_name hz_contact_points.owner_table_name%TYPE;
983: l_owner_table_id NUMBER;
984: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=
985: p_contact_point_rec.contact_point_type;
986: l_primary_flag hz_contact_points.primary_flag%TYPE;

Line 984: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=

980: l_formatted_phone_number VARCHAR2(100);
981: l_country_code hz_locations.country%TYPE;
982: l_owner_table_name hz_contact_points.owner_table_name%TYPE;
983: l_owner_table_id NUMBER;
984: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=
985: p_contact_point_rec.contact_point_type;
986: l_primary_flag hz_contact_points.primary_flag%TYPE;
987: l_status hz_contact_points.status%TYPE;
988: l_phone_area_code hz_contact_points.phone_area_code%TYPE;

Line 986: l_primary_flag hz_contact_points.primary_flag%TYPE;

982: l_owner_table_name hz_contact_points.owner_table_name%TYPE;
983: l_owner_table_id NUMBER;
984: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=
985: p_contact_point_rec.contact_point_type;
986: l_primary_flag hz_contact_points.primary_flag%TYPE;
987: l_status hz_contact_points.status%TYPE;
988: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
989: l_phone_number hz_contact_points.phone_number%TYPE;
990: l_phone_country_code hz_contact_points.phone_country_code%TYPE;

Line 987: l_status hz_contact_points.status%TYPE;

983: l_owner_table_id NUMBER;
984: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=
985: p_contact_point_rec.contact_point_type;
986: l_primary_flag hz_contact_points.primary_flag%TYPE;
987: l_status hz_contact_points.status%TYPE;
988: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
989: l_phone_number hz_contact_points.phone_number%TYPE;
990: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
991: l_url hz_contact_points.url%TYPE;

Line 988: l_phone_area_code hz_contact_points.phone_area_code%TYPE;

984: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=
985: p_contact_point_rec.contact_point_type;
986: l_primary_flag hz_contact_points.primary_flag%TYPE;
987: l_status hz_contact_points.status%TYPE;
988: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
989: l_phone_number hz_contact_points.phone_number%TYPE;
990: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
991: l_url hz_contact_points.url%TYPE;
992: l_email_address hz_contact_points.email_address%TYPE;

Line 989: l_phone_number hz_contact_points.phone_number%TYPE;

985: p_contact_point_rec.contact_point_type;
986: l_primary_flag hz_contact_points.primary_flag%TYPE;
987: l_status hz_contact_points.status%TYPE;
988: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
989: l_phone_number hz_contact_points.phone_number%TYPE;
990: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
991: l_url hz_contact_points.url%TYPE;
992: l_email_address hz_contact_points.email_address%TYPE;
993: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;

Line 990: l_phone_country_code hz_contact_points.phone_country_code%TYPE;

986: l_primary_flag hz_contact_points.primary_flag%TYPE;
987: l_status hz_contact_points.status%TYPE;
988: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
989: l_phone_number hz_contact_points.phone_number%TYPE;
990: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
991: l_url hz_contact_points.url%TYPE;
992: l_email_address hz_contact_points.email_address%TYPE;
993: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;
994: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;

Line 991: l_url hz_contact_points.url%TYPE;

987: l_status hz_contact_points.status%TYPE;
988: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
989: l_phone_number hz_contact_points.phone_number%TYPE;
990: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
991: l_url hz_contact_points.url%TYPE;
992: l_email_address hz_contact_points.email_address%TYPE;
993: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;
994: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;
995: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;

Line 992: l_email_address hz_contact_points.email_address%TYPE;

988: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
989: l_phone_number hz_contact_points.phone_number%TYPE;
990: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
991: l_url hz_contact_points.url%TYPE;
992: l_email_address hz_contact_points.email_address%TYPE;
993: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;
994: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;
995: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
996:

Line 993: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;

989: l_phone_number hz_contact_points.phone_number%TYPE;
990: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
991: l_url hz_contact_points.url%TYPE;
992: l_email_address hz_contact_points.email_address%TYPE;
993: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;
994: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;
995: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
996:
997: --BugNo:1695595.Added local variables to hold denormalized column values----

Line 994: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;

990: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
991: l_url hz_contact_points.url%TYPE;
992: l_email_address hz_contact_points.email_address%TYPE;
993: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;
994: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;
995: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
996:
997: --BugNo:1695595.Added local variables to hold denormalized column values----
998: l_contact_point_id hz_contact_points.contact_point_id%TYPE;

Line 995: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;

991: l_url hz_contact_points.url%TYPE;
992: l_email_address hz_contact_points.email_address%TYPE;
993: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;
994: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;
995: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
996:
997: --BugNo:1695595.Added local variables to hold denormalized column values----
998: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
999: l_phone_line_type hz_contact_points.phone_line_type%TYPE;

Line 998: l_contact_point_id hz_contact_points.contact_point_id%TYPE;

994: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;
995: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
996:
997: --BugNo:1695595.Added local variables to hold denormalized column values----
998: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
999: l_phone_line_type hz_contact_points.phone_line_type%TYPE;
1000: l_phone_extension hz_contact_points.phone_extension%TYPE;
1001: -----------------------------------------------------------------
1002: l_edi_rec edi_rec_type;

Line 999: l_phone_line_type hz_contact_points.phone_line_type%TYPE;

995: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
996:
997: --BugNo:1695595.Added local variables to hold denormalized column values----
998: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
999: l_phone_line_type hz_contact_points.phone_line_type%TYPE;
1000: l_phone_extension hz_contact_points.phone_extension%TYPE;
1001: -----------------------------------------------------------------
1002: l_edi_rec edi_rec_type;
1003: l_eft_rec eft_rec_type;

Line 1000: l_phone_extension hz_contact_points.phone_extension%TYPE;

996:
997: --BugNo:1695595.Added local variables to hold denormalized column values----
998: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
999: l_phone_line_type hz_contact_points.phone_line_type%TYPE;
1000: l_phone_extension hz_contact_points.phone_extension%TYPE;
1001: -----------------------------------------------------------------
1002: l_edi_rec edi_rec_type;
1003: l_eft_rec eft_rec_type;
1004: l_email_rec email_rec_type;

Line 1010: db_actual_content_source hz_contact_points.actual_content_source%TYPE;

1006: l_telex_rec telex_rec_type;
1007: l_web_rec web_rec_type;
1008:
1009: -- Bug 2197181: added for mix-n-match project.
1010: db_actual_content_source hz_contact_points.actual_content_source%TYPE;
1011: -- Bug 4693719 : Added for local assignment
1012: l_acs hz_contact_points.actual_content_source%TYPE;
1013:
1014: -- Bug 2117973: defined the following cursors for PL/SQL coding standards

Line 1012: l_acs hz_contact_points.actual_content_source%TYPE;

1008:
1009: -- Bug 2197181: added for mix-n-match project.
1010: db_actual_content_source hz_contact_points.actual_content_source%TYPE;
1011: -- Bug 4693719 : Added for local assignment
1012: l_acs hz_contact_points.actual_content_source%TYPE;
1013:
1014: -- Bug 2117973: defined the following cursors for PL/SQL coding standards
1015: -- compliance.
1016: CURSOR c_country (p_owner_table_id IN NUMBER) IS

Line 1038: FROM hz_contact_points

1034: p_owner_table_id IN NUMBER,
1035: p_contact_point_type IN VARCHAR2
1036: ) IS
1037: SELECT 'Y'
1038: FROM hz_contact_points
1039: WHERE owner_table_name = p_owner_table_name
1040: AND owner_table_id = p_owner_table_id
1041: AND contact_point_type = p_contact_point_type
1042: AND contact_point_id <> p_contact_point_rec.contact_point_id

Line 1059: FROM hz_contact_points

1055: p_contact_point_id IN NUMBER
1056: ) IS
1057: SELECT rowid, url, email_address,contact_point_id,contact_point_purpose,
1058: phone_line_type,phone_area_code,phone_country_code,phone_number,phone_extension
1059: FROM hz_contact_points
1060: WHERE contact_point_id = (
1061: SELECT MIN(contact_point_id)
1062: FROM hz_contact_points
1063: WHERE owner_table_name = p_owner_table_name

Line 1062: FROM hz_contact_points

1058: phone_line_type,phone_area_code,phone_country_code,phone_number,phone_extension
1059: FROM hz_contact_points
1060: WHERE contact_point_id = (
1061: SELECT MIN(contact_point_id)
1062: FROM hz_contact_points
1063: WHERE owner_table_name = p_owner_table_name
1064: AND owner_table_id = p_owner_table_id
1065: AND contact_point_type = p_contact_point_type
1066: /* AND HZ_MIXNM_UTILITY.isDataSourceSelected (

Line 1099: FROM hz_contact_points

1095: l_contact_point_type,l_phone_line_type,
1096: l_phone_country_code, l_phone_area_code, l_phone_number,l_phone_extension,
1097: l_primary_flag, l_status, l_contact_point_purpose,
1098: l_url, l_email_address, l_primary_by_purpose, db_actual_content_source
1099: FROM hz_contact_points
1100: WHERE contact_point_id = p_contact_point_rec.contact_point_id
1101: FOR UPDATE NOWAIT;
1102:
1103: IF NOT ((p_object_version_number IS NULL AND

Line 1110: fnd_message.set_token('TABLE', 'hz_contact_points');

1106: l_object_version_number IS NOT NULL AND
1107: p_object_version_number = l_object_version_number))
1108: THEN
1109: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1110: fnd_message.set_token('TABLE', 'hz_contact_points');
1111: fnd_msg_pub.add;
1112: RAISE fnd_api.g_exc_error;
1113: END IF;
1114:

Line 1607: UPDATE hz_contact_points

1603: l_phone_extension
1604: );
1605: END IF;
1606: ELSE
1607: UPDATE hz_contact_points
1608: SET primary_flag = 'Y'
1609: WHERE rowid = l_contact_point_rowid;
1610:
1611: -- De-normalize primary contact point to HZ_PARTIES.

Line 1700: hz_utility_v2pub.debug(p_message=>'hz_contact_points_pkg.update_row (+) ',

1696: end if;
1697:
1698: -- Debug info.
1699: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1700: hz_utility_v2pub.debug(p_message=>'hz_contact_points_pkg.update_row (+) ',
1701: p_prefix=>l_debug_prefix,
1702: p_msg_level=>fnd_log.level_procedure);
1703: END IF;
1704:

Line 1712: hz_contact_points_pkg.update_row (

1708: ELSE
1709: l_acs := NULL;
1710: END IF;
1711: -- Call table-handler.
1712: hz_contact_points_pkg.update_row (
1713: x_rowid => l_rowid,
1714: x_contact_point_id => p_contact_point_rec.contact_point_id,
1715: x_contact_point_type => p_contact_point_rec.contact_point_type,
1716: x_status => p_contact_point_rec.status,

Line 1782: hz_utility_v2pub.debug(p_message=>'hz_contact_points_PKG.Update_Row (-) ',

1778: );
1779:
1780: -- Debug info.
1781: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1782: hz_utility_v2pub.debug(p_message=>'hz_contact_points_PKG.Update_Row (-) ',
1783: p_prefix=>l_debug_prefix,
1784: p_msg_level=>fnd_log.level_procedure);
1785: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',
1786: p_prefix=>l_debug_prefix,

Line 1829: FROM hz_contact_points CP

1825:
1826: --bug #5203798
1827: CURSOR c_contact_point IS
1828: SELECT contact_point_id
1829: FROM hz_contact_points CP
1830: WHERE CP.owner_table_name = p_owner_table_name
1831: AND CP.owner_table_id = p_owner_table_id
1832: AND CP.contact_point_type = p_contact_point_type
1833: AND CP.contact_point_id <> p_contact_point_id

Line 1864: UPDATE hz_contact_points

1860: ELSE
1861: l_contact_point_id := p_contact_point_id;
1862: END IF;
1863:
1864: UPDATE hz_contact_points
1865: SET primary_flag = 'N',
1866: --Bug number 2914238 .Updated the who columns.
1867: last_update_date = hz_utility_v2pub.last_update_date,
1868: last_updated_by = hz_utility_v2pub.last_updated_by,

Line 1884: HZ_POPULATE_BOT_PKG.pop_hz_contact_points(

1880:
1881: --bug #5203798
1882: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1883: -- populate function for integration service
1884: HZ_POPULATE_BOT_PKG.pop_hz_contact_points(
1885: p_operation => p_mode,
1886: p_contact_point_id => l_unset_prim_contact_point_id);
1887: END IF;
1888:

Line 2071: UPDATE hz_contact_points

2067: ELSE
2068: l_contact_point_id := p_contact_point_id;
2069: END IF;
2070:
2071: UPDATE hz_contact_points
2072: SET primary_by_purpose = 'N',
2073: last_update_date = hz_utility_v2pub.last_update_date,
2074: last_updated_by = hz_utility_v2pub.last_updated_by,
2075: last_update_login = hz_utility_v2pub.last_update_login,

Line 2383: -- hz_contact_points_PKG.Select_Row

2379: -- DESCRIPTION
2380: -- Cets contact point record.
2381: --
2382: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2383: -- hz_contact_points_PKG.Select_Row
2384: --
2385: -- ARGUMENTS
2386: -- IN:
2387: -- p_init_msg_list Initialize message stack if it is set to

Line 2432: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;

2428: x_msg_count OUT NOCOPY NUMBER,
2429: x_msg_data OUT NOCOPY VARCHAR2
2430: ) IS
2431:
2432: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
2433: l_contact_point_rec hz_contact_points%ROWTYPE;
2434: l_debug_prefix VARCHAR2(30) := '';
2435: BEGIN
2436: -- Debug info.

Line 2433: l_contact_point_rec hz_contact_points%ROWTYPE;

2429: x_msg_data OUT NOCOPY VARCHAR2
2430: ) IS
2431:
2432: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
2433: l_contact_point_rec hz_contact_points%ROWTYPE;
2434: l_debug_prefix VARCHAR2(30) := '';
2435: BEGIN
2436: -- Debug info.
2437:

Line 2465: hz_utility_v2pub.debug(p_message=>'hz_contact_points_PKG.Select_Row (+)',

2461: x_contact_point_rec.contact_point_id := p_contact_point_id;
2462:
2463: -- Debug info.
2464: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2465: hz_utility_v2pub.debug(p_message=>'hz_contact_points_PKG.Select_Row (+)',
2466: p_prefix=>l_debug_prefix,
2467: p_msg_level=>fnd_log.level_procedure);
2468: END IF;
2469:

Line 2471: hz_contact_points_pkg.select_row (

2467: p_msg_level=>fnd_log.level_procedure);
2468: END IF;
2469:
2470: -- Call table-handler
2471: hz_contact_points_pkg.select_row (
2472: x_contact_point_id => x_contact_point_rec.contact_point_id,
2473: x_contact_point_type => x_contact_point_rec.contact_point_type,
2474: x_status => x_contact_point_rec.status,
2475: x_owner_table_name => x_contact_point_rec.owner_table_name,

Line 2537: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Select_Row (-)',

2533: );
2534:
2535: -- Debug info.
2536: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2537: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_POINTS_PKG.Select_Row (-)',
2538: p_prefix=>l_debug_prefix,
2539: p_msg_level=>fnd_log.level_procedure);
2540: END IF;
2541:

Line 2660: p_entity_name => 'HZ_CONTACT_POINTS',

2656: /*
2657: * SSM SST Integration and Extension
2658: * For non-profile entities, the concept of select/de-select data sources is obsoleted.
2659: HZ_MIXNM_UTILITY.LoadDataSources(
2660: p_entity_name => 'HZ_CONTACT_POINTS',
2661: p_entity_attr_id => g_cpt_entity_attr_id,
2662: p_mixnmatch_enabled => g_cpt_mixnmatch_enabled,
2663: p_selected_datasources => g_cpt_selected_datasources );
2664: -- END IF;

Line 2667: p_entity_name => 'HZ_CONTACT_POINTS',

2663: p_selected_datasources => g_cpt_selected_datasources );
2664: -- END IF;
2665: */
2666: HZ_MIXNM_UTILITY.AssignDataSourceDuringCreation (
2667: p_entity_name => 'HZ_CONTACT_POINTS',
2668: p_entity_attr_id => g_cpt_entity_attr_id,
2669: p_mixnmatch_enabled => g_cpt_mixnmatch_enabled,
2670: p_selected_datasources => g_cpt_selected_datasources,
2671: p_content_source_type => l_contact_point_rec.content_source_type,

Line 2701: p_db_object_name => 'HZ_CONTACT_POINTS',

2697: THEN
2698: l_test_security :=
2699: hz_dss_util_pub.test_instance(
2700: p_operation_code => 'INSERT',
2701: p_db_object_name => 'HZ_CONTACT_POINTS',
2702: p_instance_pk1_value => x_contact_point_id,
2703: p_user_name => fnd_global.user_name,
2704: x_return_status => dss_return_status,
2705: x_msg_count => dss_msg_count,

Line 2751: HZ_POPULATE_BOT_PKG.pop_hz_contact_points(

2747: l_web_rec);
2748: END IF;
2749:
2750: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2751: HZ_POPULATE_BOT_PKG.pop_hz_contact_points(
2752: p_operation => 'I',
2753: p_contact_point_id => x_contact_point_id);
2754: END IF;
2755: -- Call to indicate contact point creation to DQM

Line 2852: l_phone_country_code HZ_CONTACT_POINTS.phone_country_code%type;

2848: l_old_phone_rec phone_rec_type;
2849: l_old_telex_rec telex_rec_type;
2850: l_old_web_rec web_rec_type;
2851: l_old_eft_rec eft_rec_type;
2852: l_phone_country_code HZ_CONTACT_POINTS.phone_country_code%type;
2853: l_phone_area_code HZ_CONTACT_POINTS.phone_area_code%type;
2854:
2855: l_data_source_from VARCHAR2(30);
2856:

Line 2853: l_phone_area_code HZ_CONTACT_POINTS.phone_area_code%type;

2849: l_old_telex_rec telex_rec_type;
2850: l_old_web_rec web_rec_type;
2851: l_old_eft_rec eft_rec_type;
2852: l_phone_country_code HZ_CONTACT_POINTS.phone_country_code%type;
2853: l_phone_area_code HZ_CONTACT_POINTS.phone_area_code%type;
2854:
2855: l_data_source_from VARCHAR2(30);
2856:
2857: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2896: p_owner_table_name => 'HZ_CONTACT_POINTS',

2892: and (p_contact_point_rec.contact_point_id = FND_API.G_MISS_NUM or p_contact_point_rec.contact_point_id is null) THEN
2893: hz_orig_system_ref_pub.get_owner_table_id
2894: (p_orig_system => p_contact_point_rec.orig_system,
2895: p_orig_system_reference => p_contact_point_rec.orig_system_reference,
2896: p_owner_table_name => 'HZ_CONTACT_POINTS',
2897: x_owner_table_id => l_contact_point_rec.contact_point_id,
2898: x_return_status => x_return_status);
2899: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2900: RAISE FND_API.G_EXC_ERROR;

Line 2935: p_db_object_name => 'HZ_CONTACT_POINTS',

2931: THEN
2932: l_test_security :=
2933: hz_dss_util_pub.test_instance(
2934: p_operation_code => 'UPDATE',
2935: p_db_object_name => 'HZ_CONTACT_POINTS',
2936: p_instance_pk1_value => l_contact_point_rec.contact_point_id,
2937: p_user_name => fnd_global.user_name,
2938: x_return_status => dss_return_status,
2939: x_msg_count => dss_msg_count,

Line 2974: p_entity_name => 'HZ_CONTACT_POINTS',

2970: * There is no need to check if the data-source is selected.
2971:
2972: -- IF g_cpt_mixnmatch_enabled IS NULL THEN
2973: HZ_MIXNM_UTILITY.LoadDataSources(
2974: p_entity_name => 'HZ_CONTACT_POINTS',
2975: p_entity_attr_id => g_cpt_entity_attr_id,
2976: p_mixnmatch_enabled => g_cpt_mixnmatch_enabled,
2977: p_selected_datasources => g_cpt_selected_datasources );
2978: -- END IF;

Line 3086: HZ_POPULATE_BOT_PKG.pop_hz_contact_points(

3082: l_old_web_rec);
3083: END IF;
3084:
3085: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3086: HZ_POPULATE_BOT_PKG.pop_hz_contact_points(
3087: p_operation => 'U',
3088: p_contact_point_id => l_contact_point_rec.contact_point_id);
3089: END IF;
3090: -- Call to indicate contact point update to DQM

Line 7073: l_owner_table_name HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;

7069: SELECT party_type
7070: FROM HZ_PARTIES
7071: WHERE party_id=p_party_id;
7072:
7073: l_owner_table_name HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;
7074: l_contact_point_type HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%TYPE;
7075: TYPE siteidtab IS TABLE OF HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID%TYPE;
7076: l_siteidtab siteidtab;
7077: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;

Line 7074: l_contact_point_type HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%TYPE;

7070: FROM HZ_PARTIES
7071: WHERE party_id=p_party_id;
7072:
7073: l_owner_table_name HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;
7074: l_contact_point_type HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%TYPE;
7075: TYPE siteidtab IS TABLE OF HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID%TYPE;
7076: l_siteidtab siteidtab;
7077: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
7078: BEGIN