APPS.OZF_PARTY_MERGE_PVT dependencies on HZ_UTILITY_PUB

Line 87: last_update_date = hz_utility_pub.last_update_date,

83: IF l_to_party_exists = 'FALSE' THEN
84: -- update the from party profile to to_party
85: UPDATE OZF_CUST_TRD_PRFLS_ALL
86: SET party_id = p_to_fk_id,
87: last_update_date = hz_utility_pub.last_update_date,
88: last_updated_by = hz_utility_pub.user_id,
89: last_update_login = hz_utility_pub.last_update_login,
90: program_application_id = hz_utility_pub.program_application_id,
91: program_id = hz_utility_pub.program_id,

Line 88: last_updated_by = hz_utility_pub.user_id,

84: -- update the from party profile to to_party
85: UPDATE OZF_CUST_TRD_PRFLS_ALL
86: SET party_id = p_to_fk_id,
87: last_update_date = hz_utility_pub.last_update_date,
88: last_updated_by = hz_utility_pub.user_id,
89: last_update_login = hz_utility_pub.last_update_login,
90: program_application_id = hz_utility_pub.program_application_id,
91: program_id = hz_utility_pub.program_id,
92: program_update_date = sysdate

Line 89: last_update_login = hz_utility_pub.last_update_login,

85: UPDATE OZF_CUST_TRD_PRFLS_ALL
86: SET party_id = p_to_fk_id,
87: last_update_date = hz_utility_pub.last_update_date,
88: last_updated_by = hz_utility_pub.user_id,
89: last_update_login = hz_utility_pub.last_update_login,
90: program_application_id = hz_utility_pub.program_application_id,
91: program_id = hz_utility_pub.program_id,
92: program_update_date = sysdate
93: where party_id = p_from_fk_id;

Line 90: program_application_id = hz_utility_pub.program_application_id,

86: SET party_id = p_to_fk_id,
87: last_update_date = hz_utility_pub.last_update_date,
88: last_updated_by = hz_utility_pub.user_id,
89: last_update_login = hz_utility_pub.last_update_login,
90: program_application_id = hz_utility_pub.program_application_id,
91: program_id = hz_utility_pub.program_id,
92: program_update_date = sysdate
93: where party_id = p_from_fk_id;
94: ELSIF l_to_party_exists = 'TRUE' THEN

Line 91: program_id = hz_utility_pub.program_id,

87: last_update_date = hz_utility_pub.last_update_date,
88: last_updated_by = hz_utility_pub.user_id,
89: last_update_login = hz_utility_pub.last_update_login,
90: program_application_id = hz_utility_pub.program_application_id,
91: program_id = hz_utility_pub.program_id,
92: program_update_date = sysdate
93: where party_id = p_from_fk_id;
94: ELSIF l_to_party_exists = 'TRUE' THEN
95: -- delete the from party profile since to_party profile exists

Line 162: last_update_date = hz_utility_pub.last_update_date,

158: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
159:
160: UPDATE OZF_CLAIMS_ALL
161: SET broker_id = p_to_fk_id,
162: last_update_date = hz_utility_pub.last_update_date,
163: last_updated_by = hz_utility_pub.user_id,
164: last_update_login = hz_utility_pub.last_update_login,
165: program_application_id = hz_utility_pub.program_application_id,
166: program_id = hz_utility_pub.program_id,

Line 163: last_updated_by = hz_utility_pub.user_id,

159:
160: UPDATE OZF_CLAIMS_ALL
161: SET broker_id = p_to_fk_id,
162: last_update_date = hz_utility_pub.last_update_date,
163: last_updated_by = hz_utility_pub.user_id,
164: last_update_login = hz_utility_pub.last_update_login,
165: program_application_id = hz_utility_pub.program_application_id,
166: program_id = hz_utility_pub.program_id,
167: program_update_date = sysdate

Line 164: last_update_login = hz_utility_pub.last_update_login,

160: UPDATE OZF_CLAIMS_ALL
161: SET broker_id = p_to_fk_id,
162: last_update_date = hz_utility_pub.last_update_date,
163: last_updated_by = hz_utility_pub.user_id,
164: last_update_login = hz_utility_pub.last_update_login,
165: program_application_id = hz_utility_pub.program_application_id,
166: program_id = hz_utility_pub.program_id,
167: program_update_date = sysdate
168: where broker_id = p_from_fk_id;

Line 165: program_application_id = hz_utility_pub.program_application_id,

161: SET broker_id = p_to_fk_id,
162: last_update_date = hz_utility_pub.last_update_date,
163: last_updated_by = hz_utility_pub.user_id,
164: last_update_login = hz_utility_pub.last_update_login,
165: program_application_id = hz_utility_pub.program_application_id,
166: program_id = hz_utility_pub.program_id,
167: program_update_date = sysdate
168: where broker_id = p_from_fk_id;
169:

Line 166: program_id = hz_utility_pub.program_id,

162: last_update_date = hz_utility_pub.last_update_date,
163: last_updated_by = hz_utility_pub.user_id,
164: last_update_login = hz_utility_pub.last_update_login,
165: program_application_id = hz_utility_pub.program_application_id,
166: program_id = hz_utility_pub.program_id,
167: program_update_date = sysdate
168: where broker_id = p_from_fk_id;
169:
170: END IF;

Line 231: last_update_date = hz_utility_pub.last_update_date,

227: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
228:
229: UPDATE OZF_CLAIMS_ALL
230: SET contact_id = p_to_fk_id,
231: last_update_date = hz_utility_pub.last_update_date,
232: last_updated_by = hz_utility_pub.user_id,
233: last_update_login = hz_utility_pub.last_update_login,
234: program_application_id = hz_utility_pub.program_application_id,
235: program_id = hz_utility_pub.program_id,

Line 232: last_updated_by = hz_utility_pub.user_id,

228:
229: UPDATE OZF_CLAIMS_ALL
230: SET contact_id = p_to_fk_id,
231: last_update_date = hz_utility_pub.last_update_date,
232: last_updated_by = hz_utility_pub.user_id,
233: last_update_login = hz_utility_pub.last_update_login,
234: program_application_id = hz_utility_pub.program_application_id,
235: program_id = hz_utility_pub.program_id,
236: program_update_date = sysdate

Line 233: last_update_login = hz_utility_pub.last_update_login,

229: UPDATE OZF_CLAIMS_ALL
230: SET contact_id = p_to_fk_id,
231: last_update_date = hz_utility_pub.last_update_date,
232: last_updated_by = hz_utility_pub.user_id,
233: last_update_login = hz_utility_pub.last_update_login,
234: program_application_id = hz_utility_pub.program_application_id,
235: program_id = hz_utility_pub.program_id,
236: program_update_date = sysdate
237: where contact_id = p_from_fk_id;

Line 234: program_application_id = hz_utility_pub.program_application_id,

230: SET contact_id = p_to_fk_id,
231: last_update_date = hz_utility_pub.last_update_date,
232: last_updated_by = hz_utility_pub.user_id,
233: last_update_login = hz_utility_pub.last_update_login,
234: program_application_id = hz_utility_pub.program_application_id,
235: program_id = hz_utility_pub.program_id,
236: program_update_date = sysdate
237: where contact_id = p_from_fk_id;
238:

Line 235: program_id = hz_utility_pub.program_id,

231: last_update_date = hz_utility_pub.last_update_date,
232: last_updated_by = hz_utility_pub.user_id,
233: last_update_login = hz_utility_pub.last_update_login,
234: program_application_id = hz_utility_pub.program_application_id,
235: program_id = hz_utility_pub.program_id,
236: program_update_date = sysdate
237: where contact_id = p_from_fk_id;
238:
239: END IF;

Line 301: last_update_date = hz_utility_pub.last_update_date,

297: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
298:
299: UPDATE OZF_CLAIMS_HISTORY_ALL
300: SET broker_id = p_to_fk_id,
301: last_update_date = hz_utility_pub.last_update_date,
302: last_updated_by = hz_utility_pub.user_id,
303: last_update_login = hz_utility_pub.last_update_login,
304: program_application_id = hz_utility_pub.program_application_id,
305: program_id = hz_utility_pub.program_id,

Line 302: last_updated_by = hz_utility_pub.user_id,

298:
299: UPDATE OZF_CLAIMS_HISTORY_ALL
300: SET broker_id = p_to_fk_id,
301: last_update_date = hz_utility_pub.last_update_date,
302: last_updated_by = hz_utility_pub.user_id,
303: last_update_login = hz_utility_pub.last_update_login,
304: program_application_id = hz_utility_pub.program_application_id,
305: program_id = hz_utility_pub.program_id,
306: program_update_date = sysdate

Line 303: last_update_login = hz_utility_pub.last_update_login,

299: UPDATE OZF_CLAIMS_HISTORY_ALL
300: SET broker_id = p_to_fk_id,
301: last_update_date = hz_utility_pub.last_update_date,
302: last_updated_by = hz_utility_pub.user_id,
303: last_update_login = hz_utility_pub.last_update_login,
304: program_application_id = hz_utility_pub.program_application_id,
305: program_id = hz_utility_pub.program_id,
306: program_update_date = sysdate
307: where broker_id = p_from_fk_id;

Line 304: program_application_id = hz_utility_pub.program_application_id,

300: SET broker_id = p_to_fk_id,
301: last_update_date = hz_utility_pub.last_update_date,
302: last_updated_by = hz_utility_pub.user_id,
303: last_update_login = hz_utility_pub.last_update_login,
304: program_application_id = hz_utility_pub.program_application_id,
305: program_id = hz_utility_pub.program_id,
306: program_update_date = sysdate
307: where broker_id = p_from_fk_id;
308:

Line 305: program_id = hz_utility_pub.program_id,

301: last_update_date = hz_utility_pub.last_update_date,
302: last_updated_by = hz_utility_pub.user_id,
303: last_update_login = hz_utility_pub.last_update_login,
304: program_application_id = hz_utility_pub.program_application_id,
305: program_id = hz_utility_pub.program_id,
306: program_update_date = sysdate
307: where broker_id = p_from_fk_id;
308:
309: END IF;

Line 371: last_update_date = hz_utility_pub.last_update_date,

367: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
368:
369: UPDATE OZF_CLAIMS_HISTORY_ALL
370: SET contact_id = p_to_fk_id,
371: last_update_date = hz_utility_pub.last_update_date,
372: last_updated_by = hz_utility_pub.user_id,
373: last_update_login = hz_utility_pub.last_update_login,
374: program_application_id = hz_utility_pub.program_application_id,
375: program_id = hz_utility_pub.program_id,

Line 372: last_updated_by = hz_utility_pub.user_id,

368:
369: UPDATE OZF_CLAIMS_HISTORY_ALL
370: SET contact_id = p_to_fk_id,
371: last_update_date = hz_utility_pub.last_update_date,
372: last_updated_by = hz_utility_pub.user_id,
373: last_update_login = hz_utility_pub.last_update_login,
374: program_application_id = hz_utility_pub.program_application_id,
375: program_id = hz_utility_pub.program_id,
376: program_update_date = sysdate

Line 373: last_update_login = hz_utility_pub.last_update_login,

369: UPDATE OZF_CLAIMS_HISTORY_ALL
370: SET contact_id = p_to_fk_id,
371: last_update_date = hz_utility_pub.last_update_date,
372: last_updated_by = hz_utility_pub.user_id,
373: last_update_login = hz_utility_pub.last_update_login,
374: program_application_id = hz_utility_pub.program_application_id,
375: program_id = hz_utility_pub.program_id,
376: program_update_date = sysdate
377: where contact_id = p_from_fk_id;

Line 374: program_application_id = hz_utility_pub.program_application_id,

370: SET contact_id = p_to_fk_id,
371: last_update_date = hz_utility_pub.last_update_date,
372: last_updated_by = hz_utility_pub.user_id,
373: last_update_login = hz_utility_pub.last_update_login,
374: program_application_id = hz_utility_pub.program_application_id,
375: program_id = hz_utility_pub.program_id,
376: program_update_date = sysdate
377: where contact_id = p_from_fk_id;
378:

Line 375: program_id = hz_utility_pub.program_id,

371: last_update_date = hz_utility_pub.last_update_date,
372: last_updated_by = hz_utility_pub.user_id,
373: last_update_login = hz_utility_pub.last_update_login,
374: program_application_id = hz_utility_pub.program_application_id,
375: program_id = hz_utility_pub.program_id,
376: program_update_date = sysdate
377: where contact_id = p_from_fk_id;
378:
379: END IF;

Line 440: last_update_date = hz_utility_pub.last_update_date,

436: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
437:
438: UPDATE OZF_ACT_BUDGETS
439: SET budget_source_id = p_to_fk_id,
440: last_update_date = hz_utility_pub.last_update_date,
441: last_updated_by = hz_utility_pub.user_id,
442: last_update_login = hz_utility_pub.last_update_login
443: -- ,program_application_id = hz_utility_pub.program_application_id,
444: -- program_id = hz_utility_pub.program_id,

Line 441: last_updated_by = hz_utility_pub.user_id,

437:
438: UPDATE OZF_ACT_BUDGETS
439: SET budget_source_id = p_to_fk_id,
440: last_update_date = hz_utility_pub.last_update_date,
441: last_updated_by = hz_utility_pub.user_id,
442: last_update_login = hz_utility_pub.last_update_login
443: -- ,program_application_id = hz_utility_pub.program_application_id,
444: -- program_id = hz_utility_pub.program_id,
445: -- program_update_date = sysdate

Line 442: last_update_login = hz_utility_pub.last_update_login

438: UPDATE OZF_ACT_BUDGETS
439: SET budget_source_id = p_to_fk_id,
440: last_update_date = hz_utility_pub.last_update_date,
441: last_updated_by = hz_utility_pub.user_id,
442: last_update_login = hz_utility_pub.last_update_login
443: -- ,program_application_id = hz_utility_pub.program_application_id,
444: -- program_id = hz_utility_pub.program_id,
445: -- program_update_date = sysdate
446: where budget_source_id = p_from_fk_id

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

439: SET budget_source_id = p_to_fk_id,
440: last_update_date = hz_utility_pub.last_update_date,
441: last_updated_by = hz_utility_pub.user_id,
442: last_update_login = hz_utility_pub.last_update_login
443: -- ,program_application_id = hz_utility_pub.program_application_id,
444: -- program_id = hz_utility_pub.program_id,
445: -- program_update_date = sysdate
446: where budget_source_id = p_from_fk_id
447: and budget_source_type = 'PTNR' ;

Line 444: -- program_id = hz_utility_pub.program_id,

440: last_update_date = hz_utility_pub.last_update_date,
441: last_updated_by = hz_utility_pub.user_id,
442: last_update_login = hz_utility_pub.last_update_login
443: -- ,program_application_id = hz_utility_pub.program_application_id,
444: -- program_id = hz_utility_pub.program_id,
445: -- program_update_date = sysdate
446: where budget_source_id = p_from_fk_id
447: and budget_source_type = 'PTNR' ;
448:

Line 510: last_update_date = hz_utility_pub.last_update_date,

506: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
507:
508: UPDATE OZF_ACT_BUDGETS
509: SET vendor_id = p_to_fk_id,
510: last_update_date = hz_utility_pub.last_update_date,
511: last_updated_by = hz_utility_pub.user_id,
512: last_update_login = hz_utility_pub.last_update_login
513: -- ,program_application_id = hz_utility_pub.program_application_id,
514: -- program_id = hz_utility_pub.program_id,

Line 511: last_updated_by = hz_utility_pub.user_id,

507:
508: UPDATE OZF_ACT_BUDGETS
509: SET vendor_id = p_to_fk_id,
510: last_update_date = hz_utility_pub.last_update_date,
511: last_updated_by = hz_utility_pub.user_id,
512: last_update_login = hz_utility_pub.last_update_login
513: -- ,program_application_id = hz_utility_pub.program_application_id,
514: -- program_id = hz_utility_pub.program_id,
515: -- program_update_date = sysdate

Line 512: last_update_login = hz_utility_pub.last_update_login

508: UPDATE OZF_ACT_BUDGETS
509: SET vendor_id = p_to_fk_id,
510: last_update_date = hz_utility_pub.last_update_date,
511: last_updated_by = hz_utility_pub.user_id,
512: last_update_login = hz_utility_pub.last_update_login
513: -- ,program_application_id = hz_utility_pub.program_application_id,
514: -- program_id = hz_utility_pub.program_id,
515: -- program_update_date = sysdate
516: where vendor_id = p_from_fk_id;

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

509: SET vendor_id = p_to_fk_id,
510: last_update_date = hz_utility_pub.last_update_date,
511: last_updated_by = hz_utility_pub.user_id,
512: last_update_login = hz_utility_pub.last_update_login
513: -- ,program_application_id = hz_utility_pub.program_application_id,
514: -- program_id = hz_utility_pub.program_id,
515: -- program_update_date = sysdate
516: where vendor_id = p_from_fk_id;
517:

Line 514: -- program_id = hz_utility_pub.program_id,

510: last_update_date = hz_utility_pub.last_update_date,
511: last_updated_by = hz_utility_pub.user_id,
512: last_update_login = hz_utility_pub.last_update_login
513: -- ,program_application_id = hz_utility_pub.program_application_id,
514: -- program_id = hz_utility_pub.program_id,
515: -- program_update_date = sysdate
516: where vendor_id = p_from_fk_id;
517:
518: END IF;

Line 572: last_update_date = hz_utility_pub.last_update_date,

568: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
569:
570: UPDATE OZF_OFFERS
571: SET BUYING_GROUP_CONTACT_ID = p_to_fk_id,
572: last_update_date = hz_utility_pub.last_update_date,
573: last_updated_by = hz_utility_pub.user_id,
574: last_update_login = hz_utility_pub.last_update_login
575: where BUYING_GROUP_CONTACT_ID = p_from_fk_id;
576:

Line 573: last_updated_by = hz_utility_pub.user_id,

569:
570: UPDATE OZF_OFFERS
571: SET BUYING_GROUP_CONTACT_ID = p_to_fk_id,
572: last_update_date = hz_utility_pub.last_update_date,
573: last_updated_by = hz_utility_pub.user_id,
574: last_update_login = hz_utility_pub.last_update_login
575: where BUYING_GROUP_CONTACT_ID = p_from_fk_id;
576:
577: END IF;

Line 574: last_update_login = hz_utility_pub.last_update_login

570: UPDATE OZF_OFFERS
571: SET BUYING_GROUP_CONTACT_ID = p_to_fk_id,
572: last_update_date = hz_utility_pub.last_update_date,
573: last_updated_by = hz_utility_pub.user_id,
574: last_update_login = hz_utility_pub.last_update_login
575: where BUYING_GROUP_CONTACT_ID = p_from_fk_id;
576:
577: END IF;
578: EXCEPTION

Line 703: ,last_update_date = hz_utility_pub.last_update_date

699: AND party_id = p_from_fk_id;
700: ELSE*/
701: UPDATE ozf_activity_customers
702: SET party_id = p_to_fk_id
703: ,last_update_date = hz_utility_pub.last_update_date
704: ,last_updated_by = hz_utility_pub.user_id
705: ,last_update_login = hz_utility_pub.last_update_login
706: WHERE party_id = p_from_fk_id;
707: -- END IF;

Line 704: ,last_updated_by = hz_utility_pub.user_id

700: ELSE*/
701: UPDATE ozf_activity_customers
702: SET party_id = p_to_fk_id
703: ,last_update_date = hz_utility_pub.last_update_date
704: ,last_updated_by = hz_utility_pub.user_id
705: ,last_update_login = hz_utility_pub.last_update_login
706: WHERE party_id = p_from_fk_id;
707: -- END IF;
708:

Line 705: ,last_update_login = hz_utility_pub.last_update_login

701: UPDATE ozf_activity_customers
702: SET party_id = p_to_fk_id
703: ,last_update_date = hz_utility_pub.last_update_date
704: ,last_updated_by = hz_utility_pub.user_id
705: ,last_update_login = hz_utility_pub.last_update_login
706: WHERE party_id = p_from_fk_id;
707: -- END IF;
708:
709: -- END LOOP;

Line 772: last_update_date = hz_utility_pub.last_update_date,

768: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
769:
770: UPDATE OZF_CLAIM_LINES_ALL
771: SET buy_group_party_id = p_to_fk_id,
772: last_update_date = hz_utility_pub.last_update_date,
773: last_updated_by = hz_utility_pub.user_id,
774: last_update_login = hz_utility_pub.last_update_login,
775: program_application_id = hz_utility_pub.program_application_id,
776: program_id = hz_utility_pub.program_id,

Line 773: last_updated_by = hz_utility_pub.user_id,

769:
770: UPDATE OZF_CLAIM_LINES_ALL
771: SET buy_group_party_id = p_to_fk_id,
772: last_update_date = hz_utility_pub.last_update_date,
773: last_updated_by = hz_utility_pub.user_id,
774: last_update_login = hz_utility_pub.last_update_login,
775: program_application_id = hz_utility_pub.program_application_id,
776: program_id = hz_utility_pub.program_id,
777: program_update_date = sysdate

Line 774: last_update_login = hz_utility_pub.last_update_login,

770: UPDATE OZF_CLAIM_LINES_ALL
771: SET buy_group_party_id = p_to_fk_id,
772: last_update_date = hz_utility_pub.last_update_date,
773: last_updated_by = hz_utility_pub.user_id,
774: last_update_login = hz_utility_pub.last_update_login,
775: program_application_id = hz_utility_pub.program_application_id,
776: program_id = hz_utility_pub.program_id,
777: program_update_date = sysdate
778: where buy_group_party_id = p_from_fk_id;

Line 775: program_application_id = hz_utility_pub.program_application_id,

771: SET buy_group_party_id = p_to_fk_id,
772: last_update_date = hz_utility_pub.last_update_date,
773: last_updated_by = hz_utility_pub.user_id,
774: last_update_login = hz_utility_pub.last_update_login,
775: program_application_id = hz_utility_pub.program_application_id,
776: program_id = hz_utility_pub.program_id,
777: program_update_date = sysdate
778: where buy_group_party_id = p_from_fk_id;
779:

Line 776: program_id = hz_utility_pub.program_id,

772: last_update_date = hz_utility_pub.last_update_date,
773: last_updated_by = hz_utility_pub.user_id,
774: last_update_login = hz_utility_pub.last_update_login,
775: program_application_id = hz_utility_pub.program_application_id,
776: program_id = hz_utility_pub.program_id,
777: program_update_date = sysdate
778: where buy_group_party_id = p_from_fk_id;
779:
780: END IF;

Line 841: last_update_date = hz_utility_pub.last_update_date,

837: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
838:
839: UPDATE OZF_CLAIM_LINES_HIST_ALL
840: SET buy_group_party_id = p_to_fk_id,
841: last_update_date = hz_utility_pub.last_update_date,
842: last_updated_by = hz_utility_pub.user_id,
843: last_update_login = hz_utility_pub.last_update_login,
844: program_application_id = hz_utility_pub.program_application_id,
845: program_id = hz_utility_pub.program_id,

Line 842: last_updated_by = hz_utility_pub.user_id,

838:
839: UPDATE OZF_CLAIM_LINES_HIST_ALL
840: SET buy_group_party_id = p_to_fk_id,
841: last_update_date = hz_utility_pub.last_update_date,
842: last_updated_by = hz_utility_pub.user_id,
843: last_update_login = hz_utility_pub.last_update_login,
844: program_application_id = hz_utility_pub.program_application_id,
845: program_id = hz_utility_pub.program_id,
846: program_update_date = sysdate

Line 843: last_update_login = hz_utility_pub.last_update_login,

839: UPDATE OZF_CLAIM_LINES_HIST_ALL
840: SET buy_group_party_id = p_to_fk_id,
841: last_update_date = hz_utility_pub.last_update_date,
842: last_updated_by = hz_utility_pub.user_id,
843: last_update_login = hz_utility_pub.last_update_login,
844: program_application_id = hz_utility_pub.program_application_id,
845: program_id = hz_utility_pub.program_id,
846: program_update_date = sysdate
847: where buy_group_party_id = p_from_fk_id;

Line 844: program_application_id = hz_utility_pub.program_application_id,

840: SET buy_group_party_id = p_to_fk_id,
841: last_update_date = hz_utility_pub.last_update_date,
842: last_updated_by = hz_utility_pub.user_id,
843: last_update_login = hz_utility_pub.last_update_login,
844: program_application_id = hz_utility_pub.program_application_id,
845: program_id = hz_utility_pub.program_id,
846: program_update_date = sysdate
847: where buy_group_party_id = p_from_fk_id;
848:

Line 845: program_id = hz_utility_pub.program_id,

841: last_update_date = hz_utility_pub.last_update_date,
842: last_updated_by = hz_utility_pub.user_id,
843: last_update_login = hz_utility_pub.last_update_login,
844: program_application_id = hz_utility_pub.program_application_id,
845: program_id = hz_utility_pub.program_id,
846: program_update_date = sysdate
847: where buy_group_party_id = p_from_fk_id;
848:
849: END IF;

Line 909: last_update_date = hz_utility_pub.last_update_date,

905: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
906:
907: UPDATE ozf_code_conversions_all
908: SET party_id = p_to_fk_id,
909: last_update_date = hz_utility_pub.last_update_date,
910: last_updated_by = hz_utility_pub.user_id,
911: last_update_login = hz_utility_pub.last_update_login
912: where party_id = p_from_fk_id;
913:

Line 910: last_updated_by = hz_utility_pub.user_id,

906:
907: UPDATE ozf_code_conversions_all
908: SET party_id = p_to_fk_id,
909: last_update_date = hz_utility_pub.last_update_date,
910: last_updated_by = hz_utility_pub.user_id,
911: last_update_login = hz_utility_pub.last_update_login
912: where party_id = p_from_fk_id;
913:
914: END IF;

Line 911: last_update_login = hz_utility_pub.last_update_login

907: UPDATE ozf_code_conversions_all
908: SET party_id = p_to_fk_id,
909: last_update_date = hz_utility_pub.last_update_date,
910: last_updated_by = hz_utility_pub.user_id,
911: last_update_login = hz_utility_pub.last_update_login
912: where party_id = p_from_fk_id;
913:
914: END IF;
915: EXCEPTION

Line 975: last_update_date = hz_utility_pub.last_update_date,

971: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
972:
973: UPDATE ozf_resale_batches_all
974: SET partner_party_id = p_to_fk_id,
975: last_update_date = hz_utility_pub.last_update_date,
976: last_updated_by = hz_utility_pub.user_id,
977: last_update_login = hz_utility_pub.last_update_login,
978: program_application_id = hz_utility_pub.program_application_id,
979: program_id = hz_utility_pub.program_id,

Line 976: last_updated_by = hz_utility_pub.user_id,

972:
973: UPDATE ozf_resale_batches_all
974: SET partner_party_id = p_to_fk_id,
975: last_update_date = hz_utility_pub.last_update_date,
976: last_updated_by = hz_utility_pub.user_id,
977: last_update_login = hz_utility_pub.last_update_login,
978: program_application_id = hz_utility_pub.program_application_id,
979: program_id = hz_utility_pub.program_id,
980: program_update_date = sysdate

Line 977: last_update_login = hz_utility_pub.last_update_login,

973: UPDATE ozf_resale_batches_all
974: SET partner_party_id = p_to_fk_id,
975: last_update_date = hz_utility_pub.last_update_date,
976: last_updated_by = hz_utility_pub.user_id,
977: last_update_login = hz_utility_pub.last_update_login,
978: program_application_id = hz_utility_pub.program_application_id,
979: program_id = hz_utility_pub.program_id,
980: program_update_date = sysdate
981: where partner_party_id = p_from_fk_id;

Line 978: program_application_id = hz_utility_pub.program_application_id,

974: SET partner_party_id = p_to_fk_id,
975: last_update_date = hz_utility_pub.last_update_date,
976: last_updated_by = hz_utility_pub.user_id,
977: last_update_login = hz_utility_pub.last_update_login,
978: program_application_id = hz_utility_pub.program_application_id,
979: program_id = hz_utility_pub.program_id,
980: program_update_date = sysdate
981: where partner_party_id = p_from_fk_id;
982:

Line 979: program_id = hz_utility_pub.program_id,

975: last_update_date = hz_utility_pub.last_update_date,
976: last_updated_by = hz_utility_pub.user_id,
977: last_update_login = hz_utility_pub.last_update_login,
978: program_application_id = hz_utility_pub.program_application_id,
979: program_id = hz_utility_pub.program_id,
980: program_update_date = sysdate
981: where partner_party_id = p_from_fk_id;
982:
983: END IF;

Line 1044: last_update_date = hz_utility_pub.last_update_date,

1040: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1041:
1042: UPDATE ozf_resale_batches_all
1043: SET partner_contact_party_id = p_to_fk_id,
1044: last_update_date = hz_utility_pub.last_update_date,
1045: last_updated_by = hz_utility_pub.user_id,
1046: last_update_login = hz_utility_pub.last_update_login,
1047: program_application_id = hz_utility_pub.program_application_id,
1048: program_id = hz_utility_pub.program_id,

Line 1045: last_updated_by = hz_utility_pub.user_id,

1041:
1042: UPDATE ozf_resale_batches_all
1043: SET partner_contact_party_id = p_to_fk_id,
1044: last_update_date = hz_utility_pub.last_update_date,
1045: last_updated_by = hz_utility_pub.user_id,
1046: last_update_login = hz_utility_pub.last_update_login,
1047: program_application_id = hz_utility_pub.program_application_id,
1048: program_id = hz_utility_pub.program_id,
1049: program_update_date = sysdate

Line 1046: last_update_login = hz_utility_pub.last_update_login,

1042: UPDATE ozf_resale_batches_all
1043: SET partner_contact_party_id = p_to_fk_id,
1044: last_update_date = hz_utility_pub.last_update_date,
1045: last_updated_by = hz_utility_pub.user_id,
1046: last_update_login = hz_utility_pub.last_update_login,
1047: program_application_id = hz_utility_pub.program_application_id,
1048: program_id = hz_utility_pub.program_id,
1049: program_update_date = sysdate
1050: where partner_contact_party_id = p_from_fk_id;

Line 1047: program_application_id = hz_utility_pub.program_application_id,

1043: SET partner_contact_party_id = p_to_fk_id,
1044: last_update_date = hz_utility_pub.last_update_date,
1045: last_updated_by = hz_utility_pub.user_id,
1046: last_update_login = hz_utility_pub.last_update_login,
1047: program_application_id = hz_utility_pub.program_application_id,
1048: program_id = hz_utility_pub.program_id,
1049: program_update_date = sysdate
1050: where partner_contact_party_id = p_from_fk_id;
1051:

Line 1048: program_id = hz_utility_pub.program_id,

1044: last_update_date = hz_utility_pub.last_update_date,
1045: last_updated_by = hz_utility_pub.user_id,
1046: last_update_login = hz_utility_pub.last_update_login,
1047: program_application_id = hz_utility_pub.program_application_id,
1048: program_id = hz_utility_pub.program_id,
1049: program_update_date = sysdate
1050: where partner_contact_party_id = p_from_fk_id;
1051:
1052: END IF;

Line 1113: last_update_date = hz_utility_pub.last_update_date,

1109: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1110:
1111: UPDATE ozf_resale_lines_int_all
1112: SET ship_from_contact_party_id = p_to_fk_id,
1113: last_update_date = hz_utility_pub.last_update_date,
1114: last_updated_by = hz_utility_pub.user_id,
1115: last_update_login = hz_utility_pub.last_update_login,
1116: program_application_id = hz_utility_pub.program_application_id,
1117: program_id = hz_utility_pub.program_id,

Line 1114: last_updated_by = hz_utility_pub.user_id,

1110:
1111: UPDATE ozf_resale_lines_int_all
1112: SET ship_from_contact_party_id = p_to_fk_id,
1113: last_update_date = hz_utility_pub.last_update_date,
1114: last_updated_by = hz_utility_pub.user_id,
1115: last_update_login = hz_utility_pub.last_update_login,
1116: program_application_id = hz_utility_pub.program_application_id,
1117: program_id = hz_utility_pub.program_id,
1118: program_update_date = sysdate

Line 1115: last_update_login = hz_utility_pub.last_update_login,

1111: UPDATE ozf_resale_lines_int_all
1112: SET ship_from_contact_party_id = p_to_fk_id,
1113: last_update_date = hz_utility_pub.last_update_date,
1114: last_updated_by = hz_utility_pub.user_id,
1115: last_update_login = hz_utility_pub.last_update_login,
1116: program_application_id = hz_utility_pub.program_application_id,
1117: program_id = hz_utility_pub.program_id,
1118: program_update_date = sysdate
1119: where ship_from_contact_party_id = p_from_fk_id;

Line 1116: program_application_id = hz_utility_pub.program_application_id,

1112: SET ship_from_contact_party_id = p_to_fk_id,
1113: last_update_date = hz_utility_pub.last_update_date,
1114: last_updated_by = hz_utility_pub.user_id,
1115: last_update_login = hz_utility_pub.last_update_login,
1116: program_application_id = hz_utility_pub.program_application_id,
1117: program_id = hz_utility_pub.program_id,
1118: program_update_date = sysdate
1119: where ship_from_contact_party_id = p_from_fk_id;
1120:

Line 1117: program_id = hz_utility_pub.program_id,

1113: last_update_date = hz_utility_pub.last_update_date,
1114: last_updated_by = hz_utility_pub.user_id,
1115: last_update_login = hz_utility_pub.last_update_login,
1116: program_application_id = hz_utility_pub.program_application_id,
1117: program_id = hz_utility_pub.program_id,
1118: program_update_date = sysdate
1119: where ship_from_contact_party_id = p_from_fk_id;
1120:
1121: END IF;

Line 1182: last_update_date = hz_utility_pub.last_update_date,

1178: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1179:
1180: UPDATE ozf_resale_lines_int_all
1181: SET sold_from_contact_party_id = p_to_fk_id,
1182: last_update_date = hz_utility_pub.last_update_date,
1183: last_updated_by = hz_utility_pub.user_id,
1184: last_update_login = hz_utility_pub.last_update_login,
1185: program_application_id = hz_utility_pub.program_application_id,
1186: program_id = hz_utility_pub.program_id,

Line 1183: last_updated_by = hz_utility_pub.user_id,

1179:
1180: UPDATE ozf_resale_lines_int_all
1181: SET sold_from_contact_party_id = p_to_fk_id,
1182: last_update_date = hz_utility_pub.last_update_date,
1183: last_updated_by = hz_utility_pub.user_id,
1184: last_update_login = hz_utility_pub.last_update_login,
1185: program_application_id = hz_utility_pub.program_application_id,
1186: program_id = hz_utility_pub.program_id,
1187: program_update_date = sysdate

Line 1184: last_update_login = hz_utility_pub.last_update_login,

1180: UPDATE ozf_resale_lines_int_all
1181: SET sold_from_contact_party_id = p_to_fk_id,
1182: last_update_date = hz_utility_pub.last_update_date,
1183: last_updated_by = hz_utility_pub.user_id,
1184: last_update_login = hz_utility_pub.last_update_login,
1185: program_application_id = hz_utility_pub.program_application_id,
1186: program_id = hz_utility_pub.program_id,
1187: program_update_date = sysdate
1188: where sold_from_contact_party_id = p_from_fk_id;

Line 1185: program_application_id = hz_utility_pub.program_application_id,

1181: SET sold_from_contact_party_id = p_to_fk_id,
1182: last_update_date = hz_utility_pub.last_update_date,
1183: last_updated_by = hz_utility_pub.user_id,
1184: last_update_login = hz_utility_pub.last_update_login,
1185: program_application_id = hz_utility_pub.program_application_id,
1186: program_id = hz_utility_pub.program_id,
1187: program_update_date = sysdate
1188: where sold_from_contact_party_id = p_from_fk_id;
1189:

Line 1186: program_id = hz_utility_pub.program_id,

1182: last_update_date = hz_utility_pub.last_update_date,
1183: last_updated_by = hz_utility_pub.user_id,
1184: last_update_login = hz_utility_pub.last_update_login,
1185: program_application_id = hz_utility_pub.program_application_id,
1186: program_id = hz_utility_pub.program_id,
1187: program_update_date = sysdate
1188: where sold_from_contact_party_id = p_from_fk_id;
1189:
1190: END IF;

Line 1252: last_update_date = hz_utility_pub.last_update_date,

1248: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1249:
1250: UPDATE ozf_resale_lines_int_all
1251: SET bill_to_party_id = p_to_fk_id,
1252: last_update_date = hz_utility_pub.last_update_date,
1253: last_updated_by = hz_utility_pub.user_id,
1254: last_update_login = hz_utility_pub.last_update_login,
1255: program_application_id = hz_utility_pub.program_application_id,
1256: program_id = hz_utility_pub.program_id,

Line 1253: last_updated_by = hz_utility_pub.user_id,

1249:
1250: UPDATE ozf_resale_lines_int_all
1251: SET bill_to_party_id = p_to_fk_id,
1252: last_update_date = hz_utility_pub.last_update_date,
1253: last_updated_by = hz_utility_pub.user_id,
1254: last_update_login = hz_utility_pub.last_update_login,
1255: program_application_id = hz_utility_pub.program_application_id,
1256: program_id = hz_utility_pub.program_id,
1257: program_update_date = sysdate

Line 1254: last_update_login = hz_utility_pub.last_update_login,

1250: UPDATE ozf_resale_lines_int_all
1251: SET bill_to_party_id = p_to_fk_id,
1252: last_update_date = hz_utility_pub.last_update_date,
1253: last_updated_by = hz_utility_pub.user_id,
1254: last_update_login = hz_utility_pub.last_update_login,
1255: program_application_id = hz_utility_pub.program_application_id,
1256: program_id = hz_utility_pub.program_id,
1257: program_update_date = sysdate
1258: where bill_to_party_id = p_from_fk_id;

Line 1255: program_application_id = hz_utility_pub.program_application_id,

1251: SET bill_to_party_id = p_to_fk_id,
1252: last_update_date = hz_utility_pub.last_update_date,
1253: last_updated_by = hz_utility_pub.user_id,
1254: last_update_login = hz_utility_pub.last_update_login,
1255: program_application_id = hz_utility_pub.program_application_id,
1256: program_id = hz_utility_pub.program_id,
1257: program_update_date = sysdate
1258: where bill_to_party_id = p_from_fk_id;
1259:

Line 1256: program_id = hz_utility_pub.program_id,

1252: last_update_date = hz_utility_pub.last_update_date,
1253: last_updated_by = hz_utility_pub.user_id,
1254: last_update_login = hz_utility_pub.last_update_login,
1255: program_application_id = hz_utility_pub.program_application_id,
1256: program_id = hz_utility_pub.program_id,
1257: program_update_date = sysdate
1258: where bill_to_party_id = p_from_fk_id;
1259:
1260: END IF;

Line 1322: last_update_date = hz_utility_pub.last_update_date,

1318: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1319:
1320: UPDATE ozf_resale_lines_int_all
1321: SET bill_to_contact_party_id = p_to_fk_id,
1322: last_update_date = hz_utility_pub.last_update_date,
1323: last_updated_by = hz_utility_pub.user_id,
1324: last_update_login = hz_utility_pub.last_update_login,
1325: program_application_id = hz_utility_pub.program_application_id,
1326: program_id = hz_utility_pub.program_id,

Line 1323: last_updated_by = hz_utility_pub.user_id,

1319:
1320: UPDATE ozf_resale_lines_int_all
1321: SET bill_to_contact_party_id = p_to_fk_id,
1322: last_update_date = hz_utility_pub.last_update_date,
1323: last_updated_by = hz_utility_pub.user_id,
1324: last_update_login = hz_utility_pub.last_update_login,
1325: program_application_id = hz_utility_pub.program_application_id,
1326: program_id = hz_utility_pub.program_id,
1327: program_update_date = sysdate

Line 1324: last_update_login = hz_utility_pub.last_update_login,

1320: UPDATE ozf_resale_lines_int_all
1321: SET bill_to_contact_party_id = p_to_fk_id,
1322: last_update_date = hz_utility_pub.last_update_date,
1323: last_updated_by = hz_utility_pub.user_id,
1324: last_update_login = hz_utility_pub.last_update_login,
1325: program_application_id = hz_utility_pub.program_application_id,
1326: program_id = hz_utility_pub.program_id,
1327: program_update_date = sysdate
1328: where bill_to_contact_party_id = p_from_fk_id;

Line 1325: program_application_id = hz_utility_pub.program_application_id,

1321: SET bill_to_contact_party_id = p_to_fk_id,
1322: last_update_date = hz_utility_pub.last_update_date,
1323: last_updated_by = hz_utility_pub.user_id,
1324: last_update_login = hz_utility_pub.last_update_login,
1325: program_application_id = hz_utility_pub.program_application_id,
1326: program_id = hz_utility_pub.program_id,
1327: program_update_date = sysdate
1328: where bill_to_contact_party_id = p_from_fk_id;
1329:

Line 1326: program_id = hz_utility_pub.program_id,

1322: last_update_date = hz_utility_pub.last_update_date,
1323: last_updated_by = hz_utility_pub.user_id,
1324: last_update_login = hz_utility_pub.last_update_login,
1325: program_application_id = hz_utility_pub.program_application_id,
1326: program_id = hz_utility_pub.program_id,
1327: program_update_date = sysdate
1328: where bill_to_contact_party_id = p_from_fk_id;
1329:
1330: END IF;

Line 1391: last_update_date = hz_utility_pub.last_update_date,

1387: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1388:
1389: UPDATE ozf_resale_lines_int_all
1390: SET ship_to_party_id = p_to_fk_id,
1391: last_update_date = hz_utility_pub.last_update_date,
1392: last_updated_by = hz_utility_pub.user_id,
1393: last_update_login = hz_utility_pub.last_update_login,
1394: program_application_id = hz_utility_pub.program_application_id,
1395: program_id = hz_utility_pub.program_id,

Line 1392: last_updated_by = hz_utility_pub.user_id,

1388:
1389: UPDATE ozf_resale_lines_int_all
1390: SET ship_to_party_id = p_to_fk_id,
1391: last_update_date = hz_utility_pub.last_update_date,
1392: last_updated_by = hz_utility_pub.user_id,
1393: last_update_login = hz_utility_pub.last_update_login,
1394: program_application_id = hz_utility_pub.program_application_id,
1395: program_id = hz_utility_pub.program_id,
1396: program_update_date = sysdate

Line 1393: last_update_login = hz_utility_pub.last_update_login,

1389: UPDATE ozf_resale_lines_int_all
1390: SET ship_to_party_id = p_to_fk_id,
1391: last_update_date = hz_utility_pub.last_update_date,
1392: last_updated_by = hz_utility_pub.user_id,
1393: last_update_login = hz_utility_pub.last_update_login,
1394: program_application_id = hz_utility_pub.program_application_id,
1395: program_id = hz_utility_pub.program_id,
1396: program_update_date = sysdate
1397: where ship_to_party_id = p_from_fk_id;

Line 1394: program_application_id = hz_utility_pub.program_application_id,

1390: SET ship_to_party_id = p_to_fk_id,
1391: last_update_date = hz_utility_pub.last_update_date,
1392: last_updated_by = hz_utility_pub.user_id,
1393: last_update_login = hz_utility_pub.last_update_login,
1394: program_application_id = hz_utility_pub.program_application_id,
1395: program_id = hz_utility_pub.program_id,
1396: program_update_date = sysdate
1397: where ship_to_party_id = p_from_fk_id;
1398:

Line 1395: program_id = hz_utility_pub.program_id,

1391: last_update_date = hz_utility_pub.last_update_date,
1392: last_updated_by = hz_utility_pub.user_id,
1393: last_update_login = hz_utility_pub.last_update_login,
1394: program_application_id = hz_utility_pub.program_application_id,
1395: program_id = hz_utility_pub.program_id,
1396: program_update_date = sysdate
1397: where ship_to_party_id = p_from_fk_id;
1398:
1399: END IF;

Line 1461: last_update_date = hz_utility_pub.last_update_date,

1457: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1458:
1459: UPDATE ozf_resale_lines_int_all
1460: SET ship_to_contact_party_id = p_to_fk_id,
1461: last_update_date = hz_utility_pub.last_update_date,
1462: last_updated_by = hz_utility_pub.user_id,
1463: last_update_login = hz_utility_pub.last_update_login,
1464: program_application_id = hz_utility_pub.program_application_id,
1465: program_id = hz_utility_pub.program_id,

Line 1462: last_updated_by = hz_utility_pub.user_id,

1458:
1459: UPDATE ozf_resale_lines_int_all
1460: SET ship_to_contact_party_id = p_to_fk_id,
1461: last_update_date = hz_utility_pub.last_update_date,
1462: last_updated_by = hz_utility_pub.user_id,
1463: last_update_login = hz_utility_pub.last_update_login,
1464: program_application_id = hz_utility_pub.program_application_id,
1465: program_id = hz_utility_pub.program_id,
1466: program_update_date = sysdate

Line 1463: last_update_login = hz_utility_pub.last_update_login,

1459: UPDATE ozf_resale_lines_int_all
1460: SET ship_to_contact_party_id = p_to_fk_id,
1461: last_update_date = hz_utility_pub.last_update_date,
1462: last_updated_by = hz_utility_pub.user_id,
1463: last_update_login = hz_utility_pub.last_update_login,
1464: program_application_id = hz_utility_pub.program_application_id,
1465: program_id = hz_utility_pub.program_id,
1466: program_update_date = sysdate
1467: where ship_to_contact_party_id = p_from_fk_id;

Line 1464: program_application_id = hz_utility_pub.program_application_id,

1460: SET ship_to_contact_party_id = p_to_fk_id,
1461: last_update_date = hz_utility_pub.last_update_date,
1462: last_updated_by = hz_utility_pub.user_id,
1463: last_update_login = hz_utility_pub.last_update_login,
1464: program_application_id = hz_utility_pub.program_application_id,
1465: program_id = hz_utility_pub.program_id,
1466: program_update_date = sysdate
1467: where ship_to_contact_party_id = p_from_fk_id;
1468:

Line 1465: program_id = hz_utility_pub.program_id,

1461: last_update_date = hz_utility_pub.last_update_date,
1462: last_updated_by = hz_utility_pub.user_id,
1463: last_update_login = hz_utility_pub.last_update_login,
1464: program_application_id = hz_utility_pub.program_application_id,
1465: program_id = hz_utility_pub.program_id,
1466: program_update_date = sysdate
1467: where ship_to_contact_party_id = p_from_fk_id;
1468:
1469: END IF;

Line 1530: last_update_date = hz_utility_pub.last_update_date,

1526: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1527:
1528: UPDATE ozf_resale_lines_int_all
1529: SET end_cust_party_id = p_to_fk_id,
1530: last_update_date = hz_utility_pub.last_update_date,
1531: last_updated_by = hz_utility_pub.user_id,
1532: last_update_login = hz_utility_pub.last_update_login,
1533: program_application_id = hz_utility_pub.program_application_id,
1534: program_id = hz_utility_pub.program_id,

Line 1531: last_updated_by = hz_utility_pub.user_id,

1527:
1528: UPDATE ozf_resale_lines_int_all
1529: SET end_cust_party_id = p_to_fk_id,
1530: last_update_date = hz_utility_pub.last_update_date,
1531: last_updated_by = hz_utility_pub.user_id,
1532: last_update_login = hz_utility_pub.last_update_login,
1533: program_application_id = hz_utility_pub.program_application_id,
1534: program_id = hz_utility_pub.program_id,
1535: program_update_date = sysdate

Line 1532: last_update_login = hz_utility_pub.last_update_login,

1528: UPDATE ozf_resale_lines_int_all
1529: SET end_cust_party_id = p_to_fk_id,
1530: last_update_date = hz_utility_pub.last_update_date,
1531: last_updated_by = hz_utility_pub.user_id,
1532: last_update_login = hz_utility_pub.last_update_login,
1533: program_application_id = hz_utility_pub.program_application_id,
1534: program_id = hz_utility_pub.program_id,
1535: program_update_date = sysdate
1536: where end_cust_party_id = p_from_fk_id;

Line 1533: program_application_id = hz_utility_pub.program_application_id,

1529: SET end_cust_party_id = p_to_fk_id,
1530: last_update_date = hz_utility_pub.last_update_date,
1531: last_updated_by = hz_utility_pub.user_id,
1532: last_update_login = hz_utility_pub.last_update_login,
1533: program_application_id = hz_utility_pub.program_application_id,
1534: program_id = hz_utility_pub.program_id,
1535: program_update_date = sysdate
1536: where end_cust_party_id = p_from_fk_id;
1537:

Line 1534: program_id = hz_utility_pub.program_id,

1530: last_update_date = hz_utility_pub.last_update_date,
1531: last_updated_by = hz_utility_pub.user_id,
1532: last_update_login = hz_utility_pub.last_update_login,
1533: program_application_id = hz_utility_pub.program_application_id,
1534: program_id = hz_utility_pub.program_id,
1535: program_update_date = sysdate
1536: where end_cust_party_id = p_from_fk_id;
1537:
1538: END IF;

Line 1599: last_update_date = hz_utility_pub.last_update_date,

1595: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1596:
1597: UPDATE ozf_resale_lines_int_all
1598: SET end_cust_contact_party_id = p_to_fk_id,
1599: last_update_date = hz_utility_pub.last_update_date,
1600: last_updated_by = hz_utility_pub.user_id,
1601: last_update_login = hz_utility_pub.last_update_login,
1602: program_application_id = hz_utility_pub.program_application_id,
1603: program_id = hz_utility_pub.program_id,

Line 1600: last_updated_by = hz_utility_pub.user_id,

1596:
1597: UPDATE ozf_resale_lines_int_all
1598: SET end_cust_contact_party_id = p_to_fk_id,
1599: last_update_date = hz_utility_pub.last_update_date,
1600: last_updated_by = hz_utility_pub.user_id,
1601: last_update_login = hz_utility_pub.last_update_login,
1602: program_application_id = hz_utility_pub.program_application_id,
1603: program_id = hz_utility_pub.program_id,
1604: program_update_date = sysdate

Line 1601: last_update_login = hz_utility_pub.last_update_login,

1597: UPDATE ozf_resale_lines_int_all
1598: SET end_cust_contact_party_id = p_to_fk_id,
1599: last_update_date = hz_utility_pub.last_update_date,
1600: last_updated_by = hz_utility_pub.user_id,
1601: last_update_login = hz_utility_pub.last_update_login,
1602: program_application_id = hz_utility_pub.program_application_id,
1603: program_id = hz_utility_pub.program_id,
1604: program_update_date = sysdate
1605: where end_cust_contact_party_id = p_from_fk_id;

Line 1602: program_application_id = hz_utility_pub.program_application_id,

1598: SET end_cust_contact_party_id = p_to_fk_id,
1599: last_update_date = hz_utility_pub.last_update_date,
1600: last_updated_by = hz_utility_pub.user_id,
1601: last_update_login = hz_utility_pub.last_update_login,
1602: program_application_id = hz_utility_pub.program_application_id,
1603: program_id = hz_utility_pub.program_id,
1604: program_update_date = sysdate
1605: where end_cust_contact_party_id = p_from_fk_id;
1606:

Line 1603: program_id = hz_utility_pub.program_id,

1599: last_update_date = hz_utility_pub.last_update_date,
1600: last_updated_by = hz_utility_pub.user_id,
1601: last_update_login = hz_utility_pub.last_update_login,
1602: program_application_id = hz_utility_pub.program_application_id,
1603: program_id = hz_utility_pub.program_id,
1604: program_update_date = sysdate
1605: where end_cust_contact_party_id = p_from_fk_id;
1606:
1607: END IF;

Line 1668: last_update_date = hz_utility_pub.last_update_date,

1664: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1665:
1666: UPDATE ozf_resale_headers_all
1667: SET bill_to_party_id = p_to_fk_id,
1668: last_update_date = hz_utility_pub.last_update_date,
1669: last_updated_by = hz_utility_pub.user_id,
1670: last_update_login = hz_utility_pub.last_update_login,
1671: program_application_id = hz_utility_pub.program_application_id,
1672: program_id = hz_utility_pub.program_id,

Line 1669: last_updated_by = hz_utility_pub.user_id,

1665:
1666: UPDATE ozf_resale_headers_all
1667: SET bill_to_party_id = p_to_fk_id,
1668: last_update_date = hz_utility_pub.last_update_date,
1669: last_updated_by = hz_utility_pub.user_id,
1670: last_update_login = hz_utility_pub.last_update_login,
1671: program_application_id = hz_utility_pub.program_application_id,
1672: program_id = hz_utility_pub.program_id,
1673: program_update_date = sysdate

Line 1670: last_update_login = hz_utility_pub.last_update_login,

1666: UPDATE ozf_resale_headers_all
1667: SET bill_to_party_id = p_to_fk_id,
1668: last_update_date = hz_utility_pub.last_update_date,
1669: last_updated_by = hz_utility_pub.user_id,
1670: last_update_login = hz_utility_pub.last_update_login,
1671: program_application_id = hz_utility_pub.program_application_id,
1672: program_id = hz_utility_pub.program_id,
1673: program_update_date = sysdate
1674: where bill_to_party_id = p_from_fk_id;

Line 1671: program_application_id = hz_utility_pub.program_application_id,

1667: SET bill_to_party_id = p_to_fk_id,
1668: last_update_date = hz_utility_pub.last_update_date,
1669: last_updated_by = hz_utility_pub.user_id,
1670: last_update_login = hz_utility_pub.last_update_login,
1671: program_application_id = hz_utility_pub.program_application_id,
1672: program_id = hz_utility_pub.program_id,
1673: program_update_date = sysdate
1674: where bill_to_party_id = p_from_fk_id;
1675:

Line 1672: program_id = hz_utility_pub.program_id,

1668: last_update_date = hz_utility_pub.last_update_date,
1669: last_updated_by = hz_utility_pub.user_id,
1670: last_update_login = hz_utility_pub.last_update_login,
1671: program_application_id = hz_utility_pub.program_application_id,
1672: program_id = hz_utility_pub.program_id,
1673: program_update_date = sysdate
1674: where bill_to_party_id = p_from_fk_id;
1675:
1676: END IF;

Line 1737: last_update_date = hz_utility_pub.last_update_date,

1733: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1734:
1735: UPDATE ozf_resale_headers_all
1736: SET bill_to_contact_party_id = p_to_fk_id,
1737: last_update_date = hz_utility_pub.last_update_date,
1738: last_updated_by = hz_utility_pub.user_id,
1739: last_update_login = hz_utility_pub.last_update_login,
1740: program_application_id = hz_utility_pub.program_application_id,
1741: program_id = hz_utility_pub.program_id,

Line 1738: last_updated_by = hz_utility_pub.user_id,

1734:
1735: UPDATE ozf_resale_headers_all
1736: SET bill_to_contact_party_id = p_to_fk_id,
1737: last_update_date = hz_utility_pub.last_update_date,
1738: last_updated_by = hz_utility_pub.user_id,
1739: last_update_login = hz_utility_pub.last_update_login,
1740: program_application_id = hz_utility_pub.program_application_id,
1741: program_id = hz_utility_pub.program_id,
1742: program_update_date = sysdate

Line 1739: last_update_login = hz_utility_pub.last_update_login,

1735: UPDATE ozf_resale_headers_all
1736: SET bill_to_contact_party_id = p_to_fk_id,
1737: last_update_date = hz_utility_pub.last_update_date,
1738: last_updated_by = hz_utility_pub.user_id,
1739: last_update_login = hz_utility_pub.last_update_login,
1740: program_application_id = hz_utility_pub.program_application_id,
1741: program_id = hz_utility_pub.program_id,
1742: program_update_date = sysdate
1743: where bill_to_contact_party_id = p_from_fk_id;

Line 1740: program_application_id = hz_utility_pub.program_application_id,

1736: SET bill_to_contact_party_id = p_to_fk_id,
1737: last_update_date = hz_utility_pub.last_update_date,
1738: last_updated_by = hz_utility_pub.user_id,
1739: last_update_login = hz_utility_pub.last_update_login,
1740: program_application_id = hz_utility_pub.program_application_id,
1741: program_id = hz_utility_pub.program_id,
1742: program_update_date = sysdate
1743: where bill_to_contact_party_id = p_from_fk_id;
1744:

Line 1741: program_id = hz_utility_pub.program_id,

1737: last_update_date = hz_utility_pub.last_update_date,
1738: last_updated_by = hz_utility_pub.user_id,
1739: last_update_login = hz_utility_pub.last_update_login,
1740: program_application_id = hz_utility_pub.program_application_id,
1741: program_id = hz_utility_pub.program_id,
1742: program_update_date = sysdate
1743: where bill_to_contact_party_id = p_from_fk_id;
1744:
1745: END IF;

Line 1806: last_update_date = hz_utility_pub.last_update_date,

1802: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1803:
1804: UPDATE ozf_resale_headers_all
1805: SET ship_to_party_id = p_to_fk_id,
1806: last_update_date = hz_utility_pub.last_update_date,
1807: last_updated_by = hz_utility_pub.user_id,
1808: last_update_login = hz_utility_pub.last_update_login,
1809: program_application_id = hz_utility_pub.program_application_id,
1810: program_id = hz_utility_pub.program_id,

Line 1807: last_updated_by = hz_utility_pub.user_id,

1803:
1804: UPDATE ozf_resale_headers_all
1805: SET ship_to_party_id = p_to_fk_id,
1806: last_update_date = hz_utility_pub.last_update_date,
1807: last_updated_by = hz_utility_pub.user_id,
1808: last_update_login = hz_utility_pub.last_update_login,
1809: program_application_id = hz_utility_pub.program_application_id,
1810: program_id = hz_utility_pub.program_id,
1811: program_update_date = sysdate

Line 1808: last_update_login = hz_utility_pub.last_update_login,

1804: UPDATE ozf_resale_headers_all
1805: SET ship_to_party_id = p_to_fk_id,
1806: last_update_date = hz_utility_pub.last_update_date,
1807: last_updated_by = hz_utility_pub.user_id,
1808: last_update_login = hz_utility_pub.last_update_login,
1809: program_application_id = hz_utility_pub.program_application_id,
1810: program_id = hz_utility_pub.program_id,
1811: program_update_date = sysdate
1812: where ship_to_party_id = p_from_fk_id;

Line 1809: program_application_id = hz_utility_pub.program_application_id,

1805: SET ship_to_party_id = p_to_fk_id,
1806: last_update_date = hz_utility_pub.last_update_date,
1807: last_updated_by = hz_utility_pub.user_id,
1808: last_update_login = hz_utility_pub.last_update_login,
1809: program_application_id = hz_utility_pub.program_application_id,
1810: program_id = hz_utility_pub.program_id,
1811: program_update_date = sysdate
1812: where ship_to_party_id = p_from_fk_id;
1813:

Line 1810: program_id = hz_utility_pub.program_id,

1806: last_update_date = hz_utility_pub.last_update_date,
1807: last_updated_by = hz_utility_pub.user_id,
1808: last_update_login = hz_utility_pub.last_update_login,
1809: program_application_id = hz_utility_pub.program_application_id,
1810: program_id = hz_utility_pub.program_id,
1811: program_update_date = sysdate
1812: where ship_to_party_id = p_from_fk_id;
1813:
1814: END IF;

Line 1875: last_update_date = hz_utility_pub.last_update_date,

1871: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1872:
1873: UPDATE ozf_resale_headers_all
1874: SET ship_to_contact_party_id = p_to_fk_id,
1875: last_update_date = hz_utility_pub.last_update_date,
1876: last_updated_by = hz_utility_pub.user_id,
1877: last_update_login = hz_utility_pub.last_update_login,
1878: program_application_id = hz_utility_pub.program_application_id,
1879: program_id = hz_utility_pub.program_id,

Line 1876: last_updated_by = hz_utility_pub.user_id,

1872:
1873: UPDATE ozf_resale_headers_all
1874: SET ship_to_contact_party_id = p_to_fk_id,
1875: last_update_date = hz_utility_pub.last_update_date,
1876: last_updated_by = hz_utility_pub.user_id,
1877: last_update_login = hz_utility_pub.last_update_login,
1878: program_application_id = hz_utility_pub.program_application_id,
1879: program_id = hz_utility_pub.program_id,
1880: program_update_date = sysdate

Line 1877: last_update_login = hz_utility_pub.last_update_login,

1873: UPDATE ozf_resale_headers_all
1874: SET ship_to_contact_party_id = p_to_fk_id,
1875: last_update_date = hz_utility_pub.last_update_date,
1876: last_updated_by = hz_utility_pub.user_id,
1877: last_update_login = hz_utility_pub.last_update_login,
1878: program_application_id = hz_utility_pub.program_application_id,
1879: program_id = hz_utility_pub.program_id,
1880: program_update_date = sysdate
1881: where ship_to_contact_party_id = p_from_fk_id;

Line 1878: program_application_id = hz_utility_pub.program_application_id,

1874: SET ship_to_contact_party_id = p_to_fk_id,
1875: last_update_date = hz_utility_pub.last_update_date,
1876: last_updated_by = hz_utility_pub.user_id,
1877: last_update_login = hz_utility_pub.last_update_login,
1878: program_application_id = hz_utility_pub.program_application_id,
1879: program_id = hz_utility_pub.program_id,
1880: program_update_date = sysdate
1881: where ship_to_contact_party_id = p_from_fk_id;
1882:

Line 1879: program_id = hz_utility_pub.program_id,

1875: last_update_date = hz_utility_pub.last_update_date,
1876: last_updated_by = hz_utility_pub.user_id,
1877: last_update_login = hz_utility_pub.last_update_login,
1878: program_application_id = hz_utility_pub.program_application_id,
1879: program_id = hz_utility_pub.program_id,
1880: program_update_date = sysdate
1881: where ship_to_contact_party_id = p_from_fk_id;
1882:
1883: END IF;

Line 1944: last_update_date = hz_utility_pub.last_update_date,

1940: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1941:
1942: UPDATE ozf_resale_lines_all
1943: SET ship_from_contact_party_id = p_to_fk_id,
1944: last_update_date = hz_utility_pub.last_update_date,
1945: last_updated_by = hz_utility_pub.user_id,
1946: last_update_login = hz_utility_pub.last_update_login,
1947: program_application_id = hz_utility_pub.program_application_id,
1948: program_id = hz_utility_pub.program_id,

Line 1945: last_updated_by = hz_utility_pub.user_id,

1941:
1942: UPDATE ozf_resale_lines_all
1943: SET ship_from_contact_party_id = p_to_fk_id,
1944: last_update_date = hz_utility_pub.last_update_date,
1945: last_updated_by = hz_utility_pub.user_id,
1946: last_update_login = hz_utility_pub.last_update_login,
1947: program_application_id = hz_utility_pub.program_application_id,
1948: program_id = hz_utility_pub.program_id,
1949: program_update_date = sysdate

Line 1946: last_update_login = hz_utility_pub.last_update_login,

1942: UPDATE ozf_resale_lines_all
1943: SET ship_from_contact_party_id = p_to_fk_id,
1944: last_update_date = hz_utility_pub.last_update_date,
1945: last_updated_by = hz_utility_pub.user_id,
1946: last_update_login = hz_utility_pub.last_update_login,
1947: program_application_id = hz_utility_pub.program_application_id,
1948: program_id = hz_utility_pub.program_id,
1949: program_update_date = sysdate
1950: where ship_from_contact_party_id = p_from_fk_id;

Line 1947: program_application_id = hz_utility_pub.program_application_id,

1943: SET ship_from_contact_party_id = p_to_fk_id,
1944: last_update_date = hz_utility_pub.last_update_date,
1945: last_updated_by = hz_utility_pub.user_id,
1946: last_update_login = hz_utility_pub.last_update_login,
1947: program_application_id = hz_utility_pub.program_application_id,
1948: program_id = hz_utility_pub.program_id,
1949: program_update_date = sysdate
1950: where ship_from_contact_party_id = p_from_fk_id;
1951:

Line 1948: program_id = hz_utility_pub.program_id,

1944: last_update_date = hz_utility_pub.last_update_date,
1945: last_updated_by = hz_utility_pub.user_id,
1946: last_update_login = hz_utility_pub.last_update_login,
1947: program_application_id = hz_utility_pub.program_application_id,
1948: program_id = hz_utility_pub.program_id,
1949: program_update_date = sysdate
1950: where ship_from_contact_party_id = p_from_fk_id;
1951:
1952: END IF;

Line 2013: last_update_date = hz_utility_pub.last_update_date,

2009: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2010:
2011: UPDATE ozf_resale_lines_all
2012: SET sold_from_contact_party_id = p_to_fk_id,
2013: last_update_date = hz_utility_pub.last_update_date,
2014: last_updated_by = hz_utility_pub.user_id,
2015: last_update_login = hz_utility_pub.last_update_login,
2016: program_application_id = hz_utility_pub.program_application_id,
2017: program_id = hz_utility_pub.program_id,

Line 2014: last_updated_by = hz_utility_pub.user_id,

2010:
2011: UPDATE ozf_resale_lines_all
2012: SET sold_from_contact_party_id = p_to_fk_id,
2013: last_update_date = hz_utility_pub.last_update_date,
2014: last_updated_by = hz_utility_pub.user_id,
2015: last_update_login = hz_utility_pub.last_update_login,
2016: program_application_id = hz_utility_pub.program_application_id,
2017: program_id = hz_utility_pub.program_id,
2018: program_update_date = sysdate

Line 2015: last_update_login = hz_utility_pub.last_update_login,

2011: UPDATE ozf_resale_lines_all
2012: SET sold_from_contact_party_id = p_to_fk_id,
2013: last_update_date = hz_utility_pub.last_update_date,
2014: last_updated_by = hz_utility_pub.user_id,
2015: last_update_login = hz_utility_pub.last_update_login,
2016: program_application_id = hz_utility_pub.program_application_id,
2017: program_id = hz_utility_pub.program_id,
2018: program_update_date = sysdate
2019: where sold_from_contact_party_id = p_from_fk_id;

Line 2016: program_application_id = hz_utility_pub.program_application_id,

2012: SET sold_from_contact_party_id = p_to_fk_id,
2013: last_update_date = hz_utility_pub.last_update_date,
2014: last_updated_by = hz_utility_pub.user_id,
2015: last_update_login = hz_utility_pub.last_update_login,
2016: program_application_id = hz_utility_pub.program_application_id,
2017: program_id = hz_utility_pub.program_id,
2018: program_update_date = sysdate
2019: where sold_from_contact_party_id = p_from_fk_id;
2020:

Line 2017: program_id = hz_utility_pub.program_id,

2013: last_update_date = hz_utility_pub.last_update_date,
2014: last_updated_by = hz_utility_pub.user_id,
2015: last_update_login = hz_utility_pub.last_update_login,
2016: program_application_id = hz_utility_pub.program_application_id,
2017: program_id = hz_utility_pub.program_id,
2018: program_update_date = sysdate
2019: where sold_from_contact_party_id = p_from_fk_id;
2020:
2021: END IF;

Line 2082: last_update_date = hz_utility_pub.last_update_date,

2078: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2079:
2080: UPDATE ozf_resale_lines_all
2081: SET bill_to_party_id = p_to_fk_id,
2082: last_update_date = hz_utility_pub.last_update_date,
2083: last_updated_by = hz_utility_pub.user_id,
2084: last_update_login = hz_utility_pub.last_update_login,
2085: program_application_id = hz_utility_pub.program_application_id,
2086: program_id = hz_utility_pub.program_id,

Line 2083: last_updated_by = hz_utility_pub.user_id,

2079:
2080: UPDATE ozf_resale_lines_all
2081: SET bill_to_party_id = p_to_fk_id,
2082: last_update_date = hz_utility_pub.last_update_date,
2083: last_updated_by = hz_utility_pub.user_id,
2084: last_update_login = hz_utility_pub.last_update_login,
2085: program_application_id = hz_utility_pub.program_application_id,
2086: program_id = hz_utility_pub.program_id,
2087: program_update_date = sysdate

Line 2084: last_update_login = hz_utility_pub.last_update_login,

2080: UPDATE ozf_resale_lines_all
2081: SET bill_to_party_id = p_to_fk_id,
2082: last_update_date = hz_utility_pub.last_update_date,
2083: last_updated_by = hz_utility_pub.user_id,
2084: last_update_login = hz_utility_pub.last_update_login,
2085: program_application_id = hz_utility_pub.program_application_id,
2086: program_id = hz_utility_pub.program_id,
2087: program_update_date = sysdate
2088: where bill_to_party_id = p_from_fk_id;

Line 2085: program_application_id = hz_utility_pub.program_application_id,

2081: SET bill_to_party_id = p_to_fk_id,
2082: last_update_date = hz_utility_pub.last_update_date,
2083: last_updated_by = hz_utility_pub.user_id,
2084: last_update_login = hz_utility_pub.last_update_login,
2085: program_application_id = hz_utility_pub.program_application_id,
2086: program_id = hz_utility_pub.program_id,
2087: program_update_date = sysdate
2088: where bill_to_party_id = p_from_fk_id;
2089:

Line 2086: program_id = hz_utility_pub.program_id,

2082: last_update_date = hz_utility_pub.last_update_date,
2083: last_updated_by = hz_utility_pub.user_id,
2084: last_update_login = hz_utility_pub.last_update_login,
2085: program_application_id = hz_utility_pub.program_application_id,
2086: program_id = hz_utility_pub.program_id,
2087: program_update_date = sysdate
2088: where bill_to_party_id = p_from_fk_id;
2089:
2090: END IF;

Line 2152: last_update_date = hz_utility_pub.last_update_date,

2148: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2149:
2150: UPDATE ozf_resale_lines_all
2151: SET bill_to_contact_party_id = p_to_fk_id,
2152: last_update_date = hz_utility_pub.last_update_date,
2153: last_updated_by = hz_utility_pub.user_id,
2154: last_update_login = hz_utility_pub.last_update_login,
2155: program_application_id = hz_utility_pub.program_application_id,
2156: program_id = hz_utility_pub.program_id,

Line 2153: last_updated_by = hz_utility_pub.user_id,

2149:
2150: UPDATE ozf_resale_lines_all
2151: SET bill_to_contact_party_id = p_to_fk_id,
2152: last_update_date = hz_utility_pub.last_update_date,
2153: last_updated_by = hz_utility_pub.user_id,
2154: last_update_login = hz_utility_pub.last_update_login,
2155: program_application_id = hz_utility_pub.program_application_id,
2156: program_id = hz_utility_pub.program_id,
2157: program_update_date = sysdate

Line 2154: last_update_login = hz_utility_pub.last_update_login,

2150: UPDATE ozf_resale_lines_all
2151: SET bill_to_contact_party_id = p_to_fk_id,
2152: last_update_date = hz_utility_pub.last_update_date,
2153: last_updated_by = hz_utility_pub.user_id,
2154: last_update_login = hz_utility_pub.last_update_login,
2155: program_application_id = hz_utility_pub.program_application_id,
2156: program_id = hz_utility_pub.program_id,
2157: program_update_date = sysdate
2158: where bill_to_contact_party_id = p_from_fk_id;

Line 2155: program_application_id = hz_utility_pub.program_application_id,

2151: SET bill_to_contact_party_id = p_to_fk_id,
2152: last_update_date = hz_utility_pub.last_update_date,
2153: last_updated_by = hz_utility_pub.user_id,
2154: last_update_login = hz_utility_pub.last_update_login,
2155: program_application_id = hz_utility_pub.program_application_id,
2156: program_id = hz_utility_pub.program_id,
2157: program_update_date = sysdate
2158: where bill_to_contact_party_id = p_from_fk_id;
2159:

Line 2156: program_id = hz_utility_pub.program_id,

2152: last_update_date = hz_utility_pub.last_update_date,
2153: last_updated_by = hz_utility_pub.user_id,
2154: last_update_login = hz_utility_pub.last_update_login,
2155: program_application_id = hz_utility_pub.program_application_id,
2156: program_id = hz_utility_pub.program_id,
2157: program_update_date = sysdate
2158: where bill_to_contact_party_id = p_from_fk_id;
2159:
2160: END IF;

Line 2222: last_update_date = hz_utility_pub.last_update_date,

2218: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2219:
2220: UPDATE ozf_resale_lines_all
2221: SET ship_to_party_id = p_to_fk_id,
2222: last_update_date = hz_utility_pub.last_update_date,
2223: last_updated_by = hz_utility_pub.user_id,
2224: last_update_login = hz_utility_pub.last_update_login,
2225: program_application_id = hz_utility_pub.program_application_id,
2226: program_id = hz_utility_pub.program_id,

Line 2223: last_updated_by = hz_utility_pub.user_id,

2219:
2220: UPDATE ozf_resale_lines_all
2221: SET ship_to_party_id = p_to_fk_id,
2222: last_update_date = hz_utility_pub.last_update_date,
2223: last_updated_by = hz_utility_pub.user_id,
2224: last_update_login = hz_utility_pub.last_update_login,
2225: program_application_id = hz_utility_pub.program_application_id,
2226: program_id = hz_utility_pub.program_id,
2227: program_update_date = sysdate

Line 2224: last_update_login = hz_utility_pub.last_update_login,

2220: UPDATE ozf_resale_lines_all
2221: SET ship_to_party_id = p_to_fk_id,
2222: last_update_date = hz_utility_pub.last_update_date,
2223: last_updated_by = hz_utility_pub.user_id,
2224: last_update_login = hz_utility_pub.last_update_login,
2225: program_application_id = hz_utility_pub.program_application_id,
2226: program_id = hz_utility_pub.program_id,
2227: program_update_date = sysdate
2228: where ship_to_party_id = p_from_fk_id;

Line 2225: program_application_id = hz_utility_pub.program_application_id,

2221: SET ship_to_party_id = p_to_fk_id,
2222: last_update_date = hz_utility_pub.last_update_date,
2223: last_updated_by = hz_utility_pub.user_id,
2224: last_update_login = hz_utility_pub.last_update_login,
2225: program_application_id = hz_utility_pub.program_application_id,
2226: program_id = hz_utility_pub.program_id,
2227: program_update_date = sysdate
2228: where ship_to_party_id = p_from_fk_id;
2229:

Line 2226: program_id = hz_utility_pub.program_id,

2222: last_update_date = hz_utility_pub.last_update_date,
2223: last_updated_by = hz_utility_pub.user_id,
2224: last_update_login = hz_utility_pub.last_update_login,
2225: program_application_id = hz_utility_pub.program_application_id,
2226: program_id = hz_utility_pub.program_id,
2227: program_update_date = sysdate
2228: where ship_to_party_id = p_from_fk_id;
2229:
2230: END IF;

Line 2292: last_update_date = hz_utility_pub.last_update_date,

2288: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2289:
2290: UPDATE ozf_resale_lines_all
2291: SET ship_to_contact_party_id = p_to_fk_id,
2292: last_update_date = hz_utility_pub.last_update_date,
2293: last_updated_by = hz_utility_pub.user_id,
2294: last_update_login = hz_utility_pub.last_update_login,
2295: program_application_id = hz_utility_pub.program_application_id,
2296: program_id = hz_utility_pub.program_id,

Line 2293: last_updated_by = hz_utility_pub.user_id,

2289:
2290: UPDATE ozf_resale_lines_all
2291: SET ship_to_contact_party_id = p_to_fk_id,
2292: last_update_date = hz_utility_pub.last_update_date,
2293: last_updated_by = hz_utility_pub.user_id,
2294: last_update_login = hz_utility_pub.last_update_login,
2295: program_application_id = hz_utility_pub.program_application_id,
2296: program_id = hz_utility_pub.program_id,
2297: program_update_date = sysdate

Line 2294: last_update_login = hz_utility_pub.last_update_login,

2290: UPDATE ozf_resale_lines_all
2291: SET ship_to_contact_party_id = p_to_fk_id,
2292: last_update_date = hz_utility_pub.last_update_date,
2293: last_updated_by = hz_utility_pub.user_id,
2294: last_update_login = hz_utility_pub.last_update_login,
2295: program_application_id = hz_utility_pub.program_application_id,
2296: program_id = hz_utility_pub.program_id,
2297: program_update_date = sysdate
2298: where ship_to_contact_party_id = p_from_fk_id;

Line 2295: program_application_id = hz_utility_pub.program_application_id,

2291: SET ship_to_contact_party_id = p_to_fk_id,
2292: last_update_date = hz_utility_pub.last_update_date,
2293: last_updated_by = hz_utility_pub.user_id,
2294: last_update_login = hz_utility_pub.last_update_login,
2295: program_application_id = hz_utility_pub.program_application_id,
2296: program_id = hz_utility_pub.program_id,
2297: program_update_date = sysdate
2298: where ship_to_contact_party_id = p_from_fk_id;
2299:

Line 2296: program_id = hz_utility_pub.program_id,

2292: last_update_date = hz_utility_pub.last_update_date,
2293: last_updated_by = hz_utility_pub.user_id,
2294: last_update_login = hz_utility_pub.last_update_login,
2295: program_application_id = hz_utility_pub.program_application_id,
2296: program_id = hz_utility_pub.program_id,
2297: program_update_date = sysdate
2298: where ship_to_contact_party_id = p_from_fk_id;
2299:
2300: END IF;

Line 2361: last_update_date = hz_utility_pub.last_update_date,

2357: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2358:
2359: UPDATE ozf_resale_lines_all
2360: SET end_cust_party_id = p_to_fk_id,
2361: last_update_date = hz_utility_pub.last_update_date,
2362: last_updated_by = hz_utility_pub.user_id,
2363: last_update_login = hz_utility_pub.last_update_login,
2364: program_application_id = hz_utility_pub.program_application_id,
2365: program_id = hz_utility_pub.program_id,

Line 2362: last_updated_by = hz_utility_pub.user_id,

2358:
2359: UPDATE ozf_resale_lines_all
2360: SET end_cust_party_id = p_to_fk_id,
2361: last_update_date = hz_utility_pub.last_update_date,
2362: last_updated_by = hz_utility_pub.user_id,
2363: last_update_login = hz_utility_pub.last_update_login,
2364: program_application_id = hz_utility_pub.program_application_id,
2365: program_id = hz_utility_pub.program_id,
2366: program_update_date = sysdate

Line 2363: last_update_login = hz_utility_pub.last_update_login,

2359: UPDATE ozf_resale_lines_all
2360: SET end_cust_party_id = p_to_fk_id,
2361: last_update_date = hz_utility_pub.last_update_date,
2362: last_updated_by = hz_utility_pub.user_id,
2363: last_update_login = hz_utility_pub.last_update_login,
2364: program_application_id = hz_utility_pub.program_application_id,
2365: program_id = hz_utility_pub.program_id,
2366: program_update_date = sysdate
2367: where end_cust_party_id = p_from_fk_id;

Line 2364: program_application_id = hz_utility_pub.program_application_id,

2360: SET end_cust_party_id = p_to_fk_id,
2361: last_update_date = hz_utility_pub.last_update_date,
2362: last_updated_by = hz_utility_pub.user_id,
2363: last_update_login = hz_utility_pub.last_update_login,
2364: program_application_id = hz_utility_pub.program_application_id,
2365: program_id = hz_utility_pub.program_id,
2366: program_update_date = sysdate
2367: where end_cust_party_id = p_from_fk_id;
2368:

Line 2365: program_id = hz_utility_pub.program_id,

2361: last_update_date = hz_utility_pub.last_update_date,
2362: last_updated_by = hz_utility_pub.user_id,
2363: last_update_login = hz_utility_pub.last_update_login,
2364: program_application_id = hz_utility_pub.program_application_id,
2365: program_id = hz_utility_pub.program_id,
2366: program_update_date = sysdate
2367: where end_cust_party_id = p_from_fk_id;
2368:
2369: END IF;

Line 2429: last_update_date = hz_utility_pub.last_update_date,

2425: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2426:
2427: UPDATE ozf_resale_lines_all
2428: SET end_cust_contact_party_id = p_to_fk_id,
2429: last_update_date = hz_utility_pub.last_update_date,
2430: last_updated_by = hz_utility_pub.user_id,
2431: last_update_login = hz_utility_pub.last_update_login,
2432: program_application_id = hz_utility_pub.program_application_id,
2433: program_id = hz_utility_pub.program_id,

Line 2430: last_updated_by = hz_utility_pub.user_id,

2426:
2427: UPDATE ozf_resale_lines_all
2428: SET end_cust_contact_party_id = p_to_fk_id,
2429: last_update_date = hz_utility_pub.last_update_date,
2430: last_updated_by = hz_utility_pub.user_id,
2431: last_update_login = hz_utility_pub.last_update_login,
2432: program_application_id = hz_utility_pub.program_application_id,
2433: program_id = hz_utility_pub.program_id,
2434: program_update_date = sysdate

Line 2431: last_update_login = hz_utility_pub.last_update_login,

2427: UPDATE ozf_resale_lines_all
2428: SET end_cust_contact_party_id = p_to_fk_id,
2429: last_update_date = hz_utility_pub.last_update_date,
2430: last_updated_by = hz_utility_pub.user_id,
2431: last_update_login = hz_utility_pub.last_update_login,
2432: program_application_id = hz_utility_pub.program_application_id,
2433: program_id = hz_utility_pub.program_id,
2434: program_update_date = sysdate
2435: where end_cust_contact_party_id = p_from_fk_id;

Line 2432: program_application_id = hz_utility_pub.program_application_id,

2428: SET end_cust_contact_party_id = p_to_fk_id,
2429: last_update_date = hz_utility_pub.last_update_date,
2430: last_updated_by = hz_utility_pub.user_id,
2431: last_update_login = hz_utility_pub.last_update_login,
2432: program_application_id = hz_utility_pub.program_application_id,
2433: program_id = hz_utility_pub.program_id,
2434: program_update_date = sysdate
2435: where end_cust_contact_party_id = p_from_fk_id;
2436:

Line 2433: program_id = hz_utility_pub.program_id,

2429: last_update_date = hz_utility_pub.last_update_date,
2430: last_updated_by = hz_utility_pub.user_id,
2431: last_update_login = hz_utility_pub.last_update_login,
2432: program_application_id = hz_utility_pub.program_application_id,
2433: program_id = hz_utility_pub.program_id,
2434: program_update_date = sysdate
2435: where end_cust_contact_party_id = p_from_fk_id;
2436:
2437: END IF;

Line 2498: last_update_date = hz_utility_pub.last_update_date,

2494: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2495:
2496: UPDATE ozf_request_headers_all_b
2497: SET end_cust_party_id = p_to_fk_id,
2498: last_update_date = hz_utility_pub.last_update_date,
2499: last_updated_by = hz_utility_pub.user_id,
2500: last_update_login = hz_utility_pub.last_update_login,
2501: program_application_id = hz_utility_pub.program_application_id,
2502: program_id = hz_utility_pub.program_id,

Line 2499: last_updated_by = hz_utility_pub.user_id,

2495:
2496: UPDATE ozf_request_headers_all_b
2497: SET end_cust_party_id = p_to_fk_id,
2498: last_update_date = hz_utility_pub.last_update_date,
2499: last_updated_by = hz_utility_pub.user_id,
2500: last_update_login = hz_utility_pub.last_update_login,
2501: program_application_id = hz_utility_pub.program_application_id,
2502: program_id = hz_utility_pub.program_id,
2503: program_update_date = sysdate

Line 2500: last_update_login = hz_utility_pub.last_update_login,

2496: UPDATE ozf_request_headers_all_b
2497: SET end_cust_party_id = p_to_fk_id,
2498: last_update_date = hz_utility_pub.last_update_date,
2499: last_updated_by = hz_utility_pub.user_id,
2500: last_update_login = hz_utility_pub.last_update_login,
2501: program_application_id = hz_utility_pub.program_application_id,
2502: program_id = hz_utility_pub.program_id,
2503: program_update_date = sysdate
2504: where end_cust_party_id = p_from_fk_id;

Line 2501: program_application_id = hz_utility_pub.program_application_id,

2497: SET end_cust_party_id = p_to_fk_id,
2498: last_update_date = hz_utility_pub.last_update_date,
2499: last_updated_by = hz_utility_pub.user_id,
2500: last_update_login = hz_utility_pub.last_update_login,
2501: program_application_id = hz_utility_pub.program_application_id,
2502: program_id = hz_utility_pub.program_id,
2503: program_update_date = sysdate
2504: where end_cust_party_id = p_from_fk_id;
2505:

Line 2502: program_id = hz_utility_pub.program_id,

2498: last_update_date = hz_utility_pub.last_update_date,
2499: last_updated_by = hz_utility_pub.user_id,
2500: last_update_login = hz_utility_pub.last_update_login,
2501: program_application_id = hz_utility_pub.program_application_id,
2502: program_id = hz_utility_pub.program_id,
2503: program_update_date = sysdate
2504: where end_cust_party_id = p_from_fk_id;
2505:
2506: END IF;

Line 2567: last_update_date = hz_utility_pub.last_update_date,

2563: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2564:
2565: UPDATE ozf_request_headers_all_b
2566: SET reseller_party_id = p_to_fk_id,
2567: last_update_date = hz_utility_pub.last_update_date,
2568: last_updated_by = hz_utility_pub.user_id,
2569: last_update_login = hz_utility_pub.last_update_login,
2570: program_application_id = hz_utility_pub.program_application_id,
2571: program_id = hz_utility_pub.program_id,

Line 2568: last_updated_by = hz_utility_pub.user_id,

2564:
2565: UPDATE ozf_request_headers_all_b
2566: SET reseller_party_id = p_to_fk_id,
2567: last_update_date = hz_utility_pub.last_update_date,
2568: last_updated_by = hz_utility_pub.user_id,
2569: last_update_login = hz_utility_pub.last_update_login,
2570: program_application_id = hz_utility_pub.program_application_id,
2571: program_id = hz_utility_pub.program_id,
2572: program_update_date = sysdate

Line 2569: last_update_login = hz_utility_pub.last_update_login,

2565: UPDATE ozf_request_headers_all_b
2566: SET reseller_party_id = p_to_fk_id,
2567: last_update_date = hz_utility_pub.last_update_date,
2568: last_updated_by = hz_utility_pub.user_id,
2569: last_update_login = hz_utility_pub.last_update_login,
2570: program_application_id = hz_utility_pub.program_application_id,
2571: program_id = hz_utility_pub.program_id,
2572: program_update_date = sysdate
2573: where reseller_party_id = p_from_fk_id;

Line 2570: program_application_id = hz_utility_pub.program_application_id,

2566: SET reseller_party_id = p_to_fk_id,
2567: last_update_date = hz_utility_pub.last_update_date,
2568: last_updated_by = hz_utility_pub.user_id,
2569: last_update_login = hz_utility_pub.last_update_login,
2570: program_application_id = hz_utility_pub.program_application_id,
2571: program_id = hz_utility_pub.program_id,
2572: program_update_date = sysdate
2573: where reseller_party_id = p_from_fk_id;
2574:

Line 2571: program_id = hz_utility_pub.program_id,

2567: last_update_date = hz_utility_pub.last_update_date,
2568: last_updated_by = hz_utility_pub.user_id,
2569: last_update_login = hz_utility_pub.last_update_login,
2570: program_application_id = hz_utility_pub.program_application_id,
2571: program_id = hz_utility_pub.program_id,
2572: program_update_date = sysdate
2573: where reseller_party_id = p_from_fk_id;
2574:
2575: END IF;

Line 2636: last_update_date = hz_utility_pub.last_update_date,

2632: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2633:
2634: UPDATE ozf_account_allocations
2635: SET parent_party_id = p_to_fk_id,
2636: last_update_date = hz_utility_pub.last_update_date,
2637: last_updated_by = hz_utility_pub.user_id,
2638: last_update_login = hz_utility_pub.last_update_login
2639: where parent_party_id = p_from_fk_id;
2640:

Line 2637: last_updated_by = hz_utility_pub.user_id,

2633:
2634: UPDATE ozf_account_allocations
2635: SET parent_party_id = p_to_fk_id,
2636: last_update_date = hz_utility_pub.last_update_date,
2637: last_updated_by = hz_utility_pub.user_id,
2638: last_update_login = hz_utility_pub.last_update_login
2639: where parent_party_id = p_from_fk_id;
2640:
2641: END IF;

Line 2638: last_update_login = hz_utility_pub.last_update_login

2634: UPDATE ozf_account_allocations
2635: SET parent_party_id = p_to_fk_id,
2636: last_update_date = hz_utility_pub.last_update_date,
2637: last_updated_by = hz_utility_pub.user_id,
2638: last_update_login = hz_utility_pub.last_update_login
2639: where parent_party_id = p_from_fk_id;
2640:
2641: END IF;
2642: EXCEPTION

Line 2702: last_update_date = hz_utility_pub.last_update_date,

2698: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2699:
2700: UPDATE ozf_account_allocations
2701: SET rollup_party_id = p_to_fk_id,
2702: last_update_date = hz_utility_pub.last_update_date,
2703: last_updated_by = hz_utility_pub.user_id,
2704: last_update_login = hz_utility_pub.last_update_login
2705: where rollup_party_id = p_from_fk_id;
2706:

Line 2703: last_updated_by = hz_utility_pub.user_id,

2699:
2700: UPDATE ozf_account_allocations
2701: SET rollup_party_id = p_to_fk_id,
2702: last_update_date = hz_utility_pub.last_update_date,
2703: last_updated_by = hz_utility_pub.user_id,
2704: last_update_login = hz_utility_pub.last_update_login
2705: where rollup_party_id = p_from_fk_id;
2706:
2707: END IF;

Line 2704: last_update_login = hz_utility_pub.last_update_login

2700: UPDATE ozf_account_allocations
2701: SET rollup_party_id = p_to_fk_id,
2702: last_update_date = hz_utility_pub.last_update_date,
2703: last_updated_by = hz_utility_pub.user_id,
2704: last_update_login = hz_utility_pub.last_update_login
2705: where rollup_party_id = p_from_fk_id;
2706:
2707: END IF;
2708: EXCEPTION

Line 2770: last_update_date = hz_utility_pub.last_update_date,

2766: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2767:
2768: UPDATE OZF_OFFERS
2769: SET autopay_party_id = p_to_fk_id,
2770: last_update_date = hz_utility_pub.last_update_date,
2771: last_updated_by = hz_utility_pub.user_id,
2772: last_update_login = hz_utility_pub.last_update_login
2773: where autopay_party_id = p_from_fk_id;
2774:

Line 2771: last_updated_by = hz_utility_pub.user_id,

2767:
2768: UPDATE OZF_OFFERS
2769: SET autopay_party_id = p_to_fk_id,
2770: last_update_date = hz_utility_pub.last_update_date,
2771: last_updated_by = hz_utility_pub.user_id,
2772: last_update_login = hz_utility_pub.last_update_login
2773: where autopay_party_id = p_from_fk_id;
2774:
2775: END IF;

Line 2772: last_update_login = hz_utility_pub.last_update_login

2768: UPDATE OZF_OFFERS
2769: SET autopay_party_id = p_to_fk_id,
2770: last_update_date = hz_utility_pub.last_update_date,
2771: last_updated_by = hz_utility_pub.user_id,
2772: last_update_login = hz_utility_pub.last_update_login
2773: where autopay_party_id = p_from_fk_id;
2774:
2775: END IF;
2776: EXCEPTION

Line 2836: last_update_date = hz_utility_pub.last_update_date,

2832: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2833:
2834: UPDATE ozf_request_headers_all_b
2835: SET partner_id = p_to_fk_id,
2836: last_update_date = hz_utility_pub.last_update_date,
2837: last_updated_by = hz_utility_pub.user_id,
2838: last_update_login = hz_utility_pub.last_update_login,
2839: program_application_id = hz_utility_pub.program_application_id,
2840: program_id = hz_utility_pub.program_id,

Line 2837: last_updated_by = hz_utility_pub.user_id,

2833:
2834: UPDATE ozf_request_headers_all_b
2835: SET partner_id = p_to_fk_id,
2836: last_update_date = hz_utility_pub.last_update_date,
2837: last_updated_by = hz_utility_pub.user_id,
2838: last_update_login = hz_utility_pub.last_update_login,
2839: program_application_id = hz_utility_pub.program_application_id,
2840: program_id = hz_utility_pub.program_id,
2841: program_update_date = sysdate

Line 2838: last_update_login = hz_utility_pub.last_update_login,

2834: UPDATE ozf_request_headers_all_b
2835: SET partner_id = p_to_fk_id,
2836: last_update_date = hz_utility_pub.last_update_date,
2837: last_updated_by = hz_utility_pub.user_id,
2838: last_update_login = hz_utility_pub.last_update_login,
2839: program_application_id = hz_utility_pub.program_application_id,
2840: program_id = hz_utility_pub.program_id,
2841: program_update_date = sysdate
2842: where partner_id = p_from_fk_id;

Line 2839: program_application_id = hz_utility_pub.program_application_id,

2835: SET partner_id = p_to_fk_id,
2836: last_update_date = hz_utility_pub.last_update_date,
2837: last_updated_by = hz_utility_pub.user_id,
2838: last_update_login = hz_utility_pub.last_update_login,
2839: program_application_id = hz_utility_pub.program_application_id,
2840: program_id = hz_utility_pub.program_id,
2841: program_update_date = sysdate
2842: where partner_id = p_from_fk_id;
2843:

Line 2840: program_id = hz_utility_pub.program_id,

2836: last_update_date = hz_utility_pub.last_update_date,
2837: last_updated_by = hz_utility_pub.user_id,
2838: last_update_login = hz_utility_pub.last_update_login,
2839: program_application_id = hz_utility_pub.program_application_id,
2840: program_id = hz_utility_pub.program_id,
2841: program_update_date = sysdate
2842: where partner_id = p_from_fk_id;
2843:
2844: END IF;