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

Line 85: last_update_date = hz_utility_pub.last_update_date,

81: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
82:
83: UPDATE AMS_EVENT_REGISTRATIONS
84: set REGISTRANT_PARTY_ID = p_to_fk_id,
85: last_update_date = hz_utility_pub.last_update_date,
86: last_updated_by = hz_utility_pub.user_id,
87: last_update_login = hz_utility_pub.last_update_login,
88: program_application_id = hz_utility_pub.program_application_id,
89: program_id = hz_utility_pub.program_id,

Line 86: last_updated_by = hz_utility_pub.user_id,

82:
83: UPDATE AMS_EVENT_REGISTRATIONS
84: set REGISTRANT_PARTY_ID = p_to_fk_id,
85: last_update_date = hz_utility_pub.last_update_date,
86: last_updated_by = hz_utility_pub.user_id,
87: last_update_login = hz_utility_pub.last_update_login,
88: program_application_id = hz_utility_pub.program_application_id,
89: program_id = hz_utility_pub.program_id,
90: program_update_date = sysdate

Line 87: last_update_login = hz_utility_pub.last_update_login,

83: UPDATE AMS_EVENT_REGISTRATIONS
84: set REGISTRANT_PARTY_ID = p_to_fk_id,
85: last_update_date = hz_utility_pub.last_update_date,
86: last_updated_by = hz_utility_pub.user_id,
87: last_update_login = hz_utility_pub.last_update_login,
88: program_application_id = hz_utility_pub.program_application_id,
89: program_id = hz_utility_pub.program_id,
90: program_update_date = sysdate
91: where REGISTRANT_PARTY_ID = p_from_fk_id;

Line 88: program_application_id = hz_utility_pub.program_application_id,

84: set REGISTRANT_PARTY_ID = p_to_fk_id,
85: last_update_date = hz_utility_pub.last_update_date,
86: last_updated_by = hz_utility_pub.user_id,
87: last_update_login = hz_utility_pub.last_update_login,
88: program_application_id = hz_utility_pub.program_application_id,
89: program_id = hz_utility_pub.program_id,
90: program_update_date = sysdate
91: where REGISTRANT_PARTY_ID = p_from_fk_id;
92:

Line 89: program_id = hz_utility_pub.program_id,

85: last_update_date = hz_utility_pub.last_update_date,
86: last_updated_by = hz_utility_pub.user_id,
87: last_update_login = hz_utility_pub.last_update_login,
88: program_application_id = hz_utility_pub.program_application_id,
89: program_id = hz_utility_pub.program_id,
90: program_update_date = sysdate
91: where REGISTRANT_PARTY_ID = p_from_fk_id;
92:
93: -- following part added by soagrawa on 17-jan-2003

Line 98: last_update_date = hz_utility_pub.last_update_date,

94: -- for bug# 2696534. Also refer to bug# 1539211
95:
96: UPDATE AMS_EVENT_REGISTRATIONS
97: set REGISTRANT_CONTACT_ID = p_to_fk_id,
98: last_update_date = hz_utility_pub.last_update_date,
99: last_updated_by = hz_utility_pub.user_id,
100: last_update_login = hz_utility_pub.last_update_login,
101: program_application_id = hz_utility_pub.program_application_id,
102: program_id = hz_utility_pub.program_id,

Line 99: last_updated_by = hz_utility_pub.user_id,

95:
96: UPDATE AMS_EVENT_REGISTRATIONS
97: set REGISTRANT_CONTACT_ID = p_to_fk_id,
98: last_update_date = hz_utility_pub.last_update_date,
99: last_updated_by = hz_utility_pub.user_id,
100: last_update_login = hz_utility_pub.last_update_login,
101: program_application_id = hz_utility_pub.program_application_id,
102: program_id = hz_utility_pub.program_id,
103: program_update_date = sysdate

Line 100: last_update_login = hz_utility_pub.last_update_login,

96: UPDATE AMS_EVENT_REGISTRATIONS
97: set REGISTRANT_CONTACT_ID = p_to_fk_id,
98: last_update_date = hz_utility_pub.last_update_date,
99: last_updated_by = hz_utility_pub.user_id,
100: last_update_login = hz_utility_pub.last_update_login,
101: program_application_id = hz_utility_pub.program_application_id,
102: program_id = hz_utility_pub.program_id,
103: program_update_date = sysdate
104: where REGISTRANT_CONTACT_ID = p_from_fk_id;

Line 101: program_application_id = hz_utility_pub.program_application_id,

97: set REGISTRANT_CONTACT_ID = p_to_fk_id,
98: last_update_date = hz_utility_pub.last_update_date,
99: last_updated_by = hz_utility_pub.user_id,
100: last_update_login = hz_utility_pub.last_update_login,
101: program_application_id = hz_utility_pub.program_application_id,
102: program_id = hz_utility_pub.program_id,
103: program_update_date = sysdate
104: where REGISTRANT_CONTACT_ID = p_from_fk_id;
105:

Line 102: program_id = hz_utility_pub.program_id,

98: last_update_date = hz_utility_pub.last_update_date,
99: last_updated_by = hz_utility_pub.user_id,
100: last_update_login = hz_utility_pub.last_update_login,
101: program_application_id = hz_utility_pub.program_application_id,
102: program_id = hz_utility_pub.program_id,
103: program_update_date = sysdate
104: where REGISTRANT_CONTACT_ID = p_from_fk_id;
105:
106: -- following part removed by soagrawa on 17-jan-2003

Line 113: last_update_date = hz_utility_pub.last_update_date,

109: /*
110: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN -- merge org_contact
111: UPDATE AMS_EVENT_REGISTRATIONS
112: set REGISTRANT_CONTACT_ID = p_to_fk_id,
113: last_update_date = hz_utility_pub.last_update_date,
114: last_updated_by = hz_utility_pub.user_id,
115: last_update_login = hz_utility_pub.last_update_login,
116: program_application_id = hz_utility_pub.program_application_id,
117: program_id = hz_utility_pub.program_id,

Line 114: last_updated_by = hz_utility_pub.user_id,

110: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN -- merge org_contact
111: UPDATE AMS_EVENT_REGISTRATIONS
112: set REGISTRANT_CONTACT_ID = p_to_fk_id,
113: last_update_date = hz_utility_pub.last_update_date,
114: last_updated_by = hz_utility_pub.user_id,
115: last_update_login = hz_utility_pub.last_update_login,
116: program_application_id = hz_utility_pub.program_application_id,
117: program_id = hz_utility_pub.program_id,
118: program_update_date = sysdate

Line 115: last_update_login = hz_utility_pub.last_update_login,

111: UPDATE AMS_EVENT_REGISTRATIONS
112: set REGISTRANT_CONTACT_ID = p_to_fk_id,
113: last_update_date = hz_utility_pub.last_update_date,
114: last_updated_by = hz_utility_pub.user_id,
115: last_update_login = hz_utility_pub.last_update_login,
116: program_application_id = hz_utility_pub.program_application_id,
117: program_id = hz_utility_pub.program_id,
118: program_update_date = sysdate
119: where REGISTRANT_CONTACT_ID = p_from_fk_id;

Line 116: program_application_id = hz_utility_pub.program_application_id,

112: set REGISTRANT_CONTACT_ID = p_to_fk_id,
113: last_update_date = hz_utility_pub.last_update_date,
114: last_updated_by = hz_utility_pub.user_id,
115: last_update_login = hz_utility_pub.last_update_login,
116: program_application_id = hz_utility_pub.program_application_id,
117: program_id = hz_utility_pub.program_id,
118: program_update_date = sysdate
119: where REGISTRANT_CONTACT_ID = p_from_fk_id;
120: */

Line 117: program_id = hz_utility_pub.program_id,

113: last_update_date = hz_utility_pub.last_update_date,
114: last_updated_by = hz_utility_pub.user_id,
115: last_update_login = hz_utility_pub.last_update_login,
116: program_application_id = hz_utility_pub.program_application_id,
117: program_id = hz_utility_pub.program_id,
118: program_update_date = sysdate
119: where REGISTRANT_CONTACT_ID = p_from_fk_id;
120: */
121: END IF;

Line 212: last_update_date = hz_utility_pub.last_update_date,

208: BEGIN
209: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
210: UPDATE AMS_EVENT_REGISTRATIONS
211: set ATTENDANT_PARTY_ID = p_to_fk_id,
212: last_update_date = hz_utility_pub.last_update_date,
213: last_updated_by = hz_utility_pub.user_id,
214: last_update_login = hz_utility_pub.last_update_login,
215: program_application_id = hz_utility_pub.program_application_id,
216: program_id = hz_utility_pub.program_id,

Line 213: last_updated_by = hz_utility_pub.user_id,

209: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
210: UPDATE AMS_EVENT_REGISTRATIONS
211: set ATTENDANT_PARTY_ID = p_to_fk_id,
212: last_update_date = hz_utility_pub.last_update_date,
213: last_updated_by = hz_utility_pub.user_id,
214: last_update_login = hz_utility_pub.last_update_login,
215: program_application_id = hz_utility_pub.program_application_id,
216: program_id = hz_utility_pub.program_id,
217: program_update_date = sysdate

Line 214: last_update_login = hz_utility_pub.last_update_login,

210: UPDATE AMS_EVENT_REGISTRATIONS
211: set ATTENDANT_PARTY_ID = p_to_fk_id,
212: last_update_date = hz_utility_pub.last_update_date,
213: last_updated_by = hz_utility_pub.user_id,
214: last_update_login = hz_utility_pub.last_update_login,
215: program_application_id = hz_utility_pub.program_application_id,
216: program_id = hz_utility_pub.program_id,
217: program_update_date = sysdate
218: where ATTENDANT_PARTY_ID = p_from_fk_id;

Line 215: program_application_id = hz_utility_pub.program_application_id,

211: set ATTENDANT_PARTY_ID = p_to_fk_id,
212: last_update_date = hz_utility_pub.last_update_date,
213: last_updated_by = hz_utility_pub.user_id,
214: last_update_login = hz_utility_pub.last_update_login,
215: program_application_id = hz_utility_pub.program_application_id,
216: program_id = hz_utility_pub.program_id,
217: program_update_date = sysdate
218: where ATTENDANT_PARTY_ID = p_from_fk_id;
219:

Line 216: program_id = hz_utility_pub.program_id,

212: last_update_date = hz_utility_pub.last_update_date,
213: last_updated_by = hz_utility_pub.user_id,
214: last_update_login = hz_utility_pub.last_update_login,
215: program_application_id = hz_utility_pub.program_application_id,
216: program_id = hz_utility_pub.program_id,
217: program_update_date = sysdate
218: where ATTENDANT_PARTY_ID = p_from_fk_id;
219:
220: -- following part added by soagrawa on 17-jan-2003

Line 225: last_update_date = hz_utility_pub.last_update_date,

221: -- for bug# 2696534. Also refer to bug# 1539211
222:
223: UPDATE AMS_EVENT_REGISTRATIONS
224: set ATTENDANT_CONTACT_ID = p_to_fk_id,
225: last_update_date = hz_utility_pub.last_update_date,
226: last_updated_by = hz_utility_pub.user_id,
227: last_update_login = hz_utility_pub.last_update_login,
228: program_application_id = hz_utility_pub.program_application_id,
229: program_id = hz_utility_pub.program_id,

Line 226: last_updated_by = hz_utility_pub.user_id,

222:
223: UPDATE AMS_EVENT_REGISTRATIONS
224: set ATTENDANT_CONTACT_ID = p_to_fk_id,
225: last_update_date = hz_utility_pub.last_update_date,
226: last_updated_by = hz_utility_pub.user_id,
227: last_update_login = hz_utility_pub.last_update_login,
228: program_application_id = hz_utility_pub.program_application_id,
229: program_id = hz_utility_pub.program_id,
230: program_update_date = sysdate

Line 227: last_update_login = hz_utility_pub.last_update_login,

223: UPDATE AMS_EVENT_REGISTRATIONS
224: set ATTENDANT_CONTACT_ID = p_to_fk_id,
225: last_update_date = hz_utility_pub.last_update_date,
226: last_updated_by = hz_utility_pub.user_id,
227: last_update_login = hz_utility_pub.last_update_login,
228: program_application_id = hz_utility_pub.program_application_id,
229: program_id = hz_utility_pub.program_id,
230: program_update_date = sysdate
231: where ATTENDANT_CONTACT_ID = p_from_fk_id;

Line 228: program_application_id = hz_utility_pub.program_application_id,

224: set ATTENDANT_CONTACT_ID = p_to_fk_id,
225: last_update_date = hz_utility_pub.last_update_date,
226: last_updated_by = hz_utility_pub.user_id,
227: last_update_login = hz_utility_pub.last_update_login,
228: program_application_id = hz_utility_pub.program_application_id,
229: program_id = hz_utility_pub.program_id,
230: program_update_date = sysdate
231: where ATTENDANT_CONTACT_ID = p_from_fk_id;
232:

Line 229: program_id = hz_utility_pub.program_id,

225: last_update_date = hz_utility_pub.last_update_date,
226: last_updated_by = hz_utility_pub.user_id,
227: last_update_login = hz_utility_pub.last_update_login,
228: program_application_id = hz_utility_pub.program_application_id,
229: program_id = hz_utility_pub.program_id,
230: program_update_date = sysdate
231: where ATTENDANT_CONTACT_ID = p_from_fk_id;
232:
233:

Line 240: last_update_date = hz_utility_pub.last_update_date,

236:
237: /* ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN -- merge org_contact
238: UPDATE AMS_EVENT_REGISTRATIONS
239: set ATTENDANT_CONTACT_ID = p_to_fk_id,
240: last_update_date = hz_utility_pub.last_update_date,
241: last_updated_by = hz_utility_pub.user_id,
242: last_update_login = hz_utility_pub.last_update_login,
243: program_application_id = hz_utility_pub.program_application_id,
244: program_id = hz_utility_pub.program_id,

Line 241: last_updated_by = hz_utility_pub.user_id,

237: /* ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN -- merge org_contact
238: UPDATE AMS_EVENT_REGISTRATIONS
239: set ATTENDANT_CONTACT_ID = p_to_fk_id,
240: last_update_date = hz_utility_pub.last_update_date,
241: last_updated_by = hz_utility_pub.user_id,
242: last_update_login = hz_utility_pub.last_update_login,
243: program_application_id = hz_utility_pub.program_application_id,
244: program_id = hz_utility_pub.program_id,
245: program_update_date = sysdate

Line 242: last_update_login = hz_utility_pub.last_update_login,

238: UPDATE AMS_EVENT_REGISTRATIONS
239: set ATTENDANT_CONTACT_ID = p_to_fk_id,
240: last_update_date = hz_utility_pub.last_update_date,
241: last_updated_by = hz_utility_pub.user_id,
242: last_update_login = hz_utility_pub.last_update_login,
243: program_application_id = hz_utility_pub.program_application_id,
244: program_id = hz_utility_pub.program_id,
245: program_update_date = sysdate
246: where ATTENDANT_CONTACT_ID = p_from_fk_id;

Line 243: program_application_id = hz_utility_pub.program_application_id,

239: set ATTENDANT_CONTACT_ID = p_to_fk_id,
240: last_update_date = hz_utility_pub.last_update_date,
241: last_updated_by = hz_utility_pub.user_id,
242: last_update_login = hz_utility_pub.last_update_login,
243: program_application_id = hz_utility_pub.program_application_id,
244: program_id = hz_utility_pub.program_id,
245: program_update_date = sysdate
246: where ATTENDANT_CONTACT_ID = p_from_fk_id;
247: */

Line 244: program_id = hz_utility_pub.program_id,

240: last_update_date = hz_utility_pub.last_update_date,
241: last_updated_by = hz_utility_pub.user_id,
242: last_update_login = hz_utility_pub.last_update_login,
243: program_application_id = hz_utility_pub.program_application_id,
244: program_id = hz_utility_pub.program_id,
245: program_update_date = sysdate
246: where ATTENDANT_CONTACT_ID = p_from_fk_id;
247: */
248: END IF;

Line 348: last_update_date = hz_utility_pub.last_update_date,

344: -- Following lines of code is added by ptendulk on 14-May-2001
345: -- to do the party merge for table ams_channels_b
346: UPDATE AMS_CHANNELS_B
347: SET party_id = p_to_fk_id,
348: last_update_date = hz_utility_pub.last_update_date,
349: last_updated_by = hz_utility_pub.user_id,
350: last_update_login = hz_utility_pub.last_update_login,
351: program_application_id = hz_utility_pub.program_application_id,
352: program_id = hz_utility_pub.program_id,

Line 349: last_updated_by = hz_utility_pub.user_id,

345: -- to do the party merge for table ams_channels_b
346: UPDATE AMS_CHANNELS_B
347: SET party_id = p_to_fk_id,
348: last_update_date = hz_utility_pub.last_update_date,
349: last_updated_by = hz_utility_pub.user_id,
350: last_update_login = hz_utility_pub.last_update_login,
351: program_application_id = hz_utility_pub.program_application_id,
352: program_id = hz_utility_pub.program_id,
353: program_update_date = sysdate

Line 350: last_update_login = hz_utility_pub.last_update_login,

346: UPDATE AMS_CHANNELS_B
347: SET party_id = p_to_fk_id,
348: last_update_date = hz_utility_pub.last_update_date,
349: last_updated_by = hz_utility_pub.user_id,
350: last_update_login = hz_utility_pub.last_update_login,
351: program_application_id = hz_utility_pub.program_application_id,
352: program_id = hz_utility_pub.program_id,
353: program_update_date = sysdate
354: where party_id = p_from_fk_id;

Line 351: program_application_id = hz_utility_pub.program_application_id,

347: SET party_id = p_to_fk_id,
348: last_update_date = hz_utility_pub.last_update_date,
349: last_updated_by = hz_utility_pub.user_id,
350: last_update_login = hz_utility_pub.last_update_login,
351: program_application_id = hz_utility_pub.program_application_id,
352: program_id = hz_utility_pub.program_id,
353: program_update_date = sysdate
354: where party_id = p_from_fk_id;
355:

Line 352: program_id = hz_utility_pub.program_id,

348: last_update_date = hz_utility_pub.last_update_date,
349: last_updated_by = hz_utility_pub.user_id,
350: last_update_login = hz_utility_pub.last_update_login,
351: program_application_id = hz_utility_pub.program_application_id,
352: program_id = hz_utility_pub.program_id,
353: program_update_date = sysdate
354: where party_id = p_from_fk_id;
355:
356: END IF;

Line 456: last_update_date = hz_utility_pub.last_update_date,

452: -- Following lines of code is added by ptendulk on 14-May-2001
453: -- to do the party merge for table ams_channels_b
454: UPDATE AMS_PARTY_SOURCES
455: SET party_id = p_to_fk_id,
456: last_update_date = hz_utility_pub.last_update_date,
457: last_updated_by = hz_utility_pub.user_id,
458: last_update_login = hz_utility_pub.last_update_login,
459: program_application_id = hz_utility_pub.program_application_id,
460: program_id = hz_utility_pub.program_id,

Line 457: last_updated_by = hz_utility_pub.user_id,

453: -- to do the party merge for table ams_channels_b
454: UPDATE AMS_PARTY_SOURCES
455: SET party_id = p_to_fk_id,
456: last_update_date = hz_utility_pub.last_update_date,
457: last_updated_by = hz_utility_pub.user_id,
458: last_update_login = hz_utility_pub.last_update_login,
459: program_application_id = hz_utility_pub.program_application_id,
460: program_id = hz_utility_pub.program_id,
461: program_update_date = sysdate

Line 458: last_update_login = hz_utility_pub.last_update_login,

454: UPDATE AMS_PARTY_SOURCES
455: SET party_id = p_to_fk_id,
456: last_update_date = hz_utility_pub.last_update_date,
457: last_updated_by = hz_utility_pub.user_id,
458: last_update_login = hz_utility_pub.last_update_login,
459: program_application_id = hz_utility_pub.program_application_id,
460: program_id = hz_utility_pub.program_id,
461: program_update_date = sysdate
462: where party_id = p_from_fk_id;

Line 459: program_application_id = hz_utility_pub.program_application_id,

455: SET party_id = p_to_fk_id,
456: last_update_date = hz_utility_pub.last_update_date,
457: last_updated_by = hz_utility_pub.user_id,
458: last_update_login = hz_utility_pub.last_update_login,
459: program_application_id = hz_utility_pub.program_application_id,
460: program_id = hz_utility_pub.program_id,
461: program_update_date = sysdate
462: where party_id = p_from_fk_id;
463:

Line 460: program_id = hz_utility_pub.program_id,

456: last_update_date = hz_utility_pub.last_update_date,
457: last_updated_by = hz_utility_pub.user_id,
458: last_update_login = hz_utility_pub.last_update_login,
459: program_application_id = hz_utility_pub.program_application_id,
460: program_id = hz_utility_pub.program_id,
461: program_update_date = sysdate
462: where party_id = p_from_fk_id;
463:
464: END IF;

Line 564: last_update_date = hz_utility_pub.last_update_date,

560: -- Following lines of code is added by yxliu on 15-May-2001
561: -- to do the party merge for table ams_party_market_segments
562: UPDATE AMS_PARTY_MARKET_SEGMENTS
563: SET party_id = p_to_fk_id,
564: last_update_date = hz_utility_pub.last_update_date,
565: last_updated_by = hz_utility_pub.user_id,
566: last_update_login = hz_utility_pub.last_update_login,
567: program_application_id = hz_utility_pub.program_application_id,
568: program_id = hz_utility_pub.program_id,

Line 565: last_updated_by = hz_utility_pub.user_id,

561: -- to do the party merge for table ams_party_market_segments
562: UPDATE AMS_PARTY_MARKET_SEGMENTS
563: SET party_id = p_to_fk_id,
564: last_update_date = hz_utility_pub.last_update_date,
565: last_updated_by = hz_utility_pub.user_id,
566: last_update_login = hz_utility_pub.last_update_login,
567: program_application_id = hz_utility_pub.program_application_id,
568: program_id = hz_utility_pub.program_id,
569: program_update_date = sysdate

Line 566: last_update_login = hz_utility_pub.last_update_login,

562: UPDATE AMS_PARTY_MARKET_SEGMENTS
563: SET party_id = p_to_fk_id,
564: last_update_date = hz_utility_pub.last_update_date,
565: last_updated_by = hz_utility_pub.user_id,
566: last_update_login = hz_utility_pub.last_update_login,
567: program_application_id = hz_utility_pub.program_application_id,
568: program_id = hz_utility_pub.program_id,
569: program_update_date = sysdate
570: where party_id = p_from_fk_id;

Line 567: program_application_id = hz_utility_pub.program_application_id,

563: SET party_id = p_to_fk_id,
564: last_update_date = hz_utility_pub.last_update_date,
565: last_updated_by = hz_utility_pub.user_id,
566: last_update_login = hz_utility_pub.last_update_login,
567: program_application_id = hz_utility_pub.program_application_id,
568: program_id = hz_utility_pub.program_id,
569: program_update_date = sysdate
570: where party_id = p_from_fk_id;
571:

Line 568: program_id = hz_utility_pub.program_id,

564: last_update_date = hz_utility_pub.last_update_date,
565: last_updated_by = hz_utility_pub.user_id,
566: last_update_login = hz_utility_pub.last_update_login,
567: program_application_id = hz_utility_pub.program_application_id,
568: program_id = hz_utility_pub.program_id,
569: program_update_date = sysdate
570: where party_id = p_from_fk_id;
571:
572: END IF;

Line 672: last_update_date = hz_utility_pub.last_update_date,

668: -- Following lines of code is added by ptendulk on 14-May-2001
669: -- to do the party merge for table ams_iba_postings_b
670: UPDATE AMS_IBA_POSTINGS_B
671: SET customer_party_id = p_to_fk_id,
672: last_update_date = hz_utility_pub.last_update_date,
673: last_updated_by = hz_utility_pub.user_id,
674: last_update_login = hz_utility_pub.last_update_login
675: --, program_application_id = hz_utility_pub.program_application_id,
676: -- program_id = hz_utility_pub.program_id,

Line 673: last_updated_by = hz_utility_pub.user_id,

669: -- to do the party merge for table ams_iba_postings_b
670: UPDATE AMS_IBA_POSTINGS_B
671: SET customer_party_id = p_to_fk_id,
672: last_update_date = hz_utility_pub.last_update_date,
673: last_updated_by = hz_utility_pub.user_id,
674: last_update_login = hz_utility_pub.last_update_login
675: --, program_application_id = hz_utility_pub.program_application_id,
676: -- program_id = hz_utility_pub.program_id,
677: -- program_update_date = sysdate

Line 674: last_update_login = hz_utility_pub.last_update_login

670: UPDATE AMS_IBA_POSTINGS_B
671: SET customer_party_id = p_to_fk_id,
672: last_update_date = hz_utility_pub.last_update_date,
673: last_updated_by = hz_utility_pub.user_id,
674: last_update_login = hz_utility_pub.last_update_login
675: --, program_application_id = hz_utility_pub.program_application_id,
676: -- program_id = hz_utility_pub.program_id,
677: -- program_update_date = sysdate
678: where customer_party_id = p_from_fk_id;

Line 675: --, program_application_id = hz_utility_pub.program_application_id,

671: SET customer_party_id = p_to_fk_id,
672: last_update_date = hz_utility_pub.last_update_date,
673: last_updated_by = hz_utility_pub.user_id,
674: last_update_login = hz_utility_pub.last_update_login
675: --, program_application_id = hz_utility_pub.program_application_id,
676: -- program_id = hz_utility_pub.program_id,
677: -- program_update_date = sysdate
678: where customer_party_id = p_from_fk_id;
679:

Line 676: -- program_id = hz_utility_pub.program_id,

672: last_update_date = hz_utility_pub.last_update_date,
673: last_updated_by = hz_utility_pub.user_id,
674: last_update_login = hz_utility_pub.last_update_login
675: --, program_application_id = hz_utility_pub.program_application_id,
676: -- program_id = hz_utility_pub.program_id,
677: -- program_update_date = sysdate
678: where customer_party_id = p_from_fk_id;
679:
680: END IF;

Line 780: last_update_date = hz_utility_pub.last_update_date,

776: -- Following lines of code is added by ptendulk on 14-May-2001
777: -- to do the party merge for table ams_iba_postings_b
778: UPDATE AMS_IBA_POSTINGS_B
779: SET affiliate_party_id = p_to_fk_id,
780: last_update_date = hz_utility_pub.last_update_date,
781: last_updated_by = hz_utility_pub.user_id,
782: last_update_login = hz_utility_pub.last_update_login
783: -- ,program_application_id = hz_utility_pub.program_application_id,
784: -- program_id = hz_utility_pub.program_id,

Line 781: last_updated_by = hz_utility_pub.user_id,

777: -- to do the party merge for table ams_iba_postings_b
778: UPDATE AMS_IBA_POSTINGS_B
779: SET affiliate_party_id = p_to_fk_id,
780: last_update_date = hz_utility_pub.last_update_date,
781: last_updated_by = hz_utility_pub.user_id,
782: last_update_login = hz_utility_pub.last_update_login
783: -- ,program_application_id = hz_utility_pub.program_application_id,
784: -- program_id = hz_utility_pub.program_id,
785: -- program_update_date = sysdate

Line 782: last_update_login = hz_utility_pub.last_update_login

778: UPDATE AMS_IBA_POSTINGS_B
779: SET affiliate_party_id = p_to_fk_id,
780: last_update_date = hz_utility_pub.last_update_date,
781: last_updated_by = hz_utility_pub.user_id,
782: last_update_login = hz_utility_pub.last_update_login
783: -- ,program_application_id = hz_utility_pub.program_application_id,
784: -- program_id = hz_utility_pub.program_id,
785: -- program_update_date = sysdate
786: where affiliate_party_id = p_from_fk_id;

Line 783: -- ,program_application_id = hz_utility_pub.program_application_id,

779: SET affiliate_party_id = p_to_fk_id,
780: last_update_date = hz_utility_pub.last_update_date,
781: last_updated_by = hz_utility_pub.user_id,
782: last_update_login = hz_utility_pub.last_update_login
783: -- ,program_application_id = hz_utility_pub.program_application_id,
784: -- program_id = hz_utility_pub.program_id,
785: -- program_update_date = sysdate
786: where affiliate_party_id = p_from_fk_id;
787:

Line 784: -- program_id = hz_utility_pub.program_id,

780: last_update_date = hz_utility_pub.last_update_date,
781: last_updated_by = hz_utility_pub.user_id,
782: last_update_login = hz_utility_pub.last_update_login
783: -- ,program_application_id = hz_utility_pub.program_application_id,
784: -- program_id = hz_utility_pub.program_id,
785: -- program_update_date = sysdate
786: where affiliate_party_id = p_from_fk_id;
787:
788: END IF;

Line 850: last_update_date = hz_utility_pub.last_update_date,

846: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
847:
848: UPDATE AMS_ACT_PARTNERS
849: SET partner_id = p_to_fk_id,
850: last_update_date = hz_utility_pub.last_update_date,
851: last_updated_by = hz_utility_pub.user_id,
852: last_update_login = hz_utility_pub.last_update_login
853: --, program_application_id = hz_utility_pub.program_application_id,
854: -- program_id = hz_utility_pub.program_id,

Line 851: last_updated_by = hz_utility_pub.user_id,

847:
848: UPDATE AMS_ACT_PARTNERS
849: SET partner_id = p_to_fk_id,
850: last_update_date = hz_utility_pub.last_update_date,
851: last_updated_by = hz_utility_pub.user_id,
852: last_update_login = hz_utility_pub.last_update_login
853: --, program_application_id = hz_utility_pub.program_application_id,
854: -- program_id = hz_utility_pub.program_id,
855: -- program_update_date = sysdate

Line 852: last_update_login = hz_utility_pub.last_update_login

848: UPDATE AMS_ACT_PARTNERS
849: SET partner_id = p_to_fk_id,
850: last_update_date = hz_utility_pub.last_update_date,
851: last_updated_by = hz_utility_pub.user_id,
852: last_update_login = hz_utility_pub.last_update_login
853: --, program_application_id = hz_utility_pub.program_application_id,
854: -- program_id = hz_utility_pub.program_id,
855: -- program_update_date = sysdate
856: where partner_id = p_from_fk_id;

Line 853: --, program_application_id = hz_utility_pub.program_application_id,

849: SET partner_id = p_to_fk_id,
850: last_update_date = hz_utility_pub.last_update_date,
851: last_updated_by = hz_utility_pub.user_id,
852: last_update_login = hz_utility_pub.last_update_login
853: --, program_application_id = hz_utility_pub.program_application_id,
854: -- program_id = hz_utility_pub.program_id,
855: -- program_update_date = sysdate
856: where partner_id = p_from_fk_id;
857:

Line 854: -- program_id = hz_utility_pub.program_id,

850: last_update_date = hz_utility_pub.last_update_date,
851: last_updated_by = hz_utility_pub.user_id,
852: last_update_login = hz_utility_pub.last_update_login
853: --, program_application_id = hz_utility_pub.program_application_id,
854: -- program_id = hz_utility_pub.program_id,
855: -- program_update_date = sysdate
856: where partner_id = p_from_fk_id;
857:
858: END IF;

Line 919: last_update_date = hz_utility_pub.last_update_date,

915: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
916:
917: UPDATE AMS_ACT_PARTNERS
918: SET preferred_vad_id = p_to_fk_id,
919: last_update_date = hz_utility_pub.last_update_date,
920: last_updated_by = hz_utility_pub.user_id,
921: last_update_login = hz_utility_pub.last_update_login
922: --,program_application_id = hz_utility_pub.program_application_id,
923: -- program_id = hz_utility_pub.program_id,

Line 920: last_updated_by = hz_utility_pub.user_id,

916:
917: UPDATE AMS_ACT_PARTNERS
918: SET preferred_vad_id = p_to_fk_id,
919: last_update_date = hz_utility_pub.last_update_date,
920: last_updated_by = hz_utility_pub.user_id,
921: last_update_login = hz_utility_pub.last_update_login
922: --,program_application_id = hz_utility_pub.program_application_id,
923: -- program_id = hz_utility_pub.program_id,
924: -- program_update_date = sysdate

Line 921: last_update_login = hz_utility_pub.last_update_login

917: UPDATE AMS_ACT_PARTNERS
918: SET preferred_vad_id = p_to_fk_id,
919: last_update_date = hz_utility_pub.last_update_date,
920: last_updated_by = hz_utility_pub.user_id,
921: last_update_login = hz_utility_pub.last_update_login
922: --,program_application_id = hz_utility_pub.program_application_id,
923: -- program_id = hz_utility_pub.program_id,
924: -- program_update_date = sysdate
925: where preferred_vad_id = p_from_fk_id;

Line 922: --,program_application_id = hz_utility_pub.program_application_id,

918: SET preferred_vad_id = p_to_fk_id,
919: last_update_date = hz_utility_pub.last_update_date,
920: last_updated_by = hz_utility_pub.user_id,
921: last_update_login = hz_utility_pub.last_update_login
922: --,program_application_id = hz_utility_pub.program_application_id,
923: -- program_id = hz_utility_pub.program_id,
924: -- program_update_date = sysdate
925: where preferred_vad_id = p_from_fk_id;
926:

Line 923: -- program_id = hz_utility_pub.program_id,

919: last_update_date = hz_utility_pub.last_update_date,
920: last_updated_by = hz_utility_pub.user_id,
921: last_update_login = hz_utility_pub.last_update_login
922: --,program_application_id = hz_utility_pub.program_application_id,
923: -- program_id = hz_utility_pub.program_id,
924: -- program_update_date = sysdate
925: where preferred_vad_id = p_from_fk_id;
926:
927: END IF;

Line 988: last_update_date = hz_utility_pub.last_update_date,

984: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
985:
986: UPDATE AMS_ACT_PARTNERS
987: SET primary_contact_id = p_to_fk_id,
988: last_update_date = hz_utility_pub.last_update_date,
989: last_updated_by = hz_utility_pub.user_id,
990: last_update_login = hz_utility_pub.last_update_login
991: --, program_application_id = hz_utility_pub.program_application_id,
992: -- program_id = hz_utility_pub.program_id,

Line 989: last_updated_by = hz_utility_pub.user_id,

985:
986: UPDATE AMS_ACT_PARTNERS
987: SET primary_contact_id = p_to_fk_id,
988: last_update_date = hz_utility_pub.last_update_date,
989: last_updated_by = hz_utility_pub.user_id,
990: last_update_login = hz_utility_pub.last_update_login
991: --, program_application_id = hz_utility_pub.program_application_id,
992: -- program_id = hz_utility_pub.program_id,
993: -- program_update_date = sysdate

Line 990: last_update_login = hz_utility_pub.last_update_login

986: UPDATE AMS_ACT_PARTNERS
987: SET primary_contact_id = p_to_fk_id,
988: last_update_date = hz_utility_pub.last_update_date,
989: last_updated_by = hz_utility_pub.user_id,
990: last_update_login = hz_utility_pub.last_update_login
991: --, program_application_id = hz_utility_pub.program_application_id,
992: -- program_id = hz_utility_pub.program_id,
993: -- program_update_date = sysdate
994: where primary_contact_id = p_from_fk_id;

Line 991: --, program_application_id = hz_utility_pub.program_application_id,

987: SET primary_contact_id = p_to_fk_id,
988: last_update_date = hz_utility_pub.last_update_date,
989: last_updated_by = hz_utility_pub.user_id,
990: last_update_login = hz_utility_pub.last_update_login
991: --, program_application_id = hz_utility_pub.program_application_id,
992: -- program_id = hz_utility_pub.program_id,
993: -- program_update_date = sysdate
994: where primary_contact_id = p_from_fk_id;
995:

Line 992: -- program_id = hz_utility_pub.program_id,

988: last_update_date = hz_utility_pub.last_update_date,
989: last_updated_by = hz_utility_pub.user_id,
990: last_update_login = hz_utility_pub.last_update_login
991: --, program_application_id = hz_utility_pub.program_application_id,
992: -- program_id = hz_utility_pub.program_id,
993: -- program_update_date = sysdate
994: where primary_contact_id = p_from_fk_id;
995:
996: END IF;

Line 1088: last_update_date = hz_utility_pub.last_update_date,

1084: IF l_to_party_exists = 'FALSE' THEN
1085: -- update the from party profile to to_party
1086: UPDATE OZF_CUST_TRD_PRFLS_ALL
1087: SET party_id = p_to_fk_id,
1088: last_update_date = hz_utility_pub.last_update_date,
1089: last_updated_by = hz_utility_pub.user_id,
1090: last_update_login = hz_utility_pub.last_update_login,
1091: program_application_id = hz_utility_pub.program_application_id,
1092: program_id = hz_utility_pub.program_id,

Line 1089: last_updated_by = hz_utility_pub.user_id,

1085: -- update the from party profile to to_party
1086: UPDATE OZF_CUST_TRD_PRFLS_ALL
1087: SET party_id = p_to_fk_id,
1088: last_update_date = hz_utility_pub.last_update_date,
1089: last_updated_by = hz_utility_pub.user_id,
1090: last_update_login = hz_utility_pub.last_update_login,
1091: program_application_id = hz_utility_pub.program_application_id,
1092: program_id = hz_utility_pub.program_id,
1093: program_update_date = sysdate

Line 1090: last_update_login = hz_utility_pub.last_update_login,

1086: UPDATE OZF_CUST_TRD_PRFLS_ALL
1087: SET party_id = p_to_fk_id,
1088: last_update_date = hz_utility_pub.last_update_date,
1089: last_updated_by = hz_utility_pub.user_id,
1090: last_update_login = hz_utility_pub.last_update_login,
1091: program_application_id = hz_utility_pub.program_application_id,
1092: program_id = hz_utility_pub.program_id,
1093: program_update_date = sysdate
1094: where party_id = p_from_fk_id;

Line 1091: program_application_id = hz_utility_pub.program_application_id,

1087: SET party_id = p_to_fk_id,
1088: last_update_date = hz_utility_pub.last_update_date,
1089: last_updated_by = hz_utility_pub.user_id,
1090: last_update_login = hz_utility_pub.last_update_login,
1091: program_application_id = hz_utility_pub.program_application_id,
1092: program_id = hz_utility_pub.program_id,
1093: program_update_date = sysdate
1094: where party_id = p_from_fk_id;
1095: ELSIF l_to_party_exists = 'TRUE' THEN

Line 1092: program_id = hz_utility_pub.program_id,

1088: last_update_date = hz_utility_pub.last_update_date,
1089: last_updated_by = hz_utility_pub.user_id,
1090: last_update_login = hz_utility_pub.last_update_login,
1091: program_application_id = hz_utility_pub.program_application_id,
1092: program_id = hz_utility_pub.program_id,
1093: program_update_date = sysdate
1094: where party_id = p_from_fk_id;
1095: ELSIF l_to_party_exists = 'TRUE' THEN
1096: -- delete the from party profile since to_party profile exists

Line 1164: last_update_date = hz_utility_pub.last_update_date,

1160: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1161:
1162: UPDATE OZF_CLAIMS_ALL
1163: SET broker_id = p_to_fk_id,
1164: last_update_date = hz_utility_pub.last_update_date,
1165: last_updated_by = hz_utility_pub.user_id,
1166: last_update_login = hz_utility_pub.last_update_login,
1167: program_application_id = hz_utility_pub.program_application_id,
1168: program_id = hz_utility_pub.program_id,

Line 1165: last_updated_by = hz_utility_pub.user_id,

1161:
1162: UPDATE OZF_CLAIMS_ALL
1163: SET broker_id = p_to_fk_id,
1164: last_update_date = hz_utility_pub.last_update_date,
1165: last_updated_by = hz_utility_pub.user_id,
1166: last_update_login = hz_utility_pub.last_update_login,
1167: program_application_id = hz_utility_pub.program_application_id,
1168: program_id = hz_utility_pub.program_id,
1169: program_update_date = sysdate

Line 1166: last_update_login = hz_utility_pub.last_update_login,

1162: UPDATE OZF_CLAIMS_ALL
1163: SET broker_id = p_to_fk_id,
1164: last_update_date = hz_utility_pub.last_update_date,
1165: last_updated_by = hz_utility_pub.user_id,
1166: last_update_login = hz_utility_pub.last_update_login,
1167: program_application_id = hz_utility_pub.program_application_id,
1168: program_id = hz_utility_pub.program_id,
1169: program_update_date = sysdate
1170: where broker_id = p_from_fk_id;

Line 1167: program_application_id = hz_utility_pub.program_application_id,

1163: SET broker_id = p_to_fk_id,
1164: last_update_date = hz_utility_pub.last_update_date,
1165: last_updated_by = hz_utility_pub.user_id,
1166: last_update_login = hz_utility_pub.last_update_login,
1167: program_application_id = hz_utility_pub.program_application_id,
1168: program_id = hz_utility_pub.program_id,
1169: program_update_date = sysdate
1170: where broker_id = p_from_fk_id;
1171:

Line 1168: program_id = hz_utility_pub.program_id,

1164: last_update_date = hz_utility_pub.last_update_date,
1165: last_updated_by = hz_utility_pub.user_id,
1166: last_update_login = hz_utility_pub.last_update_login,
1167: program_application_id = hz_utility_pub.program_application_id,
1168: program_id = hz_utility_pub.program_id,
1169: program_update_date = sysdate
1170: where broker_id = p_from_fk_id;
1171:
1172: END IF;

Line 1234: last_update_date = hz_utility_pub.last_update_date,

1230: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1231:
1232: UPDATE OZF_CLAIMS_ALL
1233: SET contact_id = p_to_fk_id,
1234: last_update_date = hz_utility_pub.last_update_date,
1235: last_updated_by = hz_utility_pub.user_id,
1236: last_update_login = hz_utility_pub.last_update_login,
1237: program_application_id = hz_utility_pub.program_application_id,
1238: program_id = hz_utility_pub.program_id,

Line 1235: last_updated_by = hz_utility_pub.user_id,

1231:
1232: UPDATE OZF_CLAIMS_ALL
1233: SET contact_id = p_to_fk_id,
1234: last_update_date = hz_utility_pub.last_update_date,
1235: last_updated_by = hz_utility_pub.user_id,
1236: last_update_login = hz_utility_pub.last_update_login,
1237: program_application_id = hz_utility_pub.program_application_id,
1238: program_id = hz_utility_pub.program_id,
1239: program_update_date = sysdate

Line 1236: last_update_login = hz_utility_pub.last_update_login,

1232: UPDATE OZF_CLAIMS_ALL
1233: SET contact_id = p_to_fk_id,
1234: last_update_date = hz_utility_pub.last_update_date,
1235: last_updated_by = hz_utility_pub.user_id,
1236: last_update_login = hz_utility_pub.last_update_login,
1237: program_application_id = hz_utility_pub.program_application_id,
1238: program_id = hz_utility_pub.program_id,
1239: program_update_date = sysdate
1240: where contact_id = p_from_fk_id;

Line 1237: program_application_id = hz_utility_pub.program_application_id,

1233: SET contact_id = p_to_fk_id,
1234: last_update_date = hz_utility_pub.last_update_date,
1235: last_updated_by = hz_utility_pub.user_id,
1236: last_update_login = hz_utility_pub.last_update_login,
1237: program_application_id = hz_utility_pub.program_application_id,
1238: program_id = hz_utility_pub.program_id,
1239: program_update_date = sysdate
1240: where contact_id = p_from_fk_id;
1241:

Line 1238: program_id = hz_utility_pub.program_id,

1234: last_update_date = hz_utility_pub.last_update_date,
1235: last_updated_by = hz_utility_pub.user_id,
1236: last_update_login = hz_utility_pub.last_update_login,
1237: program_application_id = hz_utility_pub.program_application_id,
1238: program_id = hz_utility_pub.program_id,
1239: program_update_date = sysdate
1240: where contact_id = p_from_fk_id;
1241:
1242: END IF;

Line 1305: last_update_date = hz_utility_pub.last_update_date,

1301: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1302:
1303: UPDATE OZF_CLAIMS_HISTORY_ALL
1304: SET broker_id = p_to_fk_id,
1305: last_update_date = hz_utility_pub.last_update_date,
1306: last_updated_by = hz_utility_pub.user_id,
1307: last_update_login = hz_utility_pub.last_update_login,
1308: program_application_id = hz_utility_pub.program_application_id,
1309: program_id = hz_utility_pub.program_id,

Line 1306: last_updated_by = hz_utility_pub.user_id,

1302:
1303: UPDATE OZF_CLAIMS_HISTORY_ALL
1304: SET broker_id = p_to_fk_id,
1305: last_update_date = hz_utility_pub.last_update_date,
1306: last_updated_by = hz_utility_pub.user_id,
1307: last_update_login = hz_utility_pub.last_update_login,
1308: program_application_id = hz_utility_pub.program_application_id,
1309: program_id = hz_utility_pub.program_id,
1310: program_update_date = sysdate

Line 1307: last_update_login = hz_utility_pub.last_update_login,

1303: UPDATE OZF_CLAIMS_HISTORY_ALL
1304: SET broker_id = p_to_fk_id,
1305: last_update_date = hz_utility_pub.last_update_date,
1306: last_updated_by = hz_utility_pub.user_id,
1307: last_update_login = hz_utility_pub.last_update_login,
1308: program_application_id = hz_utility_pub.program_application_id,
1309: program_id = hz_utility_pub.program_id,
1310: program_update_date = sysdate
1311: where broker_id = p_from_fk_id;

Line 1308: program_application_id = hz_utility_pub.program_application_id,

1304: SET broker_id = p_to_fk_id,
1305: last_update_date = hz_utility_pub.last_update_date,
1306: last_updated_by = hz_utility_pub.user_id,
1307: last_update_login = hz_utility_pub.last_update_login,
1308: program_application_id = hz_utility_pub.program_application_id,
1309: program_id = hz_utility_pub.program_id,
1310: program_update_date = sysdate
1311: where broker_id = p_from_fk_id;
1312:

Line 1309: program_id = hz_utility_pub.program_id,

1305: last_update_date = hz_utility_pub.last_update_date,
1306: last_updated_by = hz_utility_pub.user_id,
1307: last_update_login = hz_utility_pub.last_update_login,
1308: program_application_id = hz_utility_pub.program_application_id,
1309: program_id = hz_utility_pub.program_id,
1310: program_update_date = sysdate
1311: where broker_id = p_from_fk_id;
1312:
1313: END IF;

Line 1376: last_update_date = hz_utility_pub.last_update_date,

1372: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1373:
1374: UPDATE OZF_CLAIMS_HISTORY_ALL
1375: SET contact_id = p_to_fk_id,
1376: last_update_date = hz_utility_pub.last_update_date,
1377: last_updated_by = hz_utility_pub.user_id,
1378: last_update_login = hz_utility_pub.last_update_login,
1379: program_application_id = hz_utility_pub.program_application_id,
1380: program_id = hz_utility_pub.program_id,

Line 1377: last_updated_by = hz_utility_pub.user_id,

1373:
1374: UPDATE OZF_CLAIMS_HISTORY_ALL
1375: SET contact_id = p_to_fk_id,
1376: last_update_date = hz_utility_pub.last_update_date,
1377: last_updated_by = hz_utility_pub.user_id,
1378: last_update_login = hz_utility_pub.last_update_login,
1379: program_application_id = hz_utility_pub.program_application_id,
1380: program_id = hz_utility_pub.program_id,
1381: program_update_date = sysdate

Line 1378: last_update_login = hz_utility_pub.last_update_login,

1374: UPDATE OZF_CLAIMS_HISTORY_ALL
1375: SET contact_id = p_to_fk_id,
1376: last_update_date = hz_utility_pub.last_update_date,
1377: last_updated_by = hz_utility_pub.user_id,
1378: last_update_login = hz_utility_pub.last_update_login,
1379: program_application_id = hz_utility_pub.program_application_id,
1380: program_id = hz_utility_pub.program_id,
1381: program_update_date = sysdate
1382: where contact_id = p_from_fk_id;

Line 1379: program_application_id = hz_utility_pub.program_application_id,

1375: SET contact_id = p_to_fk_id,
1376: last_update_date = hz_utility_pub.last_update_date,
1377: last_updated_by = hz_utility_pub.user_id,
1378: last_update_login = hz_utility_pub.last_update_login,
1379: program_application_id = hz_utility_pub.program_application_id,
1380: program_id = hz_utility_pub.program_id,
1381: program_update_date = sysdate
1382: where contact_id = p_from_fk_id;
1383:

Line 1380: program_id = hz_utility_pub.program_id,

1376: last_update_date = hz_utility_pub.last_update_date,
1377: last_updated_by = hz_utility_pub.user_id,
1378: last_update_login = hz_utility_pub.last_update_login,
1379: program_application_id = hz_utility_pub.program_application_id,
1380: program_id = hz_utility_pub.program_id,
1381: program_update_date = sysdate
1382: where contact_id = p_from_fk_id;
1383:
1384: END IF;

Line 1446: last_update_date = hz_utility_pub.last_update_date,

1442: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1443:
1444: UPDATE AMS_ACT_BUDGETS
1445: SET budget_source_id = p_to_fk_id,
1446: last_update_date = hz_utility_pub.last_update_date,
1447: last_updated_by = hz_utility_pub.user_id,
1448: last_update_login = hz_utility_pub.last_update_login
1449: -- ,program_application_id = hz_utility_pub.program_application_id,
1450: -- program_id = hz_utility_pub.program_id,

Line 1447: last_updated_by = hz_utility_pub.user_id,

1443:
1444: UPDATE AMS_ACT_BUDGETS
1445: SET budget_source_id = p_to_fk_id,
1446: last_update_date = hz_utility_pub.last_update_date,
1447: last_updated_by = hz_utility_pub.user_id,
1448: last_update_login = hz_utility_pub.last_update_login
1449: -- ,program_application_id = hz_utility_pub.program_application_id,
1450: -- program_id = hz_utility_pub.program_id,
1451: -- program_update_date = sysdate

Line 1448: last_update_login = hz_utility_pub.last_update_login

1444: UPDATE AMS_ACT_BUDGETS
1445: SET budget_source_id = p_to_fk_id,
1446: last_update_date = hz_utility_pub.last_update_date,
1447: last_updated_by = hz_utility_pub.user_id,
1448: last_update_login = hz_utility_pub.last_update_login
1449: -- ,program_application_id = hz_utility_pub.program_application_id,
1450: -- program_id = hz_utility_pub.program_id,
1451: -- program_update_date = sysdate
1452: where budget_source_id = p_from_fk_id

Line 1449: -- ,program_application_id = hz_utility_pub.program_application_id,

1445: SET budget_source_id = p_to_fk_id,
1446: last_update_date = hz_utility_pub.last_update_date,
1447: last_updated_by = hz_utility_pub.user_id,
1448: last_update_login = hz_utility_pub.last_update_login
1449: -- ,program_application_id = hz_utility_pub.program_application_id,
1450: -- program_id = hz_utility_pub.program_id,
1451: -- program_update_date = sysdate
1452: where budget_source_id = p_from_fk_id
1453: and budget_source_type = 'PTNR' ;

Line 1450: -- program_id = hz_utility_pub.program_id,

1446: last_update_date = hz_utility_pub.last_update_date,
1447: last_updated_by = hz_utility_pub.user_id,
1448: last_update_login = hz_utility_pub.last_update_login
1449: -- ,program_application_id = hz_utility_pub.program_application_id,
1450: -- program_id = hz_utility_pub.program_id,
1451: -- program_update_date = sysdate
1452: where budget_source_id = p_from_fk_id
1453: and budget_source_type = 'PTNR' ;
1454:

Line 1517: last_update_date = hz_utility_pub.last_update_date,

1513: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1514:
1515: UPDATE AMS_ACT_BUDGETS
1516: SET vendor_id = p_to_fk_id,
1517: last_update_date = hz_utility_pub.last_update_date,
1518: last_updated_by = hz_utility_pub.user_id,
1519: last_update_login = hz_utility_pub.last_update_login
1520: -- ,program_application_id = hz_utility_pub.program_application_id,
1521: -- program_id = hz_utility_pub.program_id,

Line 1518: last_updated_by = hz_utility_pub.user_id,

1514:
1515: UPDATE AMS_ACT_BUDGETS
1516: SET vendor_id = p_to_fk_id,
1517: last_update_date = hz_utility_pub.last_update_date,
1518: last_updated_by = hz_utility_pub.user_id,
1519: last_update_login = hz_utility_pub.last_update_login
1520: -- ,program_application_id = hz_utility_pub.program_application_id,
1521: -- program_id = hz_utility_pub.program_id,
1522: -- program_update_date = sysdate

Line 1519: last_update_login = hz_utility_pub.last_update_login

1515: UPDATE AMS_ACT_BUDGETS
1516: SET vendor_id = p_to_fk_id,
1517: last_update_date = hz_utility_pub.last_update_date,
1518: last_updated_by = hz_utility_pub.user_id,
1519: last_update_login = hz_utility_pub.last_update_login
1520: -- ,program_application_id = hz_utility_pub.program_application_id,
1521: -- program_id = hz_utility_pub.program_id,
1522: -- program_update_date = sysdate
1523: where vendor_id = p_from_fk_id;

Line 1520: -- ,program_application_id = hz_utility_pub.program_application_id,

1516: SET vendor_id = p_to_fk_id,
1517: last_update_date = hz_utility_pub.last_update_date,
1518: last_updated_by = hz_utility_pub.user_id,
1519: last_update_login = hz_utility_pub.last_update_login
1520: -- ,program_application_id = hz_utility_pub.program_application_id,
1521: -- program_id = hz_utility_pub.program_id,
1522: -- program_update_date = sysdate
1523: where vendor_id = p_from_fk_id;
1524:

Line 1521: -- program_id = hz_utility_pub.program_id,

1517: last_update_date = hz_utility_pub.last_update_date,
1518: last_updated_by = hz_utility_pub.user_id,
1519: last_update_login = hz_utility_pub.last_update_login
1520: -- ,program_application_id = hz_utility_pub.program_application_id,
1521: -- program_id = hz_utility_pub.program_id,
1522: -- program_update_date = sysdate
1523: where vendor_id = p_from_fk_id;
1524:
1525: END IF;

Line 1580: last_update_date = hz_utility_pub.last_update_date,

1576: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1577:
1578: UPDATE AMS_OFFERS
1579: SET BUYING_GROUP_CONTACT_ID = p_to_fk_id,
1580: last_update_date = hz_utility_pub.last_update_date,
1581: last_updated_by = hz_utility_pub.user_id,
1582: last_update_login = hz_utility_pub.last_update_login
1583: where BUYING_GROUP_CONTACT_ID = p_from_fk_id;
1584:

Line 1581: last_updated_by = hz_utility_pub.user_id,

1577:
1578: UPDATE AMS_OFFERS
1579: SET BUYING_GROUP_CONTACT_ID = p_to_fk_id,
1580: last_update_date = hz_utility_pub.last_update_date,
1581: last_updated_by = hz_utility_pub.user_id,
1582: last_update_login = hz_utility_pub.last_update_login
1583: where BUYING_GROUP_CONTACT_ID = p_from_fk_id;
1584:
1585: END IF;

Line 1582: last_update_login = hz_utility_pub.last_update_login

1578: UPDATE AMS_OFFERS
1579: SET BUYING_GROUP_CONTACT_ID = p_to_fk_id,
1580: last_update_date = hz_utility_pub.last_update_date,
1581: last_updated_by = hz_utility_pub.user_id,
1582: last_update_login = hz_utility_pub.last_update_login
1583: where BUYING_GROUP_CONTACT_ID = p_from_fk_id;
1584:
1585: END IF;
1586: EXCEPTION

Line 1648: last_update_date = hz_utility_pub.last_update_date,

1644: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1645:
1646: UPDATE ams_competitor_products_b
1647: SET COMPETITOR_PARTY_ID = p_to_fk_id,
1648: last_update_date = hz_utility_pub.last_update_date,
1649: last_updated_by = hz_utility_pub.user_id,
1650: last_update_login = hz_utility_pub.last_update_login
1651: where COMPETITOR_PARTY_ID = p_from_fk_id ;
1652:

Line 1649: last_updated_by = hz_utility_pub.user_id,

1645:
1646: UPDATE ams_competitor_products_b
1647: SET COMPETITOR_PARTY_ID = p_to_fk_id,
1648: last_update_date = hz_utility_pub.last_update_date,
1649: last_updated_by = hz_utility_pub.user_id,
1650: last_update_login = hz_utility_pub.last_update_login
1651: where COMPETITOR_PARTY_ID = p_from_fk_id ;
1652:
1653: END IF;

Line 1650: last_update_login = hz_utility_pub.last_update_login

1646: UPDATE ams_competitor_products_b
1647: SET COMPETITOR_PARTY_ID = p_to_fk_id,
1648: last_update_date = hz_utility_pub.last_update_date,
1649: last_updated_by = hz_utility_pub.user_id,
1650: last_update_login = hz_utility_pub.last_update_login
1651: where COMPETITOR_PARTY_ID = p_from_fk_id ;
1652:
1653: END IF;
1654: EXCEPTION

Line 1714: last_update_date = hz_utility_pub.last_update_date,

1710: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1711:
1712: UPDATE AMS_IBA_PL_SITES_B
1713: SET SITE_CATEGORY_OBJECT_ID = p_to_fk_id,
1714: last_update_date = hz_utility_pub.last_update_date,
1715: last_updated_by = hz_utility_pub.user_id,
1716: last_update_login = hz_utility_pub.last_update_login
1717: where SITE_CATEGORY_OBJECT_ID = p_from_fk_id
1718: and SITE_CATEGORY_TYPE = 'AFFILIATES' ;

Line 1715: last_updated_by = hz_utility_pub.user_id,

1711:
1712: UPDATE AMS_IBA_PL_SITES_B
1713: SET SITE_CATEGORY_OBJECT_ID = p_to_fk_id,
1714: last_update_date = hz_utility_pub.last_update_date,
1715: last_updated_by = hz_utility_pub.user_id,
1716: last_update_login = hz_utility_pub.last_update_login
1717: where SITE_CATEGORY_OBJECT_ID = p_from_fk_id
1718: and SITE_CATEGORY_TYPE = 'AFFILIATES' ;
1719:

Line 1716: last_update_login = hz_utility_pub.last_update_login

1712: UPDATE AMS_IBA_PL_SITES_B
1713: SET SITE_CATEGORY_OBJECT_ID = p_to_fk_id,
1714: last_update_date = hz_utility_pub.last_update_date,
1715: last_updated_by = hz_utility_pub.user_id,
1716: last_update_login = hz_utility_pub.last_update_login
1717: where SITE_CATEGORY_OBJECT_ID = p_from_fk_id
1718: and SITE_CATEGORY_TYPE = 'AFFILIATES' ;
1719:
1720: END IF;

Line 1820: last_update_date = hz_utility_pub.last_update_date,

1816: -- Following lines of code is added by ptendulk on 14-May-2001
1817: -- to do the party merge for table ams_channels_b
1818: UPDATE AMS_IMP_SOURCE_LINES
1819: SET party_id = p_to_fk_id,
1820: last_update_date = hz_utility_pub.last_update_date,
1821: last_updated_by = hz_utility_pub.user_id,
1822: last_update_login = hz_utility_pub.last_update_login
1823: where party_id = p_from_fk_id;
1824:

Line 1821: last_updated_by = hz_utility_pub.user_id,

1817: -- to do the party merge for table ams_channels_b
1818: UPDATE AMS_IMP_SOURCE_LINES
1819: SET party_id = p_to_fk_id,
1820: last_update_date = hz_utility_pub.last_update_date,
1821: last_updated_by = hz_utility_pub.user_id,
1822: last_update_login = hz_utility_pub.last_update_login
1823: where party_id = p_from_fk_id;
1824:
1825: END IF;

Line 1822: last_update_login = hz_utility_pub.last_update_login

1818: UPDATE AMS_IMP_SOURCE_LINES
1819: SET party_id = p_to_fk_id,
1820: last_update_date = hz_utility_pub.last_update_date,
1821: last_updated_by = hz_utility_pub.user_id,
1822: last_update_login = hz_utility_pub.last_update_login
1823: where party_id = p_from_fk_id;
1824:
1825: END IF;
1826: EXCEPTION

Line 1925: last_update_date = hz_utility_pub.last_update_date,

1921: -- Following lines of code is added by ptendulk on 14-May-2001
1922: -- to do the party merge for table ams_channels_b
1923: UPDATE AMS_LIST_ENTRIES
1924: SET party_id = p_to_fk_id,
1925: last_update_date = hz_utility_pub.last_update_date,
1926: last_updated_by = hz_utility_pub.user_id,
1927: last_update_login = hz_utility_pub.last_update_login
1928: where party_id = p_from_fk_id;
1929:

Line 1926: last_updated_by = hz_utility_pub.user_id,

1922: -- to do the party merge for table ams_channels_b
1923: UPDATE AMS_LIST_ENTRIES
1924: SET party_id = p_to_fk_id,
1925: last_update_date = hz_utility_pub.last_update_date,
1926: last_updated_by = hz_utility_pub.user_id,
1927: last_update_login = hz_utility_pub.last_update_login
1928: where party_id = p_from_fk_id;
1929:
1930: END IF;

Line 1927: last_update_login = hz_utility_pub.last_update_login

1923: UPDATE AMS_LIST_ENTRIES
1924: SET party_id = p_to_fk_id,
1925: last_update_date = hz_utility_pub.last_update_date,
1926: last_updated_by = hz_utility_pub.user_id,
1927: last_update_login = hz_utility_pub.last_update_login
1928: where party_id = p_from_fk_id;
1929:
1930: END IF;
1931: EXCEPTION

Line 2030: last_update_date = hz_utility_pub.last_update_date,

2026: -- Following lines of code is added by ptendulk on 14-May-2001
2027: -- to do the party merge for table ams_channels_b
2028: UPDATE AMS_LIST_ENTRIES
2029: SET parent_party_id = p_to_fk_id,
2030: last_update_date = hz_utility_pub.last_update_date,
2031: last_updated_by = hz_utility_pub.user_id,
2032: last_update_login = hz_utility_pub.last_update_login
2033: where parent_party_id = p_from_fk_id;
2034:

Line 2031: last_updated_by = hz_utility_pub.user_id,

2027: -- to do the party merge for table ams_channels_b
2028: UPDATE AMS_LIST_ENTRIES
2029: SET parent_party_id = p_to_fk_id,
2030: last_update_date = hz_utility_pub.last_update_date,
2031: last_updated_by = hz_utility_pub.user_id,
2032: last_update_login = hz_utility_pub.last_update_login
2033: where parent_party_id = p_from_fk_id;
2034:
2035: END IF;

Line 2032: last_update_login = hz_utility_pub.last_update_login

2028: UPDATE AMS_LIST_ENTRIES
2029: SET parent_party_id = p_to_fk_id,
2030: last_update_date = hz_utility_pub.last_update_date,
2031: last_updated_by = hz_utility_pub.user_id,
2032: last_update_login = hz_utility_pub.last_update_login
2033: where parent_party_id = p_from_fk_id;
2034:
2035: END IF;
2036: EXCEPTION

Line 2135: last_update_date = hz_utility_pub.last_update_date,

2131: -- Following lines of code is added by musman on 6-Mar-2003
2132: -- to do the party merge for table ams_venues_b
2133: UPDATE AMS_VENUES_B
2134: SET party_id = p_to_fk_id,
2135: last_update_date = hz_utility_pub.last_update_date,
2136: last_updated_by = hz_utility_pub.user_id,
2137: last_update_login = hz_utility_pub.last_update_login
2138: --enabled_flag = 'N' -- added to fix bug#3483075:anchaudh
2139: where party_id = p_from_fk_id;

Line 2136: last_updated_by = hz_utility_pub.user_id,

2132: -- to do the party merge for table ams_venues_b
2133: UPDATE AMS_VENUES_B
2134: SET party_id = p_to_fk_id,
2135: last_update_date = hz_utility_pub.last_update_date,
2136: last_updated_by = hz_utility_pub.user_id,
2137: last_update_login = hz_utility_pub.last_update_login
2138: --enabled_flag = 'N' -- added to fix bug#3483075:anchaudh
2139: where party_id = p_from_fk_id;
2140:

Line 2137: last_update_login = hz_utility_pub.last_update_login

2133: UPDATE AMS_VENUES_B
2134: SET party_id = p_to_fk_id,
2135: last_update_date = hz_utility_pub.last_update_date,
2136: last_updated_by = hz_utility_pub.user_id,
2137: last_update_login = hz_utility_pub.last_update_login
2138: --enabled_flag = 'N' -- added to fix bug#3483075:anchaudh
2139: where party_id = p_from_fk_id;
2140:
2141: END IF;

Line 2264: ,last_update_date = hz_utility_pub.last_update_date

2260: AND party_id = p_from_fk_id;
2261: ELSE
2262: UPDATE ams_offer_parties
2263: SET party_id = p_to_fk_id
2264: ,last_update_date = hz_utility_pub.last_update_date
2265: ,last_updated_by = hz_utility_pub.user_id
2266: ,last_update_login = hz_utility_pub.last_update_login
2267: WHERE qp_list_header_id = l_list_header_id.qp_list_header_id
2268: AND party_id = p_from_fk_id;

Line 2265: ,last_updated_by = hz_utility_pub.user_id

2261: ELSE
2262: UPDATE ams_offer_parties
2263: SET party_id = p_to_fk_id
2264: ,last_update_date = hz_utility_pub.last_update_date
2265: ,last_updated_by = hz_utility_pub.user_id
2266: ,last_update_login = hz_utility_pub.last_update_login
2267: WHERE qp_list_header_id = l_list_header_id.qp_list_header_id
2268: AND party_id = p_from_fk_id;
2269: END IF;

Line 2266: ,last_update_login = hz_utility_pub.last_update_login

2262: UPDATE ams_offer_parties
2263: SET party_id = p_to_fk_id
2264: ,last_update_date = hz_utility_pub.last_update_date
2265: ,last_updated_by = hz_utility_pub.user_id
2266: ,last_update_login = hz_utility_pub.last_update_login
2267: WHERE qp_list_header_id = l_list_header_id.qp_list_header_id
2268: AND party_id = p_from_fk_id;
2269: END IF;
2270:

Line 2381: last_update_date = hz_utility_pub.last_update_date,

2377: -- to do the party merge for table ams_act_resources
2378:
2379: UPDATE AMS_ACT_RESOURCES
2380: SET resource_id = p_to_fk_id,
2381: last_update_date = hz_utility_pub.last_update_date,
2382: last_updated_by = hz_utility_pub.user_id,
2383: last_update_login = hz_utility_pub.last_update_login
2384: where resource_id = p_from_fk_id;
2385:

Line 2382: last_updated_by = hz_utility_pub.user_id,

2378:
2379: UPDATE AMS_ACT_RESOURCES
2380: SET resource_id = p_to_fk_id,
2381: last_update_date = hz_utility_pub.last_update_date,
2382: last_updated_by = hz_utility_pub.user_id,
2383: last_update_login = hz_utility_pub.last_update_login
2384: where resource_id = p_from_fk_id;
2385:
2386: END IF;

Line 2383: last_update_login = hz_utility_pub.last_update_login

2379: UPDATE AMS_ACT_RESOURCES
2380: SET resource_id = p_to_fk_id,
2381: last_update_date = hz_utility_pub.last_update_date,
2382: last_updated_by = hz_utility_pub.user_id,
2383: last_update_login = hz_utility_pub.last_update_login
2384: where resource_id = p_from_fk_id;
2385:
2386: END IF;
2387: EXCEPTION

Line 2491: last_update_date = hz_utility_pub.last_update_date,

2487: -- Following lines of code is added by dbiswas on 09-Mar-2003
2488: -- to do the party merge for table ams_agendas_b
2489: UPDATE AMS_AGENDAS_B
2490: SET coordinator_id = p_to_fk_id,
2491: last_update_date = hz_utility_pub.last_update_date,
2492: last_updated_by = hz_utility_pub.user_id,
2493: last_update_login = hz_utility_pub.last_update_login
2494: where coordinator_id = p_from_fk_id;
2495:

Line 2492: last_updated_by = hz_utility_pub.user_id,

2488: -- to do the party merge for table ams_agendas_b
2489: UPDATE AMS_AGENDAS_B
2490: SET coordinator_id = p_to_fk_id,
2491: last_update_date = hz_utility_pub.last_update_date,
2492: last_updated_by = hz_utility_pub.user_id,
2493: last_update_login = hz_utility_pub.last_update_login
2494: where coordinator_id = p_from_fk_id;
2495:
2496: END IF;

Line 2493: last_update_login = hz_utility_pub.last_update_login

2489: UPDATE AMS_AGENDAS_B
2490: SET coordinator_id = p_to_fk_id,
2491: last_update_date = hz_utility_pub.last_update_date,
2492: last_updated_by = hz_utility_pub.user_id,
2493: last_update_login = hz_utility_pub.last_update_login
2494: where coordinator_id = p_from_fk_id;
2495:
2496: END IF;
2497: EXCEPTION

Line 2611: last_update_date = hz_utility_pub.last_update_date,

2607:
2608: -- Update the rows which do not satisfy the above criteria
2609: UPDATE AMS_TCOP_CHANNEL_SUMMARY
2610: SET party_id = p_to_fk_id,
2611: last_update_date = hz_utility_pub.last_update_date,
2612: last_updated_by = hz_utility_pub.user_id,
2613: last_update_login = hz_utility_pub.last_update_login
2614: WHERE party_id = p_from_fk_id
2615: and channel_summary_id not in

Line 2612: last_updated_by = hz_utility_pub.user_id,

2608: -- Update the rows which do not satisfy the above criteria
2609: UPDATE AMS_TCOP_CHANNEL_SUMMARY
2610: SET party_id = p_to_fk_id,
2611: last_update_date = hz_utility_pub.last_update_date,
2612: last_updated_by = hz_utility_pub.user_id,
2613: last_update_login = hz_utility_pub.last_update_login
2614: WHERE party_id = p_from_fk_id
2615: and channel_summary_id not in
2616: (SELECT f.channel_summary_id

Line 2613: last_update_login = hz_utility_pub.last_update_login

2609: UPDATE AMS_TCOP_CHANNEL_SUMMARY
2610: SET party_id = p_to_fk_id,
2611: last_update_date = hz_utility_pub.last_update_date,
2612: last_updated_by = hz_utility_pub.user_id,
2613: last_update_login = hz_utility_pub.last_update_login
2614: WHERE party_id = p_from_fk_id
2615: and channel_summary_id not in
2616: (SELECT f.channel_summary_id
2617: FROM AMS_TCOP_CHANNEL_SUMMARY f, AMS_TCOP_CHANNEL_SUMMARY t

Line 2739: last_update_date = hz_utility_pub.last_update_date,

2735:
2736:
2737: UPDATE AMS_TCOP_CONTACTS
2738: SET party_id = p_to_fk_id,
2739: last_update_date = hz_utility_pub.last_update_date,
2740: last_updated_by = hz_utility_pub.user_id,
2741: last_update_login = hz_utility_pub.last_update_login
2742: WHERE party_id = p_from_fk_id
2743: and CONTACT_ID not in

Line 2740: last_updated_by = hz_utility_pub.user_id,

2736:
2737: UPDATE AMS_TCOP_CONTACTS
2738: SET party_id = p_to_fk_id,
2739: last_update_date = hz_utility_pub.last_update_date,
2740: last_updated_by = hz_utility_pub.user_id,
2741: last_update_login = hz_utility_pub.last_update_login
2742: WHERE party_id = p_from_fk_id
2743: and CONTACT_ID not in
2744: (SELECT f.CONTACT_ID

Line 2741: last_update_login = hz_utility_pub.last_update_login

2737: UPDATE AMS_TCOP_CONTACTS
2738: SET party_id = p_to_fk_id,
2739: last_update_date = hz_utility_pub.last_update_date,
2740: last_updated_by = hz_utility_pub.user_id,
2741: last_update_login = hz_utility_pub.last_update_login
2742: WHERE party_id = p_from_fk_id
2743: and CONTACT_ID not in
2744: (SELECT f.CONTACT_ID
2745: FROM AMS_TCOP_CONTACTS f, AMS_TCOP_CONTACTS t

Line 2879: last_update_date = hz_utility_pub.last_update_date,

2875:
2876: ELSE
2877: UPDATE AMS_TCOP_CONTACT_SUMMARY
2878: SET party_id = p_to_fk_id,
2879: last_update_date = hz_utility_pub.last_update_date,
2880: last_updated_by = hz_utility_pub.user_id,
2881: last_update_login = hz_utility_pub.last_update_login
2882: WHERE party_id = p_from_fk_id;
2883: END IF;

Line 2880: last_updated_by = hz_utility_pub.user_id,

2876: ELSE
2877: UPDATE AMS_TCOP_CONTACT_SUMMARY
2878: SET party_id = p_to_fk_id,
2879: last_update_date = hz_utility_pub.last_update_date,
2880: last_updated_by = hz_utility_pub.user_id,
2881: last_update_login = hz_utility_pub.last_update_login
2882: WHERE party_id = p_from_fk_id;
2883: END IF;
2884:

Line 2881: last_update_login = hz_utility_pub.last_update_login

2877: UPDATE AMS_TCOP_CONTACT_SUMMARY
2878: SET party_id = p_to_fk_id,
2879: last_update_date = hz_utility_pub.last_update_date,
2880: last_updated_by = hz_utility_pub.user_id,
2881: last_update_login = hz_utility_pub.last_update_login
2882: WHERE party_id = p_from_fk_id;
2883: END IF;
2884:
2885: END IF;

Line 2991: last_update_date = hz_utility_pub.last_update_date,

2987:
2988:
2989: UPDATE AMS_TCOP_PRVW_CONTACTS
2990: SET party_id = p_to_fk_id,
2991: last_update_date = hz_utility_pub.last_update_date,
2992: last_updated_by = hz_utility_pub.user_id,
2993: last_update_login = hz_utility_pub.last_update_login
2994: WHERE party_id = p_from_fk_id;
2995:

Line 2992: last_updated_by = hz_utility_pub.user_id,

2988:
2989: UPDATE AMS_TCOP_PRVW_CONTACTS
2990: SET party_id = p_to_fk_id,
2991: last_update_date = hz_utility_pub.last_update_date,
2992: last_updated_by = hz_utility_pub.user_id,
2993: last_update_login = hz_utility_pub.last_update_login
2994: WHERE party_id = p_from_fk_id;
2995:
2996: END IF;

Line 2993: last_update_login = hz_utility_pub.last_update_login

2989: UPDATE AMS_TCOP_PRVW_CONTACTS
2990: SET party_id = p_to_fk_id,
2991: last_update_date = hz_utility_pub.last_update_date,
2992: last_updated_by = hz_utility_pub.user_id,
2993: last_update_login = hz_utility_pub.last_update_login
2994: WHERE party_id = p_from_fk_id;
2995:
2996: END IF;
2997: EXCEPTION

Line 3109: last_update_date = hz_utility_pub.last_update_date,

3105: AND f.PREVIEW_ID = t.PREVIEW_ID);
3106:
3107: UPDATE AMS_TCOP_PRVW_FTG_DTLS
3108: SET party_id = p_to_fk_id,
3109: last_update_date = hz_utility_pub.last_update_date,
3110: last_updated_by = hz_utility_pub.user_id,
3111: last_update_login = hz_utility_pub.last_update_login
3112: where party_id = p_from_fk_id
3113: and FATIGUE_DETAIL_ID not in

Line 3110: last_updated_by = hz_utility_pub.user_id,

3106:
3107: UPDATE AMS_TCOP_PRVW_FTG_DTLS
3108: SET party_id = p_to_fk_id,
3109: last_update_date = hz_utility_pub.last_update_date,
3110: last_updated_by = hz_utility_pub.user_id,
3111: last_update_login = hz_utility_pub.last_update_login
3112: where party_id = p_from_fk_id
3113: and FATIGUE_DETAIL_ID not in
3114: (SELECT f.FATIGUE_DETAIL_ID

Line 3111: last_update_login = hz_utility_pub.last_update_login

3107: UPDATE AMS_TCOP_PRVW_FTG_DTLS
3108: SET party_id = p_to_fk_id,
3109: last_update_date = hz_utility_pub.last_update_date,
3110: last_updated_by = hz_utility_pub.user_id,
3111: last_update_login = hz_utility_pub.last_update_login
3112: where party_id = p_from_fk_id
3113: and FATIGUE_DETAIL_ID not in
3114: (SELECT f.FATIGUE_DETAIL_ID
3115: FROM AMS_TCOP_PRVW_FTG_DTLS f, AMS_TCOP_PRVW_FTG_DTLS t