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 6980: last_update_date = hz_utility_v2pub.last_update_date,

6976:
6977: IF p_contact_point_type = 'WEB' THEN
6978: UPDATE hz_parties
6979: SET url = p_url,
6980: last_update_date = hz_utility_v2pub.last_update_date,
6981: last_updated_by = hz_utility_v2pub.last_updated_by,
6982: last_update_login = hz_utility_v2pub.last_update_login,
6983: request_id = hz_utility_v2pub.request_id,
6984: program_application_id = hz_utility_v2pub.program_application_id,

Line 6981: last_updated_by = hz_utility_v2pub.last_updated_by,

6977: IF p_contact_point_type = 'WEB' THEN
6978: UPDATE hz_parties
6979: SET url = p_url,
6980: last_update_date = hz_utility_v2pub.last_update_date,
6981: last_updated_by = hz_utility_v2pub.last_updated_by,
6982: last_update_login = hz_utility_v2pub.last_update_login,
6983: request_id = hz_utility_v2pub.request_id,
6984: program_application_id = hz_utility_v2pub.program_application_id,
6985: program_id = hz_utility_v2pub.program_id,

Line 6982: last_update_login = hz_utility_v2pub.last_update_login,

6978: UPDATE hz_parties
6979: SET url = p_url,
6980: last_update_date = hz_utility_v2pub.last_update_date,
6981: last_updated_by = hz_utility_v2pub.last_updated_by,
6982: last_update_login = hz_utility_v2pub.last_update_login,
6983: request_id = hz_utility_v2pub.request_id,
6984: program_application_id = hz_utility_v2pub.program_application_id,
6985: program_id = hz_utility_v2pub.program_id,
6986: program_update_date = sysdate

Line 6983: request_id = hz_utility_v2pub.request_id,

6979: SET url = p_url,
6980: last_update_date = hz_utility_v2pub.last_update_date,
6981: last_updated_by = hz_utility_v2pub.last_updated_by,
6982: last_update_login = hz_utility_v2pub.last_update_login,
6983: request_id = hz_utility_v2pub.request_id,
6984: program_application_id = hz_utility_v2pub.program_application_id,
6985: program_id = hz_utility_v2pub.program_id,
6986: program_update_date = sysdate
6987: WHERE party_id = p_party_id;

Line 6984: program_application_id = hz_utility_v2pub.program_application_id,

6980: last_update_date = hz_utility_v2pub.last_update_date,
6981: last_updated_by = hz_utility_v2pub.last_updated_by,
6982: last_update_login = hz_utility_v2pub.last_update_login,
6983: request_id = hz_utility_v2pub.request_id,
6984: program_application_id = hz_utility_v2pub.program_application_id,
6985: program_id = hz_utility_v2pub.program_id,
6986: program_update_date = sysdate
6987: WHERE party_id = p_party_id;
6988: ELSIF p_contact_point_type = 'EMAIL' THEN

Line 6985: program_id = hz_utility_v2pub.program_id,

6981: last_updated_by = hz_utility_v2pub.last_updated_by,
6982: last_update_login = hz_utility_v2pub.last_update_login,
6983: request_id = hz_utility_v2pub.request_id,
6984: program_application_id = hz_utility_v2pub.program_application_id,
6985: program_id = hz_utility_v2pub.program_id,
6986: program_update_date = sysdate
6987: WHERE party_id = p_party_id;
6988: ELSIF p_contact_point_type = 'EMAIL' THEN
6989: UPDATE hz_parties

Line 6991: last_update_date = hz_utility_v2pub.last_update_date,

6987: WHERE party_id = p_party_id;
6988: ELSIF p_contact_point_type = 'EMAIL' THEN
6989: UPDATE hz_parties
6990: SET email_address = p_email_address,
6991: last_update_date = hz_utility_v2pub.last_update_date,
6992: last_updated_by = hz_utility_v2pub.last_updated_by,
6993: last_update_login = hz_utility_v2pub.last_update_login,
6994: request_id = hz_utility_v2pub.request_id,
6995: program_application_id = hz_utility_v2pub.program_application_id,

Line 6992: last_updated_by = hz_utility_v2pub.last_updated_by,

6988: ELSIF p_contact_point_type = 'EMAIL' THEN
6989: UPDATE hz_parties
6990: SET email_address = p_email_address,
6991: last_update_date = hz_utility_v2pub.last_update_date,
6992: last_updated_by = hz_utility_v2pub.last_updated_by,
6993: last_update_login = hz_utility_v2pub.last_update_login,
6994: request_id = hz_utility_v2pub.request_id,
6995: program_application_id = hz_utility_v2pub.program_application_id,
6996: program_id = hz_utility_v2pub.program_id,

Line 6993: last_update_login = hz_utility_v2pub.last_update_login,

6989: UPDATE hz_parties
6990: SET email_address = p_email_address,
6991: last_update_date = hz_utility_v2pub.last_update_date,
6992: last_updated_by = hz_utility_v2pub.last_updated_by,
6993: last_update_login = hz_utility_v2pub.last_update_login,
6994: request_id = hz_utility_v2pub.request_id,
6995: program_application_id = hz_utility_v2pub.program_application_id,
6996: program_id = hz_utility_v2pub.program_id,
6997: program_update_date = sysdate

Line 6994: request_id = hz_utility_v2pub.request_id,

6990: SET email_address = p_email_address,
6991: last_update_date = hz_utility_v2pub.last_update_date,
6992: last_updated_by = hz_utility_v2pub.last_updated_by,
6993: last_update_login = hz_utility_v2pub.last_update_login,
6994: request_id = hz_utility_v2pub.request_id,
6995: program_application_id = hz_utility_v2pub.program_application_id,
6996: program_id = hz_utility_v2pub.program_id,
6997: program_update_date = sysdate
6998: WHERE party_id = p_party_id;

Line 6995: program_application_id = hz_utility_v2pub.program_application_id,

6991: last_update_date = hz_utility_v2pub.last_update_date,
6992: last_updated_by = hz_utility_v2pub.last_updated_by,
6993: last_update_login = hz_utility_v2pub.last_update_login,
6994: request_id = hz_utility_v2pub.request_id,
6995: program_application_id = hz_utility_v2pub.program_application_id,
6996: program_id = hz_utility_v2pub.program_id,
6997: program_update_date = sysdate
6998: WHERE party_id = p_party_id;
6999: ELSIF p_contact_point_type = 'PHONE' THEN

Line 6996: program_id = hz_utility_v2pub.program_id,

6992: last_updated_by = hz_utility_v2pub.last_updated_by,
6993: last_update_login = hz_utility_v2pub.last_update_login,
6994: request_id = hz_utility_v2pub.request_id,
6995: program_application_id = hz_utility_v2pub.program_application_id,
6996: program_id = hz_utility_v2pub.program_id,
6997: program_update_date = sysdate
6998: WHERE party_id = p_party_id;
6999: ELSIF p_contact_point_type = 'PHONE' THEN
7000: UPDATE hz_parties

Line 7008: last_update_date = hz_utility_v2pub.last_update_date,

7004: primary_phone_country_code = p_phone_country_code,
7005: primary_phone_area_code = p_phone_area_code,
7006: primary_phone_number = p_phone_number,
7007: primary_phone_extension = p_phone_extension,
7008: last_update_date = hz_utility_v2pub.last_update_date,
7009: last_updated_by = hz_utility_v2pub.last_updated_by,
7010: last_update_login = hz_utility_v2pub.last_update_login,
7011: request_id = hz_utility_v2pub.request_id,
7012: program_application_id = hz_utility_v2pub.program_application_id,

Line 7009: last_updated_by = hz_utility_v2pub.last_updated_by,

7005: primary_phone_area_code = p_phone_area_code,
7006: primary_phone_number = p_phone_number,
7007: primary_phone_extension = p_phone_extension,
7008: last_update_date = hz_utility_v2pub.last_update_date,
7009: last_updated_by = hz_utility_v2pub.last_updated_by,
7010: last_update_login = hz_utility_v2pub.last_update_login,
7011: request_id = hz_utility_v2pub.request_id,
7012: program_application_id = hz_utility_v2pub.program_application_id,
7013: program_id = hz_utility_v2pub.program_id,

Line 7010: last_update_login = hz_utility_v2pub.last_update_login,

7006: primary_phone_number = p_phone_number,
7007: primary_phone_extension = p_phone_extension,
7008: last_update_date = hz_utility_v2pub.last_update_date,
7009: last_updated_by = hz_utility_v2pub.last_updated_by,
7010: last_update_login = hz_utility_v2pub.last_update_login,
7011: request_id = hz_utility_v2pub.request_id,
7012: program_application_id = hz_utility_v2pub.program_application_id,
7013: program_id = hz_utility_v2pub.program_id,
7014: program_update_date = sysdate

Line 7011: request_id = hz_utility_v2pub.request_id,

7007: primary_phone_extension = p_phone_extension,
7008: last_update_date = hz_utility_v2pub.last_update_date,
7009: last_updated_by = hz_utility_v2pub.last_updated_by,
7010: last_update_login = hz_utility_v2pub.last_update_login,
7011: request_id = hz_utility_v2pub.request_id,
7012: program_application_id = hz_utility_v2pub.program_application_id,
7013: program_id = hz_utility_v2pub.program_id,
7014: program_update_date = sysdate
7015: WHERE party_id = p_party_id;

Line 7012: program_application_id = hz_utility_v2pub.program_application_id,

7008: last_update_date = hz_utility_v2pub.last_update_date,
7009: last_updated_by = hz_utility_v2pub.last_updated_by,
7010: last_update_login = hz_utility_v2pub.last_update_login,
7011: request_id = hz_utility_v2pub.request_id,
7012: program_application_id = hz_utility_v2pub.program_application_id,
7013: program_id = hz_utility_v2pub.program_id,
7014: program_update_date = sysdate
7015: WHERE party_id = p_party_id;
7016: END IF;

Line 7013: program_id = hz_utility_v2pub.program_id,

7009: last_updated_by = hz_utility_v2pub.last_updated_by,
7010: last_update_login = hz_utility_v2pub.last_update_login,
7011: request_id = hz_utility_v2pub.request_id,
7012: program_application_id = hz_utility_v2pub.program_application_id,
7013: program_id = hz_utility_v2pub.program_id,
7014: program_update_date = sysdate
7015: WHERE party_id = p_party_id;
7016: END IF;
7017: