APPS.HZ_PARTY_MERGE dependencies on HZ_ORIG_SYS_REFERENCES

Line 3686: UPDATE HZ_ORIG_SYS_REFERENCES

3682: program_id = hz_utility_pub.program_id,
3683: program_update_date = sysdate
3684: WHERE party_site_id = l_to;
3685: ----Inactivating SSM Record
3686: UPDATE HZ_ORIG_SYS_REFERENCES
3687: SET STATUS = 'I',
3688: END_DATE_ACTIVE =trunc(SYSDATE-1),
3689: last_update_date = hz_utility_pub.last_update_date,
3690: last_updated_by = hz_utility_pub.user_id,

Line 3805: UPDATE HZ_ORIG_SYS_REFERENCES

3801: program_update_date = sysdate
3802: WHERE party_site_id =FROM_PS.party_site_id ;
3803:
3804: ----Inactivating SSM Record
3805: UPDATE HZ_ORIG_SYS_REFERENCES
3806: SET STATUS = 'I',
3807: END_DATE_ACTIVE =trunc(SYSDATE-1),
3808: last_update_date = hz_utility_pub.last_update_date,
3809: last_updated_by = hz_utility_pub.user_id,

Line 3986: UPDATE HZ_ORIG_SYS_REFERENCES

3982: program_id = hz_utility_pub.program_id,
3983: program_update_date = sysdate
3984: WHERE relationship_id = l_to;
3985: ----Inactivating SSM Record
3986: UPDATE HZ_ORIG_SYS_REFERENCES
3987: SET STATUS = 'I',
3988: END_DATE_ACTIVE =trunc(SYSDATE-1),
3989: last_update_date = hz_utility_pub.last_update_date,
3990: last_updated_by = hz_utility_pub.user_id,

Line 4028: UPDATE HZ_ORIG_SYS_REFERENCES

4024: program_update_date = sysdate
4025: WHERE relationship_id =FROM_REL.RELATIONSHIP_ID;
4026:
4027: ----Inactivating SSM Record
4028: UPDATE HZ_ORIG_SYS_REFERENCES
4029: SET STATUS = 'I',
4030: END_DATE_ACTIVE =trunc(SYSDATE-1),
4031: last_update_date = hz_utility_pub.last_update_date,
4032: last_updated_by = hz_utility_pub.user_id,

Line 4238: UPDATE HZ_ORIG_SYS_REFERENCES

4234: program_id = hz_utility_pub.program_id,
4235: program_update_date = sysdate
4236: WHERE contact_point_id = l_to;
4237: ----Inactivating SSM Record
4238: UPDATE HZ_ORIG_SYS_REFERENCES
4239: SET STATUS = 'I',
4240: END_DATE_ACTIVE =trunc(SYSDATE-1),
4241: last_update_date = hz_utility_pub.last_update_date,
4242: last_updated_by = hz_utility_pub.user_id,

Line 4355: UPDATE HZ_ORIG_SYS_REFERENCES

4351: program_id = hz_utility_pub.program_id,
4352: program_update_date = sysdate
4353: WHERE contact_point_id = FROM_CP.contact_point_id;
4354: ----Inactivating SSM Record
4355: UPDATE HZ_ORIG_SYS_REFERENCES
4356: SET STATUS = 'I',
4357: END_DATE_ACTIVE =trunc(SYSDATE-1),
4358: last_update_date = hz_utility_pub.last_update_date,
4359: last_updated_by = hz_utility_pub.user_id,