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 OE_PRICE_ADJ_ATTRIBS

Line 58: -- This check is not required for oe_price_adj_attribs

54: -- If the parent has changed(ie. Parent is getting merged) then transfer the
55: -- dependent record to the new parent. Before transferring check if a similar
56: -- dependent record exists on the new parent. If a duplicate exists then do
57: -- not transfer and return the id of the duplicate record as the Merged To Id
58: -- This check is not required for oe_price_adj_attribs
59:
60: if p_from_fk_id <> p_to_fk_id then
61: -- obtain lock on records to be updated.
62: --arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

Line 63: --arp_message.set_token( 'TABLE_NAME', 'OE_PRICE_ADJ_ATTRIBS', FALSE );

59:
60: if p_from_fk_id <> p_to_fk_id then
61: -- obtain lock on records to be updated.
62: --arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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,

Line 65: UPDATE /+ index(S OE_PRICE_ADJ_ATTRIBS_N2) / OE_PRICE_ADJ_ATTRIBS S

61: -- obtain lock on records to be updated.
62: --arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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,

Line 147: -- This check is not required for oe_price_adj_attribs

143: -- If the parent has changed(ie. Parent is getting merged) then transfer the
144: -- dependent record to the new parent. Before transferring check if a similar
145: -- dependent record exists on the new parent. If a duplicate exists then do
146: -- not transfer and return the id of the duplicate record as the Merged To Id
147: -- This check is not required for oe_price_adj_attribs
148:
149: if p_from_fk_id <> p_to_fk_id then
150: -- obtain lock on records to be updated.
151: --arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

Line 152: --arp_message.set_token( 'TABLE_NAME', 'OE_PRICE_ADJ_ATTRIBS', FALSE );

148:
149: if p_from_fk_id <> p_to_fk_id then
150: -- obtain lock on records to be updated.
151: --arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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,

Line 154: UPDATE /+ index(S OE_PRICE_ADJ_ATTRIBS_N2) / OE_PRICE_ADJ_ATTRIBS S

150: -- obtain lock on records to be updated.
151: --arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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,