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.PVX_PARTY_MERGE_PKG dependencies on PV_REFERRALS_B

Line 82: UPDATE pv_referrals_b

78: -- ---------------------------------------------------------------
79: -- Merge party (hz_parties)
80: -- ---------------------------------------------------------------
81: IF (p_parent_entity_name = 'HZ_PARTIES') THEN
82: UPDATE pv_referrals_b
83: SET partner_id = p_to_fk_id,
84: last_update_date = SYSDATE,
85: last_updated_by = G_USER_ID,
86: last_update_login = G_LOGIN_ID

Line 89: UPDATE pv_referrals_b

85: last_updated_by = G_USER_ID,
86: last_update_login = G_LOGIN_ID
87: WHERE partner_id = p_from_fk_id;
88:
89: UPDATE pv_referrals_b
90: SET customer_party_id = p_to_fk_id,
91: last_update_date = SYSDATE,
92: last_updated_by = G_USER_ID,
93: last_update_login = G_LOGIN_ID

Line 100: UPDATE pv_referrals_b

96: -- ---------------------------------------------------------------
97: -- Merge party_sites (hz_party_sites)
98: -- ---------------------------------------------------------------
99: ELSIF (p_parent_entity_name = 'HZ_PARTY_SITES') THEN
100: UPDATE pv_referrals_b
101: SET customer_party_site_id = p_to_fk_id,
102: last_update_date = SYSDATE,
103: last_updated_by = G_USER_ID,
104: last_update_login = G_LOGIN_ID

Line 111: UPDATE pv_referrals_b

107: -- ---------------------------------------------------------------
108: -- Merge contact_points (hz_contact_points)
109: -- ---------------------------------------------------------------
110: ELSIF (p_parent_entity_name = 'HZ_CONTACT_POINTS') THEN
111: UPDATE pv_referrals_b
112: SET customer_contact_party_id = p_to_fk_id,
113: last_update_date = SYSDATE,
114: last_updated_by = G_USER_ID,
115: last_update_login = G_LOGIN_ID

Line 122: UPDATE pv_referrals_b

118: -- ---------------------------------------------------------------
119: -- Merge org_contacts (hz_org_contacts)
120: -- ---------------------------------------------------------------
121: ELSIF (p_parent_entity_name = 'HZ_ORG_CONTACTS') THEN
122: UPDATE pv_referrals_b
123: SET customer_org_contact_id = p_to_fk_id,
124: last_update_date = SYSDATE,
125: last_updated_by = G_USER_ID,
126: last_update_login = G_LOGIN_ID