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

Line 867: FROM hz_contact_points cp,hz_imp_contactpts_int cpint,hz_imp_contactpts_sg cpsg

863: l_msg_count NUMBER;
864: l_msg_data VARCHAR2(2000);
865:
866: l_new_sql varchar2(1000) := 'SELECT cp.contact_point_id, cp.phone_country_code, cp.phone_area_code
867: FROM hz_contact_points cp,hz_imp_contactpts_int cpint,hz_imp_contactpts_sg cpsg
868: WHERE cpsg.batch_id = :p_batch_id
869: AND cpsg.party_orig_system = :p_os
870: AND cpsg.party_orig_system_reference between :p_from_osr and :p_to_osr
871: AND cpsg.batch_mode_flag = :p_batch_mode_flag

Line 880: FROM hz_contact_points cp,hz_imp_contactpts_int cpint,hz_imp_contactpts_sg cpsg, hz_imp_batch_details bd

876: AND cpint.timezone_code is NULL
877: AND (decode(cpint.phone_country_code,:p_g_miss_char,NULL,cpint.phone_country_code) IS NOT NULL OR decode(cpint.phone_area_code,:p_g_miss_char,NULL,cpint.phone_area_code) IS NOT NULL)';
878:
879: l_rerun_sql varchar2(1000) := 'SELECT cp.contact_point_id, cp.phone_country_code, cp.phone_area_code
880: FROM hz_contact_points cp,hz_imp_contactpts_int cpint,hz_imp_contactpts_sg cpsg, hz_imp_batch_details bd
881: WHERE cpsg.batch_id = :p_batch_id
882: AND cpsg.party_orig_system = :p_os
883: AND cpsg.party_orig_system_reference between :p_from_osr and :p_to_osr
884: AND cpsg.batch_mode_flag = :p_batch_mode_flag

Line 934: UPDATE hz_contact_points

930: then -- we don't raise error
931: l_timezone_id := null;
932: end if;
933:
934: UPDATE hz_contact_points
935: SET timezone_id = l_timezone_id
936: WHERE contact_point_id = l_contact_point_id(i);
937: EXCEPTION
938: WHEN OTHERS THEN

Line 984: FROM hz_contact_points cp, hz_imp_contactpts_sg cps

980: cp.contact_point_id record_id,
981: ''CONTACT_POINTS'' entity,
982: decode(cps.action_flag, ''I'', ''C'', cps.action_flag) operation_flag,
983: null party_type
984: FROM hz_contact_points cp, hz_imp_contactpts_sg cps
985: WHERE cp.request_id = :p_request_id
986: AND cp.contact_point_id = cps.contact_point_id
987: and cps.batch_id = :p_batch_id
988: and cps.party_orig_system = :p_os

Line 1005: FROM hz_contact_points cp, hz_imp_contactpts_sg cps, hz_imp_batch_details bd

1001: cp.contact_point_id record_id,
1002: ''CONTACT_POINTS'' entity,
1003: decode(cps.action_flag, ''I'', ''C'', cps.action_flag) operation_flag,
1004: null party_type
1005: FROM hz_contact_points cp, hz_imp_contactpts_sg cps, hz_imp_batch_details bd
1006: WHERE cp.request_id = bd.main_conc_req_id
1007: AND bd.batch_id = cps.batch_id
1008: AND cp.contact_point_id = cps.contact_point_id
1009: and cps.batch_id = :p_batch_id

Line 1105: Update hz_contact_points SET

1101: fnd_file.put_line(fnd_file.log,' The phone format API failed for contact point id ' || l_contact_point_id(i));
1102: -- l_formatted_phone_number := NULL;
1103: END IF;
1104:
1105: Update hz_contact_points SET
1106: phone_number = l_phone_number(i),
1107: phone_area_code = l_phone_area_code(i),
1108: phone_country_code = l_country_code(i),
1109: transposed_phone_number = hz_phone_number_pkg.transpose(

Line 1114: Update hz_contact_points SET

1110: l_country_code(i)||l_phone_area_code(i)||l_phone_number(i))
1111: Where contact_point_id = l_contact_point_id(i);
1112:
1113: ELSIF l_raw_phone_number(i) IS NULL THEN /* Phone Number is passed */
1114: Update hz_contact_points SET
1115: raw_phone_number = l_phone_area_code(i) || '-' || l_phone_number(i),
1116: transposed_phone_number = hz_phone_number_pkg.transpose(
1117: l_country_code(i)||l_phone_area_code(i)||l_phone_number(i))
1118: Where contact_point_id = l_contact_point_id(i);

Line 1307: /* HZ_CONTACT_POINTS */

1303: pp_dnb_hierarchy(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR);
1304: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (-) ');
1305: END IF;
1306:
1307: /* HZ_CONTACT_POINTS */
1308: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_CONTACT_POINTS entity ');
1309: fnd_file.put_line(fnd_file.log,' Phone Format (+) ');
1310: pp_phone_format(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1311: l_enable_dqm_sync_flag, NULL);

Line 1308: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_CONTACT_POINTS entity ');

1304: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (-) ');
1305: END IF;
1306:
1307: /* HZ_CONTACT_POINTS */
1308: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_CONTACT_POINTS entity ');
1309: fnd_file.put_line(fnd_file.log,' Phone Format (+) ');
1310: pp_phone_format(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1311: l_enable_dqm_sync_flag, NULL);
1312: fnd_file.put_line(fnd_file.log,' Phone Format (-) ');

Line 1414: /* HZ_CONTACT_POINTS */

1410: pp_dnb_hierarchy(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR);
1411: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (-) ');
1412: END IF;
1413:
1414: /* HZ_CONTACT_POINTS */
1415: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_CONTACT_POINTS entity ');
1416: fnd_file.put_line(fnd_file.log,' Phone Format (+) ');
1417: pp_phone_format(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1418: l_enable_dqm_sync_flag, 'U');

Line 1415: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_CONTACT_POINTS entity ');

1411: fnd_file.put_line(fnd_file.log,' DNB Hierarchy (-) ');
1412: END IF;
1413:
1414: /* HZ_CONTACT_POINTS */
1415: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_CONTACT_POINTS entity ');
1416: fnd_file.put_line(fnd_file.log,' Phone Format (+) ');
1417: pp_phone_format(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,
1418: l_enable_dqm_sync_flag, 'U');
1419: fnd_file.put_line(fnd_file.log,' Phone Format (-) ');