DBA Data[Home] [Help]

APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_UTILITY_V2PUB

Line 4115: last_update_date = hz_utility_v2pub.last_update_date,

4111:
4112: IF l_rowid IS NOT NULL THEN
4113: UPDATE HZ_PARTY_SITE_USES
4114: SET PRIMARY_PER_TYPE = 'N',
4115: last_update_date = hz_utility_v2pub.last_update_date,
4116: last_updated_by = hz_utility_v2pub.last_updated_by,
4117: last_update_login = hz_utility_v2pub.last_update_login,
4118: request_id = hz_utility_v2pub.request_id,
4119: program_id = hz_utility_v2pub.program_id,

Line 4116: last_updated_by = hz_utility_v2pub.last_updated_by,

4112: IF l_rowid IS NOT NULL THEN
4113: UPDATE HZ_PARTY_SITE_USES
4114: SET PRIMARY_PER_TYPE = 'N',
4115: last_update_date = hz_utility_v2pub.last_update_date,
4116: last_updated_by = hz_utility_v2pub.last_updated_by,
4117: last_update_login = hz_utility_v2pub.last_update_login,
4118: request_id = hz_utility_v2pub.request_id,
4119: program_id = hz_utility_v2pub.program_id,
4120: program_application_id = hz_utility_v2pub.program_application_id,

Line 4117: last_update_login = hz_utility_v2pub.last_update_login,

4113: UPDATE HZ_PARTY_SITE_USES
4114: SET PRIMARY_PER_TYPE = 'N',
4115: last_update_date = hz_utility_v2pub.last_update_date,
4116: last_updated_by = hz_utility_v2pub.last_updated_by,
4117: last_update_login = hz_utility_v2pub.last_update_login,
4118: request_id = hz_utility_v2pub.request_id,
4119: program_id = hz_utility_v2pub.program_id,
4120: program_application_id = hz_utility_v2pub.program_application_id,
4121: program_update_date = hz_utility_v2pub.program_update_date

Line 4118: request_id = hz_utility_v2pub.request_id,

4114: SET PRIMARY_PER_TYPE = 'N',
4115: last_update_date = hz_utility_v2pub.last_update_date,
4116: last_updated_by = hz_utility_v2pub.last_updated_by,
4117: last_update_login = hz_utility_v2pub.last_update_login,
4118: request_id = hz_utility_v2pub.request_id,
4119: program_id = hz_utility_v2pub.program_id,
4120: program_application_id = hz_utility_v2pub.program_application_id,
4121: program_update_date = hz_utility_v2pub.program_update_date
4122: WHERE ROWID = l_rowid;

Line 4119: program_id = hz_utility_v2pub.program_id,

4115: last_update_date = hz_utility_v2pub.last_update_date,
4116: last_updated_by = hz_utility_v2pub.last_updated_by,
4117: last_update_login = hz_utility_v2pub.last_update_login,
4118: request_id = hz_utility_v2pub.request_id,
4119: program_id = hz_utility_v2pub.program_id,
4120: program_application_id = hz_utility_v2pub.program_application_id,
4121: program_update_date = hz_utility_v2pub.program_update_date
4122: WHERE ROWID = l_rowid;
4123: END IF;

Line 4120: program_application_id = hz_utility_v2pub.program_application_id,

4116: last_updated_by = hz_utility_v2pub.last_updated_by,
4117: last_update_login = hz_utility_v2pub.last_update_login,
4118: request_id = hz_utility_v2pub.request_id,
4119: program_id = hz_utility_v2pub.program_id,
4120: program_application_id = hz_utility_v2pub.program_application_id,
4121: program_update_date = hz_utility_v2pub.program_update_date
4122: WHERE ROWID = l_rowid;
4123: END IF;
4124:

Line 4121: program_update_date = hz_utility_v2pub.program_update_date

4117: last_update_login = hz_utility_v2pub.last_update_login,
4118: request_id = hz_utility_v2pub.request_id,
4119: program_id = hz_utility_v2pub.program_id,
4120: program_application_id = hz_utility_v2pub.program_application_id,
4121: program_update_date = hz_utility_v2pub.program_update_date
4122: WHERE ROWID = l_rowid;
4123: END IF;
4124:
4125: END do_unmark_primary_per_type;