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.OE_PARTY_MERGE_PKG dependencies on HZ_UTILITY_V2PUB

Line 67: last_update_date = hz_utility_v2pub.last_update_date,

63: --arp_message.set_token( 'TABLE_NAME', 'OE_PRICE_ADJ_ATTRIBS', FALSE );
64:
65: UPDATE /*+ index(S OE_PRICE_ADJ_ATTRIBS_N2) */ OE_PRICE_ADJ_ATTRIBS S
66: SET pricing_attr_value_from = to_char(p_to_fk_id),
67: last_update_date = hz_utility_v2pub.last_update_date,
68: last_updated_by = hz_utility_v2pub.user_id,
69: last_update_login = hz_utility_v2pub.last_update_login,
70: request_id = hz_utility_v2pub.request_id,
71: program_application_id = hz_utility_v2pub.program_application_id,

Line 68: last_updated_by = hz_utility_v2pub.user_id,

64:
65: UPDATE /*+ index(S OE_PRICE_ADJ_ATTRIBS_N2) */ OE_PRICE_ADJ_ATTRIBS S
66: SET pricing_attr_value_from = to_char(p_to_fk_id),
67: last_update_date = hz_utility_v2pub.last_update_date,
68: last_updated_by = hz_utility_v2pub.user_id,
69: last_update_login = hz_utility_v2pub.last_update_login,
70: request_id = hz_utility_v2pub.request_id,
71: program_application_id = hz_utility_v2pub.program_application_id,
72: program_id = hz_utility_v2pub.program_id,

Line 69: last_update_login = hz_utility_v2pub.last_update_login,

65: UPDATE /*+ index(S OE_PRICE_ADJ_ATTRIBS_N2) */ OE_PRICE_ADJ_ATTRIBS S
66: SET pricing_attr_value_from = to_char(p_to_fk_id),
67: last_update_date = hz_utility_v2pub.last_update_date,
68: last_updated_by = hz_utility_v2pub.user_id,
69: last_update_login = hz_utility_v2pub.last_update_login,
70: request_id = hz_utility_v2pub.request_id,
71: program_application_id = hz_utility_v2pub.program_application_id,
72: program_id = hz_utility_v2pub.program_id,
73: program_update_date = sysdate

Line 70: request_id = hz_utility_v2pub.request_id,

66: SET pricing_attr_value_from = to_char(p_to_fk_id),
67: last_update_date = hz_utility_v2pub.last_update_date,
68: last_updated_by = hz_utility_v2pub.user_id,
69: last_update_login = hz_utility_v2pub.last_update_login,
70: request_id = hz_utility_v2pub.request_id,
71: program_application_id = hz_utility_v2pub.program_application_id,
72: program_id = hz_utility_v2pub.program_id,
73: program_update_date = sysdate
74: WHERE pricing_attr_value_from = to_char(p_from_fk_id)

Line 71: program_application_id = hz_utility_v2pub.program_application_id,

67: last_update_date = hz_utility_v2pub.last_update_date,
68: last_updated_by = hz_utility_v2pub.user_id,
69: last_update_login = hz_utility_v2pub.last_update_login,
70: request_id = hz_utility_v2pub.request_id,
71: program_application_id = hz_utility_v2pub.program_application_id,
72: program_id = hz_utility_v2pub.program_id,
73: program_update_date = sysdate
74: WHERE pricing_attr_value_from = to_char(p_from_fk_id)
75: and (pricing_context = 'ASOPARTYINFO' AND pricing_attribute = 'QUALIFIER_ATTRIBUTE1'

Line 72: program_id = hz_utility_v2pub.program_id,

68: last_updated_by = hz_utility_v2pub.user_id,
69: last_update_login = hz_utility_v2pub.last_update_login,
70: request_id = hz_utility_v2pub.request_id,
71: program_application_id = hz_utility_v2pub.program_application_id,
72: program_id = hz_utility_v2pub.program_id,
73: program_update_date = sysdate
74: WHERE pricing_attr_value_from = to_char(p_from_fk_id)
75: and (pricing_context = 'ASOPARTYINFO' AND pricing_attribute = 'QUALIFIER_ATTRIBUTE1'
76: OR pricing_context = 'CUSTOMER' AND pricing_attribute ='QUALIFIER_ATTRIBUTE16'

Line 156: last_update_date = hz_utility_v2pub.last_update_date,

152: --arp_message.set_token( 'TABLE_NAME', 'OE_PRICE_ADJ_ATTRIBS', FALSE );
153:
154: UPDATE /*+ index(S OE_PRICE_ADJ_ATTRIBS_N2) */ OE_PRICE_ADJ_ATTRIBS S
155: SET pricing_attr_value_from = to_char(p_to_fk_id),
156: last_update_date = hz_utility_v2pub.last_update_date,
157: last_updated_by = hz_utility_v2pub.user_id,
158: last_update_login = hz_utility_v2pub.last_update_login,
159: request_id = hz_utility_v2pub.request_id,
160: program_application_id = hz_utility_v2pub.program_application_id,

Line 157: last_updated_by = hz_utility_v2pub.user_id,

153:
154: UPDATE /*+ index(S OE_PRICE_ADJ_ATTRIBS_N2) */ OE_PRICE_ADJ_ATTRIBS S
155: SET pricing_attr_value_from = to_char(p_to_fk_id),
156: last_update_date = hz_utility_v2pub.last_update_date,
157: last_updated_by = hz_utility_v2pub.user_id,
158: last_update_login = hz_utility_v2pub.last_update_login,
159: request_id = hz_utility_v2pub.request_id,
160: program_application_id = hz_utility_v2pub.program_application_id,
161: program_id = hz_utility_v2pub.program_id,

Line 158: last_update_login = hz_utility_v2pub.last_update_login,

154: UPDATE /*+ index(S OE_PRICE_ADJ_ATTRIBS_N2) */ OE_PRICE_ADJ_ATTRIBS S
155: SET pricing_attr_value_from = to_char(p_to_fk_id),
156: last_update_date = hz_utility_v2pub.last_update_date,
157: last_updated_by = hz_utility_v2pub.user_id,
158: last_update_login = hz_utility_v2pub.last_update_login,
159: request_id = hz_utility_v2pub.request_id,
160: program_application_id = hz_utility_v2pub.program_application_id,
161: program_id = hz_utility_v2pub.program_id,
162: program_update_date = sysdate

Line 159: request_id = hz_utility_v2pub.request_id,

155: SET pricing_attr_value_from = to_char(p_to_fk_id),
156: last_update_date = hz_utility_v2pub.last_update_date,
157: last_updated_by = hz_utility_v2pub.user_id,
158: last_update_login = hz_utility_v2pub.last_update_login,
159: request_id = hz_utility_v2pub.request_id,
160: program_application_id = hz_utility_v2pub.program_application_id,
161: program_id = hz_utility_v2pub.program_id,
162: program_update_date = sysdate
163: WHERE pricing_attr_value_from = to_char(p_from_fk_id)

Line 160: program_application_id = hz_utility_v2pub.program_application_id,

156: last_update_date = hz_utility_v2pub.last_update_date,
157: last_updated_by = hz_utility_v2pub.user_id,
158: last_update_login = hz_utility_v2pub.last_update_login,
159: request_id = hz_utility_v2pub.request_id,
160: program_application_id = hz_utility_v2pub.program_application_id,
161: program_id = hz_utility_v2pub.program_id,
162: program_update_date = sysdate
163: WHERE pricing_attr_value_from = to_char(p_from_fk_id)
164: AND (pricing_context = 'ASOPARTYINFO'

Line 161: program_id = hz_utility_v2pub.program_id,

157: last_updated_by = hz_utility_v2pub.user_id,
158: last_update_login = hz_utility_v2pub.last_update_login,
159: request_id = hz_utility_v2pub.request_id,
160: program_application_id = hz_utility_v2pub.program_application_id,
161: program_id = hz_utility_v2pub.program_id,
162: program_update_date = sysdate
163: WHERE pricing_attr_value_from = to_char(p_from_fk_id)
164: AND (pricing_context = 'ASOPARTYINFO'
165: AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11')