63: -- the resource record for the old party id.
64:
65: UPDATE PA_RESOURCE_TXN_ATTRIBUTES
66: SET PARTY_ID = P_TO_FK_ID,
67: last_update_date = hz_utility_pub.last_update_date,
68: last_updated_by = hz_utility_pub.user_id,
69: last_update_login = hz_utility_pub.last_update_login,
70: request_id = hz_utility_pub.request_id,
71: program_application_id = hz_utility_pub.program_application_id,
64:
65: UPDATE PA_RESOURCE_TXN_ATTRIBUTES
66: SET PARTY_ID = P_TO_FK_ID,
67: last_update_date = hz_utility_pub.last_update_date,
68: last_updated_by = hz_utility_pub.user_id,
69: last_update_login = hz_utility_pub.last_update_login,
70: request_id = hz_utility_pub.request_id,
71: program_application_id = hz_utility_pub.program_application_id,
72: program_id = hz_utility_pub.program_id,
65: UPDATE PA_RESOURCE_TXN_ATTRIBUTES
66: SET PARTY_ID = P_TO_FK_ID,
67: last_update_date = hz_utility_pub.last_update_date,
68: last_updated_by = hz_utility_pub.user_id,
69: last_update_login = hz_utility_pub.last_update_login,
70: request_id = hz_utility_pub.request_id,
71: program_application_id = hz_utility_pub.program_application_id,
72: program_id = hz_utility_pub.program_id,
73: program_update_date = sysdate
66: SET PARTY_ID = P_TO_FK_ID,
67: last_update_date = hz_utility_pub.last_update_date,
68: last_updated_by = hz_utility_pub.user_id,
69: last_update_login = hz_utility_pub.last_update_login,
70: request_id = hz_utility_pub.request_id,
71: program_application_id = hz_utility_pub.program_application_id,
72: program_id = hz_utility_pub.program_id,
73: program_update_date = sysdate
74: WHERE PARTY_ID = P_FROM_FK_ID;
67: last_update_date = hz_utility_pub.last_update_date,
68: last_updated_by = hz_utility_pub.user_id,
69: last_update_login = hz_utility_pub.last_update_login,
70: request_id = hz_utility_pub.request_id,
71: program_application_id = hz_utility_pub.program_application_id,
72: program_id = hz_utility_pub.program_id,
73: program_update_date = sysdate
74: WHERE PARTY_ID = P_FROM_FK_ID;
75:
68: last_updated_by = hz_utility_pub.user_id,
69: last_update_login = hz_utility_pub.last_update_login,
70: request_id = hz_utility_pub.request_id,
71: program_application_id = hz_utility_pub.program_application_id,
72: program_id = hz_utility_pub.program_id,
73: program_update_date = sysdate
74: WHERE PARTY_ID = P_FROM_FK_ID;
75:
76: RETURN;