APPS.PA_RES_MERGE_PKG dependencies on HZ_UTILITY_PUB

Line 67: last_update_date = hz_utility_pub.last_update_date,

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,

Line 68: last_updated_by = hz_utility_pub.user_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,

Line 69: last_update_login = hz_utility_pub.last_update_login,

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

Line 70: request_id = hz_utility_pub.request_id,

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;

Line 71: program_application_id = hz_utility_pub.program_application_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:

Line 72: program_id = hz_utility_pub.program_id,

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;