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_LOCATIONS

Line 450: FROM hz_locations l, hz_party_sites ps,

446: ,ps.party_site_id record_id
447: ,''PARTY_SITES'' entity
448: ,decode(addr_sg.action_flag, ''I'', ''C'', addr_sg.action_flag) operation_flag
449: ,null party_type
450: FROM hz_locations l, hz_party_sites ps,
451: hz_imp_addresses_sg addr_sg
452: WHERE l.request_id = :p_request_id
453: and l.location_id = ps.location_id
454: and addr_sg.batch_id = :p_batch_id

Line 471: FROM hz_locations l, hz_party_sites ps,

467: ,ps.party_site_id record_id
468: ,''PARTY_SITES'' entity
469: ,decode(addr_sg.action_flag, ''I'', ''C'', addr_sg.action_flag) operation_flag
470: ,null party_type
471: FROM hz_locations l, hz_party_sites ps,
472: hz_imp_addresses_sg addr_sg, hz_imp_batch_details bd
473: WHERE l.request_id = bd.main_conc_req_id
474: and bd.batch_id = addr_sg.batch_id
475: and l.location_id = ps.location_id

Line 533: UPDATE HZ_LOCATIONS

529: p_postal_code => l_postal_code(i),
530: p_first_name => NULL,
531: p_last_name => NULL);
532:
533: UPDATE HZ_LOCATIONS
534: SET address_key = l_key
535: WHERE location_id = l_location_id(i);
536: EXCEPTION
537: WHEN OTHERS THEN

Line 721: and gnr.location_table_name = 'HZ_LOCATIONS');

717: AND site_int.interface_status IS NULL /* check if any validation error */
718: AND site_sg.party_site_id = ps.party_site_id
719: AND exists (select 1 from hz_geo_name_references gnr
720: where gnr.location_id = ps.location_id
721: and gnr.location_table_name = 'HZ_LOCATIONS');
722:
723: l_msg_count NUMBER;
724: l_msg_data VARCHAR2(2000);
725: l_loc_id NUMBER;

Line 789: from hz_locations l,hz_imp_addresses_int addr_int, hz_imp_addresses_sg addr_sg,

785: l_msg_data VARCHAR2(2000);
786:
787: cursor c_timezone_loc is
788: select l.location_id, l.country, l.state, l.city, l.postal_code
789: from hz_locations l,hz_imp_addresses_int addr_int, hz_imp_addresses_sg addr_sg,
790: hz_party_sites ps
791: where l.location_id = ps.location_id
792: and addr_sg.batch_id = p_batch_id
793: and addr_sg.batch_mode_flag = p_batch_mode_flag

Line 837: UPDATE hz_locations

833: IF l_return_status <> fnd_api.g_ret_sts_success THEN -- we don't raise error
834: l_timezone_id := null;
835: END IF;
836:
837: UPDATE hz_locations
838: SET timezone_id = l_timezone_id
839: WHERE location_id = l_location_id(i);
840: EXCEPTION
841: WHEN OTHERS THEN

Line 1017: FROM hz_locations

1013: and cps.action_flag is not null';
1014:
1015: CURSOR c_country (p_site_id IN NUMBER) IS
1016: SELECT country
1017: FROM hz_locations
1018: WHERE location_id = (SELECT location_id
1019: FROM hz_party_sites
1020: WHERE party_site_id = p_site_id);
1021:

Line 1318: /* HZ_LOCATIONS */

1314: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (+) ');
1315: pp_generate_cp_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char, NULL);
1316: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (-) ');
1317:
1318: /* HZ_LOCATIONS */
1319: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_LOCATIONS entity ');
1320:
1321: IF (P_GENERATE_FUZZY_KEY = 'Y' OR l_enable_dqm_sync_flag <> 'DISABLE') THEN
1322: fnd_file.put_line(fnd_file.log,' Generate Address Key (+) ');

Line 1319: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_LOCATIONS entity ');

1315: pp_generate_cp_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char, NULL);
1316: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (-) ');
1317:
1318: /* HZ_LOCATIONS */
1319: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_LOCATIONS entity ');
1320:
1321: IF (P_GENERATE_FUZZY_KEY = 'Y' OR l_enable_dqm_sync_flag <> 'DISABLE') THEN
1322: fnd_file.put_line(fnd_file.log,' Generate Address Key (+) ');
1323: pp_generate_addr_key(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,

Line 1425: /* HZ_LOCATIONS */

1421: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (+) ');
1422: pp_generate_cp_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char, 'U');
1423: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (-) ');
1424:
1425: /* HZ_LOCATIONS */
1426: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_LOCATIONS entity ');
1427:
1428: IF (P_GENERATE_FUZZY_KEY = 'Y' OR l_enable_dqm_sync_flag <> 'DISABLE') THEN
1429: fnd_file.put_line(fnd_file.log,' Generate Address Key (+) ');

Line 1426: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_LOCATIONS entity ');

1422: pp_generate_cp_timezone(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,l_g_miss_char, 'U');
1423: fnd_file.put_line(fnd_file.log,' Generate Contact point Timezone (-) ');
1424:
1425: /* HZ_LOCATIONS */
1426: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_LOCATIONS entity ');
1427:
1428: IF (P_GENERATE_FUZZY_KEY = 'Y' OR l_enable_dqm_sync_flag <> 'DISABLE') THEN
1429: fnd_file.put_line(fnd_file.log,' Generate Address Key (+) ');
1430: pp_generate_addr_key(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID,