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,
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,
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
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;
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;
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:
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;