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_REGISTRY_VALIDATE_V2PUB dependencies on HZ_CONTACT_POINTS

Line 1120: l_owner_table_name hz_contact_points.owner_table_name%TYPE;

1116: l_fk_column VARCHAR2(30);
1117: l_error BOOLEAN := FALSE;
1118: l_return_status VARCHAR2(1);
1119:
1120: l_owner_table_name hz_contact_points.owner_table_name%TYPE;
1121: l_owner_table_id NUMBER;
1122: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=
1123: p_contact_point_rec.contact_point_type;
1124: l_content_source_type hz_contact_points.content_source_type%TYPE;

Line 1122: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=

1118: l_return_status VARCHAR2(1);
1119:
1120: l_owner_table_name hz_contact_points.owner_table_name%TYPE;
1121: l_owner_table_id NUMBER;
1122: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=
1123: p_contact_point_rec.contact_point_type;
1124: l_content_source_type hz_contact_points.content_source_type%TYPE;
1125: l_orig_system_reference hz_contact_points.orig_system_reference%TYPE;
1126: l_primary_flag hz_contact_points.primary_flag%TYPE;

Line 1124: l_content_source_type hz_contact_points.content_source_type%TYPE;

1120: l_owner_table_name hz_contact_points.owner_table_name%TYPE;
1121: l_owner_table_id NUMBER;
1122: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=
1123: p_contact_point_rec.contact_point_type;
1124: l_content_source_type hz_contact_points.content_source_type%TYPE;
1125: l_orig_system_reference hz_contact_points.orig_system_reference%TYPE;
1126: l_primary_flag hz_contact_points.primary_flag%TYPE;
1127: l_preferred_flag hz_contact_points.primary_by_purpose%TYPE;
1128: l_status hz_contact_points.status%TYPE;

Line 1125: l_orig_system_reference hz_contact_points.orig_system_reference%TYPE;

1121: l_owner_table_id NUMBER;
1122: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=
1123: p_contact_point_rec.contact_point_type;
1124: l_content_source_type hz_contact_points.content_source_type%TYPE;
1125: l_orig_system_reference hz_contact_points.orig_system_reference%TYPE;
1126: l_primary_flag hz_contact_points.primary_flag%TYPE;
1127: l_preferred_flag hz_contact_points.primary_by_purpose%TYPE;
1128: l_status hz_contact_points.status%TYPE;
1129: l_created_by_module hz_contact_points.created_by_module%TYPE;

Line 1126: l_primary_flag hz_contact_points.primary_flag%TYPE;

1122: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=
1123: p_contact_point_rec.contact_point_type;
1124: l_content_source_type hz_contact_points.content_source_type%TYPE;
1125: l_orig_system_reference hz_contact_points.orig_system_reference%TYPE;
1126: l_primary_flag hz_contact_points.primary_flag%TYPE;
1127: l_preferred_flag hz_contact_points.primary_by_purpose%TYPE;
1128: l_status hz_contact_points.status%TYPE;
1129: l_created_by_module hz_contact_points.created_by_module%TYPE;
1130: l_application_id NUMBER;

Line 1127: l_preferred_flag hz_contact_points.primary_by_purpose%TYPE;

1123: p_contact_point_rec.contact_point_type;
1124: l_content_source_type hz_contact_points.content_source_type%TYPE;
1125: l_orig_system_reference hz_contact_points.orig_system_reference%TYPE;
1126: l_primary_flag hz_contact_points.primary_flag%TYPE;
1127: l_preferred_flag hz_contact_points.primary_by_purpose%TYPE;
1128: l_status hz_contact_points.status%TYPE;
1129: l_created_by_module hz_contact_points.created_by_module%TYPE;
1130: l_application_id NUMBER;
1131: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;

Line 1128: l_status hz_contact_points.status%TYPE;

1124: l_content_source_type hz_contact_points.content_source_type%TYPE;
1125: l_orig_system_reference hz_contact_points.orig_system_reference%TYPE;
1126: l_primary_flag hz_contact_points.primary_flag%TYPE;
1127: l_preferred_flag hz_contact_points.primary_by_purpose%TYPE;
1128: l_status hz_contact_points.status%TYPE;
1129: l_created_by_module hz_contact_points.created_by_module%TYPE;
1130: l_application_id NUMBER;
1131: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;
1132: l_email_format hz_contact_points.email_format%TYPE;

Line 1129: l_created_by_module hz_contact_points.created_by_module%TYPE;

1125: l_orig_system_reference hz_contact_points.orig_system_reference%TYPE;
1126: l_primary_flag hz_contact_points.primary_flag%TYPE;
1127: l_preferred_flag hz_contact_points.primary_by_purpose%TYPE;
1128: l_status hz_contact_points.status%TYPE;
1129: l_created_by_module hz_contact_points.created_by_module%TYPE;
1130: l_application_id NUMBER;
1131: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;
1132: l_email_format hz_contact_points.email_format%TYPE;
1133: l_phone_line_type hz_contact_points.phone_line_type%TYPE;

Line 1131: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;

1127: l_preferred_flag hz_contact_points.primary_by_purpose%TYPE;
1128: l_status hz_contact_points.status%TYPE;
1129: l_created_by_module hz_contact_points.created_by_module%TYPE;
1130: l_application_id NUMBER;
1131: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;
1132: l_email_format hz_contact_points.email_format%TYPE;
1133: l_phone_line_type hz_contact_points.phone_line_type%TYPE;
1134: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;
1135:

Line 1132: l_email_format hz_contact_points.email_format%TYPE;

1128: l_status hz_contact_points.status%TYPE;
1129: l_created_by_module hz_contact_points.created_by_module%TYPE;
1130: l_application_id NUMBER;
1131: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;
1132: l_email_format hz_contact_points.email_format%TYPE;
1133: l_phone_line_type hz_contact_points.phone_line_type%TYPE;
1134: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;
1135:
1136: -- Bug 2197181: added for mix-n-match

Line 1133: l_phone_line_type hz_contact_points.phone_line_type%TYPE;

1129: l_created_by_module hz_contact_points.created_by_module%TYPE;
1130: l_application_id NUMBER;
1131: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;
1132: l_email_format hz_contact_points.email_format%TYPE;
1133: l_phone_line_type hz_contact_points.phone_line_type%TYPE;
1134: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;
1135:
1136: -- Bug 2197181: added for mix-n-match
1137: db_actual_content_source hz_contact_points.actual_content_source%TYPE;

Line 1134: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;

1130: l_application_id NUMBER;
1131: l_contact_point_purpose hz_contact_points.contact_point_purpose%TYPE;
1132: l_email_format hz_contact_points.email_format%TYPE;
1133: l_phone_line_type hz_contact_points.phone_line_type%TYPE;
1134: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;
1135:
1136: -- Bug 2197181: added for mix-n-match
1137: db_actual_content_source hz_contact_points.actual_content_source%TYPE;
1138: l_phone_area_code hz_contact_points.phone_area_code%TYPE;

Line 1137: db_actual_content_source hz_contact_points.actual_content_source%TYPE;

1133: l_phone_line_type hz_contact_points.phone_line_type%TYPE;
1134: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;
1135:
1136: -- Bug 2197181: added for mix-n-match
1137: db_actual_content_source hz_contact_points.actual_content_source%TYPE;
1138: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
1139: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
1140: l_phone_number hz_contact_points.phone_number%TYPE;
1141: l_phone_extension hz_contact_points.phone_extension%TYPE;

Line 1138: l_phone_area_code hz_contact_points.phone_area_code%TYPE;

1134: l_primary_by_purpose hz_contact_points.primary_by_purpose%TYPE;
1135:
1136: -- Bug 2197181: added for mix-n-match
1137: db_actual_content_source hz_contact_points.actual_content_source%TYPE;
1138: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
1139: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
1140: l_phone_number hz_contact_points.phone_number%TYPE;
1141: l_phone_extension hz_contact_points.phone_extension%TYPE;
1142: l_raw_phone_number hz_contact_points.raw_phone_number%TYPE;

Line 1139: l_phone_country_code hz_contact_points.phone_country_code%TYPE;

1135:
1136: -- Bug 2197181: added for mix-n-match
1137: db_actual_content_source hz_contact_points.actual_content_source%TYPE;
1138: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
1139: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
1140: l_phone_number hz_contact_points.phone_number%TYPE;
1141: l_phone_extension hz_contact_points.phone_extension%TYPE;
1142: l_raw_phone_number hz_contact_points.raw_phone_number%TYPE;
1143: -- Bug 4226199 : Added for update validation

Line 1140: l_phone_number hz_contact_points.phone_number%TYPE;

1136: -- Bug 2197181: added for mix-n-match
1137: db_actual_content_source hz_contact_points.actual_content_source%TYPE;
1138: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
1139: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
1140: l_phone_number hz_contact_points.phone_number%TYPE;
1141: l_phone_extension hz_contact_points.phone_extension%TYPE;
1142: l_raw_phone_number hz_contact_points.raw_phone_number%TYPE;
1143: -- Bug 4226199 : Added for update validation
1144: l_email_address hz_contact_points.email_address%TYPE;

Line 1141: l_phone_extension hz_contact_points.phone_extension%TYPE;

1137: db_actual_content_source hz_contact_points.actual_content_source%TYPE;
1138: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
1139: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
1140: l_phone_number hz_contact_points.phone_number%TYPE;
1141: l_phone_extension hz_contact_points.phone_extension%TYPE;
1142: l_raw_phone_number hz_contact_points.raw_phone_number%TYPE;
1143: -- Bug 4226199 : Added for update validation
1144: l_email_address hz_contact_points.email_address%TYPE;
1145: l_telex hz_contact_points.telex_number%TYPE;

Line 1142: l_raw_phone_number hz_contact_points.raw_phone_number%TYPE;

1138: l_phone_area_code hz_contact_points.phone_area_code%TYPE;
1139: l_phone_country_code hz_contact_points.phone_country_code%TYPE;
1140: l_phone_number hz_contact_points.phone_number%TYPE;
1141: l_phone_extension hz_contact_points.phone_extension%TYPE;
1142: l_raw_phone_number hz_contact_points.raw_phone_number%TYPE;
1143: -- Bug 4226199 : Added for update validation
1144: l_email_address hz_contact_points.email_address%TYPE;
1145: l_telex hz_contact_points.telex_number%TYPE;
1146: l_url hz_contact_points.url%TYPE;

Line 1144: l_email_address hz_contact_points.email_address%TYPE;

1140: l_phone_number hz_contact_points.phone_number%TYPE;
1141: l_phone_extension hz_contact_points.phone_extension%TYPE;
1142: l_raw_phone_number hz_contact_points.raw_phone_number%TYPE;
1143: -- Bug 4226199 : Added for update validation
1144: l_email_address hz_contact_points.email_address%TYPE;
1145: l_telex hz_contact_points.telex_number%TYPE;
1146: l_url hz_contact_points.url%TYPE;
1147:
1148: l_validate_osr varchar2(1) := 'Y';

Line 1145: l_telex hz_contact_points.telex_number%TYPE;

1141: l_phone_extension hz_contact_points.phone_extension%TYPE;
1142: l_raw_phone_number hz_contact_points.raw_phone_number%TYPE;
1143: -- Bug 4226199 : Added for update validation
1144: l_email_address hz_contact_points.email_address%TYPE;
1145: l_telex hz_contact_points.telex_number%TYPE;
1146: l_url hz_contact_points.url%TYPE;
1147:
1148: l_validate_osr varchar2(1) := 'Y';
1149: l_mosr_owner_table_id number;

Line 1146: l_url hz_contact_points.url%TYPE;

1142: l_raw_phone_number hz_contact_points.raw_phone_number%TYPE;
1143: -- Bug 4226199 : Added for update validation
1144: l_email_address hz_contact_points.email_address%TYPE;
1145: l_telex hz_contact_points.telex_number%TYPE;
1146: l_url hz_contact_points.url%TYPE;
1147:
1148: l_validate_osr varchar2(1) := 'Y';
1149: l_mosr_owner_table_id number;
1150:

Line 1181: FROM hz_contact_points hcp

1177: -- Bug 4226199 : Added for update validation
1178: hcp.email_address,
1179: hcp.telex_number,
1180: hcp.url
1181: FROM hz_contact_points hcp
1182: WHERE ROWID = p_rowid;
1183:
1184: CURSOR c_dup (p_contact_point_id IN NUMBER) IS
1185: SELECT 'Y'

Line 1186: FROM hz_contact_points hcp

1182: WHERE ROWID = p_rowid;
1183:
1184: CURSOR c_dup (p_contact_point_id IN NUMBER) IS
1185: SELECT 'Y'
1186: FROM hz_contact_points hcp
1187: WHERE hcp.contact_point_id = p_contact_point_id;
1188:
1189: CURSOR c_pexist (p_owner_table_id IN NUMBER) IS
1190: SELECT 'Y'

Line 1641: p_owner_table_name => 'HZ_CONTACT_POINTS',

1637: then
1638: hz_orig_system_ref_pub.get_owner_table_id
1639: (p_orig_system => p_contact_point_rec.orig_system,
1640: p_orig_system_reference => p_contact_point_rec.orig_system_reference,
1641: p_owner_table_name => 'HZ_CONTACT_POINTS',
1642: x_owner_table_id => l_mosr_owner_table_id,
1643: x_return_status => l_temp_return_status);
1644:
1645: IF (l_temp_return_status = fnd_api.g_ret_sts_success AND

Line 1772: p_entity_name => 'HZ_CONTACT_POINTS',

1768: p_content_source_type => p_contact_point_rec.content_source_type,
1769: p_old_content_source_type => l_content_source_type,
1770: p_actual_content_source => p_contact_point_rec.actual_content_source,
1771: p_old_actual_content_source => db_actual_content_source,
1772: p_entity_name => 'HZ_CONTACT_POINTS',
1773: x_return_status => x_return_status );
1774:
1775: --------------------------------------
1776: -- validate status

Line 2249: p_entity_name => 'HZ_CONTACT_POINTS',

2245: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2246: HZ_MIXNM_UTILITY.CheckUserUpdatePrivilege(
2247: p_actual_content_source => db_actual_content_source,
2248: p_new_actual_content_source=> p_contact_point_rec.actual_content_source,
2249: p_entity_name => 'HZ_CONTACT_POINTS',
2250: x_return_status => x_return_status);
2251: -- Bug 4693719 : set global variable to Y
2252: HZ_UTILITY_V2PUB.G_UPDATE_ACS := 'Y';
2253: END IF;

Line 2655: p_entity_name => 'HZ_CONTACT_POINTS',

2651:
2652: HZ_MIXNM_UTILITY.CheckUserUpdatePrivilege(
2653: p_actual_content_source => db_actual_content_source,
2654: p_new_actual_content_source=> p_contact_point_rec.actual_content_source,
2655: p_entity_name => 'HZ_CONTACT_POINTS',
2656: x_return_status => x_return_status);
2657: -- Bug 4693719 : set global variable to Y
2658: HZ_UTILITY_V2PUB.G_UPDATE_ACS := 'Y';
2659:

Line 2734: p_entity_name => 'HZ_CONTACT_POINTS',

2730: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2731: HZ_MIXNM_UTILITY.CheckUserUpdatePrivilege(
2732: p_actual_content_source => db_actual_content_source,
2733: p_new_actual_content_source=> p_contact_point_rec.actual_content_source,
2734: p_entity_name => 'HZ_CONTACT_POINTS',
2735: x_return_status => x_return_status);
2736: -- Bug 4693719 : set global variable to Y
2737: HZ_UTILITY_V2PUB.G_UPDATE_ACS := 'Y';
2738: END IF;

Line 2805: p_entity_name => 'HZ_CONTACT_POINTS',

2801: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2802: HZ_MIXNM_UTILITY.CheckUserUpdatePrivilege(
2803: p_actual_content_source => db_actual_content_source,
2804: p_new_actual_content_source=> p_contact_point_rec.actual_content_source,
2805: p_entity_name => 'HZ_CONTACT_POINTS',
2806: x_return_status => x_return_status);
2807: -- Bug 4693719 : set global variable to Y
2808: HZ_UTILITY_V2PUB.G_UPDATE_ACS := 'Y';
2809: END IF;