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_MERGE_PKG dependencies on HZ_UTILITY_V2PUB

Line 6852: last_update_date = hz_utility_v2pub.last_update_date,

6848:
6849: IF p_contact_point_type = 'WEB' THEN
6850: UPDATE hz_parties
6851: SET url = p_url,
6852: last_update_date = hz_utility_v2pub.last_update_date,
6853: last_updated_by = hz_utility_v2pub.last_updated_by,
6854: last_update_login = hz_utility_v2pub.last_update_login,
6855: request_id = hz_utility_v2pub.request_id,
6856: program_application_id = hz_utility_v2pub.program_application_id,

Line 6853: last_updated_by = hz_utility_v2pub.last_updated_by,

6849: IF p_contact_point_type = 'WEB' THEN
6850: UPDATE hz_parties
6851: SET url = p_url,
6852: last_update_date = hz_utility_v2pub.last_update_date,
6853: last_updated_by = hz_utility_v2pub.last_updated_by,
6854: last_update_login = hz_utility_v2pub.last_update_login,
6855: request_id = hz_utility_v2pub.request_id,
6856: program_application_id = hz_utility_v2pub.program_application_id,
6857: program_id = hz_utility_v2pub.program_id,

Line 6854: last_update_login = hz_utility_v2pub.last_update_login,

6850: UPDATE hz_parties
6851: SET url = p_url,
6852: last_update_date = hz_utility_v2pub.last_update_date,
6853: last_updated_by = hz_utility_v2pub.last_updated_by,
6854: last_update_login = hz_utility_v2pub.last_update_login,
6855: request_id = hz_utility_v2pub.request_id,
6856: program_application_id = hz_utility_v2pub.program_application_id,
6857: program_id = hz_utility_v2pub.program_id,
6858: program_update_date = sysdate

Line 6855: request_id = hz_utility_v2pub.request_id,

6851: SET url = p_url,
6852: last_update_date = hz_utility_v2pub.last_update_date,
6853: last_updated_by = hz_utility_v2pub.last_updated_by,
6854: last_update_login = hz_utility_v2pub.last_update_login,
6855: request_id = hz_utility_v2pub.request_id,
6856: program_application_id = hz_utility_v2pub.program_application_id,
6857: program_id = hz_utility_v2pub.program_id,
6858: program_update_date = sysdate
6859: WHERE party_id = p_party_id;

Line 6856: program_application_id = hz_utility_v2pub.program_application_id,

6852: last_update_date = hz_utility_v2pub.last_update_date,
6853: last_updated_by = hz_utility_v2pub.last_updated_by,
6854: last_update_login = hz_utility_v2pub.last_update_login,
6855: request_id = hz_utility_v2pub.request_id,
6856: program_application_id = hz_utility_v2pub.program_application_id,
6857: program_id = hz_utility_v2pub.program_id,
6858: program_update_date = sysdate
6859: WHERE party_id = p_party_id;
6860: ELSIF p_contact_point_type = 'EMAIL' THEN

Line 6857: program_id = hz_utility_v2pub.program_id,

6853: last_updated_by = hz_utility_v2pub.last_updated_by,
6854: last_update_login = hz_utility_v2pub.last_update_login,
6855: request_id = hz_utility_v2pub.request_id,
6856: program_application_id = hz_utility_v2pub.program_application_id,
6857: program_id = hz_utility_v2pub.program_id,
6858: program_update_date = sysdate
6859: WHERE party_id = p_party_id;
6860: ELSIF p_contact_point_type = 'EMAIL' THEN
6861: UPDATE hz_parties

Line 6863: last_update_date = hz_utility_v2pub.last_update_date,

6859: WHERE party_id = p_party_id;
6860: ELSIF p_contact_point_type = 'EMAIL' THEN
6861: UPDATE hz_parties
6862: SET email_address = p_email_address,
6863: last_update_date = hz_utility_v2pub.last_update_date,
6864: last_updated_by = hz_utility_v2pub.last_updated_by,
6865: last_update_login = hz_utility_v2pub.last_update_login,
6866: request_id = hz_utility_v2pub.request_id,
6867: program_application_id = hz_utility_v2pub.program_application_id,

Line 6864: last_updated_by = hz_utility_v2pub.last_updated_by,

6860: ELSIF p_contact_point_type = 'EMAIL' THEN
6861: UPDATE hz_parties
6862: SET email_address = p_email_address,
6863: last_update_date = hz_utility_v2pub.last_update_date,
6864: last_updated_by = hz_utility_v2pub.last_updated_by,
6865: last_update_login = hz_utility_v2pub.last_update_login,
6866: request_id = hz_utility_v2pub.request_id,
6867: program_application_id = hz_utility_v2pub.program_application_id,
6868: program_id = hz_utility_v2pub.program_id,

Line 6865: last_update_login = hz_utility_v2pub.last_update_login,

6861: UPDATE hz_parties
6862: SET email_address = p_email_address,
6863: last_update_date = hz_utility_v2pub.last_update_date,
6864: last_updated_by = hz_utility_v2pub.last_updated_by,
6865: last_update_login = hz_utility_v2pub.last_update_login,
6866: request_id = hz_utility_v2pub.request_id,
6867: program_application_id = hz_utility_v2pub.program_application_id,
6868: program_id = hz_utility_v2pub.program_id,
6869: program_update_date = sysdate

Line 6866: request_id = hz_utility_v2pub.request_id,

6862: SET email_address = p_email_address,
6863: last_update_date = hz_utility_v2pub.last_update_date,
6864: last_updated_by = hz_utility_v2pub.last_updated_by,
6865: last_update_login = hz_utility_v2pub.last_update_login,
6866: request_id = hz_utility_v2pub.request_id,
6867: program_application_id = hz_utility_v2pub.program_application_id,
6868: program_id = hz_utility_v2pub.program_id,
6869: program_update_date = sysdate
6870: WHERE party_id = p_party_id;

Line 6867: program_application_id = hz_utility_v2pub.program_application_id,

6863: last_update_date = hz_utility_v2pub.last_update_date,
6864: last_updated_by = hz_utility_v2pub.last_updated_by,
6865: last_update_login = hz_utility_v2pub.last_update_login,
6866: request_id = hz_utility_v2pub.request_id,
6867: program_application_id = hz_utility_v2pub.program_application_id,
6868: program_id = hz_utility_v2pub.program_id,
6869: program_update_date = sysdate
6870: WHERE party_id = p_party_id;
6871: ELSIF p_contact_point_type = 'PHONE' THEN

Line 6868: program_id = hz_utility_v2pub.program_id,

6864: last_updated_by = hz_utility_v2pub.last_updated_by,
6865: last_update_login = hz_utility_v2pub.last_update_login,
6866: request_id = hz_utility_v2pub.request_id,
6867: program_application_id = hz_utility_v2pub.program_application_id,
6868: program_id = hz_utility_v2pub.program_id,
6869: program_update_date = sysdate
6870: WHERE party_id = p_party_id;
6871: ELSIF p_contact_point_type = 'PHONE' THEN
6872: UPDATE hz_parties

Line 6880: last_update_date = hz_utility_v2pub.last_update_date,

6876: primary_phone_country_code = p_phone_country_code,
6877: primary_phone_area_code = p_phone_area_code,
6878: primary_phone_number = p_phone_number,
6879: primary_phone_extension = p_phone_extension,
6880: last_update_date = hz_utility_v2pub.last_update_date,
6881: last_updated_by = hz_utility_v2pub.last_updated_by,
6882: last_update_login = hz_utility_v2pub.last_update_login,
6883: request_id = hz_utility_v2pub.request_id,
6884: program_application_id = hz_utility_v2pub.program_application_id,

Line 6881: last_updated_by = hz_utility_v2pub.last_updated_by,

6877: primary_phone_area_code = p_phone_area_code,
6878: primary_phone_number = p_phone_number,
6879: primary_phone_extension = p_phone_extension,
6880: last_update_date = hz_utility_v2pub.last_update_date,
6881: last_updated_by = hz_utility_v2pub.last_updated_by,
6882: last_update_login = hz_utility_v2pub.last_update_login,
6883: request_id = hz_utility_v2pub.request_id,
6884: program_application_id = hz_utility_v2pub.program_application_id,
6885: program_id = hz_utility_v2pub.program_id,

Line 6882: last_update_login = hz_utility_v2pub.last_update_login,

6878: primary_phone_number = p_phone_number,
6879: primary_phone_extension = p_phone_extension,
6880: last_update_date = hz_utility_v2pub.last_update_date,
6881: last_updated_by = hz_utility_v2pub.last_updated_by,
6882: last_update_login = hz_utility_v2pub.last_update_login,
6883: request_id = hz_utility_v2pub.request_id,
6884: program_application_id = hz_utility_v2pub.program_application_id,
6885: program_id = hz_utility_v2pub.program_id,
6886: program_update_date = sysdate

Line 6883: request_id = hz_utility_v2pub.request_id,

6879: primary_phone_extension = p_phone_extension,
6880: last_update_date = hz_utility_v2pub.last_update_date,
6881: last_updated_by = hz_utility_v2pub.last_updated_by,
6882: last_update_login = hz_utility_v2pub.last_update_login,
6883: request_id = hz_utility_v2pub.request_id,
6884: program_application_id = hz_utility_v2pub.program_application_id,
6885: program_id = hz_utility_v2pub.program_id,
6886: program_update_date = sysdate
6887: WHERE party_id = p_party_id;

Line 6884: program_application_id = hz_utility_v2pub.program_application_id,

6880: last_update_date = hz_utility_v2pub.last_update_date,
6881: last_updated_by = hz_utility_v2pub.last_updated_by,
6882: last_update_login = hz_utility_v2pub.last_update_login,
6883: request_id = hz_utility_v2pub.request_id,
6884: program_application_id = hz_utility_v2pub.program_application_id,
6885: program_id = hz_utility_v2pub.program_id,
6886: program_update_date = sysdate
6887: WHERE party_id = p_party_id;
6888: END IF;

Line 6885: program_id = hz_utility_v2pub.program_id,

6881: last_updated_by = hz_utility_v2pub.last_updated_by,
6882: last_update_login = hz_utility_v2pub.last_update_login,
6883: request_id = hz_utility_v2pub.request_id,
6884: program_application_id = hz_utility_v2pub.program_application_id,
6885: program_id = hz_utility_v2pub.program_id,
6886: program_update_date = sysdate
6887: WHERE party_id = p_party_id;
6888: END IF;
6889: