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.FUN_PARTY_MERGE_PUB dependencies on HZ_UTILITY_PUB

Line 99: LAST_UPDATED_BY = hz_utility_pub.user_id,

95:
96: /* Update the "From" Party_ID to be equal to the new target */
97: UPDATE FUN_TRX_BATCHES
98: SET initiator_id = p_To_FK_id,
99: LAST_UPDATED_BY = hz_utility_pub.user_id,
100: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
101: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
102: WHERE initiator_id = p_From_FK_id;
103:

Line 100: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,

96: /* Update the "From" Party_ID to be equal to the new target */
97: UPDATE FUN_TRX_BATCHES
98: SET initiator_id = p_To_FK_id,
99: LAST_UPDATED_BY = hz_utility_pub.user_id,
100: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
101: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
102: WHERE initiator_id = p_From_FK_id;
103:
104: Open C2;

Line 101: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

97: UPDATE FUN_TRX_BATCHES
98: SET initiator_id = p_To_FK_id,
99: LAST_UPDATED_BY = hz_utility_pub.user_id,
100: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
101: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
102: WHERE initiator_id = p_From_FK_id;
103:
104: Open C2;
105: Close C2;

Line 109: LAST_UPDATED_BY = hz_utility_pub.user_id,

105: Close C2;
106:
107: UPDATE FUN_TRX_HEADERS
108: SET initiator_id = p_To_FK_id,
109: LAST_UPDATED_BY = hz_utility_pub.user_id,
110: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
111: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
112: WHERE initiator_id = p_From_FK_id;
113:

Line 110: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,

106:
107: UPDATE FUN_TRX_HEADERS
108: SET initiator_id = p_To_FK_id,
109: LAST_UPDATED_BY = hz_utility_pub.user_id,
110: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
111: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
112: WHERE initiator_id = p_From_FK_id;
113:
114: END IF;

Line 111: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

107: UPDATE FUN_TRX_HEADERS
108: SET initiator_id = p_To_FK_id,
109: LAST_UPDATED_BY = hz_utility_pub.user_id,
110: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
111: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
112: WHERE initiator_id = p_From_FK_id;
113:
114: END IF;
115:

Line 224: LAST_UPDATED_BY = hz_utility_pub.user_id,

220:
221: /* Update the "From" Party_ID to be equal to the new target */
222: UPDATE FUN_TRX_HEADERS
223: SET recipient_id = p_To_FK_id,
224: LAST_UPDATED_BY = hz_utility_pub.user_id,
225: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
226: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
227: WHERE recipient_id = p_From_FK_id;
228:

Line 225: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,

221: /* Update the "From" Party_ID to be equal to the new target */
222: UPDATE FUN_TRX_HEADERS
223: SET recipient_id = p_To_FK_id,
224: LAST_UPDATED_BY = hz_utility_pub.user_id,
225: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
226: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
227: WHERE recipient_id = p_From_FK_id;
228:
229: END IF;

Line 226: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

222: UPDATE FUN_TRX_HEADERS
223: SET recipient_id = p_To_FK_id,
224: LAST_UPDATED_BY = hz_utility_pub.user_id,
225: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
226: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
227: WHERE recipient_id = p_From_FK_id;
228:
229: END IF;
230:

Line 339: LAST_UPDATED_BY = hz_utility_pub.user_id,

335:
336: /* Update the "From" Party_ID to be equal to the new target */
337: UPDATE FUN_DIST_LINES
338: SET party_id = p_To_FK_id,
339: LAST_UPDATED_BY = hz_utility_pub.user_id,
340: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
341: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
342: WHERE party_id = p_From_FK_id;
343:

Line 340: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,

336: /* Update the "From" Party_ID to be equal to the new target */
337: UPDATE FUN_DIST_LINES
338: SET party_id = p_To_FK_id,
339: LAST_UPDATED_BY = hz_utility_pub.user_id,
340: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
341: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
342: WHERE party_id = p_From_FK_id;
343:
344: END IF;

Line 341: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

337: UPDATE FUN_DIST_LINES
338: SET party_id = p_To_FK_id,
339: LAST_UPDATED_BY = hz_utility_pub.user_id,
340: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
341: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
342: WHERE party_id = p_From_FK_id;
343:
344: END IF;
345:

Line 453: LAST_UPDATED_BY = hz_utility_pub.user_id,

449:
450: /* Update the "From" Party_ID to be equal to the new target */
451: UPDATE FUN_CUSTOMER_MAPS
452: SET site_use_id = p_To_FK_id,
453: LAST_UPDATED_BY = hz_utility_pub.user_id,
454: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
455: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
456: WHERE site_use_id = p_From_FK_id;
457: RETURN;

Line 454: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,

450: /* Update the "From" Party_ID to be equal to the new target */
451: UPDATE FUN_CUSTOMER_MAPS
452: SET site_use_id = p_To_FK_id,
453: LAST_UPDATED_BY = hz_utility_pub.user_id,
454: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
455: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
456: WHERE site_use_id = p_From_FK_id;
457: RETURN;
458:

Line 455: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

451: UPDATE FUN_CUSTOMER_MAPS
452: SET site_use_id = p_To_FK_id,
453: LAST_UPDATED_BY = hz_utility_pub.user_id,
454: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
455: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
456: WHERE site_use_id = p_From_FK_id;
457: RETURN;
458:
459:

Line 565: LAST_UPDATED_BY = hz_utility_pub.user_id,

561:
562: /* Update the "From" Party_ID to be equal to the new target */
563: UPDATE FUN_SUPPLIER_MAPS
564: SET vendor_site_id = p_To_FK_id,
565: LAST_UPDATED_BY = hz_utility_pub.user_id,
566: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
567: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
568: WHERE vendor_site_id = p_From_FK_id;
569: RETURN;

Line 566: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,

562: /* Update the "From" Party_ID to be equal to the new target */
563: UPDATE FUN_SUPPLIER_MAPS
564: SET vendor_site_id = p_To_FK_id,
565: LAST_UPDATED_BY = hz_utility_pub.user_id,
566: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
567: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
568: WHERE vendor_site_id = p_From_FK_id;
569: RETURN;
570:

Line 567: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

563: UPDATE FUN_SUPPLIER_MAPS
564: SET vendor_site_id = p_To_FK_id,
565: LAST_UPDATED_BY = hz_utility_pub.user_id,
566: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
567: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
568: WHERE vendor_site_id = p_From_FK_id;
569: RETURN;
570:
571: