APPS.HZ_PARTY_CERT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 46

	   select party_type
	   from hz_parties
	   where party_id = p_party_id;

Line: 78

        SELECT object_version_number, rowid , party_id
        INTO   l_object_version_number, l_rowid , l_party_id
        FROM   HZ_PARTIES
        WHERE  party_id = p_party_id
        and party_type in ('ORGANIZATION','PERSON')
        FOR UPDATE NOWAIT;

Line: 159

                  p_operation_code     => 'UPDATE',
                  p_db_object_name     => 'HZ_PARTIES',
                  p_instance_pk1_value => l_party_id,
                  p_user_name          => fnd_global.user_name,
                  x_return_status      => dss_return_status,
                  x_msg_count          => dss_msg_count,
                  x_msg_data           => dss_msg_data);

Line: 173

         FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');

Line: 183

    UPDATE HZ_PARTIES SET
        CERTIFICATION_LEVEL = DECODE( p_cert_level, FND_API.G_MISS_CHAR, NULL, p_cert_level ),
        CERT_REASON_CODE = DECODE( l_cert_reason_code, FND_API.G_MISS_CHAR, NULL, l_cert_reason_code ),
        LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
        CREATION_DATE = CREATION_DATE,
        LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
        REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
        PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
        CREATED_BY = CREATED_BY,
        LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
        PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
        PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
        OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
        WHERE ROWID = l_rowid;

Line: 263

		select party_type
		from hz_parties
		where party_id = p_party_id;

Line: 289

                  p_operation_code     => 'UPDATE',
                  p_db_object_name     => 'HZ_PARTIES',
                  p_instance_pk1_value => p_party_id,
                  p_user_name          => fnd_global.user_name,
                  x_return_status      => dss_return_status,
                  x_msg_count          => dss_msg_count,
                  x_msg_data           => dss_msg_data);

Line: 303

         FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');

Line: 322

    		UPDATE HZ_ORGANIZATION_PROFILES SET
        	internal_flag = p_internal_flag,
        	LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
        	CREATION_DATE = CREATION_DATE,
        	LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
        	REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
        	PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
        	CREATED_BY = CREATED_BY,
        	LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
        	PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
        	PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
        	OBJECT_VERSION_NUMBER = nvl(object_version_number,1)+1
        	WHERE party_id = p_party_id;

Line: 340

    		UPDATE HZ_PERSON_PROFILES SET
        	internal_flag = p_internal_flag,
        	LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
        	CREATION_DATE = CREATION_DATE,
        	LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
        	REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
        	PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
        	CREATED_BY = CREATED_BY,
        	LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
        	PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
        	PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
        	OBJECT_VERSION_NUMBER = nvl(object_version_number,1)+1
        	WHERE party_id = p_party_id;

Line: 360

		UPDATE HZ_PARTIES SET
        		status = p_status,
        		LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
        		CREATION_DATE = CREATION_DATE,
        		LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
        		REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
        		PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
        		CREATED_BY = CREATED_BY,
        		LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
        		PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
        		PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
        		OBJECT_VERSION_NUMBER = nvl(object_version_number,1)+1
        	WHERE party_id = p_party_id;